My Oracle Support Banner

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

Last updated on AUGUST 17, 2018

Applies to:

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


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]
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]
paxsql01: val[24


To view full details, 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 a vibrant support community of peers and Oracle experts.