You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can AUDIT_CHANGE_BIT_MAP_ col in Fusion audit tables be used to detect which columns have changed?

Accepted answer


Does Oracle support using AUDIT_CHANGE_BIT_MAP_ column in audit tables to detect which columns have changed?

Content (please ensure you mask any confidential information):

We have a requirement to integrate new and updated suppliers from Oracle ERP to a 3rd party application in batch. We have developed a BIP sql data model w/report to query the supplier audit tables to detect inserts/updates and we are using AUDIT_CHANGE_BIT_MAP_ to filter on the columns we care about from an integration standpoint. Does Oracle support using AUDIT_CHANGE_BIT_MAP_ for the purpose we are using it for? MOS has contradicting information whether its supported or not. It seems to work fine for us so far. However, if an issue comes up down the road we need to know that

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!