What are the possible values for the STATUS column on the GL_INTERFACE table?
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.