Getting ORA-00907: Missing Right Parenthesis Running an Allocation (Doc ID 248447.1)

Last updated on FEBRUARY 28, 2017

Applies to:

Oracle Profitability Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
Oracle Performance Analyzer - Version: 4.5

Symptoms

In Oracle Performance Analyzer (PA), you get the following errors running an Allocation ID:

ORA-00907: missing right parenthesis 
1043 Invalid Page 
1018 Allocation ID is empty 
Create table SQL in ORA-00907 error message is bad, missing a column

Example of Bad SQL:

SQL Statement: declare begin ofsa_sql.create table('OFSADEMO',
'OFSPA_DBT_09082003085824 (AS_OF_DATE DATE (,BANK_ID NUMBER(12,0), COST_TYPE_CD NUMBER(14,0), IDENTITY_CODE NUMBER(10,0), ID_NUMBER NUMBER(25,0), ORG_UNIT_ID NUMBER(14,0), PRODUCT_ID NUMBER(14,0), SOURCE_APP VARCHAR2(5), VOLUME_ID NUMBER(14,0), COST NUMBER(18,2), COUNT NUMBER(15,4))', 68697,181000);end;

Note the bad statement: (,BANK_ID NUMBER(12,0).

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