Posting (GLPPOS) Fails With Unique Constraint (GL.GL_JE_LINES_RECON_U1) Violated (Doc ID 2254448.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
GLPAUTOP, GLPPOS

Symptoms

Seeing this error intermittently when using Autopost (GLPAUTOP).

When a journal has this error using Autopost it can be manually posted without error.

The posting log file shows the following error -

UPDATE GL_JE_LINES jel1
  SET jel1.accounted_dr = jel1.accounted_dr + (:mtl * :adr)
  WHERE jel1.je_header_id = :jeh_id
  AND jel1.accounted_dr + (jel1.je_line_num/1000000) =
  (SELECT max(jel2.accounted_dr +
  (jel2.je_line_num/1000000))
  FROM GL_JE_LINES jel2
  WHERE jel2.je_header_id = :jeh_id)

SHRD0181: glpcjl() - cjl7_stmt(len) = 364
SHRD0180: glpcjl() - Performing action >> build_CJL8_stmt...
SHRD0181: glpcjl() - cjl8_stmt =
UPDATE GL_JE_LINES jel1
  SET jel1.accounted_dr = jel1.accounted_dr + (:mtl * :adr)
  WHERE jel1.je_header_id = :jeh_id
  AND jel1.accounted_dr + (jel1.je_line_num/1000000) =
  (SELECT max(jel2.accounted_dr +
  (jel2.je_line_num/1000000))
  FROM GL_CODE_COMBINATIONS cc, GL_JE_LINES jel2
  WHERE jel2.je_header_id = :jeh_id
  AND cc.code_combination_id =
  jel2.code_combination_id + 0
  AND cc.SEGMENT1 || '' = :plug_balseg)

SHRD0181: glpcjl() - cjl8_stmt(len) = 535
SHRD0180: glpcjl() - Performing action >> build_ins_je_segvals...
SHRD0180: glpcjl() - Performing action >> build_ins_recon_lines...
SHRD0180: glpcjl() - Performing action >> loop_through_CJL1_cursor...
SHRD0026: Current system time is: 28-OCT-2016 17:55:02

SHRD0181: glpcjl() - ledger_id = 2
SHRD0181: glpcjl() - je_batch_id = 2431978
SHRD0181: glpcjl() - je_header_id = 6446898
SHRD0181: glpcjl() - plug_balseg = 501
SHRD0180: glpcjl() - Performing action >> loop_count_is_1...
SHRD0181: glpcjl() - ledger_id = 8
SHRD0181: glpcjl() - je_batch_id = 2432032
SHRD0181: glpcjl() - je_header_id = 6455203
SHRD0181: glpcjl() - plug_balseg = 514
SHRD0180: glpcjl() - Performing action >> header_id_value_changed...
SHRD0181: glpcjl() - rounding_je_seg_vals_inserted = 6446898,0
PERF0005: Oracle error detected in glpcjl() - ORA-00001: unique constraint
(GL.GL_JE_LINES_RECON_U1) violated
ORA-06



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms