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.
|
|
Validated
|
All the information for this journal distribution has been successfully validated.
|
|
Pending
|
The information for this journal distribution uploaded to the GL interface table ready for uploading to Oracle General Ledger.
|
|
Accepted
|
The information for this journal distribution has not been successfully loaded into Oracle General Ledger.
|
|
Error
|
The information for this journal distribution has not been successfully loaded into Oracle General Ledger.
|
|
Deleted
|
The information for this journal distribution has been deleted from the interface table.
|
Refer to section:
