Thursday, June 16, 2022

oracle.apps.ap.invoice.import Business Event in Oracle APPS

This Business Event get triggered when Payables Open Interface Import is submitted. It has REQUEST_ID and #CURRENT_PHASE as parameter names. When  Payables Open Interface Import program completes we can find REQUEST_ID in AP_INVOICE_LINES_ALL table.


No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...