Thursday, July 11, 2013

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.

2 comments:

andrea chiu said...

You have a very good article. Thanks for sharing.

andrea

www.triciajoy.com

andrea chiu said...

You have a very good article. Thanks for sharing.

andrea

www.triciajoy.com