Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

SQL tables that store invoice and journal approval data like tasks & related rules etc.?

in Reporting and Analytics for ERP 2 comments

Summary: What are the SQL tables with invoice and journal approval data like tasks and related rules like we have for procurement where we have the table POR_AMX_TASKS, which has all the approval tasks related to procurement like DocumentApproval and ReqApproval, but not able to find any tables with task details for FinApInvoiceApproval (Invoice Approval Task) and FinGlJournalApproval (Journal Approval Task)?

I found that there is a scheduled process "Workflow Rules Report", where I can download information related to Invoice and Journal Approval data, but I need the SQL tables that store the Invoice and Journal Approval related task details and rules included with related Approval Groups and other list builders used.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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