My Oracle Support Banner

Order Management Invoice Integration with Receivables (Doc ID 1622710.1)

Last updated on AUGUST 24, 2023

Applies to:

Oracle Order Management - Version and later
Oracle Receivables - Version and later
Information in this document applies to any platform.


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
Troubleshooting Steps
 Overview of Integration
 How to View the Created Receivables Transaction
 What data/Columns are populated into AR interface tables from OM
 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?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.