JE Document Sequencing does not follow order of amount ascending since updrade from 12.0.6 to 12.1.3
Dear All,
Our Customer upgraded recently from 12.0.6 to 12.1.3. Also database 11g is upgraded from 11.2.0.2.0 to 11.2.0.4.0.
Customer is loading data in GL_INTERFACE using SQL Loader and runs Journal Import for a single group id.
R12.0.6 is updating gl_je_headers assigning sequences in what seems to be an ascending order of the Accounted_DR and Accounted_CR.
Also, je_headers_id`s are assigned in an ascending order, so, when verifying imported headers it can be noticed that doc_sequence_value is in ascending order by the sum and je_header_id.
Same data is used in R12.1.3, but Journal Import is not assigning sequence values in the same manner as in R12.0.6.