OTBI Payable invoices - Accounting user name

Hisham Abbas

Summary

OTBI Payable invoices - Accounting user name

Content

Dears,

What is the field name in OTBI which give me the user name for the person who postd the invoice to Ledger?

Sean Curry

Hey Hisham, 

It should be the CREATED_BY field from the GL_JE_HEADERS or GL_JE_LINES table depending on the level you are looking for, 

https://docs.oracle.com/en/cloud/saas/financials/21a/oedmf/general-ledger.html#gljeheaders-11907.

In OTBI it is under the subject area Payables Invoices - Transactions Real Time>Ledger Created By.

Sean Curry

It could also be under the Invoice Details >Invoice Approval Information.