Yearly Archives: 2021

Seed Data Table has not been prepared for patching at “APPS.WF_EVENTS+”

When applying ADOP  patch, we getting below error like “APPS.WF_EVENTS+” ORA-20002: Seed Data Table has not been prepared for patching ORA-06512: at “APPS.WF_EVENTS+”, line 1, ORA-04088: error during execution of…

Read More

Keynotes before upgrade the Oracle EBS to 19c database

Container Database (CDB) Architecture: With the Database 19c certification, EBS 12.2 on-premises databases are now certified with the CDB architecture (multitenant architecture). As part of the upgrade to Database 19c,…

Read More

How to apply SSL/HTTPS vendor certificate for apex application deployed on apache tomcat

Description: This article shows how to enable HTTPS for Tomcat. It uses a Third party vendor certificate for wildcard SSL and It should be format of certificate  .jks or .pem.…

Read More

Oracle Cloud 19c Grid and Database Installation in Silent mode.

Now we are going to create an instance in cloud. Create a VM instance. Click compute —>instance—>create instance. Give name to your instance and choose in which compartment you want…

Read More

How to create or rebuild Context file in database DB Tier on R12.2

1. Find out the Template file. [oracle@ebs bin]$ cd $ORACLE_HOME [oracle@ebs 12.1.0]$ cd appsutil/template/ [oracle@ebs template]$ pwd /u01/StageR122/PROD/12.1.0/appsutil/template [oracle@ebs template]$ ls -l adxdbctx.tmp -rwxrwxrwx 1 oracle oinstall 23871 Dec 29…

Read More

ADOP STATUS – FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] Solution.

Problem : [ebsprd@myebstes01 ~]$ adop -status Enter the APPS password: *******FATAL ERROR******* PROGRAM : (/u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Fri Aug 27 03:42:33 2021 FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] MESSAGES: SQLPLUS…

Read More

ADOP Status – Error FUNCTION: ADOP::GlobalVars::_ValidateArgs [ Level 1 ] – Solution

ADOP Status – Error FUNCTION: ADOP::GlobalVars::_ValidateArgs [ Level 1 ] – Solution Problem: [ebsprd@myebstes01 ~]$ adop status *******FATAL ERROR******* PROGRAM : (/u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Fri Aug 27 03:31:33 2021 FUNCTION:…

Read More

Gather Schema Statistics fails with ORA-20005

Gather Schema Statistics fails with “ORA-20005: Object Statistics Are Locked (Stattype = ALL)” Log file shows the following error, ORACLE error 20005 in FDPSTP Cause: FDPSTP failed due to ORA-20005:…

Read More

Fusion Financial Configuration – Bills Payables

Title : Fusion Financial Configuration – Bills Payables Overview:  Future dated payments or Bills Payable in Fusion Application is used to control the timing of your payments, and therefore control…

Read More

JServer JAVA Virtual Machine Component Is in Removing state

ERROR: JServer JAVA Virtual Machine Component Is in Removing state CAUSE: SQL> select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS —————————————- —————————— ———– Oracle Database Catalog Views 12.1.0.2.0 VALID…

Read More