R12: GLPAUTOP GLPPOS When Post Journals Via Automatic Posting Get "fun_bal_pkg ret_status = U " PPOS0002 Posting Terminated With Fatal Errors, The Trace File Shows ORA-01427 (Doc ID 982132.1)

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

Symptoms

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.

Error
------
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

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