PRC: Generate Cost Accounting Event Exception: Auto Accounting Could Not Create Flexfield (Doc ID 1636672.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PAGCAE module: PRC: Generate Cost Accounting Events  completes with the following exception:

Auto Accounting could not create flexfield

The log contains the following error:

paxsql 1: val[24]
paxsql 2: v[24] val0[24]
PA_AA_TOO_MANY_ROWS|RULE|ABC EMPLOYEE COMPANY
Warning in Auto Accounting for line '63853'
  Expenditure Item ID='64934'
paxsql: Executing sql [select cc.segment4
from hr.per_all_people_f f,
hr.per_all_assignments_f af,
gl.gl_code_combinations cc,
pa.pa_expenditures_all e,
pa.pa_expenditure_items_all ei
where ei.expenditure_item_id = :1
and e.expenditure_id = ei.expenditure_id
and f.person_id = e.incurred_by_person_id
and af.person_id = f.person_id
and ei.expenditure_item_date between f.effective_start_date and f.effective_end_date
and ei.expenditure_item_date between af.effective_start_date and af.effective_end_date
and cc.code_combination_id = af.default_code_comb_id]
paxsql: Rule [ABC EMPLOYEE COMPANY]
paxsql01: val[24

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