PRC: Generate Draft Revenue for a Single Project fails with AutoAccounting Error (Doc ID 1922955.1)

Last updated on MAY 13, 2024

Applies to:

Symptoms

PARGDR_SINGLE module: PRC: Generate Draft Revenue for a Single Project fails with AutoAccounting Error.

...AutoAccounting function=Generate Expense Report Revenue
...slf=ER
...sqlcode=1403 rows_this_time=1 last_time=0 total=1

Entering paaaui()
Current system time is 03-SEP-2014 12:48:41
Entered paaffc
paaffc::1
paaffc::2
paaffc::2
select CODE_COMBINATION_ID,
enabled_flag,
nvl(to_char(start_date_active, 'J'), -1),
nvl(to_char(end_date_active, 'J'), -1),
SEGMENT4||'.'||SEGMENT1||'.'||SEGMENT2||'.'||SEGMENT3||'.'||SEGMENT5||'.'||SEGMENT6||'.'||SEGMENT7||'.'||SEGMENT8||'.'||SEGMENT9||'.'||SEGMENT10||'.'||SEGMENT11,detail_posting_allowed_flag,summary_flag
from GL_CODE_COMBINATIONS
where CHART_OF_ACCOUNTS_ID = ##
and SEGMENT4 is null
order by SEGMENT4, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11
paaffc : num_flex = 
paaffc: Before paafui call check: mc_ptr=0, mc_end_ptr=0
Warning in Flex Validation for line '<ID>:1:ALL'
Null GL# <glid> key flexfield is not allowed
paafui: In paafui, decrementing mcptr: mc_ptr=1, mc_end_ptr=0
Leaving paaaui()
Current system time is 03-SEP-2014 12:48:56

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.