PLS-00306: 'CONTRACTS_CROSS_VAL' Error In CS_SERVICEREQUEST_PVT Package After Applying 12.2.6 CS RUP Patch 27753722:R12.CS.C

(Doc ID 2399501.1)

Last updated on MAY 19, 2018

Applies to:

Oracle Teleservice - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms


CS_SERVICEREQUEST_PVT object is invalid in CS schema, which is not allowing SR creation.
 
ERROR
-----------------------
PLS-00306: wrong number or types of arguments in call to 'CONTRACTS_CROSS_VAL'
PL/SQL: Statement ignored

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

1. Apply patch 27753722:R12.CS.C
2. Check for DB invalids.
3. Run the below SQL statemet to re-compile the package

    ALTER PACKAGE CS_SERVICEREQUEST_PVT COMPILE BODY;

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