Oracle Errors and Error Codes

ORA-06550 (wrong number or types of arguments)

+---------------------------------------------------------------------------+
XXEXPD Custom: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

XXEXPD_AP_CREATE_MV: Expd Create Materialized View
+---------------------------------------------------------------------------+

Current system time is 26-JUL-2018 09:13:45

+---------------------------------------------------------------------------+

**Starts**26-JUL-2018 09:13:45
**SQL error and free**26-JUL-2018 09:13:45
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXEXPD_CREATE_MV'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
.

The SQL statement being executed at26-JUL-2018 09:13:45
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size: 
0

+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Manager encountered an error while attempting to start your immediate 

concurrent program &PROGRAM. Routine &ROUTINE received a return code of failure.

Contact your support representative.
Concurrent Request for "Expd Create Materialized View" has completed with error.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 26-JUL-2018 09:13:49

+---------------------------------------------------------------------------+

Solution:

For a Procedure or Function Need to provide the default parameters error_buf and retcode, 

when registering in oracle apps concurrent program.