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

ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?

Received Response
edited Mar 8, 2022 8:15PM in General Transactional Reporting (OTBI) 1 comment


Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID columns from the Oracle table ZMM_notes within Receivables - Transactions Real Time? Ultimately, I am looking to add the notes_txt column to an existing otbi report with various other subjects areas - Payables Invoices - Transactions Real Time, Payables Invoices - Installments Real Time, Supplier - Supplier Real Time.

In order to perform the join on the AP_INVOICES_ALL table on the invoice id, it is required to have the SOURCE_OBJECT_CODE = 'Standard_AP_Invoice', and the SOURCE_OBJECT_UID = invoice_id.

Howdy, Stranger!

Log In

To view full details, sign in.


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