EBI9.2:Query To Determine Which User Prints And Finalizes A Bill
Last updated on JUNE 01, 2017
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms