Posting: ORA-1403 in glpire, Combination is Disabled

By
Advertisement
Problem:



fact: Oracle General Ledger
·  fact: GLPPOS - Posting
·  symptom: Posting program ends with errors
·  symptom: This combination is disabled.(ROUTINE=fdfvcc)
·  symptom: SHRD0030: glpire()encountered an error returning from errexit:
·  symptom: ORA-01403: no data found
·  symptom: SHRD0042: Error in ROUTINE: glpire, status: 0
·  change: NOTE ROLE: Error stack:
>> glpire()05-JAN-2001 16:04:38
This combination is disabled.(ROUTINE=fdfvcc)
24-301-10-000000-341010-000-0000-000-0000-0000
SHRD0030:glpire() encountered an error returning from errexit:
<x glpire() 05-JAN-200116:04:38
SHRD0042: Error in ROUTINE: glpire, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid:   sqlabc: 0sqlcode:  0  sqlerrml: 0
sqlerrmc:
ORA-01403: no data found
        
sqlerrp:        sqlerrd: 0 0 1 0 0 0
sqlwarn:sqltext: 
*****************************************************
SHRD0044:Process logging off database and exiting ...
>> glpuch() 05-JAN-2001 16:04:38
<<glpuch() 05-JAN-2001 16:04:38
>> glpdit() 05-JAN-2001 16:04:38
<< glpdit()05-JAN-2001 16:04:39
PPOS0002: Posting terminated with fatal errors
<x glpmai() 05-JAN-200116:04:39
+---------------------------------------------------------------------------+
Executing request completion options...


Cause:

A retained earnings account combination is disabled. Retained Earnings accounts for all balancing segment values must be
enabled. If not existing already, and dynamic insertion is enabled, there
must not be any security or cross validation rules that will prevent
their creation. If dynamic insertion is not enabled, you must pre-create
the accounts.

Fix:





Enable the account combination that is pointed out as disabled in the log. Go to the GL Accounts form (Setup..Accounts..Combinations), query the combination, 
check the enabled flag and save. For example:
 
If the log says:
This combination is disabled.(ROUTINE=fdfvcc)
  24-301-10-000000-341010-000-0000-000-0000-0000
 
Enable account combination:
  24-301-10-000000-341010-000-0000-000-0000-0000