Dimension Member Loader Fails With ORA-06550 And PLS-00306 Errors

(Doc ID 551178.1)

Last updated on JANUARY 30, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 12.0.3
This problem can occur on any platform.
Dimension Member Loader


-- Problem Statement:
On 12.0.3, when attempting to load dimension members through the WebADI spreadsheet loader, the
following error occurs in the generated Dimension Member Loader request log:

Parent request 10213005
Sub-request 10213006 encountered an unexpected error and could not continue.
ORA-06550: line 1, column 131:
PLS-00306: wrong number or types of arguments in call to 'PRE_VALIDATION'
ORA-06550: line 1, column 131:
PL/SQL: Statement ignored

No records are written to any of the interace _T tables and the spreadsheet upload completes with
green happy face.  The same errors occur when running the Dimension Member Loader concurrent program standalone.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Fill out spreadsheet for Company Cost Center Organization new dimension member
2. Click Oracle -> Upload in spreadsheet
3. Check View Log of generated 'Dimension Member Loader' request

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot create any of their dimension members.


Upgrade to R12 from R11


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