PRC: Generate Cost Accounting Events fails with error ORA-01722 and Fatal error in Auto Accouning (Doc ID 1919805.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

PAGCAE module: PRC: Generate Cost Accounting Events faisl with the following error

Error:
paaffc: After paafui call check: mc_ptr=6, mc_end_ptr=499 no_of_rows=3229
last_total=200749 num_flex=12345 sqlcode=1403 sqlerrd=1
In paaffc: Broke out of for last total sqlcode=1403 paafmcuid[499]
Leaving paaaui()
Current system time is 29-SEP-2014 20:45:25
*****************************
       500 ROWS to process
-(AA FAILED) Updating expenditure items:
-Number to be processed    100
...Updating rejection reason in cost distribution lines
Current system time is 29-SEP-2014 20:45:25
      100 UPDATED rows
-Completed rejecting failed expenditure items
-(AA SUCCEEDED) Transferring usage cost summary :
-Number to be processed    100
...Marking CDL for select for summary
Current system time is 29-SEP-2014 20:45:25
passum: ORACLE Error marking CDL for select for summary

passum: ORA-01722: invalid number
                                          

pasmvaa: Error in pascdl()

ORACLE Error marking CDL for select for summary
pasmvaa: ORA-01722: invalid number
                                          

pasmv: Fatal error in Auto Accouning

pasmv: Error in passet()

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