My Oracle Support Banner

Need Audit Tracking For Sales Order OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL Interface Tables (Doc ID 2540035.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Goal

Summary of Issue
Need audit tracking for sales order interface tables. I tried setting up audit tracking for tables
OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL but it does not work because those
tables have no primary key.

How do we retain history/auditing records that are being changed in those tables so that user will know who and when changed them and which values changed?
 

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.