Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time? — Cloud Customer Connect
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
11
Views
1
Comments
edited Mar 8, 2022 8:15PM in General Transactional Reporting (OTBI) 1 comment

Summary:

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.

Register

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