PAGCAE: PRC Generate Cost Accounting Ends In Error ORA-01427 (Doc ID 2745582.1)

Last updated on NOVEMBER 18, 2022

Applies to:

Symptoms

PAGCAE: PRC: Generate Cost Accounting Events errors with the following:

Firing rule 'XX USAGE COST CLEARING BARS RULE' ...
  Expenditure Item ID='xxxxx'
paxsql: Executing sql [select DECODE((select SUBSTR(v.COMPILED_VALUE_ATTRIBUTES,5,1) from APPLSYS.FND_FLEX_VALUES v, APPLSYS.FND_FLEX_VALUE_SETS f where f.FLEX_VALUE_SET_NAME = 'XX ACCOUNT' and v.FLEX_VALUE_SET_ID = f.FLEX_VALUE_SET_ID and v.FLEX_VALUE = o.ATTRIBUTE2),'R',
'0000000',o.ATTRIBUTE3) from PA_EXPENDITURE_ITEMS_ALL pe, PA_NON_LABOR_RESOURCE_ORGS o where pe.non_labor_resource = o.non_labor_resource and pe.organization_id = o.organization_id and pe.EXPENDITURE_ITEM_ID = :1]
AA-paxsql
pascdl => : 3 SETS of parameters

pasmvaa: Error in pascdl()

  3 SETS of parameters
pasmvaa: ORA-01427: single-row subquery returns more than one row
  

pasmv: 3 SETS of parameters

pasmv: Error in passet()
 
main: Create Accounting Events for Costs failed

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.