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

Last updated on JANUARY 23, 2024

Applies to:

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 '<EIID1>'
  Expenditure Item ID='<EIID2>'
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

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.