My Oracle Support Banner

After Upgrade from 11i to 12, AR Collection Process Fails with PLS-00201: identifier 'CN_COLLECT_INVOICES_<ORG_ID>.COLLECT' must be declared (Doc ID 1299102.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run AR collections after upgrading from Release 11i to Release 12, the following error occurs.

ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'CN_COLLECT_INVOICES_82.COLLECT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SQL", line 1575


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


Attempt ro run collections for receivables and process errors.
Incentive Compensation Manager > Tasks > Collect Transactions
Transaction Source: Receivables Posting
Transaction Type: collect invoices
 

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


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