AMS: Activate Schedule Program Fails With Errors APP-FND-01564 ORA-04068 For Package FND_CONCURRENT (Doc ID 190069.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Marketing - Version 11.5.8 to 12.0 [Release 11.5 to 12.0]
Information in this document applies to any platform.
AMSACTSCH
***Checked for relevance on 29-Jun-2014***


Symptoms

AMSACTSCH - AMS:Activate Schedule Concurrent Program fails with errors.

The AMS Activate Schedule concurrent program will pick up all the Campaign Schedules which are in Available status and for which the start date has passed and its Campaign is active and make the Schedule Active.

Log File Errors
APP-FND-01564: ORACLE error 4068 in afpirq
Cause: afpirq failed due to ORA-04068: existing state of packages has been discarded
ORA-04063: package body "APPS.FND_CONCURRENT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was: begin
Fnd_Concurrent.Init_Request; end; and was executed from the file &ERRFILE. 
 

Steps To Reproduce

Responsibility: Oracle Marketing Administrator
Navigate: Concurrent Programs

- Submit new request
- Single request
- Run program AMS: Activate Schedule
- Program completes with Errors

To determine the exact invalid packages or view and the errors:

1. Check for Invalid FND objects on system

SELECT owner, object_type, object_name
FROM dba_objects
WHERE status = 'INVALID' 

This will show the following FND packages are invalid:

2. Recompile the packages and/or views 

ALTER PACKAGE <package_name> compile body;

ALTER VIEW <view_name> compile;


Alter package FND_CONCURRENT compile body
Warning: Package Body altered with compilation errors.

alter package FND_CP_GSM_IPC compile body;
Warning: Package Body altered with compilation errors.

alter view FND_CP_SERVICES_VL compile;
Warning: View altered with compilation errors.

You still receive error messages. The packages and view will not compile successfully.

You can retrieve the errors for the package/view with: 

SELECT text 
FROM dba_errors 
WHERE name='<package/view name>;

 

Errors for PACKAGE BODY FND_CONCURRENT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2168/12 PL/SQL: SQL Statement ignored
2170/19 PLS-00905: object APPS.FND_CP_SERVICES_VL is invalid 
 
Errors for PACKAGE BODY FND_CP_GSM_IPC:
LINE/COL ERROR
-------- -----------------------------------------------------------------
214/6 PL/SQL: SQL Statement ignored
214/13 PLS-00201: identifier 'GSM_INTERNAL_STATUS' must be declared
547/5 PL/SQL: SQL Statement ignored
548/6 PLS-00417: unable to resolve "GSM_INTERNAL_STATUS" as a column
584/5 PL/SQL: SQL Statement ignored
585/6 PLS-00417: unable to resolve "GSM_INTERNAL_STATUS" as a column 

Errors for PACKAGE BODY FND_MANAGER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
683/3PL/SQL: SQL Statement ignored
692/37 PLS-00390: undefined column 'DEBUG_TYPE'in INSERT statement
707/3 PL/SQL: SQL Statement ignored
710/5 PLS-00390:undefined column 'SERVICE_PLURAL_NAME' in INSERT statement 

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