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

Last updated on JULY 07, 2023

Applies to:

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

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 

Changes

Cause

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