The Item import Interface(IOI) reads data from following tables for importing items and item details. The MTL_SYSTEMS_ITEM_INTERFACE table is used for new item numbers and all item attributes. This is the main item interface table, and can be the only table used to import items. MTL_ITEM_REVISIONS_INTERFACE is used if Item revisions history is also loaded […]
What Actions are supported? ORIGINAL – create a new documentADD – add new lines onto an existing documentUPDATE – update existing line information for a documentREPLACE – Replace the existing documentWhich interface tables are involved? PO_HEADERS_INTERFACEPO_LINES_INTERFACEPO_DISTRIBUTIONS_INTERFACE(Used for Standard PO only)
After loading the data from the interface tables into the system successfully, the data is not being removed (cleaned) from the interfaces. They will have process_code = ‘ACCEPT’ in the interface tables. To remove the processed data from the interface, a concurrent program is available. The program name is : purge purchasing open interface processed […]
Let’s say Invoices are imported from External Systems – irrespective of the transportation layer / method. Instead of viewing the Interface tables in the backend – say AP_INVOICES_INTERFACE , AP_INVOICE_LINES_INTERFACE, they can be viewed in the front-end.Responsibility – Payables ManagerNavigation – Invoices – Entry – Open Interface InvoicesClicking on the above link, opens the below […]
The concurrent programs can be called in one of the following 2 ways: 1) From standard concurrent request by attaching the concurrent program to a request group. The request group name can be found from the responsibility. Query for the request group and attach concurrent program to that request group. Now the program will be […]
Recent Comments