Last updated on NOVEMBER 20, 2016
Applies to:Oracle General Ledger - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Executable:GLPAUTOP - Program - Automatic Posting
Executable:GLPPOS - Posting
You are attempting to post journals via AutoPost.The Posting program ends in error. There is no issue when the failed post program is submitted manually. This issue is happening with both AutoPost Criteria Set with single ledger or with Ledger Set . This error comes when the BSV,LE - All Other BSV, All Other LE rule(s) defined.
GLPPOS module: Posting log file show following information:
>> fun_bal_pkg() 04-DEC-2009 09:06:01
SHRD0181: glpciba() - fun_bal_pkg ret_status = U
SHRD0180: glpmai() - Performing action >> delete_failed_alc_lines...
SHRD0026: Current system time is: 04-DEC-2009 09:06:03
SHRD0180: glpmai() - Performing action >> delete_failed_alc_jrnls...
SHRD0026: Current system time is: 04-DEC-2009 09:06:04
>> glucmt() 04-DEC-2009 09:06:05
<< glucmt() 04-DEC-2009 09:06:05
PPOS0002: Posting terminated with fatal errors
Posting is failing due to this following statement in the posting log file :
glpciba() - fun_bal_pkg ret_status = U
Trace file shows following update statement fails with ORA-1427 error.ORA-01427 Single-row Subquery Returns More Than One Row
UPDATE FUN_BAL_INTER_INT_GT INTER_INT SET REC_ACCT = (SELECT CCID FROM
FUN_INTER_ACCOUNTS ACCTS WHERE INTER_INT.LEDGER_ID = ACCTS.LEDGER_ID AND INTER_INT.REC_ACCT IS NULL AND DECODE(INTER_INT.INTERCOMPANY_MODE, 1, DECODE(LE_ID, DRIVING_CR_LE_ID, DECODE(INTER_INT.TYPE, 'C',
DRIVING_CR_LE_ID, NULL), DECODE(INTER_INT.TYPE, 'C', DRIVING_DR_LE_ID,
NULL)), 2, DECODE (INTER_INT.TYPE, 'C', LE_ID, DRIVING_DR_LE_ID), 3,
DECODE(INTER_INT.TYPE, 'C', LE_ID, DRIVING_CR_LE_ID), 4,
DECODE(INTER_INT.TYPE, 'C', LE_ID, NULL), NULL) =
ACCTS.FROM_LE_ID AND ACCTS.TO_LE_ID = -99 AND ACCTS.TYPE = 'R' AND
ACCTS.DEFAULT_FLAG = 'Y' AND (TRUNC(INTER_INT.GL_DATE) BETWEEN
TRUNC(NVL(ACCTS.START_DATE, INTER_INT.GL_DATE)) AND
TRUNC(NVL(ACCTS.END_DATE, INTER_INT.GL_DATE)))) WHERE INTER_INT.REC_ACCT IS NULL
ORA-01427 Single-row Subquery Returns More Than One Row
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms