ER: Close Sales Order when RA Interface Data has been Deleted ? (Doc ID 2206443.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance***

Goal

RA Invoicing data has been deleted from RA_INTERFACE_LINES_ALL table, which then prevents the order line from closing. How can the lines be closed ?

The issue can be reproduced by executing the following steps:

1. Process an Order through to Billing
2. Delete lines from the RA_INTERFACE_LINES_ALL table, process described in - How To Purge Records With Any Status In Autoinvoice Interface Tables (Doc ID 1639310.1)
3. It is now not possible to Close the Fulfillment Line

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms