GLPPOS Posting Intercompany Journal Errors With SHRD0181: glpciba() - fun_bal_pkg ret_status = U And PPOS0002: Posting Terminated With Fatal Errors

(Doc ID 1323175.1)

Last updated on NOVEMBER 21, 2016

Applies to:

Oracle General Ledger - Version 12.1.3 to 12.2.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Merged with 469222.1, 1323321.1, 1235826.1
Executable:GLPPOS - Posting

Symptoms

Intercompany journals fail posting with the following seen in the debug log file (generated by setting profile option GL Debug to Yes)

>> glpciba() 17-MAY-2011 17:22:15
SHRD0180: glpciba() - Performing action >> insert_fun_bal_headers...
SHRD0117: Inserted 33 record(s) into FUN_BAL_HEADERS_GT

SHRD0181: glpciba() - sqlstmtbuf =
INSERT INTO FUN_BAL_LINES_GT(
group_id,
bal_seg_val,
entered_amt_dr,
entered_amt_cr,
accounted_amt_dr,
accounted_amt_cr,
generated,
ccid)
SELECT
JEL.je_header_id,
CC.SEGMENT1,
JEL.entered_dr,
JEL.entered_cr,
JEL.accounted_dr,
JEL.accounted_cr,
'N',
JEL.code_combination_id
FROM GL_JE_BATCHES JEB,
GL_JE_HEADERS JEH,
GL_JE_LINES JEL,
GL_CODE_COMBINATIONS CC
WHERE JEB.chart_of_accounts_id = :coa_id
AND JEB.posting_run_id = :prun_id
AND JEB.status = 'I'
AND JEB.actual_flag != 'B'
AND JEH.je_batch_id = JEB.je_batch_id
AND JEH.multi_bal_seg_flag = 'I'
AND JEH.currency_code != 'STAT'
AND JEL.je_header_id = JEH.je_header_id
AND CC.code_combination_id = JEL.code_combination_id

SHRD0181: glpciba() - sqlstmtbuf(len) =
775
SHRD0180: glpciba() - Performing action >> insert_fun_bal_lines...
SHRD0117: Inserted 2267 record(s) into FUN_BAL_LINES_GT


>> fun_bal_pkg() 17-MAY-2011 17:22:15
SHRD0181: glpciba() - fun_bal_pkg ret_status = U

<x fun_bal_pkg() 17-MAY-2011 17:22:15

<x glpciba() 17-MAY-2011 17:22:15

<x glpiil() 17-MAY-2011 17:22:15

>> glpuch() 17-MAY-2011 17:22:15
SHRD0180: glpuch() - Performing action >> update_cons_history(G/D/F)...

<< glpuch() 17-MAY-2011 17:22:15

>> glpueh() 17-MAY-2011 17:22:15
SHRD0180: glpueh() - Performing action >> update_elim_history(G/D/F)...

<< glpueh() 17-MAY-2011 17:22:15

>> glpsqx() 17-MAY-2011 17:22:15

<< glpsqx() 17-MAY-2011 17:22:15

>> glucmt() 17-MAY-2011 17:22:15

<< glucmt() 17-MAY-2011 17:22:15
PPOS0002: Posting terminated with fatal errors



Use the following to check current file version:
select text
from user_source
where upper(name) = upper('FUN_BAL_PKG')
and text like '%$Header%';

file versions being used currently:
"/* $Header: funbalpkgb.pls 120.31.12010000.31 2010/05/18 11:41:06 abhaktha ship $ */
"/* $Header: funbalpkgs.pls 120.8 2006/09/22 14:43:28 bsilveir noship $ */

Patches already applied and issue still exists:
Patch 9366101 is applied
Patch 9239090 is applied

Changes

Upgrade to Release 12.1.3

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