My Oracle Support Banner

Order Management Invoice Integration with Receivables (Doc ID 1622710.1)

Last updated on MARCH 01, 2022

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Oracle 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

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