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

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.

Goal

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?
 

Solution

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