"Import Price Catalogs" Concurrent Request Errors Out with PLS-00306: wrong number or types of arguments in call to 'START_PROCESS' (Doc ID 2048183.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

When attempting to run 'Import Price Catalogs' concurrent program,
the following error occurs.

ERROR

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

STEPS

The issue can be reproduced at will with the following steps:

1. Populate the data into PO Interface tables.
2. Run 'Import Price Catalog' program.

Changes

 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)

Cause

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