Oracle Analytics and AI

Sai Poorna

Hi Team,

Which Oracle Fusion table stores the Negotiation Number, and is there any table or audit log to identify the user who deleted the negotiation?

We are trying to trace a negotiation that appears to have been deleted and need to find both the negotiation details and the user who performed the deletion.

Any guidance on the relevant Fusion tables, audit configurations would be appreciated.

Thank you.

Bhaskar Konar

Hi @Sai Poorna,

Please take a look into the following Oracle documents and the post which might be useful.

PON_AUCTION_HEADERS_ALL - PON_AUCTION_HEADERS stores auctions, RFQs, and RFIs header information.

https://docs.oracle.com/en/cloud/saas/procurement/26b/oedmp/ponauctionheadersall-15123.html#ponauctionheadersall-15123

PON_NEG_AUDIT_ACTIVITIES - This table is created to capture the activities related to negotiation life cycle as they occur for buyer user.

https://docs.oracle.com/en/cloud/saas/procurement/26b/oedmp/ponnegauditactivities-8531.html#Details

How You Audit Negotiation Changes: https://docs.oracle.com/en/cloud/saas/procurement/26b/oaprc/how-you-audit-negotiation-changes.html

Need a query to fetch the status of Manage Negotiations page — Cloud Customer Connect

Hope this help.

Thank you.