Status and Message Columns

Every worksheet will be created with the following columns:

1. Header Status - Records the overall status for each invoice

2. Header Messages – Records any warning/error messages related to the Header Status

3. Line Status - Records the overall status for each invoice line

4. Line Messages – Records any warning/error messages related to the Line Status

5. SalesCredit Status – Records the overall status for each Sales Credit Line

6. SalesCredit Messages - Records any warning/error messages related to the SalesCredit Status

7. Distribution Status – Records the overall status for each Distribution Line

8. Distribution Messages - Records any warning/error messages related to the Distribution Status

9. Apply Status – Records the status of any On Account Applications that have been performed

10. Apply Messages - Records any warning/error messages related to the Apply Status

The Status and Message columns can be moved within the sheet, but cannot be removed unless that entire section is not being used i.e. Sales Credits.

The Status columns may populate with the following:

Status	Status Explanation
Blank	Prior to running the validate/upload process.
Validated	When validation has been run and no errors are reported.
Accepted	All the information for this invoice has been successfully loaded into Receivables. Applied Credit Memo has been successfully completed in Receivables.
Pending	All the information for this invoice is uploaded to the interface table ready for importing into Oracle Receivables.
Credit Request Created	An applied Credit Memo Request has been sent to Receivables and workflow initiated. The ‘Credit Status’ button must be clicked to actually create these transactions in Receivables.
Error	All the information for this invoice has NOT been successfully loaded into Oracle Receivables. Messages will be written back into the sheet.
Uploaded	Attachment has successfully uploaded into Oracle.

Refer to section: