My Oracle Support Banner

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

Last updated on JANUARY 16, 2024

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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