Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Are there any history or audit tables for Purchase Requisition

in Self Service Procurement 3 comments

Summary:

We have a requirement to send a notification whenever the suggester buyer in a PR is reassigned to a new buyer.

We observed in case of reassignment, the same column 'ASSIGNED_BUYER_ID' in POR_REQUISITION_LINES_ALL table is getting overwritten with the new buyer id.

We wanted to know if there any history or audit table for POR_REQUISITION_LINES_ALL so that we can keep track of the old and new buyer values and accordingly send a custom notification if there is a change.

Appreciate a quick response.

Content (please ensure you mask any confidential information):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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