Loading files as attachments into Oracle EBS with ODI
At the end of last year I got a new task to work out a solution how to load files into Oracle EBS as a PO attachment. What was the small specification? To load PDF files - containing the PO number is their's name - into Oracle EBS database as an attachment for that PO headers the belong to the PO number. It was a small but quite interesting ODI and EBS development task.
What I needed to do my job? Or what I got for working out the solution
- an Oracle EBS 11i
- an Oracle Data Integrator (ODI 11.1..1.5)
- an ODI agent on that server where the Oracle EBS database installed
- a file directory on the same database node - this will contain the to be imported PDF files
- a custom EBS interface schema for database connection
I have used these 2 references for solving the problem:
Let's go into the details
