update on STATUS column on the GL_INTERFACE table

update on STATUS column on the GL_INTERFACE table

Problem Description

What are the possible values for the STATUS column on the GL_INTERFACE table?

Solution Description

There are several common codes -  'NEW', 'P', 'PROCESSED', and 'CORRECTED'.

There are also primary error codes listed at the end of the Journal Import

Execution Report.  See Note 1056801.6 for a list of the primary error codes

and step-by-step instructions on how to correct these Journal Import errors.

There is no list for all of the possible values of the STATUS column.

This is a text field and sub-ledgers are allowed to put any

value in the field other than 'PROCESSED'. Also, a line can have multiple

errors, and therefore multiple error codes in the STATUS column.

When data is loaded into the GL_INTERFACE table, STATUS must be 'NEW' in order

to be ready for Journal Import processing.   (For a complete description of how to load

this table, see the Oracle General Ledger User Guide.)

'P' indicates that Journal Import passed this line successfully but other

lines in the same transaction failed.

'PROCESSED' indicates that journal import passed the entire transaction

successfully and has created a journal for the transaction.

'CORRECTED' indicates that the line was in error and was corrected through

the Correct Journal Import form.