Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15

Error:

We are getting below error while installing UPK Server and Client on windows server 2012 R2.

UPK client / server Installation fails with a Library Loader log:

@ System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]:
@ ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored (Fault Detail is equal to An ExceptionDetail,
@ likely created by IncludeExceptionDetailInFaults=true, whose value is:
@ Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored

Fix:

Stop the installer before running Library Loader and manually add grant permissions.

Steps:

• Drop the tablespace and users.  Start a fresh installation.
• Create a setupdiag.ini

Locate the ..\setup\Branding\UPK\Installer folder

Create a new notepad file called setupdiag.ini

Open the file and enter the following:

[SetupDebug]

Stopbeforelibraryloader=1

Save and close the file.

• Create a setupdiag.ini
• Start installer and enter credentials desired to be created
• Installer pauses 
• Grant the execute privileges

• Log in as SYSDBA, run the the following queries:

grant execute on sys.dbms_lob to ODSERVER;

grant execute on sys.dbms_lob to ODSERVER_APP;

•  Log into Oracle with the credentials of the schema created (i.e.,ODSERVER)

• Run the following query:

select object_name, object_type from obj where status !='VALID';

returned two FUNCTIONS:

ADD_PART

PART_EXISTS

•  Recompile the invalid objects

alter compile;

example: alter FUNCTION ADD_PART compile;

example: alter FUNCTION PART_EXISTS compile;

• Let installer continue

• Click Finish

ORA-20008 When Running "adop phase=prepare"

Error while running command: adop phase=prepare

ERROR at line 1:
ORA-20008: No Concurrent Manager is defined that can run concurrent program ADZDPATCH
ORA-6512: at "APPS.AD_ZD_ADOP", line 240

Fix:

Set the Run filesystem / environment and run command:

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE

[ERROR]: The value of s_file_edition is not set correctly in at least one of the context files

When attempting to run adop phase=prepare, the following error occurs.

[ERROR]: JDK TOP (or FMW JDK TOP) is not set up correctly.
[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
[ERROR]: Some of the ports specified for the patch file system are not available.
[ERROR]: The value of s_file_edition is not set correctly in at least one of the context files
[ERROR]: The values of s_current_base and s_other_base are not set correctly on both RUN and PATCH filesystems

Fix:

Delete duplicate context files and run autoconfig to create new ones.

1.Please backup FND_OAM_CONTEXT_FILES

SQL>create table FND_OAM_CONTEXT_FILES_BK as select * from FND_OAM_CONTEXT_FILES;

2.Please clear data from FND_OAM_CONTEXT_FILES table.

SQL>delete from FND_OAM_CONTEXT_FILES;

3.Please execute autoconfig from all nodes.

cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh

4.Please confirm the new data from FND_OAM_CONTEXT_FILES;

SQL>select * from FND_OAM_CONTEXT_FILES;

5.Please execute the adop again.


Note: The patch file system context file is needed for adop to complete. Enoking the patch edition and running autoconfig on it should resolve that issue.

FRM-92101:There was a failure in the forms server during startup.

After upgrading to EBS 12.1.3 the following error appears when launching forms:

FRM-92101:There was a failure in the forms server during startup.

CAUSE:

Incorrect soft link to ldflags.

The ldflags softlink pointed to an incorrect file :
ls -atlr $ORACLE_HOME/lib32/ldflags

$ORACLE_HOME/lib32/ldflags ===> Patch Directory/RUP4XB6/apps/tech_st/10.1.2/lib/ldflags

SOLUTION:

Please execute the following steps to resolve the issue:

• Point the link to $ORACLE_HOME/lib/ldflags.

• Change into $ORACLE_HOME/forms/lib32 directory.

• Relink Forms : (make -f ins_forms.mk install)

• Restart the Forms-Server and retest the login.

"adop phase=finalize" Fails As ADOP Cannot Detect Any Application Tier Nodes In FND_NODES table. Ensure ICM is running and run autoconfig on all nodes

When attempting to perform "adop phase=finalize" the following error occurs.

ERROR
[UNEXPECTED]adop cannot detect any application tier nodes in FND_NODES table. Ensure ICM is running and run autoconfig on all nodes
[UNEXPECTED]Error while checking if this is a multi node instance

The issue occurs due to a null value for the concurrent/admin node status column in table FND_NODES.

More details are available via the following unpublished defect:
Bug 18533116 - AD:ADOP IN HOTPATCH FAILED FOR R12.TXK.C.DELTA.5

"In AD.Delta.4+one off patches we have a dependency on FND_NOTES.STATUS column

The column will be automatically set to 'Y' when ICM is up.

When the ICM is down the query will not detect any nodes with status 'Y',  and adop proceeds with only the current/admin node (inserts rows into AD_ADOP_SESSIONS for current/admin node only."

Fix:

To resolve the issue, test the following steps in a development instance and migrate accordingly:
Test the following steps:

    A. Set the "run" Application Tier environment
    B. Start ICM
    C. Run "adop phase=finalize" again.

Ref: (Doc ID 1904735.1)

After Upgrading EBS 12.2.5, Users Are Unable To Login And Receive The Following Error: "URL Validation Failed"

After an E-Business Suite 12.2 upgrade, user login fails with the following error:

Error

URL validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists, Please contact system administrator.

Fix:

Disable maintenance mode for the system to work as intended.

To resolve the issue, test the following steps in a development instance and migrate accordingly:

1. Check if maintenance mode is enabled via th following sql:

select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

2. If the status of the above select does not return 'NORMAL', then maintenance mode is enabled. In this case disable it via the following sql:

sqlplus <APPS_Schema name>/<APPS Password>@adsetmmd.sql | DISABLE

Ref: (Doc ID 1592363.1)

Issues While Re-starting 12.2.4 RUP Patch 17919161 Failed With ORA-04063, ORA-06508, ORA-06512 on FND_CONC Package Invalid

When applying Oracle E-Business Suite 12.2.4 Release Update Pack Patch 17919161 on the run edition application environment, using downtime mode getting the error below:

$ adop phase=apply apply_mode=downtime patches=17919161 restart=yes

Error:

SQL> select ad_zd_adop.is_icm_alive() from dual
  *
ERROR at line 1:
ORA-04063: package body "APPS.FND_CONC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CONC"
ORA-06512: at "APPS.AD_ZD_ADOP", line 1635
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[UNEXPECTED] Error occurred

Cause:

An invalid FND_CONC package.

The error in the adop log file shows the following object is invalid and it needs to be validated so the patch can continue:

ERROR at line 1:
ORA-04063: package body "APPS.FND_CONC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CONC"
ORA-06512: at "APPS.AD_ZD_ADOP", line 1635


Fix:

1. Run the script $FND_TOP/patch/115/sql/AFCPDIGB.pls to validate the FND_CONC package:

sqlplus apps/<appspwd> @$FND_TOP/patch/115/sql/AFCPDIGB.pls

2. Re-run adop.

Ref: (Doc ID 1926427.1)