Status and Message Columns
Every worksheet will be created with ‘Upload Status’, ‘Line Status’ and ‘Attach Status’ columns.
The ‘Upload Status’ is used to record the overall status for each journal. Status value could be:
|
Status
|
Status Explanation
|
|
Blank
|
Prior to running the validate/upload process.
|
|
Validated
|
All the information for this journal line has been successfully validated.
|
|
Pending
|
All the information for this journal line is uploaded to the GL interface table ready for importing into Oracle General Ledger.
|
|
Accepted
|
All the information for this journal line has been successfully loaded into Oracle General Ledger.
|
|
Error
|
All the information for this journal has not been successfully loaded into Oracle General Ledger.
|
|
Deleted
|
All the information for this journal has been deleted from the interface table.
|
The ‘Upload Message’ column is used to record any warning or error messages resulting from the validate/upload process e.g. ‘EM01'.
The ‘Line Status’ column is used to record the progress of the individual record for each distribution line of the journal. The status may be:
|
Status
|
Status Explanation
|
|
Blank
|
Prior to running the validate/upload process.
|
|
Pending
|
The information for this journal distribution uploaded to the AP interface table ready for uploading to Oracle Payables.
|
|
Accepted
|
The information for this journal distribution has not been successfully loaded into Oracle Payables.
|
|
Error
|
The information for this journal distribution has not been successfully loaded into Oracle Payables.
|
|
Deleted
|
The information for this journal distribution has been deleted from the interface table.
|
In the following example, one journal was rejected with the message ‘There is no Accounting for this Distribution’. All other journals were successfully processed.
Refer to section: