Friday, September 14, 2012

R12: Contact Center: Package CSC_ACTION_ASSEMBLER_PVT_W Invalid


Solution
To compile the CSC_ACTION_ASSEMBLER_PVT_W package and body manually,
run these statements in SQLplus:

SQL> alter session set "_disable_fast_validate"=TRUE;
SQL> alter package CSC_ACTION_ASSEMBLER_PVT compile;
SQL> alter package CSC_ACTION_ASSEMBLER_PVT compile body;

SQL> alter package CSC_ACTION_ASSEMBLER_PVT_W compile;
SQL> alter package CSC_ACTION_ASSEMBLER_PVT_W compile body;



The "_disable_fast_validate" parameter should be set to true during maintenance operations.
See this Note for further explanation:

Note.1058763.1 Ext/Pub Interoperability Notes EBS R12 with Database 11gR2
https://support.oracle.com/epmos/adf/images/t.gif

1 comment: