PRC: Generate Draft Revenue for a Single Project fails with AutoAccounting Error (Doc ID 1922955.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

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 = 50374
and SEGMENT4 is null
order by SEGMENT4, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11
paaffc : num_flex =  9803
paaffc: Before paafui call check: mc_ptr=0, mc_end_ptr=0
Warning in Flex Validation for line '12975777:1:ALL'
Null GL# 50374 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


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