What table provides PJC Integration Data, original full file loaded to Oracle for processing?
Summary:
What table provides Project Cost Integration Data, the full original data for the file loaded to Oracle for processing? I would like join processed and other transactions to create snapshot of the full integration for reconciliation back to the source system, what was sent vs current state. We would like to do this in a single report.
Content (please ensure you mask any confidential information):
Currently, we download the integration files then do manual analysis back to this with the data for processed costs, unprocessed costs, and staging errors.
We would like to create a single report for this analysis, to include all data from the original integration, regardless of statues, processed costs, unprocessed costs, and staging errors.