How to get the Error Details of the Import Auto Invoice Execution Report through query
I am trying to create the join to abstract the Data from the tables used in the Auto Invoice Execution Report but not able to extract.
Currently Using same Tables used in the Seeded BI Report of the Execution Report
For Request_Id : ESS_REQUEST_HISTORY
For Tran_FF Field : RA_INTERFACE_LINES_ALL
For Error : RA_INTERFACE_ERRORS_ALL
Required Output Columns: RequestID, INTERFACE_LINE_ATTRIBUTE1,Error.
Please help.
Tagged:
0