PARGDR Errors - Autoaccounting Error 1403 (Doc ID 1067002.1)

Last updated on OCTOBER 10, 2023

Applies to:

Symptoms

When running PRC: Generate Draft Revenue for a Single Project, it fails with an autoaccounting error.

Then error in the log is seen as below,

...AutoAccounting function=Generate Project_Journal Revenue
...slf=PJ
...sqlcode=1403 rows_this_time=1 last_time=0 total=1

select CODE_COMBINATION_ID,
enabled_flag,
nvl(to_char(start_date_active, 'J'), -1),
nvl(to_char(end_date_active, 'J'), -1),
SEGMENT3||'.'||SEGMENT1||'.'||SEGMENT2||'.'||SEGMENT4||'.'||SEGMENT5||'.'||SEGMENT6,detail_posting_allowed_flag,summary_flag from GL_CODE_COMBINATIONS
where CHART_OF_ACCOUNTS_ID = COA_ID
and SEGMENT3 is null
order by SEGMENT3, SEGMENT1, SEGMENT2, SEGMENT4, SEGMENT5, SEGMENT6
paaffc : num_flex = (num_flex value)
paaffc: Before paafui call check: mc_ptr=0, mc_end_ptr=0
Warning in Flex Validation for line '61:1:ALL'

Null GL# (GL#) key flexfield is not allowed

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.