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

Audit Report for RMCS loaded files

Summary:

We have the need to obtain an Audit Report of all manual loads made to table VRM_SOURCE_DOC_LINES.
I know that this table has a column named LOAD_REQUEST_ID which stores the actual process_id that was used in File Import and Export Screen.
When I query a load_request_id in File Import and Export Screen, I can obtain the file that was used by that process_id.

Content (please ensure you mask any confidential information):

For our Audit report, I need help to get the tables that are used to link the Load_request_id form table VRM_SOURCE_DOC_LINES with the process ID that is queried in File Import and Export screen and get the file name used.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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