Getting same data references in table gl_je_lines in R12 which were available in 11i
After upgrading from 11.5.10 to 12.1.3 newly created journals do not have the reference columns populated in gl_je_lines for Reeference1 to 4. Also, due to SLA, in gl_je_lines table, columns REFERENCE5 to REFERENCE10 are now populated with entity_id, event_id, ae_header_id, ae_line_num, accounted_cr and accounted_dr.
In 11i, If the journal is imported in detail, the information is copied over to REFERENCE1 to REFERENCE10 in GL_JE_LINES from the data from columns REFERENCE21 to REFERENCE30 of GL_INTERFACE table at posting event. The General Ledger Transfer process of sub-ledgers puts rows columns into REFERENCE21 to REFERENCE30 of GL_INTERFACE table.
0