Payables and Cash Management - EBS (MOSC)

MOSC Banner

Apply Hold on invoice via API.

edited Nov 17, 2016 8:23AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered ✓

I am in a process of writing interface for vendor invoices to AP invoices.

Data comes in text file. (tsv)

VENDORInvoice DateInvoice #Vendor Part NumberDescriptionQty InvoicedPurchase OrderUnit PriceOrder Line AmountUnit

invoice amount

MINT11/1/161234Junior_Mint098Creamy mints in Pure Chocolate10PO12340.505EA7.5
MINT11/1/161234Double_Mint765double mint10PO12340.252.5EA7.5

I have successfully created pl/sql program to map and parse the file and load it into - ap_invoices_interface and ap_invoice_lines_interface tables.

But I have a requirement to check if the item is setup in Oracle Inventory. For this I have setup Vendor Item XREF for each vendor part number so that I can get to the PO LINE.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center