R12 R11: PRC: Generate Draft Revenue, PRC: Interface Revenue To General Ledger and Several Distribution Processes Error with sqlcode=1403 and Signal 11 (Doc ID 1557156.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Project Billing - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Project Costing - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

The PATTGL module: PRC: Interface Revenue to General Ledger, PRC:  Generate Draft Revenue and several other PRC:  Distribute processes error with the following in the log file:

paaffc: After paafui call check: mc_ptr=103, mc_end_ptr=239 no_of_rows=8695 last_total=260850 num_flex=8695 sqlcode=0
sqlerrd=260850
paaffc: Before paafui call check: mc_ptr=103, mc_end_ptr=239 no_of_rows=1760 last_total=262610 num_flex=8695 sqlcode=1403
sqlerrd=262610
...
paaffc: After paafui call check: mc_ptr=103, mc_end_ptr=239 no_of_rows=1760 last_total=262610 num_flex=8695 sqlcode=1403 sqlerrd=1
In paaffc: Added solution sqlcode=1403 paafmcuid[103] 365844
/UA4O/appl/pa/11.5.0/bin/PATTGL
Program was terminated by signal 11

This seems to happen the first time a new CCID is being generate when dynamic inserts is enabled. 

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