The Payables Invoices Integrator has the ability to download Purchase Order details which makes matching to invoices easier.
There are two Download sources available, where information from different areas of Oracle can be downloaded into the same Integrator. See Download Sources for more information.
The two Download Sources available are:
● Invoices: Downloads invoices based on the download criteria provided. If downloading invoices based on a Purchase Order number they are matched to, you must enter the Purchase Order number in the Purchase Order section, not the header section, using the field ‘Line Purchase Order number’.
● Purchase Orders: Downloads Purchase Order line and header data based on the Purchase Order(s) provided. You must enter the Purchase Order number in the Purchase Order section, not the header section, using the field ‘Line Purchase Order number’.
Updateable fields that will have data (if applicable) written to them on download are:
Header Section
Purchase Order
Supplier
Supplier Site
Procurement BU
Line Section
Line Amount
Line Requester
Purchase Order Section
Line Purchase Order Number
Line Purchase Order Line
Line Purchase Order Schedule
Line Quantity
Line Unit Price
There are also a number of download only fields that are written to on download. The quantity balances are live.
Note: If the Download Source selected is ‘Purchase Orders’, the same number of invoice headers will be downloaded as there are lines on the Purchase Order.
You will need to remove the number of headers you don't require as they will be processed as new individual invoices on upload.
This is a known issue and will be addressed in another iteration.
