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

Query for Transaction Console transactions

Received Response
675
Views
6
Comments

Summary:

Query for Transaction Console transactions

Content (required):

I am looking to write a query that contains the below information from the Transaction Console, related to Expense and Invoice transactions.

I found the tables HRC_TXN_HEADER and HRC_TXN_DATA , joined by TRANSACTION_ID , however these tables do not appear to contain the Approval History information, as shown in the example below.

The only data I see in the HRC_TXN_HEADER and HRC_TXN_DATA tables seem to pertain to the information in the Header area on this page, and not the Approval History. Where can I find this additional detail? Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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