AutoAccounting Rules are Truncated when SQL Statements Exceed 250 Characters Signal 11 error (Doc ID 1211796.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Project Costing - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

PRC: Generate Cost Accounting Events completes with Signal 11 Error.

Log File shows "Program was terminated by signal 11" after PASGLT.

 

An AutoAccounting Rule is being truncated when the length of the SQL statement is greater than 250 characters. This issue seems be related to Bug 1414808: AUTOACCOUNTING RULES (PAXAADRU)TRUNCATES LENGTHY SQL STATEMENTS > 250 CHARACTERS.

Example of SQL statement that is being truncated:

SELECT NVL(B.SEGMENT_VALUE,'0') FROM
PA_SEGMENT_VALUE_LOOKUP_SETS A, PA_SEGMENT_VALUE_LOOKUPS B,
PA_PROJECT_CLASSES C WHERE A.SEGMENT_VALUE_LOOKUP_SET_NAME =
'ABC LOOKUP NAME' AND A.SEGMENT_VALUE_LOOKUP_SET_ID = B.
SEGMENT_VALUE_LOOKUP_SET_ID AND C.CLASS_CATEGORY = 'XYZ'
AND B.SEGMENT_VALUE_LOOKUP = C.CLASS_CODE AND C.
CLASS_CODE IN (SELECT PPC.CLASS_CODE FROM PA_PROJECT_CLASSES
PPC,PA_PROJECTS_ALL PP,PA_EXPENDITURE_ITEMS_ALL PEI WHERE PPC.
PROJECT_ID = PP.PROJECT_ID AND PP.PROJECT_ID = PEI.PROJECT_ID AND PEI.
EXPENDITURE_ITEM_ID = :1)

The statement above is truncated as follows:

SELECT NVL(B.SEGMENT_VALUE,'0') FROM
PA_SEGMENT_VALUE_LOOKUP_SETS A, PA_SEGMENT_VALUE_LOOKUPS B,
PA_PROJECT_CLASSES C WHERE A.SEGMENT_VALUE_LOOKUP_SET_NAME =
'ABC LOOKUP NAME' AND A.SEGMENT_VALUE_LOOKUP_SET_ID = B.
SEGMENT_VALUE_LOOKUP_SET_ID

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