Order Management Invoice Integration with Receivables
(Doc ID 1622710.1)
Last updated on AUGUST 24, 2023
Applies to:
Oracle Order Management - Version 11.5.10.2 and laterOracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
Purpose
To understand and troubleshoot Order Management integration with Receivables.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Troubleshooting Steps |
| Overview of Integration |
| How to View the Created Receivables Transaction |
| What data/Columns are populated into AR interface tables from OM |
| INVOICE_INTERFACE_STATUS_CODE = NOT_ELIGIBLE In OE_ORDER_LINES_ALL |
| Examining Invoice related Data in OE_ORDER_LINES_ALL |
| To examine data for the Order lines related to Invoicing, specifically for the columns |
| Run following select for all lines of an Order: |
| Run following select for specific order lines of an order: |
| Examining the Item Attributes for Items in MTL_SYSTEM_ITEMS_B |
| OM System Parameters Related to Invoicing |
| Generating Debug Log Workflow background process to review invoice data interfaced to AR |
| From UI |
| From back-end |
| Identifying the Orders/ Order Line with Missing Invoice data |
| When are the RA_INTERFACE tables purged? |
| Automatically |
| Manually |
| References |