My Oracle Support Banner

FA: SCM: OM: How To: Purge Sales Order Interface Data (Doc ID 2403773.1)

Last updated on AUGUST 24, 2023

Applies to:

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

Goal

This note describes how to Purge Order Interface Data from Order Management Interface Tables:

DOO_ORDER_ADDRESSES_INT
DOO_ORDER_BILLING_PLANS_INT
DOO_ORDER_CHARGES_INT
DOO_ORDER_CHARGE_COMPS_INT
DOO_ORDER_DOC_REFERENCES_INT
DOO_ORDER_HDRS_ALL_EFF_B_INT
DOO_ORDER_HEADERS_ALL_INT
DOO_ORDER_LINES_ALL_EFF_B_INT
DOO_ORDER_LINES_ALL_INT
DOO_ORDER_LOT_SERIALS_INT
DOO_ORDER_LOT_SERIAL_EFF_B_INT
DOO_ORDER_MANUAL_PRICE_ADJ_INT
DOO_ORDER_PAYMENTS_EFF_B_INT
DOO_ORDER_PAYMENTS_INT
DOO_ORDER_SALES_CREDITS_INT
DOO_ORDER_SALES_CRS_EFF_B_INT
DOO_ORDER_TXN_ATTRIBUTES_INT

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


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