Skip to main content

TXK/ADOPValidationUtils.pm Use of uninitialized value $result in split at /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.

ADOP prepare phase failed with below error:
 
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation below error reported in log adop logfile: 

 /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.
 No such file or directory /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230. 

solution: To fix this issue test the following to upload the missing PATCH context file to the database: step 1. Get the value of your patch context file. set the patch enviorment echo $CONTEXT_FILE 

step2 : Execute the following command on the run filesystem to upload the patch context file to the database.

  $ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer action=upload contextfile='/u01/applprod/fs1/inst/apps/TESTDB2_ebs_appnode28v/appl/admin/TESTDB2_ebs_appnode28v.xml' logfile=/tmp/patchctxupload.log 

Step 3: Following query to check the updated context file

 SQL> select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch'; 

PATH -------------------------------------------------------------------------------- /u01/applprod/fs1/inst/apps/TESTDB2_ebs_appnode28v/appl/admin/TESTDB2_ebs_appnode28v.xml
Labels:

Comments

Post a Comment

Popular posts from this blog

EBS R12 “Unable to Authenticate Session”

Oracle E-Business Suite environment with IE8 and higher, When  cloning the EBS envitorment or you are logging out from your DEV Instance and want to login to  PROD-Instance it happens “Unable to authenticate session” Go to all programs, Right click on your IE icon and add -noframemerging to the end of the link in the Target field e.g.”C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging (shown below) 1)  Start -> Program Files 2)  Right click on the Internet Explorer icon and select Properties 3)  Add -nomerge to the end of the link in the Target field i.e. “C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging 4)  Click the OK button to close the window 5) Stop all Browser sessions. 6) Start a new Browser session and logon to the Instance
Post a Comment
Read more

EBS Standby Role Tranistion using standby database and standby application Tier

 Role Transitions A database can operate in either a primary or standby role - these roles are mutually exclusive. Oracle Data Guard enables you to change these roles dynamically by issuing SQL commands, and supports the following transitions: Switchover Allows the primary database to switch roles with one of its standby databases. There is no data loss during a switchover. After a switchover, each database continues to participate in the Oracle Data Guard configuration with its new role. Failover Changes a standby database to the primary role in response to a primary database failure. The following role transitions are discussed: 6.1 Performing a Switchover 6.2 Performing a Failover 6.3 Performing a Switchback to the Primary Following A Switchover/Failover Each of these three transitions requires some application configuration to be performed. Most of the application configuration step...
1 comment
Read more

adgrants issue with 19c PDB database

 adgrant - system.fnd_oracle_userid ORA-06550: line 1094, column 17 SP2-0625: Error printing variable "result_set" adgrants issue with 19c PDB database  Connect to a multitenant 19c database and follow below steps to resolve ORA error 1- source the cdb env file  2-set the  ORACLE_PDB_SID=<PDB_NAME>   3- connect as  sqlplus / as sysdba 4- go to location of adgrant and execute cd /u01/app/oracle/product/19.0.0/dbhome_1/appsutil/sql    SQL>  @adgrants.sql APPS Note: ignore warnings during adgrant session a d.plsql.ad_zd_sys.GIVE_PRIVILEGE 
Post a Comment
Read more