My Oracle Support Banner

PLS-00306: Wrong Number or Types of Arguments in Call To 'FN_ALM_BI_TRANSFORMATION' (Doc ID 2888732.1)

Last updated on MARCH 25, 2024

Applies to:

Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.7 and later
Oracle Financial Services Asset Liability Management - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)

Symptoms

When attempting to run ALM_BI_Transformation for the first time, found two different errors for the same process based on parameters given during the batch run.


Error:

TRANSFORM_DATA_INFODOM_ALM_BI_TEST_20220331_1_Task1_RUNPROCEDURE.log:
[INFO][BACKEND][OFSAA][RUNPROCEDURE] Parameters : FN_ALM_BI_TRANSFORMATION,'INFODOM_ALM_BI_TEST_20220331_3','20220331',264690, 'N'
[INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := FN_ALM_BI_TRANSFORMATION('INFODOM_ALM_BI_TEST_20220331_1','20220331',264690, 'N'); END;
Error Msg :-> ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'FN_ALM_BI_TRANSFORMATION'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Could not Execute

TRANSFORM_DATA_INFODOM_ALM_BI_TEST_20220331_2_Task1_RUNPROCEDURE.log:
[INFO][BACKEND][OFSAA][RUNPROCEDURE] Parameters : FN_ALM_BI_TRANSFORMATION,'INFODOM_ALM_BI_TEST_20220331_6','20220331',264690, 'N', 'N'
[INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := FN_ALM_BI_TRANSFORMATION('INFODOM_ALM_BI_TEST_20220331_2','20220331',264690, 'N', 'N'); END;
[INFO][BACKEND][OFSAA][RUNPROCEDURE] Fetching the return status.
[INFO][BACKEND][OFSAA][RUNPROCEDURE] Return value From the Stored Procedure : 0
[SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Error code returned : 398603629
[INFO][BACKEND][OFSAA][RUNPROCEDURE] execPackage : return val : 0
[INFO][BACKEND][OFSAA][RUNPROCEDURE] After Calling execProc
[SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Stored procedure execution failed

Steps To Replicate:
1. Run ALM process successfully. Output Move Results to ALM BI Mart is not checked.
2. Run ALMBI Transformation via Batch Operations.
3. Use Parameter <Process ID>,'N', the process failed with PLS-00306: wrong number or types of arguments in call to 'FN_ALM_BI_TRANSFORMATION'.
4. Use Parameter <Process ID>,'N','N'  the process failed with Stored procedure execution failed.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.