My Oracle Support Banner

EBI9.2:Query To Determine Which User Prints And Finalizes A Bill (Doc ID 2273007.1)

Last updated on OCTOBER 18, 2021

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Question:We are in need of a query that pulls from a permanent table to show who finalized a bill. We have run into issues gathering this data as in many tables it uses 'LAST_MAINT_OPRID' and when AR Update is ran, the table shows the user who ran AR Update and no longer the user who finalized the Bill. This has been the case with the BI_HDR and BI_LINE. We also looked at the BI_EXTRCT table, and while this table provides us the correct data; from an audit standpoint we need a permanent table that we can provide history for. Do you have any suggestions as to how this data can be queried?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.