Web ADI integrator "ORA-06508: PL/SQL: could not find program unit being called"

In custom Web ADI integrator, when code changes are made to the API, then loading of rows fail with the following error: ORA-06508: PL/SQL: could not find program unit being called

Solution:

To implement the solution, please execute the following steps:

1. Run the following sql to clear the shared pool:

SQL>alter system flush shared_pool;

2. Bounce the Apache server:

cd $ADMIN_SCRIPTS_HOME 

1. adapcctl.sh stop
2. adapcctl.sh start

3. adoafmctl.sh stop

4. adoafmctl.sh start

5. adoacorectl.sh stop

           6. adoacorectl.sh start 

3. Retest the issue.