"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 07, 2017

Applies to:

Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.

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

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