"Import Price Catalogs" Concurrent Request Errors Out with PLS-00306: wrong number or types of arguments in call to 'START_PROCESS'
Last updated on MARCH 07, 2017
Applies to:Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.
When attempting to run 'Import Price Catalogs' concurrent program,
the following error occurs.
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 'START_PROCESS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
The issue can be reproduced at will with the following steps:
- Populate the data into PO Interface tables.
- Run 'Import Price Catalog' program.
Applied Inv Rollup 11 Patch 20187255:R12.INV.B.delta.11 or Rollup 12 Patch 21218468:R12.INV.B.delta.12
After PDOI Enhancement, POXPDOI concurrent type changed to PLSQL procedure, in ECWCATIB.pls, it still calling this concurrent request with 100 parameters, which causing the PLS-00306 error
This has been explained in the following bug.
Bug 21148453 - WHEN IMPORT PRICE CATALOG IS CALLED FROM ECECATI (IN: PRICE CATALOG (832/PRICAT)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms