Generated by All in One SEO v5.0.0.1, this is an llms.txt file, used by LLMs to index the site.

# Oracle Solutions

We believe in delivering tangible results for our customers in a cost-effective manner

## Sitemaps

- [XML Sitemap](https://oraclesolutions.pk/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [Custom JavaScript in Oracle Apex](https://oraclesolutions.pk/custom-javascript-in-oracle-apex/) - Extending APEX Applications Beyond Declarative Features One of the things I like about Oracle APEX is that many application requirements can be handled without writing code. Dynamic Actions, validations, processes, and built-in components cover a large number of common use cases. But sometimes an application needs something more specific. Maybe a button needs custom behavior,
- [How to update timezone from 32 to 42](https://oraclesolutions.pk/how-to-update-timezone-from-32-to-42/) - Learn how to update timezone from 32 to 42 on Oracle Cloud RAC 2 Node in DbaaS model in some easy steps. STEPS: show parameter cluster_database alter system set cluster_database=FALSE scope=spfile; show parameter cluster_database alter system set cluster_database=TRUE scope=spfile; show parameter cluster_database SELECT * FROM v$timezone_file; @ upg_tzv_apply.sql
- [How to fix REP-0004 Error: Unable to Open User Preference File](https://oraclesolutions.pk/how-to-fix-rep-0004-error-unable-to-open-user-preference-file/) - Issue faced:REP-0004: Warning: Unable to open user preference file SYMPSTOMS:Concurrent request logfiles have the below error:REP-0004: Warning: Unable to open user preference file Cause:The prefs.ora is either missing or non-accessible. Solution: No prefs.ora file in HOME directory:Oracle Reports will search for the prefs.ora preferences file in the user's HOME directory. You can copy the prefs.ora
- [How to Resolve ApplyDBTechStack Relinking Failure in Oracle EBS Due to JDK Version Mismatch](https://oraclesolutions.pk/how-to-resolve-applydbtechstack-relinking-failure-in-oracle-ebs-due-to-jdk-version-mismatch/) - In this blog we are going to solve the JDK VERSION MISMATCH which is causing the failure of dbTeckStack. perl adcfgclone.pl dbTechStack / 0% completed RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack ERROR while running Apply…Thu Jan 29 08:25:37 2026 ERROR: Failed to execute /DBA/8010_JAN26/12.1.0/appsutil/clone/bin/adclone.pl Please check logfile. [ora8010@devapp logs]$ ls -lrttotal 20-rw-------. 1
- [Migrating On-Premises Oracle Databases to Google Cloud Platform: A Windows to Linux Transformation](https://oraclesolutions.pk/migrating-on-premises-oracle-databases-to-google-cloud-platform-a-windows-to-linux-transformation/) - Step by step Migration of On-Premises Oracle Databases to Google Cloud Platform: A Windows to Linux Transformation /u01/db/12.1.0/dbs/initprodDB.ora alter database create standby controlfile as 'G:\RMAN_BACKUPS\STDBY_11_DEC_2024_EVENING.ctl'; /u01/proddb/db/data =========CREATE A TEST TABLE ON SOURCE PROD ====== create table TEST_TABLE2 (name varchar2(30));insert into TEST_TABLE2 values ('11DEC2024 12:13PM DATA');commit; =============================== MUST CREATE LATEST STANDBY CTL FILE BEFORE STARTING ACTIVITY
- [How to Clone Oracle EBS 12.2.10 & 19c Database](https://oraclesolutions.pk/oracle-e-business-application-database-cloning-document-step-by-step/) - Cloning Database : 19c & Application : EBS 12.2.10 Oracle Linux 7.9 ORACLE MOS DOC. REFERENCE: Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1) [oraprod@erpproddb ~]$ hostname erpproddb.srrco.org.sa [oraprod@erpproddb ~]$ cd $ORACLE_HOME [oraprod@erpproddb 19.0.0]$ cd appsutil/scripts/ERPPROD_erpproddb/ [oraprod@erpproddb ERPPROD_erpproddb]$ perl adpreclone.pl dbTier Copyright (c) 2011, 2014 Oracle Corporation
- [[WARNING] [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ 19c on Oracle Linux 8](https://oraclesolutions.pk/warning-ins-08101-unexpected-error-while-executing-the-action-at-state-supportedoscheck-19c-on-oracle-linux-8/) - "[WARNING] [INS-08101] "We have got this error while we begin the installation Of Oracle database 19c on Oracle Linux 8 Problem $ ./runInstaller -silent -responseFile install/response/db_install.rspLaunching Oracle Database Setup Wizard…[WARNING] [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck'CAUSE: No additional information available.ACTION: Contact Oracle Support Services or refer to the software manual.SUMMARY:- java.lang.NullPointerException
- [Oracle ACE PRO Award To Syed Saad Ali 2025](https://oraclesolutions.pk/oracle-ace-pro-award-to-syed-saad-ali-2025/) - ORACLE ACE PRO AWARD 2025 On 5th June 2025, I received an e-mail once more from the Oracle Corporation with the approval of my application to become an Oracle ACE Pro I’m proud to continue my journey with this amazing community. It’s always a true honor to be part of the Oracle ACE program with the most
- [Oracle ACE PRO Award To Syed Saad Ali](https://oraclesolutions.pk/oracle-ace-pro-award-to-syed-saad-ali/) - ORACLE ACE PRO AWARD On 5th June 2024, I finally received an e-mail from the Oracle Corporation with the approval of my application to become an Oracle ACE Pro I'm proud to continue my journey with this amazing community. It’s always a true honor to be part of the Oracle ACE program with the most awesome
- [Oracle ACE Associate Award To Syed Saad Ali](https://oraclesolutions.pk/oracle-ace-associate-award-to-syed-saad-ali/) - Oracle Ace
- [Oracle ACE Associate Award To Syed Saad Ali 2023](https://oraclesolutions.pk/oracle-ace-associate-award-to-syed-saad-ali-2023/) - ORACLE ACE ASSOCIATE AWARD 2023 On 13th July 2023, I finally received an e-mail from the Oracle Corporation with the approval of my application to become an Oracle ACE Associate I’m proud to continue my journey with this amazing community. It’s always a true honor to be part of the Oracle ACE program with the most awesome
- [Oracle ACE PRO Award To Syed Saad Ali 2026](https://oraclesolutions.pk/oracle-ace-pro-award-to-syed-saad-ali-2026/) - Oracle ACE Pro 2026 – Continuing the Journey Alhamdulillah, I am happy to share that I have once again been recognized as an Oracle ACE Pro for the 2026–2027 Oracle ACE program Year. Being part of the Oracle ACE program is always a special achievement for me. More than recognition, it represents the responsibility to continue
- [Debugging Oracle Apex Applications](https://oraclesolutions.pk/debugging-oracle-apex-applications/) - Finding Problems Faster with the Right Debugging Approach Every Oracle APEX developer eventually faces a situation where a page, report, process, or Dynamic Action does not behave as expected. Sometimes the error is obvious, while other times the application simply doesn't produce the expected result. The important thing is not just finding the error, but
- [Page Items vs Application Items vs Global Items in Oracle APEX](https://oraclesolutions.pk/page-items-vs-application-items-vs-global-items-in-oracle-apex/) - One of the first things every Oracle APEX developer learns is how to create Page Items. They're everywhere—text fields, date pickers, select lists, checkboxes, and more. As applications become larger, you'll also come across Application Items and Global Page Items. At first, these three may seem similar because they all store values. But each serves
- [LOVs in Oracle APEX](https://oraclesolutions.pk/lovs-in-oracle-apex/) - One of the first things users interact with in an Oracle APEX application is a form. Whether they are selecting a department, choosing a city, assigning a vehicle, or picking a date, they are constantly making selections. Imagine if users had to type every value manually—it would not only be slow but would also increase
- [Error Handling in Oracle APEX](https://oraclesolutions.pk/error-handling-in-oracle-apex/) - No matter how carefully we design an application, errors are inevitable. Users may enter invalid data, database constraints can be violated, APIs may become unavailable, or unexpected exceptions may occur during execution. The difference between a good Oracle APEX application and a great one is how these errors are handled.Displaying a message like: ORA-00001: unique
- [Process Vs Procedure Vs Package in Oracle Apex](https://oraclesolutions.pk/process-vs-procedure-vs-package-in-oracle-apex/) - When developing Oracle APEX applications, you'll frequently encounter Processes, Procedures, and Packages. Although they all execute business logic, they are designed for different purposes. Understanding when to use each one is essential for building clean, maintainable, and scalable applications. In this article, we'll explore what each object is, how they differ, and when you should
- [Session Management in Oracle Apex](https://oraclesolutions.pk/session-management-in-oracle-apex/) - When a user logs into an Oracle APEX application, the application needs to remember that user while they move between pages. This is handled through session management. A session maintains the context of a user's interaction with the application, while Session State stores values such as page item and application item values. Understanding this difference
- [Understanding Session State in Oracle APEX](https://oraclesolutions.pk/understanding-session-state-in-oracle-apex/) - When I first started working with Oracle APEX, one concept confused me more than anything else: Session State. I could see page items, buttons, reports, and processes working together, but I often wondered, "How does Oracle APEX remember the values I entered after I click a button or move to another page?" The answer lies
- [Oracle APEX Performance Optimization Techniques](https://oraclesolutions.pk/oracle-apex-performance-optimization-techniques/) - Performance is one of those things that users rarely notice when it's good, but immediately notice when it's bad. A page that loads in one second feels smooth and professional. The same page taking ten seconds often makes users think the application is broken, even if it eventually works. During my journey as an Oracle
- [While running EBS 12.2 rapid cloning perl adcfgclone appsTier on target machine getting error Waiting for the AdminServer to start, Connection to AdminServer failed, AdminServer start failed, Make sure that AdminServer parameters specified in the move plan are correct.](https://oraclesolutions.pk/while-running-ebs-12-2-rapid-cloning-perl-adcfgclone-appstier-on-target-machine-getting-error-waiting-for-the-adminserver-to-start-connection-to-adminserver-failed-adminserver-start-failed-make-sur/) - ISSUE:While running EBS 12.2 rapid cloning perl adcfgclone appsTier on target machine getting error Waiting for the AdminServer to start, Connection to AdminServer failed, AdminServer start failed, Make sure that AdminServer parameters specified in the move plan are correct.Behavior:1. FMW is cloned / created successfully3. But while configuring WLS , it keeps attempting to start
- [Unable to Launch EBS Java Applet FORMS on Linux 8 with error FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Please look into the web-server log file for details.](https://oraclesolutions.pk/unable-to-launch-ebs-java-applet-forms-on-linux-8-with-error-frm-92101-there-was-a-failure-in-the-forms-server-during-startup-this-could-happen-due-to-invalid-configuration-please-look-into-the-web/) - FRM-92101: There was a failure in the Forms Server during startup in a recently cloned EBS App Tier from Linux 7 to Linux 8. This could happen due to invalid configuration.Please look into the web-server log file for details.Check required RPMS are already installed. [root@ebsprod1 ~]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep motifmotif-devel-2.3.4-20.el8 (i686)motif-devel-2.3.4-20.el8
- [Oracle EBS 12.2 JAVA APPLET Cannot complete applications logon you may have entered an invalid applications password](https://oraclesolutions.pk/oracle-ebs-12-2-java-applet-cannot-complete-applications-logon-you-may-have-entered-an-invalid-applications-password/) - Solution: Change the DB Parameter sec_case_sensitive_logonFrom:True To False
- [Attention: New Oracle Learners - How to Raise a Service Request (SR) specifically for Oracle E-Business Suite in My Oracle Support (MOS) Dec-2025 New Interface Release.](https://oraclesolutions.pk/how-to-raise-a-service-request-sr-for-oracle-e-business-suite-in-my-oracle-support-mos-dec-2025-released-attention-new-oracle-learners/) - Recently, I was giving training to one of my Junior Database Associate on how to raise a Service Request (SR) for Oracle E-Business Suite (EBS) using the new My Oracle Support (MOS) portal. Using the upgraded MOS portal this was my first experience too. While working on it, I learned some useful tips and ideas.
- [Fixing ORA-12514: Listener Does Not Know of Service (Oracle EBS CDB/PDB)](https://oraclesolutions.pk/fixing-ora-12514-listener-does-not-know-of-service-oracle-ebs-cdb-pdb/) - The application was down, and a quick SQL*Plus connection was supposed to confirm the database status. Instead of a clean sqlplus login prompt, the screen flashed an error:ORA-12514: TNS: Listener does not currently know of service requested in connect descriptor.While investigation we found that The database was up. The listener was also up and running.
- [How to resolve piled-up Pending Concurrent Requests in Output Post Processor (OPP) and Standard Manager in Oracle EBS 12.2](https://oraclesolutions.pk/how-to-resolve-piled-up-pending-concurrent-requests-in-output-post-processor-opp-and-standard-manager-in-oracle-ebs-12-2/) - In Oracle E-Business Suite, one of the issues faced by EBS administrators is pending concurrent requests stuck in the Output Post Processor (OPP) or Standard Manager. Recently, I encountered a situation where both the OPP and Standard Manager were showing a high number of pending requests, even though the system appeared otherwise healthy. In this
- [Error : 400 Bad Request, Request Header Or Cookie Too Large while downloading EBS 12.2 Forms 10.1.2 Patch on the frustrating and irritating newer Oracle MOS Support Interface.](https://oraclesolutions.pk/error-400-bad-request-request-header-or-cookie-too-large-while-downloading-ebs-12-2-forms-10-1-2-patch-on-the-frustrating-and-irritating-newer-oracle-mos-support-interface/) - Issue: I had to recently download a patch as part of the migration of Oracle EBS 12.2.10 Application from Oracle Linux 7 to 8 and I faced the Error : 400 Bad Request, Request Header Or Cookie Too Large while downloading EBS 12.2 Forms 10.1.2 Patch on the frustrating and irritating newer Oracle MOS Support
- [How to fix Unable to locate 'g++' in Linux 8.10](https://oraclesolutions.pk/how-to-fix-unable-to-locate-g-in-linux-8-10/) - While performing a database tier clone in Oracle E-Business Suite 12.2 on Linux 8.10, you may encounter a failure during the execution of: perl adcfgclone.pl dbTechStack The error that i am getting today is: Unable to locate 'g++' utility in path This issue occurs due to missing OS-level dependencies required for relinking binaries during the
- [How to Perform Basic Health Checks of Oracle E-Business Suite 12.2 Database from the Application Tier (No Direct DB Access Required)](https://oraclesolutions.pk/how-to-perform-basic-health-checks-of-oracle-e-business-suite-12-2-database-from-the-application-tier-no-direct-db-access-required/) - As an Oracle EBS administrator, you may often find yourself in situations where you do not have direct SQL*Plus or SSH access to the database tier — especially in restricted production environments, cloud setups, or when working as an Apps DBA focused on the application tier. The good news is that Oracle Applications Manager (OAM)
- [How to solve JDK VERSION Mismatch during dbTechStack](https://oraclesolutions.pk/how-to-solve-jdk-version-mismatch-during-dbtechstack/) - Cloning an Oracle E-Business Suite (EBS) environment is a routine task for DBAs, but sometimes even a successful preclone can lead to unexpected failures during the dbTechStack configuration phase. Toady we are facing JDK version mismatch, which results in the failure of: perl adcfgclone.pl dbTechStack In this blog, we will walk through a real-world issue,
- [How to Fix "Failed to execute FMW pre-requisite check" Failure on Linux 8](https://oraclesolutions.pk/how-to-fix-failed-to-execute-fmw-pre-requisite-check-failure-on-linux-8/) - While performing an Oracle EBS 12.2 appsTier clone on Linux 8, you may encounter a failure if your preclone backup is sourced from Linux 7. "Failed to execute FMW pre-requisite check" This happens in upgrade or migration scenarios where environments are being moved from older OS versions to modern platforms like Linux 8. In this
- [How to Fix Oracle 19c txkGenCDBTnsAdmin.pl Error – "Can't locate TXK/ARGS.pm"](https://oraclesolutions.pk/how-to-fix-oracle-19c-txkgencdbtnsadmin-pl-error-cant-locate-txk-args-pm/) - While working with Oracle E-Business Suite 19c, generating CDB TNS Admin entries using the txkGenCDBTnsAdmin.pl script may fail on Linux with the following error: Can't locate TXK/ARGS.pm in @INC (you may need to install the TXK::ARGS module) This blog explains the cause and a simple solution to make the script run successfully. Issue run the
- [How to Fix EBS 12.2 AdminServer Start Failed](https://oraclesolutions.pk/how-to-fix-ebs-12-2-adminserver-start-failed/) - While running EBS 12.2 rapid cloning perl adcfgclone appsTier on target machine getting error Waiting for the AdminServer to start, Connection to AdminServer failed, AdminServer start failed, Make sure that AdminServer parameters specified in the move plan are correct. ISSUE Error 1: FINEST : Jun 24, 2025 12:10:52 - [ServerStartUtility:checkAdminServerStartup] Unable to get non ssl
- [How to Replace a Corrupted Undo Tablespace in Oracle RAC Database](https://oraclesolutions.pk/how-to-replace-a-corrupted-undo-tablespace-in-oracle-rac-database/) - Learn step-by-step how to replace a corrupted or problematic undo tablespace in Oracle Database, including creating a new undo tablespace and updating the spfile safely Undo tablespaces are critical in Oracle Database for managing transactions and rollback segments. Occasionally, an undo tablespace may become corrupted, offline, or unusable, causing transaction failures. This blog guides you
- [How to install Telnet on linux 8.10](https://oraclesolutions.pk/how-to-install-telnet-on-linux-8-10/) - During configuration of a DR server, when i try to do telnet from primary to dr, the telnet utility is not working on primary, so this is the procedure to install telnet. ERROR:telnet "IP" 1572bash: telnet: command not found…Install package 'telnet' to provide command 'telnet'? [N/y] y Waiting in queue…The following packages have to be
- [How to Restart Workflow Email Service Quickly and Easily](https://oraclesolutions.pk/how-to-restart-workflow-email-service-quickly-and-easily/) - In this blog we are going to discuss how we can restart the service of workflow email 1. Go to site map2. Click notification mailer3. Select Workflow Mailer Service 4. Open LOV and click on stop all5. Click ok6. Now reload browser until the status set to deactivated7. Now click on start all
- [How to Send a Test Workflow Email to a User](https://oraclesolutions.pk/how-to-send-a-test-workflow-email-to-a-user/) - If you are working with Oracle E-Business Suite and need to test whether the Workflow Notification Mailer is configured correctly, sending a test notification to a specific user is the best way to verify it. This guide will walk you through the complete step-by-step process. Step-by-Step Guide to Send Test Workflow Email1. Go to site
- [Implement SignOn Password Custom Profile](https://oraclesolutions.pk/implement-signon-password-custom-profile/) - How to Implement Signon Password Custom Profile Option in R12.2.X. Reference DOC: How to Implement Signon Password Custom Profile Option in EBS 11i / R12 (Doc ID 362663.1)How to Implement Signon Password Custom Profile Option in EBS 11i / R12KB253549 cd /apps/prod/PROD/fs2/EBSapps/comn/java/classes/oracle/apps/fnd/security/AppsPasswordValidationCUS.java vi AppsPasswordValidationCUS and copy below text in it. My Custom java class
- [Restrict Applications Users To Be Signed In](https://oraclesolutions.pk/restrict-applications-users-to-be-signed-in/) - How Can I Restrict Applications Users To Be Signed In Only Once At Any Time . Reference Doc: (Doc ID 375403.1) GOAL : How to prevent Applications user from login twice? As Per Oracle Support: if XYZ has a previously established session, when he or she wants to log in from another computer, the login
- [Enable Transparent Data Encryption on Oracle EBS](https://oraclesolutions.pk/enable-transparent-data-encryption-on-oracle-ebs/) - Using Fast Online Conversion to Enable Transparent Data Encryption (TDE) for Oracle E-Business Suite with Oracle Database 19c (KA1115). ======================================================================================================================================= Note : NO Downtime required to perform this activity. Important Recommendations------------------------- 1: Ensure the COMPATIBLE database parameter is set to the appropriate database version, 19.0.0.2: Take a full backup of your database before starting the
- [Oracle EBS Advanced Row Compression](https://oraclesolutions.pk/oracle-ebs-advanced-row-compression/) - Oracle E-Business Suite Release 12.2 with Oracle Database 12c Release 1 Advanced Row Compression (KB443050). We should avoid compression on these Objects---------------------------------------------------1. SYSTEM / CORE DATABASE OBJECTSSYSTEMSYSAUXUNDOTEMP ########################################################################################### Following objects can be compressed====1. Interface tables (BEST candidates)----------------------------------------- Following are the temporary tables: AP_*_INTERFACEAR_*_INTERFACEGL_INTERFACEMTL_*_INTERFACEPO_INTERFACE_ERRORS #############################################################################################Never compress the below: These are always HOT:---------------------- MTL_ONHAND_QUANTITIESMTL_MATERIAL_TRANSACTIONSAP_INVOICES_ALL (current data)AR_* active
- [Cloning 19c ERP database](https://oraclesolutions.pk/cloning-19c-erp-database/) - Cloning 19c ERP database -------------------------------- Reference doc : Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1) Directory Structure--------------------Same directory structure as same like source system. SHIRAZI_DATATOP'S---------------------/proddata/oracle/PROD/apps_st/data --> PDB/prodidx/oracle/PROD/apps_st/data --> PDB/redo/oracle/PROD/apps_st/data --> PDB/db/oracle/PROD/oradata/TEST --> CDB Database Binaries path= /db/oracle/PROD/tech_st/19.0.0 Source CDB SID = TEST Tagrget CDB SID = TEST
- [Corrupted Undo Tablespace in an Oracle RAC Database](https://oraclesolutions.pk/corrupted-undo-tablespace-in-an-oracle-rac-database/) - Corrupted Undo Tablespace in an Oracle RAC Database Overview Recently, I came across an issue in one of the Oracle RAC database environments where the undo tablespace became problematic and needed to be replaced safely. Undo tablespaces are a very critical part of Oracle Database because they manage transaction rollback, read consistency, and undo data
- [Cannot identify any valid application tier nodes in ADOP_VALID_NODES](https://oraclesolutions.pk/cannot-identify-any-valid-application-tier-nodes-in-adop_valid_nodes/) - How to Fix “Cannot identify any valid application tier nodes in ADOP_VALID_NODES table” in Oracle EBS R12.2 While applying patches on an Oracle E-Business Suite R12.2 environment using adop, I encountered the following fatal error during the patch apply phase. The patching command was executed as below: adop phase=apply patchtop=/u02/Patch/R12_2/APPS/R12.2.7 patches=25820806,25828573 hotpatch=yes merge=yes After
- [EBS Application Services Failed to Start After Server Crash](https://oraclesolutions.pk/ebs-application-services-failed-to-start-after-server-crash/) - Oracle E-Business Suite R12.2 Application Services Failed to Start After Server Crash Recently, faced an issue in an Oracle E-Business Suite R12.2 environment where the application tier services failed to start after an unexpected server crash. After the server came back online, I attempted to start the application services using the standard adstrtal.sh script. However,
- [Physical Standby Configuration Using RMAN Duplicate](https://oraclesolutions.pk/physical-standby-configuration-using-rman-duplicate/) - Oracle Data Guard 12c Physical Standby Configuration Using RMAN Duplicate and DGMGRL This detailed blog explains how to configure Oracle Data Guard 12c Physical Standby Database using RMAN Active Duplicate and Data Guard Broker (DGMGRL). The guide includes listener configuration, tnsnames setup, standby redo logs, RMAN duplication, broker configuration, and read-only standby testing. Environment Details
- [txkCfgUtlfileDir.pl Error in getUtlFileDir Mode](https://oraclesolutions.pk/txkcfgutlfiledir-pl-error-in-getutlfiledir-mode/) - Fixing txkCfgUtlfileDir.pl Error in getUtlFileDir Mode After Restoring Oracle EBS 19c Database Recently, after restoring an Oracle E-Business Suite database backup on Oracle Database 19c, I faced an issue while executing the txkCfgUtlfileDir.pl utility in getUtlFileDir mode. This script is normally used in EBS 19c environments to fetch or manage the UTL_FILE_DIR configuration during
- [HTTP Service Issue After Sudden Power Shutdow](https://oraclesolutions.pk/http-service-issue-after-sudden-power-shutdow/) - Fixing HTTP Service Issue After Sudden Power Shutdown of Oracle EBS 12.2 Application Server Overview Recently, I faced an issue in an Oracle E-Business Suite 12.2 environment after a sudden power shutdown of the application server machine. After the server was powered on again and the EBS services were checked, I noticed that the
- [Oracle Database RMAN Backup & Recovery – Step by Step Guide](https://oraclesolutions.pk/oracle-database-rman-backup-recovery-step-by-step-guide/) - Oracle Database RMAN Backup & Recovery – Step by Step Guide Introduction:This guide provides a practical, step-by-step approach to configuring RMAN backups in Oracle Database.Prerequisites:- Oracle Database 19c installed- ARCHIVELOG mode enabled- Proper disk space availableStep 1: Verify ARCHIVELOG ModeSQL> archive log list;If not enabled:SQL> shutdown immediate;SQL> startup mount;SQL> alter database archivelog;SQL> alter database open;Step
- [Installing and Configuring MySQL](https://oraclesolutions.pk/installing-and-configuring-mysql/) - Installing and Configuring MySQL 8.0 on Ubuntu for Production Use In this blog, we will walk through the complete installation and basic production-level configuration of MySQL 8.0 on Ubuntu Linux.The guide covers:• Installing MySQL Server• Securing the installation• Understanding important MySQL directories• Configuring performance and binary logging• Enabling Point-in-Time Recovery (PITR)• Creating databases and users•
- [Step-by-Step Guide to Change APPS Password Using FNDCPASS](https://oraclesolutions.pk/step-by-step-guide-to-change-apps-password-using-fndcpass/) - Oracle E-Business Suite R12.2: Step-by-Step Guide to Change APPS Password Using FNDCPASS This blog explains the complete procedure to change the APPS/APPLSYS password in Oracle E-Business Suite R12.2 using FNDCPASS and update the WebLogic Data Sources accordingly. The guide is useful for Oracle Apps DBAs and middleware administrators managing Oracle EBS environments. Overview In Oracle
- [Oracle RAC Architecture Explained (19c & 23ai) – Complete DBA Guide](https://oraclesolutions.pk/oracle-rac-architecture-explained-19c-23ai-complete-dba-guide/) - Oracle RAC Architecture Explained (19c & 23ai) – Complete DBA Guide Introduction Oracle Corporation Real Application Clusters (RAC) is a core technology for high availability and scalability. Unlike traditional clustering, RAC enables multiple nodes to access a single database simultaneously. Key Components of RAC 1. Clusterware Manages node membershipHandles failover 2. ASM (Automatic Storage
- [Copy Password File from Primary to Standby ASM](https://oraclesolutions.pk/copy-password-file-from-primary-to-standby-asm-2/) - Copy Password File from Primary to Standby ASM Recently, while working on an Oracle 19c Data Guard environment, I came across a requirement where the password file from the Primary database needed to be copied to the Standby database. In this environment, the database password file was not located on the normal filesystem. Instead,
- [Step-by-Step Guide to Convert Physical Standby to Snapshot Standby](https://oraclesolutions.pk/step-by-step-guide-to-convert-physical-standby-to-snapshot-standby/) - Complete Step-by-Step Guide to Convert Physical Standby to Snapshot Standby Introduction Recently, I had to work on a requirement where the standby database needed to be opened in read-write mode for testing and validation, without impacting the production primary database. In such cases, Oracle Data Guard provides a very useful feature called Snapshot Standby
- [How to Move SPFILE from ASM to File System](https://oraclesolutions.pk/how-to-move-spfile-from-asm-to-file-system/) - How to Move SPFILE from ASM to File System Recently, I faced a requirement where I had to move the Oracle database SPFILE from ASM to the file system, and in another scenario validate the reverse movement from file system back to ASM. Although this activity is quite straightforward for an Oracle DBA, it
- [Point-In-Time recovery of Oracle Muti-tenant Environment | L0 & L1 Backups restore on Different location](https://oraclesolutions.pk/point-in-time-recovery-of-oracle-muti-tenant-environment-l0-l1-backups-restore-on-different-location/) - Recovery and Restore of Oracle Muti-tenant Environment Scenario: In this scenario we have full backup of entire container and we want to perform point-in-time recovery (PITR) of the entire container on directory structure different than production. NOTE: The procedure will be the same on Standalone and RAC, the only difference will come in picture in
- [Recovery and Restore of Oracle Muti-tenant Environment | Full Backup restore on Different location](https://oraclesolutions.pk/recovery-and-restore-of-oracle-muti-tenant-environment-full-backup-restore-on-different-location/) -  Scenario: In this scenario we have full backup of entire container and we want to restore the entire container on different location or directory structure than production. NOTE: The procedure will be the same on Standalone and RAC, the only difference will come in picture in case of RAC that instead of file system
- [Backup and Recovery Scenario of Oracle 19c Multi-tenant Architecture](https://oraclesolutions.pk/backup-and-recovery-scenario-of-oracle-19c-multi-tenant-architecture/) - Ensuring the preservation of organizational data and preventing data loss is one of the primary responsibilities of a Database Administrator (DBA). This responsibility often takes precedence over any other tasks due to its critical nature. Oracle’s backup and recovery solutions have long been recognized in the market for their robustness and ability to handle a
- [Intro Post for Farhan Ali](https://oraclesolutions.pk/intro-post-for-farhan-ali/) - Intro Post for Farhan Ali 12+ Years as an Enterprise Oracle DBA | Cloud | DR | Performance Enterprise Database Leadership With over 12 years of experience as a Database Administrator, I have worked across enterprise environments managing Oracle Database (10g/11g and beyond), SQL Server, and modern cloud-based database platforms. My focus has always been
- [Intro Post for Mubashir Khan](https://oraclesolutions.pk/intro-post-for-mubashir-khan/) - Intro Post for Mubashir Khan Database and Linux Administrator with strong expertise in managing, optimizing, and securing enterprise IT environments. Skilled in Oracle, MySQL, and PostgreSQL administration, as well as Linux infrastructures (Red Hat, Oracle Linux, Ubuntu). I specialize in: Database Administration: Installation, configuration, backup & recovery (RMAN), performance tuning, security hardening, and troubleshooting. Linux
- [Intro Post for Abdul Khalique Siddiqui](https://oraclesolutions.pk/intro-post-for-abdul-khalique-siddiqui/) - Intro Post for Abdul Khalique Siddiqui With extensive hands-on experience in Oracle technologies, I specialize in delivering secure, scalable, and highly available enterprise environments. My professional journey spans Oracle Database administration, Oracle E-Business Suite (EBS), Oracle Cloud Infrastructure (OCI), and advanced disaster recovery solutions. Over the years, I have implemented, configured, and maintained Oracle E-Business
- [Implementing Oracle Discrete Manufacturing in Apparel Industry](https://oraclesolutions.pk/implementing-oracle-discrete-manufacturing-in-apparel-industry/) - Implementing Oracle Discrete Manufacturing in Apparel Industry Introduction Garment manufacturing is one of the most operationally complex discrete manufacturing domains. Unlike traditional discrete industries, apparel production must simultaneously manage size-based demand variability, ratio-driven cutting, high-volume stitching operations, multi-stage washing and finishing processes, frequent style changes, and unavoidable recut scenarios. These challenges demand not only system
- [Intro Post for Ibrahim Khalil](https://oraclesolutions.pk/intro-post-for-ibrahim-khalil/) - Intro Post for Ibrahim Khalil I’m an experienced Oracle & Cloud Database Engineer with over 8 years of expertise in database administration, high availability, and enterprise-scale performance optimization. This blog is where I share practical lessons, real-world migration strategies, and production-ready best practices from the field. What I Specialize In I work across on-prem and cloud environments, focusing on building scalable, secure, and
- [Oracle APPS R12.2.12 Step by Step Installation](https://oraclesolutions.pk/oracle-apps-r12-2-12-step-by-step-installation/) - Installation Guide: Oracle Apps R12.2.12 on Oracle Linux OEL 7.9 using Oracle VirtualBox Introduction: Welcome to our comprehensive Installation guide for Oracle Apps R12.2.12, the latest release by Oracle, on the Oracle Linux OEL 7.9 platform, utilizing Oracle VirtualBox. This post, along with the subsequent ones, will provide step-by-step instructions to ensure a successful installation.
- [Dataguard Switchover And Failover Using DGMGRL](https://oraclesolutions.pk/dataguard-switchover-and-failover-using-dgmgrl/) - Oracle Data Guard Broker Drill (19c): Switchover + Failover Using DGMGRL (End-to-End Runbook) This week I ran a Data Guard Broker DR drill for a client on Oracle 19c, covering both planned role transition (Switchover) and unplanned role transition (Failover) using the DGMGRL utility. The goal was simple: prove that we can safely switch roles
- [Copy Password File From Primary to Standby ASM](https://oraclesolutions.pk/copy-password-file-from-primary-to-standby-asm/) - Copy Password File From Primary to Standby ASM If you've worked with Oracle Real Application Clusters (RAC) or Data Guard, you know that because the password file lives inside the ASM (Automatic Storage Management) disk group, you can't simply use a standard 'cp' command to move it. Here is a detailed walkthrough of
- [Datapump](https://oraclesolutions.pk/datapump/) - Check Directories ================== SQL> desc DBA_DIRECTORIES; SQL> select * from dba_directories where directory_name='DATA_PUMP_DIR'; =================================================================== Change datapump directory =================================================================== SQL> CREATE OR REPLACE DIRECTORY "DATA_PUMP_DIR" as '/app/oracle/product/11.2.0/dbhome_1/rdbms/log/'; =================================================================== Create a database directory: =================================================================== SQL> CREATE OR REPLACE DIRECTORY tmp AS '/tmp'; ================================================ Grant a user access to the directory:
- [Configuring Oracle Data Guard Broker](https://oraclesolutions.pk/configuring-oracle-data-guard-broker/) - Configuring Oracle Data Guard Broker for High Availability How I recently standardized an existing Primary/Standby setup using Broker (DGMGRL) for simpler HA operations. In one of my recent HA/DR exercises, we already had a working Oracle Data Guard Physical Standby (redo transport + apply was working), but daily operations were still manual for checking
- [RMAN Backup Script for Windows](https://oraclesolutions.pk/rman-backup-script-for-windows/) - RMAN Backup Script for Windows Create Batch file named as rmanbackup.cmd and copy the below given script in that batch file. set oracle_sid=orcl rman target sys/passwd nocatalog cmdfile=’c:\app\rman\rmanbkp.cmd’ log=’c:\app\rman\bkp_log.log’ ————— –rmanbackup.cmd run { allocate channel d1 type disk; backup tag whole_database_open format ‘c:\app\archive\db_%t_%s_p%p’ database; sql ‘alter system archive log current’; sql ‘alter system archive log current’; backup
- [Check existing Weblogic patches in EBS 12.2 that are already applied to your existing EBS App Server](https://oraclesolutions.pk/check-ebs-12-2-weblogic-patches-that-are-applied-already-to-your-existing-ebs-app-server/) - Follow below Steps: export ORACLE_HOME=$FMW_HOME cd $FMW_HOME/utils/bsu./bsu.sh -prod_dir=$ORACLE_HOME/wlserver_10.3 -status=applied -view [appl8000@demo12 bsu]$ ./bsu.sh -prod_dir=$ORACLE_HOME/wlserver_10.3 -status=applied -viewProductName: WebLogic ServerProductVersion: 10.3 MP6Components: WebLogic Server/Core Application Server,WebLogic Server/Administration Console,WebLogic Server/Configuration Wizard andUpgrade Framework,WebLogic Server/Web 2.0 HTTP Pub-Sub Server,WebLogic Server/WebLogic SCA,WebLogic Server/WebLogic JDBCDrivers,WebLogic Server/Third Party JDBC Drivers,WebLogic Server/WebLogic Server Clients,WebLogic Server/WebLogic Web Server Plugins,WebLogic Server/UDDI and Xquery Support,WebLogic Server/Evaluation
- [EBS 12.2 Application Tier Cloning on DMZ/Secondary App Node error out with Insufficient space in /tmp mount point](https://oraclesolutions.pk/ebs-12-2-application-tier-cloning-on-dmz-secondary-app-node-error-out-with-insufficient-space-in-tmp-mount-point/) - ERROR:[root@isupplier tmp]# cat /u01/8052/ebiz8052/fs2/inst/apps/ERPPROD_isupplier/admin/log/clone/fmwT2PApply/CLONE2017-01-18_02-03-38AM.errorSEVERE : Jan 18, 2017 2:06:23 AM - ERROR - CLONE-20275 Insufficient space to create /tmp/CLONINGCLIENT-6554959005609214176.SEVERE : Jan 18, 2017 2:06:23 AM - CAUSE - CLONE-20275 Minimum required space was at least "2,339" MB, but only "2,101" MB was available for use. CAUSE:Insufficient space in /tmp mount point SOLUTION:Option 1: ( If
- [java.lang.OutOfMemoryError: GC overhead limit exceeded error while applying Weblogic Patch](https://oraclesolutions.pk/java-lang-outofmemoryerror-gc-overhead-limit-exceeded-error-while-applying-weblogic-patch/) - ISSUE:[oracle@dev bsu]$ sh bsu.sh -prod_dir=/oradb01/apps/fs1/FMW_Home/wlserver_10.3/ -patch_download_dir=/oradb01/apps/fs1/FMW_Home/utils/bsu/cache_dir/ -patchlist=DI8E -verbose -install >> Apply_WLS_DI8E_1.log Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded at com.bea.cie.common.dao.xbean.XBeanDataHandler.getValueFromObject(XBeanDataHandler.java:598)[oracle@dev bsu]$ CAUSE:bsu.sh MEM_ARGS needs to be increased or cache_dir folder to be cleaned up. SOLUTION OPTION 1: Edit bsu.shMEM_ARGS="-d64 -Xms4096m -Xmx4096m -XX:+UseParallelGC"In my case option 1 did not resolve the issue , So
- [Oracle Optimizer: A Practical Guide For a Good Execution Plan](https://oraclesolutions.pk/oracle-optimizer-a-practical-guide-for-a-good-execution-plan/) - Oracle Optimizer: A Practical Guide For a Good Execution Plan Have you ever seen a critical SQL query run lightning fast one day and unbelievably slow the next—without a single code change? The usual suspect: the Oracle Optimizer choosing a different execution plan. The optimizer constantly adapts based on new statistics, system load, and
- [Troubleshooting Workflow Mailer Errors in Oracle E-Business Suite](https://oraclesolutions.pk/troubleshooting-workflow-mailer-errors-in-oracle-e-business-suite/) - Troubleshooting Workflow Mailer Errors in Oracle E-Business Suite The Workflow Mailer in Oracle E-Business Suite is a critical component for sending notifications and driving business processes. When it fails silently, approvals stall, alerts are missed, and operations can be disrupted. To handle such issues effectively—especially before raising a Service Request (SR) with Oracle Support—you
- [How to redact a Column in a Table Object in Oracle Database 19c](https://oraclesolutions.pk/how-to-redact-a-column-in-a-table-object-in-oracle-database-19c/) - How to redact a Column in a Table Object in Oracle Database 19c Important Considerations 1. Oracle Redaction use requires license for Oracle Advance Security for Oracle Database2. Identify the PII data in your database3. Review the roles & privileges assigned to the Users for unintentional redaction exemption4. Carefully evaluate the data that needs to
- [Creating LVM In Oracle Linux](https://oraclesolutions.pk/creating-lvm-in-oracle-linux/) - Creating LVM In Oracle Linux 1. Ask the System Admin to add a raw disk into the Server 2. Check if the new RAW disk is available / reflected on the Server [oracle@terminal#] lsblkNAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTsr0 11:0 1 482K 0 romvda 251:0 0 100G 0 disk├─vda1 251:1 0 1M
- [ASM Command-Line Utility (ASMCMD) – Complete Guide](https://oraclesolutions.pk/asm-command-line-utility-asmcmd-complete-guide/) - ASM Command-Line Utility (ASMCMD) – Complete Guide for Oracle DBAs Introduction Oracle ASM Command-Line Utility (ASMCMD) is a powerful and essential tool for Oracle DBAs and Grid Infrastructure administrators working with Automatic Storage Management (ASM). ASMCMD provides a UNIX-like interface to manage ASM files and directories, making daily storage operations easier, faster, and more intuitive—especially
- [A Deep Dive into Huge Pages](https://oraclesolutions.pk/a-deep-dive-into-huge-pages/) - A Deep Dive into Huge Pages Recently, was working on optimising an Oracle database server that was struggling with memory management overhead. The server was beefy, sporting 160GB of RAM—but despite the hardware specs, we were seeing latency issues and high CPU usage related to memory access. The culprit? The standard Linux
- [Fixing OPP Concurrent Manager in System](https://oraclesolutions.pk/fixing-opp-concurrent-manager-in-system/) - Fixing OPP Concurrent Manager in System Hold Status Oracle E-Business Suite R12.1.3 (Out-of-Support Environment) While supporting an old customer still running Oracle E-Business Suite R12.1.3, an out-of-support release, I recently encountered an issue where the Output Post Processor (OPP) Concurrent Manager moved into a System Hold state. Legacy EBS environments frequently surface such issues due
- [Purge Concurrent Request and Manager Data - Part1](https://oraclesolutions.pk/purge-concurrent-request-and-manager-data-part1/) - Purge Concurrent Request and Manager Data Program Concept and Effecting Tables Overview To maintain database performance and avoid excessive disk space usage, Oracle EBS provides the FNDCPPUR concurrent program (Purge Concurrent Request and/or Manager Data) for cleaning up historical concurrent request data, logs, and related information. Key Tables Updated by FNDCPPUR Program When the FNDCPPUR
- [Oracle Home 19c Cloning](https://oraclesolutions.pk/oracle-home-19c-cloning/) - Oracle Home 19c Cloning 1. Check the groups assigned to the Oracle Home owner [oracle@test ~]$ . db.env[oracle@test ~]$ cd $ORACLE_HOME/rdbms/lib/[oracle@test lib]$ cat config.c |grep define/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */#define SS_DBA_GRP "oinstall"#define SS_OPER_GRP "oinstall"#define SS_ASM_GRP ""#define SS_BKP_GRP "oinstall"#define SS_DGD_GRP "oinstall"#define SS_KMT_GRP "oinstall"#define SS_RAC_GRP "oinstall" 2. Create
- [ADJRIINITPASSWD ORA-01031 Error in Oracle E-Business Suite](https://oraclesolutions.pk/adjriinitpasswd-ora-01031-error-in-oracle-e-business-suite/) - ADJRIINITPASSWD.sql ORA-01031 Error in Oracle E-Business Suite When running ADJRIINITPASSWD.sql, you may encounter an ORA-01031: insufficient privileges error. This typically occurs when Oracle EBS is unable to retrieve password information from the database vault due to missing grants or context definitions. Below is the complete error and the steps to resolve it. During execution, you
- [ORA-15041: Diskgroup DATA Space Exhausted](https://oraclesolutions.pk/ora-15041-diskgroup-data-space-exhausted/) - ORA-15041: Diskgroup "DATA" Space Exhausted — How to Diagnose & Fix the Issue When working in Oracle RAC/ASM environments, one of the common storage-related issues is ORA-15041: diskgroup space exhausted.This error typically appears when adding datafiles/tempfiles or when Oracle internally tries to allocate space. In this example, the issue occurs while adding a TEMPFILE. 
- [EBS 12.2 cloning adcfgclone.pl appsTier fails on Linux 8 when the precloned tar backup is sourced from a Linux 7 environment.](https://oraclesolutions.pk/ebs-12-2-cloning-adcfgclone-pl-appstier-fails-on-linux-8-when-the-precloned-tar-backup-is-sourced-from-a-linux-7-environment/) - ISSUE: EBS 12.2 adcfgclone.pl appsTier fails on Linux 8 when the precloned tar backup is sourced from a Linux 7 environment. CAUSE: The Fusion Middleware (FMW) prerequisite check fails because the OS version (oracle-8.10) is not listed as certified. The log at /u01/8045_Iteration/ebiz/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log shows that /etc/inittab is missing and the expected OS list includes only
- [Primary Oracle Database is not able to ship log to Standby Database](https://oraclesolutions.pk/primary-oracle-database-is-not-able-to-ship-log-to-standby-database-2/) - ISSUE :My Primary Database is not able to ship Archive Logs to Standby DatabaseOn Primary Database i see this error : ORA-16191: Primary log shipping client not logged on standby2025-01-27T10:14:51.519672+03:00PR00 (PID:4208): Error 1017 received logging on to the standbyPR00 (PID:4208): -------------------------------------------------------------------------PR00 (PID:4208): Check that the source and target databases are using a password filePR00 (PID:4208):
- [Check existing Weblogic patches in EBS 12.2 that are already applied to your existing EBS App Server](https://oraclesolutions.pk/check-ebs-12-2-weblogic-patches-that-are-applied-already-to-your-existing-ebs-app-server-2/) - Follow below Steps: export ORACLE_HOME=$FMW_HOME cd $FMW_HOME/utils/bsu./bsu.sh -prod_dir=$ORACLE_HOME/wlserver_10.3 -status=applied -view [appl8000@demo12 bsu]$ ./bsu.sh -prod_dir=$ORACLE_HOME/wlserver_10.3 -status=applied -viewProductName: WebLogic ServerProductVersion: 10.3 MP6Components: WebLogic Server/Core Application Server,WebLogic Server/Administration Console,WebLogic Server/Configuration Wizard andUpgrade Framework,WebLogic Server/Web 2.0 HTTP Pub-Sub Server,WebLogic Server/WebLogic SCA,WebLogic Server/WebLogic JDBCDrivers,WebLogic Server/Third Party JDBC Drivers,WebLogic Server/WebLogic Server Clients,WebLogic Server/WebLogic Web Server Plugins,WebLogic Server/UDDI and Xquery Support,WebLogic Server/Evaluation
- [EBS 12.2 Application Tier Cloning on DMZ/Secondary App Node error out with Insufficient space in /tmp mount point](https://oraclesolutions.pk/ebs-12-2-application-tier-cloning-on-dmz-secondary-app-node-error-out-with-insufficient-space-in-tmp-mount-point-2/) - ERROR:[root@isupplier tmp]# cat /u01/8052/ebiz8052/fs2/inst/apps/ERPPROD_isupplier/admin/log/clone/fmwT2PApply/CLONE2017-01-18_02-03-38AM.errorSEVERE : Jan 18, 2017 2:06:23 AM - ERROR - CLONE-20275 Insufficient space to create /tmp/CLONINGCLIENT-6554959005609214176.SEVERE : Jan 18, 2017 2:06:23 AM - CAUSE - CLONE-20275 Minimum required space was at least "2,339" MB, but only "2,101" MB was available for use. CAUSE:Insufficient space in /tmp mount point SOLUTION:Option 1: ( If
- [java.lang.OutOfMemoryError: GC overhead limit exceeded error while applying Weblogic Patch](https://oraclesolutions.pk/java-lang-outofmemoryerror-gc-overhead-limit-exceeded-error-while-applying-weblogic-patch-2/) - ISSUE:[oracle@dev bsu]$ sh bsu.sh -prod_dir=/oradb01/apps/fs1/FMW_Home/wlserver_10.3/ -patch_download_dir=/oradb01/apps/fs1/FMW_Home/utils/bsu/cache_dir/ -patchlist=DI8E -verbose -install >> Apply_WLS_DI8E_1.log Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded at com.bea.cie.common.dao.xbean.XBeanDataHandler.getValueFromObject(XBeanDataHandler.java:598)[oracle@dev bsu]$ CAUSE:bsu.sh MEM_ARGS needs to be increased or cache_dir folder to be cleaned up. SOLUTION OPTION 1: Edit bsu.shMEM_ARGS="-d64 -Xms4096m -Xmx4096m -XX:+UseParallelGC"In my case option 1 did not resolve the issue , So
- [Primary Oracle Database is not able to ship log to Standby Database](https://oraclesolutions.pk/primary-oracle-database-is-not-able-to-ship-log-to-standby-database/) - ISSUE :My Primary Database is not able to ship Archive Logs to Standby DatabaseOn Primary Database i see this error : ORA-16191: Primary log shipping client not logged on standby2025-01-27T10:14:51.519672+03:00PR00 (PID:4208): Error 1017 received logging on to the standbyPR00 (PID:4208): -------------------------------------------------------------------------PR00 (PID:4208): Check that the source and target databases are using a password filePR00 (PID:4208):
- [Oracle Database 19c Installation For OAM](https://oraclesolutions.pk/oracle-database-19c-installation-for-oam/) - Oracle Database 19c Installation on OEL 8.10 Operating System Setup 1. For Automatic Setup of Operating System Packages and Parameters, Run the following command with Root user [root@oidserver ~]# dnf install -y oracle-database-preinstall-19c If you are using RHEL8 or CentOS8, you can pick up the RPM from the OL8 repository and install it. It will
- [RAC Release Update 19.24 on RHEL8.10 Issues](https://oraclesolutions.pk/rac-release-update-19-24-on-rhel8-10-issues/) - Oracle RAC Release Update 19.24 on RHEL8.10 Issues Whille applying the RU on base 19.3 Oracle RAC version on RHEL 8.10 we faced the below issue Error#1-------- [root@oraclehost bin]# opatchauto apply /u01/soft/36582629 -oh /u01/app/19.0.0/grid PATCHAUTO-72030: Cannot execute in rolling mode, as CRS home is shared.OPATCHAUTO-72030: Execute in non-rolling mode.at com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.AbstractTopologyBuilder.buildTopology(AbstractTopologyBuilder.java:130)at com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.CRSTopologyBuilder.buildTopology(CRSTopologyBuilder.java:117)at com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBBaseProductSupport.loadTopology(DBBaseProductSupport.java:211)at com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBProductSupport.loadTopology(DBProductSupport.java:69)at com.oracle.glcm.patch.auto.OPatchAuto.loadTopology(OPatchAuto.java:1735)at
- [Oracle ODA Reboots](https://oraclesolutions.pk/oracle-oda-reboots/) - Troubleshooting KVM Reboots on Oracle ODA Due to OOM Kills and HugePages Misconfiguration Recently, I encountered an unusual behavior in one of our Oracle Database Appliance (ODA) environments that I felt compelled to share—especially for those running WebLogic workloads on ODA. We observed unplanned reboots of the KVMs hosting WebLogic Servers, which initially appeared to
- [Export & Import Process in Oracle 19c](https://oraclesolutions.pk/export-import-process-in-oracle-19c/) - Export & Import Process in Oracle 19c Container Database (CDB/PDB) In this guide, we'll walk through how to use the Data Pump (expdp/impdp) utility for export and import when working with Oracle 19c Container Databases (CDBs). Environment Details Source (PROD) and Target (TEST) databases are both Oracle 19c. Operating System: Oracle Enterprise Linux (OEL)
- [Create Accounting Concurrent Program, Application Erros with ORA-01555: Snapshot Too Old](https://oraclesolutions.pk/create-accounting-concurrent-program-application-erros-with-ora-01555-snapshot-too-old/) - An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal. ORA-01555: snapshot too old: rollback segment number 32 with name "$TEMPUNDOSEG" too small ERROR -----------------------XLAACCUP: Accounting Program+---------------------------------------------------------------------------+ Current system time is 19-APR-2025 04:21:18 +---------------------------------------------------------------------------+ [19-APR-2025 04:21:18]: **Starts**[19-APR-2025 04:21:45]: **Ends**An internal error occurred. Please inform your system administrator or support representative that: An internal error has
- [Proudly in the Top 100 Oracle Blogs on the Web](https://oraclesolutions.pk/proudly-in-the-top-100-oracle-blogs-on-the-web/) - Oraclesolutions Ranked Among the Top 100 Oracle Blogs Worldwide Since 2017 I am incredibly proud and excited to share a milestone that means a lot to me and the growing community at Oraclesolutions.pk. For the 7th consecutive year — since 2017, Oraclesolutions.pk has been listed among the Top 100 Oracle Blogs on the Web by
- [Purge Concurrent Request and Manager Data - Part2](https://oraclesolutions.pk/purge-concurrent-request-and-manager-data-part2/) - Scheduling Purge Concurrent Request and Manager Data in Oracle E-Business Suite (EBS) : A Step-by-Step Guide To schedule the purging of Concurrent Request and/or Manager Data in Oracle E-Business Suite (EBS), you can utilize the built-in concurrent program called Purge Concurrent Request and/or Manager Data. This program is designed to remove historical data related
- [Enable Archive Log Mode in Oracle 19c RAC](https://oraclesolutions.pk/enable-archive-log-mode-in-oracle-19c-rac/) - How to Enable Archive Log Mode in Oracle 19c RAC Database: Step-by-Step Guide In this article, we will learn how to enable Archive Log Mode in an Oracle 19c RAC Database. Step 1: Check the current Archive Log Mode status of the RAC database. SQL> select log_mode,name from v$database; LOG_MODE NAME———— ———NOARCHIVELOG
- [How to Clone Oracle EBS 12.2.10 & 19c Database](https://oraclesolutions.pk/how-to-clone-oracle-ebs-12-2-10-19c-database/) - Cloning Database : 19c & Application : EBS 12.2.10 Oracle Linux 7.9 ORACLE MOS DOC. REFERENCE: Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)NOTE: This blog is only applicable for ( Non TDE-enabled PDB's ) [oraprod@erpproddb ~]$ hostname erpproddb.srrco.org.sa [oraprod@erpproddb ~]$ cd $ORACLE_HOME [oraprod@erpproddb 19.0.0]$ cd appsutil/scripts/ERPPROD_erpproddb/ [oraprod@erpproddb
- [Installing 19.18 Oracle Database on Linux 8.7](https://oraclesolutions.pk/installing-19-18-oracle-database-on-linux-8-7/) - Installing 19.18 Oracle Database on Linux 8.7 [root@oratest u01]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.209.128 oratest.oracle.com oratest [root@oratest ~]# uname -arLinux oratest.oracle.com 5.15.0-3.60.5.1.el8uek.x86_64 #2 SMP Wed Oct 19 20:04:4 8 PDT 2022 x86_64 x86_64 x86_64 GNU/Linux[root@oratest ~]# uname -r5.15.0-3.60.5.1.el8uek.x86_64 [root@oratest ~]# cat /etc/*-releaseOracle Linux Server release 8.7NAME="Oracle Linux Server"VERSION="8.7"ID="ol"ID_LIKE="fedora"VARIANT="Server"VARIANT_ID="server"VERSION_ID="8.7"PLATFORM_ID="platform:el8"PRETTY_NAME="Oracle Linux Server
- [TMUX background session usage and benefits in RedHat Linux 8](https://oraclesolutions.pk/tmux-usage-and-benefits-in-redhat-linux-8/) - Executing screen command in Linux 8 gives error:bash: screen: command not foundThis is because: From Linux 8.x onwards screen has been deprecated and tmux has been introduced.Execute Un-Interrupted Red Hat Linux 8 Sessions (Remotely in the Background) using TMUX (Replacement of screen utility In Earlier Linux Versions) In the life of an Oracle EBS Apps
- [Oracle EBS 12.2.14: Upgrade JDK to the Latest Java on the Application Tier](https://oraclesolutions.pk/upgrade-jdk-latest-java-on-oracle-e-business-suite-ebs-12-2-14-application-tier/) - JAVA UPGRADE STEPS : NOTE: JDK 7 has reached Sustaining Support at the end of July 2022. However with Oracle EBS only JDK 7 is certified and supported untill the time of posting this blog To Upgrade JDK : Via Oracle Java checker utility EJCPUC.sh to check recommendation of latest certified JAVA to deploy on
- [Here's how to solve: Error on perl txkCfgUtlfileDir.pl on getUtlFileDir afer restoraion of 19c Database](https://oraclesolutions.pk/heres-how-to-solve-error-on-perl-txkcfgutlfiledir-pl-on-getutlfiledir-afer-restoraion-of-19c-database/) - ERROR on perl txkCfgUtlfileDir.pl on getUtlFileDir when 19c EBS Database backup has been restored [orauat@ebsdbuat dbs]$ su - orauatPassword:[orauat@ebsdbuat ~]$ cat envPRECDB.env. /do2/8010_uat_db/db/19.0.0/PRECDB_ebsdbuat.env[orauat@ebsdbuat ~]$ . /do2/8010_uat_db/db/19.0.0/PREUPG_ebsdbuat.env[orauat@ebsdbuat ~]$ cd /do2/8010_uat_db/db/19.0.0/appsutil/bin[orauat@ebsdbuat bin]$ [orauat@ebsdbuat bin]$ perl txkCfgUtlfileDir.pl -contextfile=/do2/8010_uat_db/db/19.0.0/appsutil/PREUPG_ebsdbuat.xml -oraclehome=/do2/8010_uat_db/db/19.0.0 -outdir=/do2/8010_uat_db/db/19.0.0/appsutil/log -mode=getUtlFileDirEnter the APPS Password:Script Name : txkCfgUtlfileDir.plScript Version : 120.0.12020000.15Started : Wed Feb 7 07:47:03 +03 2024Log File
- [ORA-28000 - the account is locked in the Active Standby Database](https://oraclesolutions.pk/ora-28000-the-account-is-locked-in-the-standby-database/) - ORA-28000, the account was unlocked in the primary database, but still locked in the Active Standby Database. Situation: The primary database is configured with Dataguard is returning an error ORA-28000, "the account is locked," when the user tries to log in. The database administrator unlocked this user's account in the primary database but still the
- [EBS 12.2 adcfgclone appsTier gives error:  libnsl.so.1: cannot open shared object file: No such file or directory](https://oraclesolutions.pk/how-to-fix-libnsl-so-1-cannot-open-shared-object-file-no-such-file-or-directory/) - ISSUE: /u01/ebs/fs1/EBSapps/10.1.2/bin/sqlplus: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory While running adcfgclone appsTier single fs on EBS 12.2.10 FATAL ERROR PROGRAM : (/u01/ebs/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkManageDBConnectionPool.pl) TIME : Sun Nov 10 15:26:51 2024 FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ] ERRORMSG: Invalid APPS database user credentials. No updates Performed .end
- [Oracle Database Archive Log Generation Details](https://oraclesolutions.pk/oracle-database-archive-log-generation-details/) - Oracle Database Archive Log Generation Details The Blog presents a script designed to query and report on redo log switch history and the size of archived logs in an Oracle Database environment. It focuses on the utilization of a single local destination for archiving, detailing how to extract relevant data such as the count
- [Implementing Class of Secure Transport (COST) in Oracle RAC 11.2](https://oraclesolutions.pk/implementing-class-of-secure-transport-cost-in-oracle-rac-11-2-2/) - Implementing Class of Secure Transport (COST) in Oracle RAC 11.2 Introduction:Class of Secure Transport (COST) is a security feature introduced in Oracle Database 11g Release 2 (11.2) that enhances the security of network communication within Oracle Real Application Clusters (RAC) environments. By implementing COST, you can protect the integrity and confidentiality of data transmitted
- [Disabling and Uninstalling AWR](https://oraclesolutions.pk/disabling-and-uninstalling-awr/) - Disabling and Uninstalling AWR (Doc ID 1909073.1) Some reference on it?– How To Avoid the AWR Usage Without Having Diagnostic Pack License (Doc ID 2276199.1)– Controlling Diagnostic and Tuning Pack Usage (Doc ID 436386.1)– Disabling and Uninstalling AWR (Doc ID 1909073.1) SELECT name, detected_usages detected,total_samples samples, currently_used used,to_char(last_sample_date,'MMDDYYYY:HH24:MI') last_sample,sample_interval intervalFROM dba_feature_usage_statisticsWHERE name = 'Automatic
- [Disable SYS Auto Jobs from the Database](https://oraclesolutions.pk/disable-sys-auto-jobs-from-the-database/) - Disable SYS Auto Jobs from the Database ======================================== DBMS_AUTO_TASK_ADMIN.DISABLE still shows the client_name enabled in DBA_AUTOTASK_CLIENT view (Doc ID 1565768.1) for Reference: Disable database jobs (DBMS_SCHEDULER , AUTOTASKS and DBMS_JOBS) before upgrade (Doc ID 1614385.1) 1. Check the currently scheduled auto jobs by SYS SQL> select client_name,status from Dba_Autotask_Client; CLIENT_NAME STATUS---------------------------------------------------------------- --------SQL TUNING ADVISOR
- [How to Verify Oracle Data Guard Sync Status](https://oraclesolutions.pk/how-to-verify-oracle-data-guard-sync-status/) - Verify whether your Primary Oracle Database is in sync with the Standby Database in a Data Guard configuration. Solution: To ensure synchronization, you need to check the Managed Recovery Process (MRP) and query relevant views that provide real-time status and logs. Below are the key SQL queries that help you confirm synchronization. 1. Check the
- [EBS 12.2: Application tier SSL wallet gives error while opening Apache folder via Oracle Wallet Manager](https://oraclesolutions.pk/346-2/) - ISSUE: I had to renew my customer's EBS SSL certificate as it was about to expire soonSince the EBS 12.2.7 wallet had the ability to open wallet in GUI mode , I tried to open wallet BUT was Not able to open it facing the below error. ! The new version of wallet I guess
- [After login to EBS 12.2.5 the Home page gives error: You have encountered an unexpected error. Please contact the system administrator for assistance](https://oraclesolutions.pk/after-login-to-ebs-12-2-5-the-home-page-gives-error-you-have-encountered-an-unexpected-error-please-contact-the-system-administrator-for-assistance/) - ERROR: When we click on the home button on landing page after login on java applet we are facing this issue." You have encountered an unexpected error. Please contact the system administrator for assistance. " when we click on " click here for exception details " SOLUTION: Compile jsps If you are login to EBS,
- [Oracle Database 23ai with Oracle E-Business Suite 12.2](https://oraclesolutions.pk/oracle-database-23ai-with-oracle-e-business-suite-12-2/) - Oracle Database 23ai with Oracle E-Business Suite 12.2 Oracle recently announced that Oracle E-Business Suite (EBS) Release 12.2 is certified with Oracle Database 23ai (DB 23ai) for on-premises Exadata Database Machine (Exadata) running Exadata Software version 24.1 (ExaOL8X) or later. To provide a central location for you to obtain information regarding Oracle Database 23ai and Oracle
- [Critical Patch Update January 2025](https://oraclesolutions.pk/critical-patch-update-january-2025/) - Critical Patch Update for January 2025 The Critical Patch Update (CPU) for January 2025 was released on 21 January 2025. Oracle strongly recommends applying the CPU patches as soon as possible. MOS Note for EBS CPUs A link to the latest available Oracle E-Business Suite CPU document is available in Identifying the Latest Critical Patch
- [Troubleshooting Oracle RAC Node Eviction](https://oraclesolutions.pk/troubleshooting-oracle-rac-node-eviction/) - Troubleshooting Oracle RAC Node Eviction The RAC Node Eviction Troubleshooting Tool is designed to help diagnose and resolve RAC node eviction issues by analyzing uploaded log files. When a known solution exists, the tool provides detailed symptoms, causes, and recommended solutions. Benefits of Using the RAC Node Eviction Troubleshooting Tool Automated Analysis: The
- [ORA-01035: ORACLE only available to users with RESTRICTED SESSION](https://oraclesolutions.pk/ora-01035-oracle-only-available-to-users-with-restricted-session/) - ORA-01035: ORACLE only available to users with RESTRICTED SESSION 1. First Check the Pdbs Status SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ------------------------------------------------------------------------------------------------------------------------ PDB$SEED READ ONLY NOUAT READ WRITE YES (RESTRICTED SESSION) 2. Now, set
- [Switchover to Production ODA Environment](https://oraclesolutions.pk/switchover-to-production-oda-environment/) - Switchover to Production ODA Environment Standby---------- SQL> SELECT PROCESS FROM V$MANAGED_STANDBY WHERE PROCESS LIKE 'MRP%'; PROCESS---------MRP0 SQL> set lines 133 pages 133select database_role,db_unique_name,open_mode,protection_mode from gv$database; DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE PROTECTION_MODE---------------- ------------------------------ -------------------- --------------------PHYSICAL STANDBY testdb READ ONLY WITH APPLY MAXIMUM PERFORMANCE SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE#
- [Configuring AdminServer for High Availability](https://oraclesolutions.pk/configuring-adminserver-for-high-availability/) - Configuring AdminServer for HA 1. Check the current Network Configuration [root@test1 u01]# ifconfig -aens34: flags=4163 mtu 1500inet 192.168.131.200 netmask 255.255.255.0 broadcast 192.168.131.255inet6 fe80::250:56ff:feab:e4e prefixlen 64 scopeid 0x20ether 00:50:56:ab:0e:4e txqueuelen 1000 (Ethernet)RX packets 56594631 bytes 22936153585 (21.3 GiB)RX errors 0 dropped 0 overruns 0 frame 0TX packets 36468224 bytes 17952810300 (16.7 GiB)TX errors 0 dropped
- [How to Change Password file in Oracle RAC](https://oraclesolutions.pk/how-to-change-password-file-in-oracle-rac/) - Changing Password file in Oracle RAC 1. First check the current configuration of the system and the password file location . [oracle@rac1-test ~]$ srvctl config database -d testdbDatabase unique name: testdbDatabase name: testdbOracle home: /home/oracle/DB/19.0.0/db_homeOracle user: oracleSpfile: +DATA/testdb/PARAMETERFILE/spfile.295.1172710733Password file: +DATA/testdb/PASSWORD/pwdtestdb.318.1178841871Domain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools:Disk Groups: DATA,ARCHMount point paths:Services:Type: RACStart
- [Implement in-memory in your RAC database](https://oraclesolutions.pk/implement-in-memory-in-your-rac-database/) - Implement in-memory in your RAC database Oracle has provided In-memory feature at base_level for free. You use 16GB allocation limit for this feature to be used without the licence. I will take you step by step on how to implement in-memory in your RAC database for the table that require HIGH I/Os. 1. Check
- [Configuring EM Express on 19c Rac Database](https://oraclesolutions.pk/configuring-em-express-on-19c-rac-database/) - Configuring EM Express on 19c Rac Database SQL> select dbms_xdb_config.getHttpPort() from dual; DBMS_XDB_CONFIG.GETHTTPPORT()-----------------------------0 SQL> select dbms_xdb_config.getHttpsPort() from dual; DBMS_XDB_CONFIG.GETHTTPSPORT()------------------------------0 SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); PL/SQL procedure successfully completed. SQL> select dbms_xdb_config.getHttpsPort() from dual; DBMS_XDB_CONFIG.GETHTTPSPORT()------------------------------5500 SQL> SELECT 'https://'||SYS_CONTEXT('USERENV','SERVER_HOST')||'.'||SYS_CONTEXT('USERENV','DB_DOMAIN')||':'||dbms_xdb_config.gethttpsport()||'/em/' from dual; 'HTTPS://'||SYS_CONTEXT('USERENV','SERVER_HOST')||'.'||SYS_CONTEXT('USERENV','DB--------------------------------------------------------------------------------https://:5500/em/ If the URL still does not work perform the below steps [oracle@dbtest ~]$ lsnrctl
- [Step By Step Upgrading Oracle EBS to R12.2.14](https://oraclesolutions.pk/step-by-step-upgrading-oracle-ebs-to-r12-2-14/) - Step By Step Upgrading Oracle EBS to R12.2.14 This post will offer comprehensive guidance on upgrading Oracle EBS Release R12.2.x to R12.2.14. Step 1: Upgrade Oracle Database This Part covers the upgrade process of Oracle Apps R12.2.x Database from 12c to 19c, followed by a verification process to ensure a successful upgrade. if you are currently
- [Configure Oracle Internet Directory(OID) 12.2.1.4](https://oraclesolutions.pk/configure-oracle-internet-directoryoid-12-2-1-4/) - Configure Oracle Internet Directory(OID) 12.2.1.4 Note: Before proceeding with this installation section, ensure you have completed the prerequisite tasks outlined below. Refer to the provided links for detailed guidance. Step 1: Install and Configure Oracle Database for Oracle Internet Directory Please refer to the following blog for detailed guidance. Link 🔗 Oracle Database
- [Oracle Internet Directory 12.2.1.4 Installation](https://oraclesolutions.pk/oracle-internet-directory-12-2-1-4-installation/) - Oracle Internet Directory 12.2.1.4 Installation Note: Before proceeding with this installation section, ensure you have completed the prerequisite tasks outlined below. Refer to the provided links for detailed guidance. Step 1: Install and Configure Oracle Database for Oracle Internet Directory Please refer to the following blog for detailed guidance. Link 🔗 Oracle
- [Configure Weblogic Domain for OID 12.2.1.4](https://oraclesolutions.pk/configure-weblogic-domain-for-oid-12-2-1-4/) - Configure Weblogic Domain for OID 12.2.1.4 Note: Before proceeding with this installation section, ensure you have completed the prerequisite tasks outlined below. Refer to the provided links for detailed guidance. Step 1: Install and Configure Oracle Database for Oracle Internet Directory Please refer to the following blog for detailed guidance. Link 🔗 Oracle
- [Step by Step Installing and Configuring OID 12.2.1.4](https://oraclesolutions.pk/step-by-step-installing-and-configuring-oid-12-2-1-4/) - Step-by-Step Guide: Installing and Configuring Oracle Internet Directory 12.2.1.4 INTRODUCTION Oracle Internet Directory(OID) What is OID? Oracle Internet Directory (OID) is a scalable LDAP-based directory service that acts like a centralized address book for businesses. It stores and manages user identities, application data, and system information securely in one place, simplifying operations for
- [Some Essential Free Learning Resources for EBS on OCI](https://oraclesolutions.pk/some-essential-free-learning-resources-for-ebs-on-oci/) - Some Essential Free Learning Resources for EBS on OCI Whatever stage you are at in deploying Oracle E-Business Suite on Oracle Cloud Infrastructure (OCI), it can be daunting to know what to learn next, or where to start. This blog aims to provide timely, easy to read updates about the journey EBS Development is making to provide
- [FMW 12.2.1.4 Installation for OID](https://oraclesolutions.pk/fmw-12-2-1-4-installation-for-oid/) - Oracle Fusion Middleware 12.2.1.4 Introduction What is Oracle Fusion Middleware 12.2.1.4? Oracle Fusion Middleware 12.2.1.4 is a set of software tools and services that help businesses build and run applications. It acts as a bridge between different systems, making it easier to connect, manage, and secure enterprise applications whether they are in the cloud, on-premises,
- [FMW 12.2.1.4 Installation for OAM](https://oraclesolutions.pk/fmw-12-2-1-4-installation-for-oam/) - Oracle Fusion Middleware 12.2.1.4 Introduction What is Oracle Fusion Middleware 12.2.1.4? Oracle Fusion Middleware 12.2.1.4 is a set of software tools and services that help businesses build and run applications. It acts as a bridge between different systems, making it easier to connect, manage, and secure enterprise applications whether they are in the cloud, on-premises,
- [Oracle Database 19c Installation For OID](https://oraclesolutions.pk/oracle-database-19c-installation-for-oid/) - Oracle Database 19c Installation on OEL 8.10 Operating System Setup 1. For Automatic Setup of Operating System Packages and Parameter, Run the following command with Root user [root@oidserver ~]# dnf install -y oracle-database-preinstall-19c If you are using RHEL8 or CentOS8, you can pick up the RPM from the OL8 repository and install it. It will
- [Oracle EBS ETCC OCT-2024 Update](https://oraclesolutions.pk/oracle-ebs-etcc-oct-2024-update/) - EBS Technology Codelevel Checker (ETCC) OCT-2024 Update Introduction to ETCC The EBS Technology Code Level Checker (ETCC) includes two scripts that examine the Oracle Homes of both the Database and the Middle tier. These scripts serve to identify any missing bug fixes that are necessary for Oracle E-Business Suite Release 12.2. It is highly recommended
- [Apply EBS AD-TXK Release 16 Update](https://oraclesolutions.pk/apply-ebs-ad-txk-release-16-update/) - Step By Step Guide to Apply Oracle E-Business Suite R12.2 ADTXK Update 16 Oracle Applications DBA (AD) and Oracle E-Business Suite Technology Stack (TXK) Release Update Packs are periodic updates provided by Oracle to enhance and maintain the technology stack components of Oracle E-Business Suite (EBS). These packs include fixes, optimizations, and new features to
- [(ECPUC) EBS Critical Patch Update Checker-OCT-2024](https://oraclesolutions.pk/ecpuc-ebs-critical-patch-update-checker-oct-2024/) - Step by Step Guide to apply EBS Latest CPU OCT-2024 through EBS Critical Patch Update Checker (ECPUC) The EBS Critical Patch Update Checker (ECPUC) is a diagnostic tool developed by Oracle to help users of Oracle E-Business Suite (EBS) determine whether they have applied the latest Critical Patch Updates (CPUs) for their environment. Critical Patch
- [On Google Cloud Platform, Redhat Enterprise Linux 8.10 Virtual Machine could not be able to connect via ssh with below error:  Permission Denied (publickey.gssapi-keyex.gssapi-with-mic)](https://oraclesolutions.pk/unable-to-connect-via-ssh-to-google-cloud-platforms-virtual-machine-with-below-error-permission-denied-publickey-gssapi-keyex-gssapi-with-mic/) - ISSUE: While migrating one of my client's Core Oracle Database from an on-premises environment to Google Cloud VM Instance. I encountered an issue while transferring files via SCP from the source Linux server to the target and was unable to connect to Google Cloud VM's Linux terminal with password using SSH? ERROR: [oraprd@core-db-prd ~]$ scp
- [How To Resolve EBS 19c DbTechStack Cloning Issues On Red Hat Enterprise Linux 8.10 (perl Adcfgclone.pl DbTechStack)](https://oraclesolutions.pk/how-to-resolve-ebs-19c-dbtechstack-cloning-issues-on-red-hat-8-10-perl-adcfgclone-pl-dbtechstack/) - ISSUE: While running perl adcfgclone.pl dbTechStack, Cloning EBS integerated 19c Database TechStack Fails on supported OS Check with Red Hat Linux 8.10 CAUSE: 19c does not contain Pre-req checks specific to Oracle Linux 8 / Red Hat Linux 8.10Silent Installer will fail with below Error,as there are no Pre-req checks specific to Linux 8. SHOW
- [How to Resolve Non-SSL Login Failures After Successfully Cloning SSL-Enabled EBS 12.2.13](https://oraclesolutions.pk/how-to-resolve-non-ssl-login-failures-after-successfully-cloning-ssl-enabled-ebs-12-2-13/) - ISSUE: After Adcfgclone appsTier for a newly cloned ebs 12.2.13 environment from an SSL-enabled ebs precloned stage backup prevents me from logging in to non-SSL EBS login URL, despite it was completed 100% successfully without any error. CAUSE: EBS Context file variable s_enable_sslterminator was empty and was required to be changed as shown below:It was
- [(EJCPUC)EBS Java Critical Patch Update Checker OCT-2024](https://oraclesolutions.pk/ejcpucebs-java-critical-patch-update-checker-oct-2024/) - (EJCPUC)EBS Java Critical Patch Update Checker OCT-2024 Introduction A new utility, Oracle E-Business Suite Java Critical Patch Update Checker (EJCPUC) was released with the October 2024 CPU. Which Oracle strongly recommend that you run EJCPUC against your EBS environment to Identify the current Java CPU level for the various Java Homes in your EBS environment.
- [Cannot insert NULL into FND_APPS_SYSTEM.CSI_NUMBER](https://oraclesolutions.pk/cannot-insert-null-into-fnd_apps_system-csi_number/) - Autoconfig errors on adgentns.pl ORA-01400 cannot insert NULL into FND_APPS_SYSTEM.CSI_NUMBER Recently, we encountered an issue while running AutoConfig on the Applications Tier in Oracle E-Business Suite Release 12. The following error was observed: ERROR ERROR: [CVM Error Report]The following report lists errors encountered during CVM Phase/.../apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2No of scripts failed in CVM phase: 1
- [Applying PSU Patch in Oracle 19c](https://oraclesolutions.pk/applying-psu-patch-in-oracle-19c/) - Step-by-Step Guide to Apply Oracle E-Business Suite Database 19c Patch Set Update In this article, we will apply the latest Oracle Database Release Update (DBRU) 19.25 (19.25.0.0.241015-Oct2024) today, as it has been certified by Oracle. What are Patch Set Updates (PSU)? Oracle Database Patch Set Updates (PSUs) are quarterly cumulative updates designed
- [How to fix http service after sudden Power Shutdown of EBS 12.2 Server/Machine](https://oraclesolutions.pk/how-to-shutdown-power-of-ebs-12-2-services/) - Issue faced: Sudden Power shutdown of EBS 12.2 Application Server / Machine cd $ADMIN_SCRIPTS_HOME./adapcctl.sh status Noticed that the http service shows STOP SOLUTION:cd /u01/ebiz_APRIL_2018/fs1/FMW_Home/webtier/instances/web_GEAPROD_OHS1/config/OPMN/opmn/states ls -lrta -rw-r-----. 1 applprod dba 14 Oct 26 10:58 .locale-rw-r-----. 1 applprod dba 579 Oct 26 10:59 p1505039354-rw-r-----. 1 applprod dba 20 Oct 26 11:00 .opmndatrename this file "p1505039354" and
- [ORA-12514: TNS:listener does not currently know of service requested](https://oraclesolutions.pk/ora-12514-tnslistener-does-not-currently-know-of-service-requested/) - Symptoms/Problem Details : Unable to connect apps user from a Recently cloned and EBS RUP 12.2.12 applied Application nodesqlplus apps/*****ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.[oracle@clone admin]$ sqlplus apps/****SQL*Plus: Release 10.1.0.5.0 - Production on Mon Sep 2 11:25:55 2024Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12514: TNS:listener does
- [How To Find Particular Database Session ID From the SQLID ( ORACLE 19c)](https://oraclesolutions.pk/how-to-find-particular-database-session-id-from-the-sqlid-oracle-19c/) - ISSUE: In this Blog we are going to learn about How To Find a Particular Database Session ID From the SQLID.One of my customer informed me I have query running since 10 hours and Healready confirmed with Business user that this query session is safe to beterminated. Here we will not discuss about invetigating if
- [How to check status ( State and Health ) of Managed Servers under weblogic console from linux instead of browser URL](https://oraclesolutions.pk/how-to-run-wlst-script-to-check-weblogic-status/) - Issue:While accessing the EBS 12.2.13 Weblogic Console to check health status of EBS managed server the browser redirects to below error as a security restriction:The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2Solution:Connect to application from OS/Linux terminal/puttySource EBS 12.2 Run File system environmentLast login: Mon Apr
- [Changing IP Address in an Oracle EBS R12 Environment](https://oraclesolutions.pk/changing-ip-address-in-an-oracle-ebs-r12-environment/) - Changing IP Address in an Oracle EBS R12 Environment 1. First, Change the IP Address of the Server by editing the /etc/hosts file 2. Now, Verify the current IP address setup in the Oracle EBS environment. Connect as apps user into SQL*Plus and run: select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name
- [AUTOCONFIG COULD NOT SUCCESSFULLY INSTANTIATE THE FOLLOWING FILES](https://oraclesolutions.pk/autoconfig-not-successfully-instantiate-following-files/) - ERROR Error: ****** DB autoconfig Error: ***************** [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by directory and phase. The report format is: [INSTANTIATE PHASE] AutoConfig could not successfully instantiate the following files: Directory: /U01/PROD/db/tech_st/11.2.0.3/appsutil/install/PROD_proddb adcrdb.sh AutoConfig is exiting with status 1 SOLUTION
- [Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status](https://oraclesolutions.pk/adrelink-fails-with-error-tech_st10-1-2libstubslibc-so-6-collect2-ld-returned-1-exit-status/) - ERROR Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status /u01/app/applmgr/TST123/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm -lpthread /usr/bin/ld: cannot find /u01/prod/apps/tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status make: *** [/u01/app/applmgr/TST123/apps/apps_st/appl/ad/12.0.0/bin/adpchnew] Error 1 Done with link of ad executable 'adpchnew' on Thu Oct 27 22:11:12 EDT 2016 Relink of module "adpchnew" failed. See error messages above (also
- [How to Create The Service Manager ‘FNDSM’ on Oracle Applications](https://oraclesolutions.pk/how-to-create-the-service-manager-fndsm-on-oracle-applications/) - Create The Service Manager ‘FNDSM’ Run below command to check if node is registered for FNDSM:- select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like ‘FNDSM%’; if not then follow Note.218893.1 :How to Create The Service Manager ‘FNDSM’ on Oracle Applications SOLUTION From the Application tier: 1. Log in as applmgr 2. cd to $FND_TOP/patch/115/sql 3. Run
- [Enable Automatic Compilation of JSP pages in R12](https://oraclesolutions.pk/enable-automatic-compilation-jsp-pages-r12/) - Enable Automatic Compilation of JSP pages in R12 1.Login into Oracle E-Business suite and select System Administrator responsibility 2. Select function AutoConfig (under Oracle Applications Manager) For each web tier server perform the following: -Click on pencil icon under Edit Parameters -Select tab System -Expand section jtff_server 3. Change value for the entry s_jsp_main_mode from
- [INCREASE FORMS_TIMEOUT IN ORACLE R12](https://oraclesolutions.pk/increase-forms_timeout-oracle-r12/) - INCREASE FORMS_TIMEOUT IN ORACLE R12 To implement the solution, please execute the following steps: 1. Edit the .xml file in $INST_TOP/appl/admin directory 2. Ensure that value of profile option “ICX: Session Timeout” and autoconfig variable “s_oc4j_sesstimeout” in context file match. e.g. In case you need the session to timeout after 2 hrs then the profile
- [FRM-92101: There was a failure in the Forms Server during startup.](https://oraclesolutions.pk/please-look-into-the-web-server-log-file-for-details/) - ERROR
- [AWR Snapshot Retention Period](https://oraclesolutions.pk/awr-snapshot-retention-period/) - AWR Snapshot Retention Period Configuration This article explores the process of modifying the AWR snapshot retention period in Oracle. Regarding AWR Reports The Oracle MMON background process gathers AWR statistics and creates snapshots according to the specified retention period, which may exceed the threshold metric. Enabling this task involves adjusting the STATISTICS_LEVEL parameter value
- [Updating OS in Oracle RAC](https://oraclesolutions.pk/updating-os-in-oracle-rac/) - Updating OS in Oracle RAC running on Azure using Flashgrid Software In this blog post we will talk about on how to update the OS for nodes running Oracle RAC Database on Flashgrid Cluster. Note: Simultaneously updating OS and applying Grid Infrastructure patches in rolling fashion is not recommended. Nodes should not be rebooted while
- [April CPU JDK Upgrade on DB](https://oraclesolutions.pk/april-cpu-jdk-upgrade-on-db/) - April CPU JDK Upgrade on DB and Grid Homes in Oracle 19c Real Application Cluster Setup Current Version:- GRID HOME:- grid> cd $GRID_HOME/jdk/bin grid> ./java -version java version "1.8.0_311" Java(TM) SE Runtime Environment (build 1.8.0_311-b11) Java HotSpot(TM) 64-Bit Server VM (build 25.311-b11, mixed mode) ORACLE_HOME:- oracle> $ORACLE_HOME/jdk/bin oracle> ./java -version java version "1.8.0_311"
- [Manually remove ODA DB HOME](https://oraclesolutions.pk/manually-remove-oda-db-home/) - Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. Check if any running jobs currently: # odacli list-jobs. 2. If none, then stop the DCSAgents (initdcsagent) by running: # systemctl stop initdcsagent 3. Manually remove the respective Oracle_Home folders using 'rm -rf . For example: - As root: rm
- [ODA Space Utilization Issue](https://oraclesolutions.pk/oda-space-utilization-issue/) - Oracle Database Appliance Space Utilization Issue One of the basic issue when having ODA (Oracle Database Appliance) system is space utilization in /opt mount point. Recently I was facing the same issue on my Oracle Database Appliance version 19.17.0.0.0 one node, on checking the /opt mount point thoroughly it was found a file “dcs-agent.log”
- [Materialized View refresh error](https://oraclesolutions.pk/materialized-view-refresh-error/) - Materialized View refresh error generating huge Archive Logs after Database Upgrade to 19c. Issue:- A huge amount of archive log generation when materialized view refreshing after database upgrade from 11g to 19c and performance issues while accessing the database. Analysis:- On checking the issue it was noticed that a database feature naming “MV Refresh
- [Removing Old Grid Home](https://oraclesolutions.pk/removing-old-grid-home/) - Manually Remove an Old Grid Home After Upgrading/Patching to a Higher Grid Home on ODA 1. Check the components and their versions [root@testlinux ~]# odacli describe-componentSystem Version---------------19.20.0.0.0 System node Name---------------testlinux Local System Version---------------19.20.0.0.0 Component Installed Version Available Version---------------------------------------- -------------------- --------------------OAK19.20.0.0.0 up-to-dateGI19.20.0.0.230718 up-to-dateDB {[OraDB19000_home5 [db1,db2]]19.20.0.0.230718 up-to-date[OraDB19000_home6 [db3]]19.20.0.0.230718 up-to-date}DCSCONTROLLER19.20.0.0.0 up-to-dateDCSCLI19.20.0.0.0 up-to-dateDCSAGENT19.20.0.0.0 up-to-dateDCSADMIN19.20.0.0.0 up-to-dateOS7.9 up-to-dateILOM5.1.1.23.r151750 up-to-dateBIOS52100600 up-to-dateLOCAL CONTROLLER
- [After applying EBS 12.2.13 RUP on Redhat Linux 8.9 OS, Viewing the Output and Log Files from any Concurrent Request Shows a Blank Page in the Browser](https://oraclesolutions.pk/after-applying-ebs-12-2-13-rup-on-redhat-linux-8-9-os-viewing-the-output-and-log-files-from-any-concurrent-request-shows-a-blank-page-in-the-browser/) - Environment: Oracle EBS Release that is 12.2.13 with 19c that is 19.22 which is Running on Red Hat Enterprise Linux release 8.9 (Ootpa) Issue: After Applying : R12.AD.C.delta.15 -> 34695811 R12.TXK.C.delta.15 -> 34785677 Oracle E-Business Suite 12.2.13 Release Update Pack -> 34776655We started facing problem i.e Concurrent Request Output and Log output displays Blank Page
- [AC-50480: Internal error occurred](https://oraclesolutions.pk/ac-50480-internal-error-occurred/) - AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora SOLUTION: AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. [ID 1324667.1] To implement the solution, please execute the following steps: NOTE: Ensure that you have taken a backup of your system before applying the recommended solution. 1. Clean the Data Topology Model Sqlplus apps/…
- [adapcctl.sh exiting with status 204](https://oraclesolutions.pk/adapcctl-sh-exiting-status-204/) - While cloning Oracle Applications You might encounter an issue: adapcctl.sh exiting with status 204 Start Services log shows: opmnctl: starting opmn managed processes... ================================================================================ opmn id=adfcvs.chainsys.com:6250 0 of 1 processes started. ias-instance id=CVS1213_adfcvs.adfcvs.chainsys.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -------------------------------------------------------------------------------- ias-component/process-type/process-set: HTTP_Server/HTTP_Server/HTTP_Server/ Error --> Process (index=1,uid=1063274728,pid=18743) failed to start a managed process after the maximum retry limit Log: //inst/apps/CVS1213_adfcvs/logs/ora/10.1.3/opmn/HTTP_Server~1.log 01/23/12-16:37:17
- [Application Report Queries](https://oraclesolutions.pk/application-report-queries/) - QUERY TO CHECK LIST OF RUNNING REQUEST SELECT q.concurrent_queue_name qname, f.user_name, a.request_id "Req Id", Decode(a.parent_request_id, -1, NULL, a.parent_request_id) "Parent", a.concurrent_program_id "Prg Id", a.phase_code, a.status_code -- ,b.os_process_id "OS" -- ,vs.sid -- ,vs.serial# "Serial#" -- ,vp.spid , a.oracle_process_id "spid", ( Nvl(a.actual_completion_date, SYSDATE) - a.actual_start_date ) * 1440 "Time", c.concurrent_program_name || ' - ' || c2.user_concurrent_program_name || ' ' || a.description "Program" FROM applsys.fnd_concurrent_requests a, applsys.fnd_concurrent_processes b, applsys.fnd_concurrent_queues q, applsys.fnd_concurrent_programs_tl c2, applsys.fnd_concurrent_programs c, applsys.fnd_user f -- ,v$session vs -- ,v$process vp WHERE a.controlling_manager = b.concurrent_process_id AND a.concurrent_program_id = c.concurrent_program_id AND a.program_application_id = c.application_id AND c2.concurrent_program_id = c.concurrent_program_id AND c2.application_id = c.application_id AND a.phase_code IN ( 'I', 'P', 'R', 'T' ) AND a.requested_by = f.user_id AND b.queue_application_id = q.application_id AND b.concurrent_queue_id = q.concurrent_queue_id AND c2.LANGUAGE = 'US' -- and vs.process (+) = b.os_process_id -- and vs.paddr = vp.addr (+) ORDER BY 9 DESC;
- [Application DBA Queries](https://oraclesolutions.pk/application-patches-queries/) - QUERY TO GET all user assigned to GIVEN RESPONSIBILITY SELECT UNIQUE u.user_id, Substr(u.user_name, 1, 30) user_name, Substr(r.responsibility_name, 1, 60) responsiblity, Substr(a.application_name, 1, 50) application FROM fnd_user u, fnd_user_resp_groups g, fnd_application_tl a, fnd_responsibility_tl r WHERE g.user_id(+) = u.user_id AND g.responsibility_application_id = a.application_id AND a.application_id = r.application_id AND g.responsibility_id = r.responsibility_id AND r.responsibility_name = 'System Administrator' --"Write Responsibility Name Here " ORDER BY Substr(user_name, 1, 30), Substr(a.application_name, 1, 50), Substr(r.responsibility_name, 1, 60); Query to get all Responsibility assigned to a user SELECT UNIQUE u.user_id, Substr (u.user_name, 1, 30) user_name, Substr (r.responsibility_name, 1, 60) responsiblity, Substr (a.application_name, 1, 50) application FROM fnd_user u, fnd_user_resp_groups g, fnd_application_tl a, fnd_responsibility_tl r WHERE g.user_id(+) = u.user_id AND g.responsibility_application_id = a.application_id AND a.application_id = r.application_id AND g.responsibility_id = r.responsibility_id AND u.user_name = 'SYED.SALI' --"Write Application User Name Here " ORDER BY Substr (user_name, 1, 30), Substr (a.application_name, 1, 50), Substr (r.responsibility_name, 1, 60); QUERY FOR
- [Oracle Database Monitoring Queries](https://oraclesolutions.pk/database-monitoring-queries/) - QUERY TO CHECK SIZE OF ALL TABLESPACES SELECT /* + RULE */ df.tablespace_name "Tablespace", df.bytes / ( 1024 * 1024 ) "Size (MB)", SUM(fs.bytes) / ( 1024 * 1024 ) "Free (MB)", Nvl(Round(SUM(fs.bytes) * 100 / df.bytes), 1) "% Free", Round(( df.bytes - SUM(fs.bytes) ) * 100 / df.bytes) "% Used" FROM dba_free_space fs, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) df WHERE fs.tablespace_name (+) = df.tablespace_name GROUP BY df.tablespace_name, df.bytes UNION ALL SELECT /* + RULE */ df.tablespace_name tspace, fs.bytes / ( 1024 * 1024 ), SUM(df.bytes_free) / ( 1024 * 1024 ), Nvl(Round(( SUM(fs.bytes) - df.bytes_used ) * 100 / fs.bytes), 1), Round(( SUM(fs.bytes) - df.bytes_free ) * 100 / fs.bytes) FROM dba_temp_files fs, (SELECT tablespace_name, bytes_free, bytes_used FROM v$temp_space_header GROUP BY tablespace_name, bytes_free, bytes_used) df WHERE fs.tablespace_name (+) = df.tablespace_name GROUP BY df.tablespace_name, fs.bytes, df.bytes_free, df.bytes_used ORDER BY 4 DESC; QUERY TO CHECK BLOCKING SESSIONS PER USER SELECT s1.username
- [OS Errors sh: scl: line 1: syntax error: unexpected end of file while starting WebLogic Admin service in EBS 12.2 on Redhat Linux 8.9, here's how to solve it!](https://oraclesolutions.pk/error-while-starting-weblogic-admin-service-in-ebs-12-2-on-redhat-linux-8-9-heres-how-to-solve-it/) - OS level error while starting WebLogic Admin adadminsrvctl.sh service in EBS 12.2 on Redhat and or Oracle Linux 8.9 : You are running adadminsrvctl.sh version 120.10.12020000.11 Starting WLS Admin Server…Refer /u01/8005_uat_app/ebiz/fs1/inst/apps/PREUPG_ebsappuat/logs/appl/admin/log/adadminsrvctl.txt for details AdminServer logs are located at /u01/8005_uat_app/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs adadminsrvctl.sh: exiting with status 0 adadminsrvctl.sh: check the logfile /u01/8005_uat_app/ebiz/fs1/inst/apps/PREUPG_ebsappuat/logs/appl/admin/log/adadminsrvctl.txt for more information … .end std
- [How to extract EBS 12.1.x or EBS 12.2.x Workflow Mailer logs having Error, Exception or UNEXPECTED Keywords in your target logfiles](https://oraclesolutions.pk/how-to-extract-ebs-12-1-x-or-ebs-12-2-x-workflow-mailer-logs-having-error-exception-or-unexpected-keywords-in-your-target-logfiles/) - Goal: Extraction of EBS 12.1.x or EBS 12.2.x Workflow Mailer logs having Error, Exception or UNEXPECTED Keywords in your target logfiles. By following the given below steps you will easily extract EBS 12.1.x or EBS 12.2.x Workflow Mailer logs having Error, Exception or UNEXPECTED Keywords in your target logfiles. Steps: Source EBS Run file system/
- [How to perform Basic Health Check, Stop & Start, Oracle E-Business 12.2.x Application & Database 19c  - 19.12](https://oraclesolutions.pk/how-to-perform-basic-health-check-stop-start-oracle-e-business-12-2-x-application-database-19c-19-12/) - Steps to STOP Oracle EBS 12.2.x Application Services:1. Connect Putty to Application Sever IP: 2. Login with Application OS User ( Username / password ) and source EBS Application Env 3. cd $ADMIN_SCRIPTS_HOME4. [applprod@erp scripts]$ pwd /u01/Ebiz/fs1/inst/apps/ERPPROD_erp/admin/scripts [applprod@erp scripts]$5. ./adstpall.sh apps/< passwordEnter Weblogic Password when Prompted Now EBS services will proceed to shut down…….Ensure All
- [How to save time and apply ebs 12.2 patch without adop online patching:](https://oraclesolutions.pk/how-to-save-time-and-apply-ebs-12-2-patch-without-adop-online-patching/) - GOAL: Avoid long and time taking adop online patching cycle and apply patch in downtime to your run file system quickly SOLUTION: adop phase=apply apply_mode=downtime
- [EBS 12.2: How to Enable Java Web Start for Java Applet Support in Modern Browsers](https://oraclesolutions.pk/how-to-enable-java-web-start-on-ebs-12-2-to-enable-all-latest-browsers-to-be-able-to-launch-java-applet/) - Step - 1: Apply All EBS 12.2 relevant Patches to your EBS Application from below JWS MOS Doc:Using Java Web Start with Oracle E-Business Suite(Doc ID 2188898.1) Step - 2: Enable Java Web Start : Source EBS Run FS Environment ( 12.2 )REGENERATE JAR FILES FORCE = YES Step -3 : UPDATE EBS CONTEXT FILE
- [How to shutdown / start pluggable Database only from a Container Database in 19c](https://oraclesolutions.pk/how-to-shutdown-start-pluggable-database-only-from-a-container-database-in-19c/) - =================================== Source Container Database Environment sqlplus "/ as sysdba" alter pluggable database EBSCLONE close immediate; alter pluggable database EBSCLONE open read write; =========================================
- [ERROR: while execution of txkPostPDBCreationTasks.pl ( Part of converting noncdb to pdb ) or any other 19c ebs Database phases:](https://oraclesolutions.pk/error-while-execution-of-txkpostpdbcreationtasks-pl-part-of-converting-noncdb-to-pdb-or-any-other-19c-ebs-database-phases/) - FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]ERRORMSG: Invalid APPS database user credentials. SOLUTION: Possible areas and tips to review and fix the above issue :Make sure :- Select name from v$active_services and make sure below services are present and configured:( ebs_PROD, PROD_ebs_patch, PROD)-PDB SID in small letters/Capital letters accordingly present in Ebs DB Ctx File.Make sure
- [After EBS 11i or EBS 12.1 Upgrade to EBS 12.2.x Some Pdf Reports show Garbage Characters](https://oraclesolutions.pk/after-ebs-11i-or-ebs-12-1-upgrade-to-ebs-12-2-x-some-pdf-reports-show-garbage-characters-2/) - After EBS 11i or EBS 12.1 Upgrade to EBS 12.2.x Some Pdf Reports show Garbage Characters OR After EBS 12.2.x Fresh Installation Some Pdf Reports show Garbage Characters after a Pre-developed Oracle Report is deployed to New EBS 12.2 Install SITUATION SHOWN ON REPORT VIEW: Insert IMAGE: CAUSE: Missing Font settings, Font File and Fornt
- [How to Change WebLogic Admin Password in EBS 12.2](https://oraclesolutions.pk/change-weblogic-admin-password-in-ebs-12-2-environment/) - Change weblogic admin password in ebs 12.2 environment by following the given below Steps. In EBS Apps DBA Life whenever you prepare a clone of Production ERP System, It is important to change all critical passwords to make it different from Live Production Enviroment.In this post I have provided steps particularly about how to change
- [How to save time and apply ebs 12.2 patch without adop online patching](https://oraclesolutions.pk/hello-world/) - GOAL: AVOID LONG AND TIME TAKING ADOP ONLINE PATCHING CYCLE AND APPLY PATCH IN DOWNTIME TO YOUR RUN FILE SYSTEM QUICKLY SOLUTION: adop phase=apply apply_mode=downtime
- [FS_CLONE give error at ADOPValidationUtils](https://oraclesolutions.pk/fs_clone-give-error-at-adopvalidationutils/) - FS_CLONE give error at ADOPValidationUtils When executing fs_Clone, the following error is encountered. ERROR [UNEXPECTED]Error occurred running "perl /u01/app/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/app/PROD/fs1/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml -patchctxfile=/u01/app/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml -phase=fs_clone -logloc=/u01/app/PROD/fs_ne/EBSapps/log/adop/48/20231102_181022/fs_clone/validate/funoracleapps -promptmsg=hide"[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on funoracleapps Checking log further below error is noticed. Use of uninitialized value $result in split at /u01/app/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.No such file or directory
- [Understanding AutoConfig in EBS](https://oraclesolutions.pk/understanding-autoconfig-in-ebs/) - Understanding AutoConfig in EBS/Oracle Apps R12.2 AutoConfig plays a pivotal role in Oracle E-Business Suite (EBS). When executed, it generates various configuration files from template files. In certain scenarios, you may need to identify and customize these template files to override the default settings used by AutoConfig. **Key Considerations for Customizing AutoConfig Templates** 1.
- [Autoconfig Completed With Error INSTE8_PRF 1](https://oraclesolutions.pk/autoconfig-completed-with-error-inste8_prf-1/) - Autoconfig Completed With Error Jtfictx.sh INSTE8_PRF 1 ERROR When attempting to run the autoconfig in apps Tier its completed with error jtfictx.sh INSTE8_PRF 1. ERROR at line 1:ORA-20000: Oracle Text error:DRG-10502: index JTF.JTF_AMV_ITEMS_URL_CTX does not existORA-06512: at "CTXSYS.DRUE", line 160ORA-06512: at "CTXSYS.CTX_DDL", line 1119ORA-06512: at "CTXSYS.AD_CTX_DDL", line 336ORA-06512: at line 96 SOLUTION 1.
- [Autoconfig Issue DRG-10502](https://oraclesolutions.pk/autoconfig-issue-drg-10502/) - Autoconfig DRG-10502: Index JTF.JTF_AMV_ITEMS_URL_CTX DNE ERROR: Autoconfig failing with the below error: Executing script in InstantiateFile:jtfictx.shscript returned:****************************************************jtfictx.sh started at Tue Oct 10 02:23:11 UTC 2023SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 10 02:23:11 UTC 2023Copyright (c) 1982, 2005, Oracle. All rights reserved.Enter value for 1: Enter value for 2: Enter value for 3:
- [Switchover MySQL](https://oraclesolutions.pk/switchover-mysql/) - Switchover MySQL Source 199Replica 198 SOURCE SET GLOBAL read_only=ON; set global super_read_only=ON; show variables like '%super%read%'; show variables like '%read_only%'; flush tables;flush logs; SHOW MASTER STATUS; REPLICA stop slave; set global read_only=OFF; set global super_read_only=OFF; show variables like '%read_o%'; SHOW MASTER STATUS; -- TEST-SQL2-bin.000002 --2760785 create user 'rep_user'@'172.25.2.198' identified with mysql_native_password by 'CP@MySQL2023'; create
- [Restarting MYSQL Instances and Servers](https://oraclesolutions.pk/restarting-mysql-instances-and-servers/) - Restarting MYSQL Instances and Servers Environment:- MySQL Database Instances running in two separate Windows Servers namely PROD (172.21.50.162) and DR (10.218.86.8). They have been setup as Source (PROD) and Replica (DR) using the MySQL native replication configuration which are in-sync. Restarting the MYSQL Databases (DR Server). Login to the DR (10.218.86.8) environment. Start
- [Configuration of MYSQL Master Slave Replication](https://oraclesolutions.pk/configuration-of-mysql-master-slave-replication/) - Configuration of MYSQL Master – Slave Replication Environment:- Two Server’s with MYSQL database and different hosts/nodes, Master (172.21.50.162) and Slave (10.218.86.8). Replication will be configured between these two servers as MYSQL Master – Slave replication. On Master (172.21.50.162):- Login to the Master (172.21.50.162) environment. Start the MYSQL workbench Connect to the server using the
- [Unable To Authenticate Session in Oracle APPS](https://oraclesolutions.pk/unable-to-authenticate-session-in-oracle-apps/) - Unable To Authenticate Session in Oracle APPS ERROR When accessing various Oracle E-Business Suite Release 12.1.x instances through Microsoft Internet Explorer versions 8 to 11, users encounter a specific problem. After successfully logging out from one instance and attempting to log in to a second or third instance, often a cloned version, an error
- [Applying EBS Latest CPU through ECPUC](https://oraclesolutions.pk/applying-ebs-latest-cpu-through-ecpuc/) - Applying EBS Latest CPU JUL-2023 through EBS Critical Patch Update Checker (ECPUC) Hello everyone, in today's blog post, I am excited to introduce you to the latest addition in the world of utilities - the EBS Critical Patch Update Checker (ECPUC). With its official release accompanying the July 2023 CPU, this utility brings some
- [Rename Datafile In Oracle Standby on New Location](https://oraclesolutions.pk/rename-datafile-in-oracle-standby-on-new-location/) - Rename Datafile In Oracle Standby on New Location "Suppose you come across a situation while serving a customer, where the DR server faces space limitations. In order to address this concern, I devised a solution to rename the data file and transfer it to a new mount with ample space. The process of renaming a
- [Oracle Apps Upgrade 12.2.0 to 12.2.12](https://oraclesolutions.pk/oracle-apps-upgrade-12-2-0-to-12-2-12/) - upgrading Oracle EBS Release R12.2.0 to R12.2.12
- [Oracle APPS 12.2 on OEL 7.9](https://oraclesolutions.pk/oracle-apps-12-2-on-oel-7-9/) - Installation of Oracle APPS 12.2.0 on OEL 7.9 Once all the prereqs steps are completed as discussed in an earlier post we are ready to do the installation of Apps12.2.0 In Case You are here for the first time, Kindly go through the Following Link given below before Proceeding with the Installation Of Oracle Apps
- [Creating Stage Area for Oracle Apps R12.2](https://oraclesolutions.pk/creating-stage-area-for-oracle-apps-r12-2/) - Creating Stage Area for Oracle Apps R12.2 In this post, our focus will be on the following: Verifying the version of the stage area and ensuring that all necessary zip files are downloaded and valid. If you haven't downloaded the media yet, you can refer to the link below for instructions on How to download
- [How to Download Oracle Products Media](https://oraclesolutions.pk/how-to-download-oracle-products-media/) - How to Download Oracle Products Media To access a majority of Oracle Enterprise Software downloads, it is necessary to have an account on Oracle e-delivery. In this blog post, I will provide step-by-step instructions on how to download Oracle Linux Media and Oracle E-Business Suit Media, enabling you to obtain these essential software components. Disclaimer:
- [OEL Configuration for Oracle Apps R12.2](https://oraclesolutions.pk/oel-configuration-for-oracle-apps-r12-2/) - OEL Configuration for Oracle Apps R12.2.12 In the preceding blog post, we discussed the installation procedure for Oracle Enterprise Linux (OEL). Our current objective is to configure and prepare the Linux system for the successful installation of Oracle Apps R12.2. Pre-Requisite Installation Steps for Oracle Apps R12.2 Configuration To ensure a seamless installation process,
- [Oracle Linux 7.9 Installation On Virtual Box](https://oraclesolutions.pk/oracle-linux-7-9-installation-on-virtual-box/) - Oracle Linux 7.9 Installation On Virtual Box In the previous section of this blog series, we explored the installation process of Oracle Virtual Box on a Windows operating system. Now, we will shift our focus towards preparing a virtual machine for the installation of Oracle Linux. To accomplish this, we will follow a set of
- [Oracle EBS Database Upgrade from 12c to 19c Part-2](https://oraclesolutions.pk/oracle-ebs-database-upgrade-from-12c-to-19c-part-2/) - Oracle EBS Database Upgrade from 12c to 19c Part-2 This post is a continuation of the previous article on Oracle EBS Database Upgrade from 12c to 19c Part-1. Here, we will delve into the remaining part of the database upgrade process from 12c to 19c. Let's begin with Section 6, building upon Section 5
- [Oracle EBS Database Upgrade from 12c to 19c Part-1](https://oraclesolutions.pk/oracle-ebs-database-upgrade-from-12c-to-19c/) - Oracle EBS Database Upgrade from 12c to 19c Part-1 In this article, I will be discussing the process of upgrading Oracle Database 12.1.0.2 to the latest version, 19.19 (Latest PSU APR-23), while using Oracle EBS Apps R12.2.12. This post follows the previous article on upgrading Oracle EBS Apps from version 12.2.0 to 12.2.12. If
- [Oracle VirtualBox Installation](https://oraclesolutions.pk/oracle-virtualbox-installation/) - Oracle VirtualBox Download and Installation Step By Step Process In this informative guide, we will walk you through the process of installing Oracle Virtual Box on the Windows operating system. Oracle Virtual Box is a feature-rich virtualization software that enables users to create and run virtual machines on their Windows-based systems. By following the
- [About Me](https://oraclesolutions.pk/about-me/) - Hi, This is Syed Saad Ali , Founder of oraclesolutions.pk I am a technically-sophisticated professional with extensive experience in updating server security, executing routine back-ups, and designing and implementing tests of the system to address issues with accessing data.I am adept at leading the planning, designing, developing, testing, and deploying efficient solutions within
- [First Post](https://oraclesolutions.pk/first-post/) - Test Post
- [EBS Critical Patch Update for April 2023](https://oraclesolutions.pk/ebs-critical-patch-update-for-april-2023/) - EBS Critical Patch Update for April 2023 The Critical Patch Update (CPU) for April 2023 was released on 18 April 2023. Oracle strongly recommends applying the CPU patches as soon as possible. MOS Note for EBS CPUs A link to the latest available Oracle E-Business Suite CPU document is available in Identifying the Latest Critical Patch
- [April 2023 FMW Consolidated Patches for EBS 12.2](https://oraclesolutions.pk/april-2023-fmw-consolidated-patches-for-ebs-12-2/) - April 2023 FMW Consolidated Patches for EBS 12.2 To facilitate Oracle E-Business Suite (EBS) customers in obtaining the necessary Oracle Fusion Middleware (FMW) patches, we are delighted to announce the availability of two consolidated zip files for FMW that have been recently released. These consolidated zip files are specifically tailored for EBS 12.2. The
- [Oracle VM Virtual Appliance for EBS 12.2](https://oraclesolutions.pk/oracle-vm-virtual-appliance-for-ebs-12-2/) - Oracle VM Virtual Appliance for EBS 12.2 Oracle is pleased to announce that a new VM Virtual Appliance, which contains Oracle E-Business Suite (EBS) Release 12.2.12 and Oracle Database 19c, can now be downloaded from the Oracle Software Delivery Cloud. You can use this on-premises appliance to create an EBS 12.2.12 Vision demonstration instance
- [EBS 12.2 Certified with Database Release Update 19.19](https://oraclesolutions.pk/ebs-12-2-certified-with-database-release-update-19-19/) - EBS 12.2 Certified with Database Release Update 19.19 - All Platforms (April 2023) We previously announced the release of the April 2023 updates to the E-Business Suite (EBS) Technology Codelevel Checker (ETCC) - Part II. With this update to ETCC, EBS 12.2 for all pending platforms (UNIX and Microsoft Windows) are now certified with Oracle
- [Oracle Dataguard 19c Configuration](https://oraclesolutions.pk/oracle-dataguard-19c-configuration/) - Oracle Dataguard 19c Configuration Implementing a disaster recovery solution for Oracle databases involves setting up Oracle 19c Dataguard with PDB, which ensures data protection and availability. Dataguard provides real-time data protection, automatic failover, and the ability to create standby databases for the primary database. In a Dataguard configuration, a PDB within a CDB can be
- [The worker should not have status Running or Restarted](https://oraclesolutions.pk/the-worker-should-not-have-status-running-or-restarted/) - AutoPatch error: The worker should not have status 'Running' or 'Restarted' at this point. ERROR: R12.2 ADOP:AutoPatch error:The worker should not have status 'Running' or 'Restarted' at this point. Telling workers to quit... All workers have quit. Connecting to APPS......Connected successfully. AutoPatch error:Error running SQL and EXEC commands in parallel
- [OPMNCTL startall Fails with status 4200](https://oraclesolutions.pk/opmnctl-startall-fails-with-status-4200/) - OPMNCTL startall Fails with unexpected exit: status 4200 When attempting to initiate the opmnctl services in E-Busines Suite R12.2, an error with the code 4200 is encountered as shown below. Error: opmnctl startall: starting opmn and all managed processes... [opmn] [ERROR:1] [] [internal] /u01/apps/fs1/FMW_Home/webtier/opmn/bin/opmn: unexpected exit: status 4200 opmnctl startall: opmn failed to start.
- [Steps to change password for APPS in EBS R12.2](https://oraclesolutions.pk/steps-to-change-password-for-apps-in-ebs-r12-2/) - Steps to change password for APPS in EBS R12.2 Today, we will delve into the process of changing the EBS APPS password in Oracle E-Business Suite R12.2. While this is a routine and fundamental task for every appsdba, it is essential to perform the steps cautiously to avoid any potential risks or unforeseen complications. Lets
- [Special Characters in APPS Password using FNDCPASS](https://oraclesolutions.pk/special-characters-in-apps-password-using-fndcpass/) - Special Characters in APPS Password using FNDCPASS Today, we will discuss the use of special characters in Oracle E-Business Suite (EBS) APPS passwords and the implications of using the FNDCPASS utility for password changes. Using special characters in passwords, particularly for database users like APPS, APPLSYS, and GL, is not supported when utilizing the FNDCPASS
- [Oracle Apex Upgrade to 22.2](https://oraclesolutions.pk/oracle-apex-upgrade-to-22-2/) - Oracle Apex Upgrade to 22.2 ORACLE APEX Oracle APEX (also known as APEX or Oracle Application Express) is an enterprise low-code development platform from Oracle Corporation that is used to develop and deploy web applications on Oracle databases. APEX provides a web-based integrated development environment (IDE) that uses wizards, drag-and-drop layout, and property editors
- [CVE-2023-21839 - Critical vulnerability in Oracle WebLogic](https://oraclesolutions.pk/cve-2023-21839-critical-vulnerability-in-oracle-weblogic/) - CVE-2023-21839 - Critical vulnerability in Oracle WebLogic CVE-2023-21839 refers to a critical vulnerability found in Oracle WebLogic, which is an enterprise-level application server used to deploy and manage Java-based applications. A Common Vulnerabilities and Exposures (CVE) identifier is a unique reference assigned to a specific security vulnerability. The CVE-2023-21839 vulnerability poses a significant risk to
- [How to Plug and Unplug a PDB in TDE Environment](https://oraclesolutions.pk/how-to-plug-and-unplug-a-pdb-in-tde-environment/) - Unplug and Plug of PDB in a Transparent Data Encryption (TDE) Environment Within an Oracle environment utilizing Transparent Data Encryption (TDE), the process of transferring a pluggable database (PDB) may necessitate additional procedures. In this blog post, we will explore the potential steps involved when performing an Unplug and Plug operation for a pluggable
- [How to Restrict Application Users in Oracle EBS](https://oraclesolutions.pk/how-to-restrict-application-users-in-oracle-ebs/) - How to Restrict Application Users to a Single Session in Oracle E-Business Suite Introduction: Maintaining security in an Oracle E-Business Suite (EBS) environment is crucial to protect sensitive data and ensure a secure user experience. One important security measure is restricting users to be signed in only once at any time. This prevents unauthorized access
- [OUTPUT POST PROCESSOR (OPP) LOG CONTAINS ERROR](https://oraclesolutions.pk/output-post-processor-opp-log-contains-error/) - OUTPUT POST PROCESSOR (OPP) LOG CONTAINS ERROR “JAVA.LANG.OUTOFMEMORYERROR” ERROR Follow the Navigation below for getting Output Post Processor log file 1. Select the System Administrator responsibility. 2. Select the menu Concurrent > Manager > Administer 3. Select the Output Post Processor Service 4. Select the Processes button. 5. Select Manager Log. 6. The
- [Tablespace Level Fragmentation](https://oraclesolutions.pk/tablespace-level-fragmentation/) - Tablespace Level Fragmentation in Oracle Database Introduction In this article, I will discuss tablespace level fragmentation, which causes slowness and wastage of space. Fragmentation is a common issue in Oracle databases due to excessive dml operations like insert followed by an update and delete operations. Brief Explanation: In Oracle, tablespace level fragmentation refers to space
- [Applying Patch on EBS Environment using ADOP](https://oraclesolutions.pk/applying-patch-on-ebs-environment-using-adop/) - Applying Patch on EBS Environment using ADOP and Creating a Restore Point for Database if patch fails in Cutover Phase Introduction: As an Apps DBA, applying patches to an E-Business Suite (EBS) environment is a critical task. To ensure a smooth patching process, it is essential to take precautions such as creating a restore point
- [Implementing Class of Secure Transport (COST) in Oracle RAC 11.2](https://oraclesolutions.pk/implementing-class-of-secure-transport-cost-in-oracle-rac-11-2/) - Implementing Class of Secure Transport (COST) in Oracle RAC 11.2 Introduction: Class of Secure Transport (COST) is a security feature introduced in Oracle Database 11g Release 2 (11.2) that enhances the security of network communication within Oracle Real Application Clusters (RAC) environments. By implementing COST, you can protect the integrity and confidentiality of data transmitted
- [Upgrade Time Zone File And Timestamp With Time Zone Data](https://oraclesolutions.pk/upgrade-time-zone-file-and-timestamp-with-time-zone-data/) - Upgrade Time Zone File And Timestamp With Time Zone Data Upgrading the time zone file and timestamp with time zone (TSTZ) data in an Oracle database is indeed necessary for certain scenarios, such as when you upgrade to a new version of the database or when there are changes to the rules for Daylight
- [Cleaning Up older records in AUD$ table](https://oraclesolutions.pk/cleaning-up-older-records-in-aud-table/) - Cleaning Up older records in AUD$ table Auditing refers to the process of monitoring and collecting specific user database actions and storing this information in designated tables. It is a feature that is consistently enabled in Oracle Database. During or after the execution of audited SQL statements, Oracle Database generates audit records. However, it's important
- [Redo Transport Services fails with ORA-16198](https://oraclesolutions.pk/redo-transport-services-fails-with-ora-16198/) - Redo Transport Services fails with ORA-16198 At the alert log, we received this error message on the production database for the 19c Data Guard. The primary alert log file showed: LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16198)LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandonedFri Jan 4 12:00:36 2023Errors in file //bdump/.trc:ORA-16198: Timeout incurred on internal channel during remote
- [Oracle Database 19C Enterprise Manager Express Not Working](https://oraclesolutions.pk/oracle-database-19c-enterprise-manager-express-not-working/) - Oracle Database 19C Enterprise Manager Express Not Working Our client, who is currently utilizing Oracle 19c Database, has expressed their desire to leverage Oracle Enterprise Manager (OEM) to monitor and analyze their database usage. Now Let us check some values from the database SQL> select dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------ 0 SQL> select dbms_xdb_config.gethttpport from
- [Oracle Data Guard Synchronization](https://oraclesolutions.pk/oracle-data-guard-synchronization/) - As an Oracle Database Administrator, one of the common challenges faced by DBAs is ensuring that the Disaster Recovery (DR) system is in sync with the Primary server. The DR system is crucial because it allows businesses to continue their operations even in the event of a disaster affecting the primary server. However,
- [Adding a New Managed Server on Oracle APPS R12.2](https://oraclesolutions.pk/adding-a-new-managed-server-on-oracle-apps-r12-2/) - Today We are going to Explore how to Ddd Managed Server on Oracle E-Business Suite R12.2. By default, every application tier node contains only a single instance of the OACORE, OAFM, FORMS and FORMS-C4WS Services. To increase the Web logic performance, we need to add up managed servers. For example, we are going
- [Roll forward of Data Guard in Oracle](https://oraclesolutions.pk/roll-forward-of-data-guard-in-oracle/) - Roll forward of Data Guard in Oracle In this blog post, we will be discussing the roll forward option of Dataguard in Oracle, which is a critical process in ensuring High Availability and Disaster Recovery for your database. We will be sharing some SQL commands that you can use to check the status of your
- [ERROR: ORA-01408 such column list already indexed](https://oraclesolutions.pk/error-ora-01408-such-column-list-already-indexed/) - ERROR ERROR: ORA-01408 such column list already indexed while upgrading database to 11.2.0.4 using DBUA SOLUTION Prior starting the upgrade drop the index in the SYSTEM Schema drop index system.REPCAT$_AUDIT_COLUMN_IDX1; Start the upgrade./dbua If the index is not dropped prior starting the upgrade, when the issue is faced drop the index and ignore the error so
- [Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request](https://oraclesolutions.pk/routine-fnd_dcp-request_session_lock-received-a-result-code-of-1-from-the-call-to-dbms_lock-request/) - ERROR The Concurrent Manager fails to start with the Error: The ICM is already running. Contact you system administrator for further assistance. A fpdlrq received an unsuccessful result from PL/SQL procedure or function FND_DCP.Request_Session_Lock. Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request. Possible DBMS_LOCK.Request resultCall to establish_icm failed. The Internal
- [ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors](https://oraclesolutions.pk/ora-04063-package-body-apps-ap_acctg_data_fix_pkg-errors/) - ERROR ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors ORA-06508: PL/SQL: could not find program unit being called: "APPS.AP_ACCTG_DATA_FIX_PKG" ORA-06512: at line 38 When trying to compile "APPS.AP_ACCTG_DATA_FIX_PKG", following errors are shown: AP_ACCTG_DATA_FIX_PKG PLS-00394: wrong number of values in the INTO list of a FETCH statement SOLUTION STEP 1. Download and review the readme and pre-requisites
- [The persistent store "_WLS_AdminServer" could not be deployed: weblogic.store.PersistentStoreException](https://oraclesolutions.pk/persistent-store-_wls_adminserver-not-deployed-weblogic-store-persistentstoreexception/) - ERROR
- [How to Get Apps Password From Backend](https://oraclesolutions.pk/how-to-get-apps-password-from-backend/) - How to Get Apps Password From Backend STEP 1. First login to Database through Command Prompt sqlplus / as sysdba STEP 2 : Create Function From Below Script to decrypt the encrypted password create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2, in_chr_encrypted_pin IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; STEP
- [How to clean FND_NODES table in Oracle Applications](https://oraclesolutions.pk/clean-fnd_nodes-table-oracle-applications/) - How to clean FND_NODES table in Oracle Applications Note: Remember That All the Latest Cloning Patches Should Be Applied to avoid Any Ambiguity. Step 1: Login to Database with Apps User $ sqlplus apps/apps SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN; SQL>COMMIT; SQL>EXIT; It will delete all old data from the table. Step 2: Run AutoConfig on all tiers, first
- [How to Change Weblogic Password in Oracle APPS R12.2](https://oraclesolutions.pk/how-to-change-weblogic-password-in-oracle-apps-r12-2/) - How to Change Weblogic Password in Oracle APPS R12.2 Today we will explore how to change Weblogic Admin Password in Oracle E-Business Suite 12.2.x, we will explore 2 different scenarios according to the Patch Level available in the System. Scenario 1: You are on R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 or later, we can change the Weblogic admin
- [Oracle E-Business Suite on Autonomous Database on Dedicated Exadata Infrastructure](https://oraclesolutions.pk/oracle-e-business-suite-on-autonomous-database-on-dedicated-exadata-infrastructure/) - Oracle E-Business Suite (EBS) Release 12.2 is now certified for Autonomous Database on Dedicated Exadata Infrastructure. Oracle runs best on Oracle. So, running Oracle applications on the Autonomous Database Dedicated is the obvious choice because it uses groundbreaking machine learning (ML)-backed automation to accelerate innovation, reduce costs, and reduce risks. Autonomous Database on Dedicated Exadata
- [How to FIND Oracle EBS R12 Component Versions](https://oraclesolutions.pk/how-to-find-oracle-ebs-r12-component-versions/) - How to FIND Oracle EBS R12 Component Versions
- [JBO-29000: Unexpected exception caught: java.lang.NoClassDefFoundError, msg=Could not initialize class oracle.apps.fnd.functionSecurity.User](https://oraclesolutions.pk/jbo-29000-unexpected-exception-caught-java-lang-noclassdeffounderror-msgcould-not-initialize-class-oracle-apps-fnd-functionsecurity-user/) - Unexpected exception caught: java.lang.NoClassDefFoundError, msg=Could not initialize class oracle.apps.fnd.functionSecurity.User
- [Oracle EBS with Oracle Database 19c FAQs](https://oraclesolutions.pk/oracle-ebs-with-oracle-database-19c-faqs/) - Oracle EBS with Oracle Database 19c FAQs
- [Oracle Database Appliance Software](https://oraclesolutions.pk/oracle-database-appliance-software/) - Oracle Database Appliance (ODA) Software
- [Oracle Database Appliance X8](https://oraclesolutions.pk/oracle-database-appliance-x8/) - Oracle Database Appliance X8
- [Persistent Memory in Exadata X8M](https://oraclesolutions.pk/persistent-memory-in-exadata-x8m/) - Persistent Memory in Exadata X8M
- [Oracle Exadata Database Machine X9M](https://oraclesolutions.pk/oracle-exadata-database-machine-x9m/) - Oracle Exadata Database Machine X9M
- [EBS Upgrade Recommendations Nov 2021](https://oraclesolutions.pk/ebs-upgrade-recommendations-nov-2021/) - EBS Upgrade Recommendations November 2021
- [RAC Management Commands](https://oraclesolutions.pk/rac-management-commands/) - Basic RAC Management Commands Cluster Related Commands crs_stat -t Shows HA resource status (hard to read) crsstat Ouptut of crs_stat -t formatted nicely ps -ef|grep d.bin crsd.bin evmd.bin ocssd.bin crsctl check crs CSS,CRS,EVM appears healthy crsctl stop crs Stop crs and all other services crsctl disable crs* Prevents CRS from starting on reboot crsctl
- [Adpreclone.pl Fails on Applications Tier With Error Message "Edit session is enabled in domain](https://oraclesolutions.pk/adpreclone-pl-fails-on-applications-tier-with-error-message-edit-session-is-enabled-in-domain/) - adpreclone.pl Fails on Applications Tier With Error Message "Edit session is enabled in domain
- [Oracle 19c Active Data Guard DML Redirection Feature](https://oraclesolutions.pk/oracle-19c-active-data-guard-dml-redirection-feature/) - 19c Active DataGuard DML Redirection ACTIVE DATAGUARD DML REDIRECTION is a new feature in Oracle 19c which enables the Data Manipulation Language (DML) operations on the Standby Server to be redirected and run on the production (Primary) database. The updated data will be streamed back to standby to maintain redundancy. Whenever DML we fire on standby
- [Oracle E-Business Suite 12.2.11 Now Available](https://oraclesolutions.pk/oracle-e-business-suite-12-2-11-now-available/) - Oracle announces Oracle E-Business Suite 12.2.11 on 4th November 2021. EBS 12.2.11 delivers new functional innovations for including industry-focused and cross-industry investments. For details regarding the EBS 2021 innovations, see: Announcing Oracle E-Business Suite 2021 Innovations (PDF) The EBS 12.2.11 release update pack (RUP) is delivered on My Oracle Support as Patch 31856789. Instructions for downloading
- [Oracle Database Release Update 19.9 (October 2020) Now Certified With EBS 12.1.3](https://oraclesolutions.pk/oracle-database-release-update-19-9-october-2020-now-certified-with-ebs-12-1-3/) - We are pleased to announce that Oracle Database Release Update 19.9 (19.9.0.0.201020) is now certified with Oracle E-Business Suite Release 12.1.3 on-premises. For additional details, refer to Appendix A, Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (MOS Note 2580629.1) References Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (MOS Note 2580629.1)
- [Multi-tenant container database architecture in Oracle Database 12cr1](https://oraclesolutions.pk/multi-tenant-container-database-architecture-oracle-database-12cr1/) - Multi-tenant container database architecture in Oracle Database 12cr1 The Oracle Database 12c Release1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of multiple pluggable databases (PDBs) together in a multi-tenant container database (CDB). Various PDBs store data in objects independently of other PDBs and are maintained separately. Because PDBs isolate data and operations, each PDB is
- [ORA-12720: operation requires database is in EXCLUSIVE mode](https://oraclesolutions.pk/ora-12720-operation-requires-database-exclusive-mode/) - ERROR CREATE CONTROLFILE ................................. ................................................. CHARACTER SET AL32UTF8; ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode SOLUTION SQL> alter system set cluster_database=FALSE scope=spfile sid='*'; SQL> shutdown immediate; SQL>startup nomount; Now, re-run script for creating controlfile CREATE CONTROLFILE ................................. ................................................. CHARACTER SET AL32UTF8; Control file created. Then, change parameter with
- [Webcast: "Managing Oracle E-Business Suite Auditing and Security"](https://oraclesolutions.pk/webcast-managing-oracle-e-business-suite-auditing-security/) - Webcast: "Managing Oracle E-Business Suite Auditing and Security" By: Steven Chan | Senior Director Oracle University has a large number of free recorded webcasts for Oracle E-Business Suite. One of the essential webcasts on security that all EBS sysadmins should review is: Managing Oracle E-Business Suite Auditing and Security (40 mins) Eric Bing, Senior Director
- [APP-AR-96983 : User Write-off limit does not exist](https://oraclesolutions.pk/app-ar-96983-user-write-off-limit-not-exist/) - ERROR APP-AR-96983 : User Write-off limit does not exist SOLUTION Step 1. Navigate to Responsibility: Receivables Manager Step 2. Navigate to : Setup > Transactions > Approval Limit Enter user limit for each currency the user is allowed to write off Step 3. Define system write-off limit Navigation To: Setup > System > System Options
- [rlwrap: error: Cannot execute sqlplus: No such file or directory](https://oraclesolutions.pk/rlwrap-error-cannot-execute-sqlplus-no-file-directory/) - ERROR $ sqlplus / as sysdba rlwrap: error: Cannot execute sqlplus: No such file or directory SOLUTION Add the following to the environment file: export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib
- [RW-50004: An Error Has Occurred](https://oraclesolutions.pk/rw-50004-an-error-has-occurred/) - While Installing Oracle E-Business Suite we might get the following error: RW-50004: An Error Has Occurred, Check the log file for details: There are Multiple solutions for this particular error, Check the log file and apply the solution accordingly. SOLUTION 1: In case of Below Error RW-50010: Error: - script has returned an error:
- [ORA-01442: column to be modified to NOT NULL is already NOT NULL ](https://oraclesolutions.pk/ora-01442-column-to-be-modified-to-not-null-is-already-not-null/) - ERROR Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL sql> alter table HR.employees modify UID not null; ORA-01442: column to be modified to NOT NULL is already NOT NULL SOLUTION ALTER TABLE table_name ADD CONSTRAINT constraint_name CHECK(column_name IS NOT NULL); OR ALTER TABLE hr.employees ADD CONSTRAINT nn_uid_hr_addrsdtls CHECK(UID IS NOT NULL);
- [RMAN backup and logical backup With Different User](https://oraclesolutions.pk/rman-backup-logical-backup-different-user/) - RMAN backup and logical backup With Different User Step 1: Create the user CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp PROFILE DEFAULT; GRANT CONNECT TO bkp_user; GRANT exp_full_database TO bkp_user; GRANT imp_full_database TO bkp_user; GRANT recovery_catalog_owner TO bkp_user; GRANT select_catalog_role TO bkp_user; GRANT CREATE SESSION TO bkp_user; Step 2: Connect RMAN with the Above Created User $ rman RMAN> connect target bkp_user/bkp_user RMAN> backup database; Note: Script can be written and job can be scheduled to take backup.
- [How to Find and repair Corrupt block in database](https://oraclesolutions.pk/find-repair-corrupt-block-database/) - How to Find and repair Corrupt block in database Step 1: Below query will show if there is any corrupted block SELECT * FROM v$database_block_corruption -- will show if any corruped block Step 2: Below query can give you Detail information about corrupted block: set head ON; set pagesize 2000 set linesize 250 SELECT * FROM v$database_block_corruption; SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file#, Greatest(e.block_id, c.block#) corr_start_block#, Least(e.block_id + e.blocks - 1, c.block# + c.blocks - 1) corr_end_block# , Least(e.block_id + e.blocks - 1, c.block# + c.blocks - 1) - Greatest(e.block_id, c.block#) + 1 blocks_corrupted, NULL description FROM dba_extents e, v$database_block_corruption c
- [ORA-07445: exception encountered: core dump](https://oraclesolutions.pk/ora-07445-exception-encountered-core-dump-2/) - ERROR ORA-07445: exception encountered: core dump [kglic0()+756] [SIGSEGV] [ADDR:0x430000010B8AE910] [PC:0x107AB7474] [Address not mapped to object] [] SOLUTION SQL> ALTER SYSTEM SET "_cursor_stats_enabled"=false SCOPE=SPFILE; Caution : This recommendation can be applied in prod database with Oracle support only. If you are applying it is your own risk.
- [ORA-01157: cannot identify/lock data file 206 - see DBWR trace file](https://oraclesolutions.pk/ora-01157-cannot-identifylock-data-file-206-see-dbwr-trace-file/) - ERROR ORA-01157: cannot identify/lock data file 206 - see DBWR trace file ORA-01110: data file 206: '+DATA' SOLUTION If you are using XML in your database and you are trying to update any XML data, then above error may come. Step 1: Add below line in your parameter file and bounce the database if not
- [Oracle Database 19c (19.3) Now Certified With EBS 12.1.3](https://oraclesolutions.pk/oracle-database-19c-certified-with-ebs-12-1-3/) - Oracle Database 19.3 is now certified with Oracle E-Business Suite Release 12.1.3 on-premises. As an Oracle E-Business Suite 12.1.3 on-premises customer, you may now start planning your upgrade to Oracle Database 19c.
- [Generating AWR Reports](https://oraclesolutions.pk/generating-awr-reports/) - Generating AWR Reports You can generate AWR reports by running SQL scripts, as described below :- # Generating an AWR Report @$ORACLE_HOME/rdbms/admin/awrrpt.sql # To generate an AWR report on a specific database instance: @$ORACLE_HOME/rdbms/admin/awrrpti.sql # To generate an AWR report in an Oracle RAC environment: @$ORACLE_HOME/rdbms/admin/awrgrpt.sql #To generate an AWR report on
- [Comparison Between Oracle GoldenGate and DataGuard](https://oraclesolutions.pk/comparison-oracle-goldengate-dataguard/) - Comparison Between Oracle GoldenGate and DataGuard Technical Points Oracle Dataguard / Active Dataguard Oracle Golden Gate Operating System Primary Database and Standby Database Should be same. (But 11g Onwards it supports Heteregenous Data Guard Configurations. Example : We can imeplement Oracle Data Guard between Oracle Linux server 6.2 (x86_64) and Microsoft Windows 2008 Server R2 (x64) Primary Database
- [Data Guard Vs SAN To SAN Replication](https://oraclesolutions.pk/data-guard-vs-san-san-replication/) - Data Guard Vs SAN to SAN Replication Oracle Data Guard SAN-to-SAN Implementation Cost Low High Database Aware Yes No Granularity of Replication Transaction level Disk Block Level Distance Limitations No Limitations Limitations Exist Recovery from human error or corruption Easy to detect and can be recovered by replaying logs Replicates block as it is
- [Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE](https://oraclesolutions.pk/adding-responsibility-sysadmin-user-resulted-ora-20001-fnd_cant_insert_user_role/) - ERROR Oracle error - 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE (USERNAME=SYSADMIN) (ROLENAME=FND_RESP|FND|FND_FUNC_ADMINI|STANDARD) (ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT SOLUTION This Issue exists in default R12 installation Step 1. Run the concurrent program "Workflow Directory Services User/Role Validation" with parameters : 100000, Yes, Yes, No Step 2. Bounce all services under oacore or bounce opmnctl . Reference Oracle Note
- [Query To find the details of the Accounting Flexfield structure](https://oraclesolutions.pk/query-find-details-accounting-flexfield-structure/) - SELECT gls.name, idfs.id_flex_num chart_of_accounts_id, idfs.segment_num, idfs.flex_value_set_id, fvs.flex_value_set_name, idfs.application_id, idfs.id_flex_code, idfs.application_column_name, idfs.segment_name, fvs.security_enabled_flag, ( CASE WHEN fvs.validation_type = 'F' THEN 'Table' WHEN fvs.validation_type = 'I' THEN 'Independent' WHEN fvs.validation_type = 'D' THEN 'Dependent' WHEN fvs.validation_type = 'N' THEN 'None' WHEN fvs.validation_type = 'P' THEN 'Pair' WHEN fvs.validation_type = 'U' THEN 'Special' ELSE 'Unknown Type' END ) validation_type, ( CASE WHEN fvs.validation_type = 'F' THEN fvt.application_table_name ELSE 'Not Applicable' END ) validation_table_name FROM gl_ledgers gls, fnd_id_flex_segments idfs, fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt WHERE gls.chart_of_accounts_id (+) = idfs.id_flex_num AND fvs.flex_value_set_id = idfs.flex_value_set_id AND gls.ledger_id = &ledgerid AND idfs.application_id = 101 AND idfs.id_flex_code IN ( 'GL#', 'GLLE' ) AND fvs.flex_value_set_id = fvt.flex_value_set_id (+) ORDER BY idfs.id_flex_code, idfs.id_flex_num, idfs.segment_num ASC;
- [Oracle Real Application Cluster Intro](https://oraclesolutions.pk/oracle-real-application-cluster-intro/) - Oracle Real Application Cluster Intro RAC Defination Oracle RAC stands for Oracle Real Application cluster. It is a clustering solution that ensures high availability of databases by providing instance failover and Load Balancing features. Oracle RAC is composed of two or more database instances. They are composed of Memory structures and background processes same as
- [How to Find CPU Usage for a Session](https://oraclesolutions.pk/how-to-find-cpu-usage-for-a-session/) - How to Find CPU Usage for a Session SET linesize 145 SET pagesize 9999 COLUMN sid format 9999 heading 'SID' COLUMN serial_id format 999999 heading 'Serial#' COLUMN session_status format a9 heading 'Status' justify right COLUMN oracle_username format a12 heading 'Oracle User' justify right COLUMN os_username format a9 heading 'O/S User' justify right COLUMN os_pid format 9999999 heading 'O/S PID' justify right COLUMN session_program format a20 heading 'Session Program' trunc COLUMN session_machine format a14 heading 'Machine' justify right trunc COLUMN cpu_value format 999, 999, 999, 999 heading 'CPU' prompt prompt +----------------------------------------------------+ prompt | USER sessions ordered BY cpu | prompt +----------------------------------------------------+ SELECT s.sid sid, s.serial# serial_id, Lpad(s.status, 9) session_status, Lpad(s.username, 12) oracle_username, Lpad(s.osuser, 9) os_username, Lpad(p.spid, 7) os_pid, s.program session_program, Lpad(s.machine, 14) session_machine, sstat.value cpu_value FROM v$process p, v$session s, v$sesstat sstat, v$statname statname WHERE p.addr (+) = s.paddr AND s.sid = sstat.sid AND statname.statistic# = sstat.statistic# AND statname.name = 'CPU used by this session' ORDER BY cpu_value DESC
- [How to Find Database Object and it's Corresponding Datafiles](https://oraclesolutions.pk/how-to-find-database-object-and-its-corresponding-datafiles/) - How to Find Database Object and it's Corresponding Datafiles SELECT DISTINCT t.ts#, t.name AS Tablespace_name, d.name AS DATAFILE, s.owner, s.segment_name, s.segment_type, s.bytes / 1024 / 1024 AS "MB" FROM v$tablespace t, v$datafile d, dba_segments s WHERE t.ts# = d.ts# AND t.name = s.tablespace_name AND s.owner = 'APPS';
- [How to rename a Datafile with Extension .dbf?](https://oraclesolutions.pk/how-to-rename-a-datafile-with-extension-dbf/) - How to rename a Datafile with Extension .dbf? For example we have added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> shutdown immediate; Step 2. Startup the Database in Mount State SQL> startup mount Step 3. Now copy the datafile by renaming it with .dbf
- [Difference between P-File and SP-File?](https://oraclesolutions.pk/difference-between-p-file-and-sp-file/) - Difference between P-File and SP-File? P-FILE SP-FILE It is called as parameter file. It is called as server parameter file. P-File is ASCII file and it can be edited Manually spfile is binary file and it cannot be edited Manually Parameters can be changed through following options: 1)alter system 2)alter session Command SQL>alter system set resource_limit=true scope=_________; Where ______ is BOTH=changes
- [How to find the Oracle E-Business Suite R12 application URL?](https://oraclesolutions.pk/find-oracle-e-business-suite-r12-application-url/) - How to find the Oracle E-Business Suite R12 application URL? $ sqlplus apps/appsdrdg SQL*Plus: Release 10.2.0.4.0 - Production on Fri Oct 20 16:55:32 2017 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
- [Application Names in Oracle E-Business Suite R12](https://oraclesolutions.pk/application-names-in-oracle-e-business-suite-r12/) - Application Names in Oracle E-Business Suite R12 Application ID Application Name Application Short Name Basepath 1 0 Application Object Library FND FND_TOP 2 1 System Administration SYSADMIN FND_TOP 3 3 Application Utilities AU AU_TOP 4 40 Environment Management System EMS EMS_TOP 5 41 Patch Tracking System PTX PTX_TOP 6 50 Applications DBA AD AD_TOP
- [Change Date and Time Formats In Oracle Database?](https://oraclesolutions.pk/change-date-time-formats-oracle-database/) - Change Date and Time Formats In Oracle Database? Option 1. If We want to change this format to DD/MONTH/YYYY format. SQL> alter session set nls_date_format='DD/MONTH/YYYY'; Session altered. SQL> select sysdate from dual; SYSDATE ----------------- 20/OCTOBER /2017 Option 2. If we want get the both date and time SQL> alter session set nls_date_format='DD/MONTH/YYYY HH24:MI:SS'; Session
- [How To Find Oracle Database 32 bit or 64 bit](https://oraclesolutions.pk/find-oracle-database-32-bit-64-bit/) - How To Find Oracle Database 32 bit or 64 bit Finding Oracle Database Version on your system through Operating System $ cd $ORACLE_HOME $ cd bin $ file oracle oracle: ELF-64 executable object file - IA64 Finding Oracle Database Version on your system through SQL Prompt SQL> select metadata from sys.kopm$ ; METADATA -------------------------------------------------------------------------------- 0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405
- [How to Check Version of Apache in Oracle Apps?](https://oraclesolutions.pk/check-version-apache-oracle-apps/) - How to Check Version of Apache in Oracle Apps? Step 1. Goto Oracle Application Home $ cd $IAS_ORACLE_HOME/Apache/Apache/bin/ $ pwd /apps/ebs/apps/tech_st/10.1.3/Apache/Apache/bin Step 2. Write httpd -v to fetch the Version Details of Apache $ httpd -v Server version: Oracle-Application-Server-10g/10.1.3.0.0 Oracle-HTTP-Server Server built: Dec 27 2006 02:31:21
- [A Brief Introduction to ADPatch](https://oraclesolutions.pk/brief-introduction-adpatch/) - A Brief Introduction to ADPatch AutoPatch (adpatch) "AutoPatch (adpatch) is the utility you use to apply patches to the Oracle E-Business Suite file system or database." Modes Of adpatch There Are Four Modes given Below In which ADpatch Can Be User Interactive mode Non-Interactive mode Test mode Pre-Install mode Interactive Mode It is the
- [Temporary Tablespace and Datafile Management in Oracle database](https://oraclesolutions.pk/temporary-tablespace-datafile-management-oracle-database/) - Temporary Tablespace and Datafile Management in Oracle database 1. For Finding temp file and temp tablespace with size SELECT file#, status, bytes / 1024 / 1024 "Size_MB", name FROM v$tempfile; SELECT file_name, tablespace_name, bytes / 1024 / 1024 / 1024, status FROM dba_temp_files; 2. Add tempfile to existing temp tablespace SQL>ALTER TABLESPACE temp ADD tempfile '/u02/apps/oracle/temp01_01.dbf' SIZE 2048m; 3. Add new temp tablespace and make as default SQL>CREATE TEMPORARY TABLESPACE temp2 tempfile '/u02/apps/oracle/temp01.dbf' SIZE 2g autoextend ON; SQL>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2; Note: use "reuse" if datafile physically exists.
- [unable to spawn jobq slave process, slot 0, error 1089](https://oraclesolutions.pk/unable-to-spawn-jobq-slave-process-slot-0-error-1089/) - ERROR kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089 SOLUTION Start your Database force fully if you don't have memory issues. $ sqlplus / as sysdba SQL> startup force; This will cause your database will be force fully down and start it again. Note: Shut abort will not work in this situation.
- [An Introduction to Financial Statement Generator (FSG)](https://oraclesolutions.pk/introduction-financial-statement-generator-fsg/) - An Introduction to Financial Statement Generator (FSG) Financial Statement Generator The Financial Statement Generator (FSG) is a powerful reporting engine that supports interchangeable report objects, server-based processing for high performance, and report scheduling for efficient use of system resources. You can define reports on-line with complete control over the rows, columns and contents of your
- [How To Setup Printers on Oracle Apps](https://oraclesolutions.pk/setup-printers-oracle-apps/) - How To Setup Printers on Oracle Apps Defined Printer at Unix OS level First check the status of printer at unix level by issuing the following command: $lpstat –a Step To Configure Printer in Oracle Applications Define Driver Define Style Define Printer Type Register the Printer 1. Define Driver Login to application using System Administrator
- [ELFCLASS64 at /usr/lib64/perl5/XSLoader.pm line 70](https://oraclesolutions.pk/elfclass64-usrlib64perl5xsloader-pm-line-70/) - ERROR ============================================= *** Latest formsapp.ear has been deployed *** ============================================= Program : /u01/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Tue Sep 4 05:45:23 2015 Perl script txkChkFormsDeployment.pl got executed successfully adformsctl.sh: exiting with status 0 adformsctl.sh: check the logfile /u01/apps/inst/apps/EBS_PROD/logs/appl/admin/log/adformsctl.txt for more information ... .end std out. Can't load '/usr/lib64/perl5/auto/Sys/Hostname/Hostname.so' for module Sys::Hostname: /usr/lib64/perl5/auto/Sys/Hostname/Hostname.so: wrong ELF class: ELFCLASS64 at
- [opmnctl start: failed. Can not resolve test.oracle.com for interface any](https://oraclesolutions.pk/can-not-resolve-test-oracle-com-for-interface-any/) - ERROR OPMN ERROR: ---------- Can not resolve test.oracle.com for interface any opmnctl start: failed. SOLUTION The issue usually occurs due to improper entries in the /etc/hosts file, Validate your /etc/hosts and verify the loopback entries (127.0.0.1), The loopback address should be in the below format. 127.0.0.1 localhost.localdomain localhost If still you have the issue, verify
- [ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST](https://oraclesolutions.pk/processorexception-unable-determine-smtp-server-use-set-fnd_smtp_host/) - ERROR Outpost Processot has encoutered the below error. This error can be found in OPP logs: ---------------------------------------- [GC 14000K->8604K(32459K), 0.0068459 secs] ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST at oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66) at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91) at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176) ---------------------------------------- SOLUTION Step 1. Log into System Administrator responsibility. Step 2. Navigate to Profile >
- [The Output Post-processor is running but has not picked up this request](https://oraclesolutions.pk/output-post-processor-running-not-picked-request/) - ERROR OPP Error in the Log file: ------------------------------------------------------------------------ The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status. Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary. ------------------------------------------------------------------------
- [System Administrator Responsibility Missing In Sysadmin](https://oraclesolutions.pk/system-administrator-responsibility-missing-sysadmin/) - ERROR System Administrator Responsibility Missing In Sysadmin SOLUTION STEP 1. Execute following select : SELECT * FROM Fnd_Responsibility_vl WHERE Application_Id = 1 AND Responsibility_Name = 'System Administrator' AND Start_Date Sysdate ); STEP 2. Execute following select : SELECT count(*) FROM Fnd_User_Resp_Groups; STEP 3. Execute following
- [mod_ossl: Cannot allocate memory for the 'shmcb' session cache\n](https://oraclesolutions.pk/mod_ossl-cannot-allocate-memory-shmcb-session-cachen/) - ERROR The below error observed from error.log. [error] mod_ossl: Cannot allocate memory for the 'shmcb' session cache\n [error] mod_ossl: Cannot allocate memory for the 'shmcb' session cache\n [warn] pid file /u01/inst/apps/TEST_vin01/pids/10.1.3/Apache/httpd.pid overwritten -- Unclean shutdown of previous Apache run? [error] mod_ossl: Cannot allocate memory for the 'shmcb' session cache\n SOLUTION Step 1. First Go to
- [ORA-12157: TNS:internal network communication error](https://oraclesolutions.pk/ora-12157-tnsinternal-network-communication-error/) - ERROR ORA-12157: TNS:internal network communication error SOLUTION This error ussualy occurs when the network files are not generated properly. Relink them using the below commands to fix the issue. Step 1. Go to Oracle Home cd $ORACLE_HOME/network/lib Step 2. Regenerate file by giving the following Command $make -f ins_net_client.mk ntcontab.o Step 3. Got to bin
- [How to Stop Concurrent Manager Properly](https://oraclesolutions.pk/stop-concurrent-manager/) - How to Stop Concurrent Manager Properly Step 1. Go to Oracle Application Scripts Home $cd /apps/ebs/inst/apps/PROD_apps/admin/scripts Step 2. Stop Concurrent Manager with the following script $adcmctl.sh stop Step 3. Check the Processes for Concurrent Manager, is it still running. $ps -ef |grep FNDLIBR Step 4. If there are processes running the we can manually kill
- [Different Statuses of Concurrent Manager](https://oraclesolutions.pk/different-statuses-concurrent-manager/) - Different Statuses of Concurrent Manager PENDING STATUS Normal - Request is waiting for the next available manager. Currently all manager are running other requests. Standby - Program to run request is incompatible with other program(s) currently running. The requests will be in the Conflict Resolution Manager’s queue. Once the other request with which the request is incompatible gets completed then
- [How to Find Scheduled Concurrent Program](https://oraclesolutions.pk/find-scheduled-concurrent-program/) - How to Find Scheduled Concurrent Program Below Query will Fetch all the details for a scheduled concurrent program. SELECT a.requested_by, a.status_code, a.phase_code, a.request_id, b.user_concurrent_program_name, c.concurrent_program_name, a.requested_start_date, c.execution_method_code, d.execution_file_name, d.execution_file_path FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_programs_tl b, apps.fnd_concurrent_programs c, apps.fnd_executables d WHERE a.status_code IN ( 'Q', 'I' ) AND a.concurrent_program_id = b.concurrent_program_id AND b.concurrent_program_id = c.concurrent_program_id AND c.application_id = d.application_id AND c.executable_id = d.executable_id AND a.requested_start_date > SYSDATE AND a.hold_flag = 'N' ORDER BY 1; Query For Finding schedules for a particular program SELECT a.requested_by, a.status_code, a.phase_code, a.request_id, b.user_concurrent_program_name, c.concurrent_program_name, a.requested_start_date, c.execution_method_code, d.execution_file_name,
- [How to Find Request Group associated for a Program](https://oraclesolutions.pk/find-request-group-associated-program/) - How to Find Request Group associated for a Program SELECT rg.application_id "Request Group Application ID", rg.request_group_id "Request Group - Group ID", rg.request_group_name, rg.description, rgu.unit_application_id, rgu.request_group_id "Request Group Unit - Group ID", rgu.request_unit_id, cp.concurrent_program_id, cp.concurrent_program_name, cpt.user_concurrent_program_name, Decode(rgu.request_unit_type, 'P', 'Program', 'S', 'Set', rgu.request_unit_type) "Unit Type" FROM fnd_request_groups rg, fnd_request_group_units rgu, fnd_concurrent_programs cp, fnd_concurrent_programs_tl cpt WHERE rg.request_group_id = rgu.request_group_id AND rgu.request_unit_id = cp.concurrent_program_id AND cp.concurrent_program_id = cpt.concurrent_program_id AND cpt.user_concurrent_program_name = 'Program Name';
- [ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE](https://oraclesolutions.pk/ora-08004-sequence-fnd_concurrent_processes_s-nextval-exceeds-maxvalue/) - ERROR Routine AFPGCP cannot create a process ID for your concurrent manager process ORACLE error 8004 in FDUUID Cause: FDUUID failed due to ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated. TheCall to establish_icm failed The Internal Concurrent Manager has encountered an error. SOLUTION The max value for the sequence FND_CONCURRENT_PROCESSES_S has been reached
- [How to Add Responsibility to User from Back End](https://oraclesolutions.pk/how-to-add-responsibility-to-user-from-back-end/) - How to Add Responsibility to User from Back End SYNTAX fnd_user_pkg.addresp(username => Application User Name ,resp_app => Responsiblity_Application_Short_Name ,resp_key => Responsibility_Key ,security_group => Security_Group 'Mostly it is 'STANDARD' so it can be hard coded it' ,description => Any comments you want ,start_date => Sysdate From Today ,end_date => Sysdate + any number of days which
- [How to Enable/Disable Maintenance Mode without using ADADMIN](https://oraclesolutions.pk/enabledisable-maintenance-mode-without-using-adadmin/) - Enable/Disable Maintenance Mode without using ADADMIN We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure: Enable Maintenance Mode: $sqlplus apps/appspassword SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE Disable Maintenance Mode: $sqlplus apps/appspassword SQL>$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
- [ORA-12899: value too large for column "APPLSYS"."FND_PROFILE_OPTION_VALUES"."PROFILE_OPTION_VALUE"](https://oraclesolutions.pk/ora-12899-value-large-column-applsys-fnd_profile_option_values-profile_option_value/) - ERROR ORA-12899: value too large for column "APPLSYS"."FND_PROFILE_OPTION_VALUES"."PROFILE_OPTION_VALUE" SOLUTION Please execute the following steps: Step 1 - Change the value dbutilfiledir in the database context file ($ORACLE_HOME/appsutil/$CONTEXT_NAME.xml) Step 2 - Run autoconfig again.
- [ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old](https://oraclesolutions.pk/ora-20002-version-of-statistics-table-applsys-fnd_stattab-is-too-old/) - ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old SOLUTION Step 1. Connect To SYS user from SqlPlus Step 2. Take Backup of FND_STATTAB Table. Step 3. Run EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE(‘APPLSYS’,'FND_STATTAB’);
- [How to View Concurrent Request Output on Browser](https://oraclesolutions.pk/view-concurrent-request-output-browser/) - How to View Concurrent Request Output on Browser Step 1. Go To System Administrator Responsibility select Profile>System Step 2. Search the Profile option 'Viewer:%' Step 3. Set the profile Viewer: Application for Text to Browser at Site Level.
- [Enabling About This Page Link in Oracle Apps R12](https://oraclesolutions.pk/enabling-page-link-oracle-apps-r12/) - Enabling About This Page Link in Oracle Apps R12 If You need to Enable About This Page Link in Oracle Apps, you need to set the following Profile Options from System Administrator Responsibility Personalize Self-Service Defn = YES FND: Personalization Region Link Enabled = YES Disable Self-Service Personal = NO (Only at Site) FND: Diagnostics = Yes Note: These
- [How to restart ADOP from FAILED session - R12.2 Online Patching](https://oraclesolutions.pk/how-to-restart-adop-from-failed-session-r12-2-online-patching/) - How to restart ADOP from FAILED session - R12.2 Online Patching Sometimes during prepare or apply phase of ADOP, some error occurs and you wants to Restart the ADOP session. Perform following steps.: $adop phase=abort Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Please wait. Validating credentials... . . . . .
- [Oracle APPLICATION R12 Log File Locations](https://oraclesolutions.pk/oracle-application-r12-log-file-locations/) - APPS R12 LOG FILE LOCATIONS Log files are useful in troubleshooting issues in Oracle Applications. Below is the given list of Log file location in Oracle Applications for Startup/Shutdown, Cloning, Patching, DataBase & Apps Listener and various components in ORACLE Apps R12/11i: 1.Startup/Shutdown Log files for Application Tier in R12 Instance Top is new
- [How to get table information? How to get About this Page link in OA page in R12](https://oraclesolutions.pk/how-to-get-table-information-how-to-get-about-this-page-link-in-oa-page-in-r12/) - How to get table information? How to get About this Page link in OA page in R12 How to find supplier related view / table information in web page environment? Step 1. Navigate to the Supplier Page Step 2. Click on the About this page link Step 3. Click Expand All Step 4. You will
- [Forms Servlet mode to Socket mode conversion on Release 12 Apps](https://oraclesolutions.pk/forms-servlet-mode-socket-mode-conversion-release-12-apps/) - Forms Servlet mode to Socket mode conversion on Release 12 Apps Run the following command to enable Forms Socket Mode on Forms/web nodes (Place correct context file name and port value) $FND_TOP/bin/txkrun.pl -script=ChangeFormsMode -contextfile=$CONTEXT_FILE -mode=socket -port=9030 -runautoconfig=No Where port = forms port and contextfile=your environment contextfile To Start/Stop/check Status of forms servers use following scripts
- [Scripts Location In Oracle Application R12](https://oraclesolutions.pk/scripts-location-in-oracle-application-r12/) - Scripts Location In Oracle Application R12 Database Tier Scripts Database Scripts are located in Database_Install_Dir/db/tech_st/10.2.0/appsutil/scripts/$CONTEXT_NAME where CONTEXT_NAME is of format SID_HOSTNAME For Database Use script addbctl.sh For Database Listener Use script addlnctl.sh Application Tier Scripts Scripts for Application Tier services in R12 are located in Install_base/inst/apps/$CONTEXT_NAME/admin/scripts where CONTEXT_NAME is of format SID_HOSTNAME adstrtal.sh Master script
- [JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError](https://oraclesolutions.pk/jsp-error-request-uri-oa_html-rf-jsp-java-lang-noclassdeffounderror/) - ERROR JSP Error: Request URI:/OA_HTML/RF.jsp Exception: java.lang.NoClassDefFoundError JSP Error: Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError The jserv.log and OACoreGroup..stderr (where is the number of the JVM) will show errors like:- Exception in static block of jtf.cache.CacheManager. Stack trace is: oracle.apps.jtf.base.resources.FrameworkException: IAS Cache initialization failed. The Distributed Caching System failed to initialize on port: 12346. The list of hosts
- [How many users are connected to Oracle Applications.](https://oraclesolutions.pk/how-many-users-connected-oracle-applications/) - How many users are connected to Oracle Applications. 1. Enable Profile Option "Sign-On Audit" at "Form" level. 2. Run "Purge Signon Audit" request. 3. Security:Users -> Monitor" option 4 With the below sql query mentioned below. select distinct fu.user_name User_Name,fr.RESPONSIBILITY_KEY Responsibility from fnd_user fu, fnd_responsibility fr, icx_sessions ic where fu.user_id = ic.user_id AND fr.responsibility_id
- [Clear Cache in Oracle EBS R12](https://oraclesolutions.pk/clear-cache-r12/) - Clear Cache in Oracle EBS R12 There are two ways to clear cache in R12 1. Functional level (individual product/all product cache) Functional Administrator -> Core Services -> Caching Framework -> Global Configuration -> "Go to specific cache or Clear All Cache" 2. Server level Basic steps for a clear cache bounce is as below:-
- [Step to install Oracle E-Business Suite R12.2.0 on Oracle Enterprise Linux(OEL).](https://oraclesolutions.pk/step-install-oracle-e-business-suite-r12-2-0-oracle-enterprise-linuxoel/) - Step to install Oracle E-Business Suite R12.2.0 on Oracle Enterprise Linux(OEL) It’s a Single Node Installation which means all the Database Stack, Application Stack and Middleware Stack will be on the same server. First of all, you need to download the media of Oracle E-Business Suite R12.2.0 from https://edelivery.oracle.com. You can Either install your Application on
- [Where Can I Find EBS 12.2.7 Documentation?](https://oraclesolutions.pk/can-find-ebs-12-2-7-documentation/) - [et_pb_section][et_pb_row][et_pb_column type="4_4"][et_pb_text]Where Can I Find EBS 12.2.7 Documentation? By: Steven Chan| Senior Director EBS 12.2.7 is the latest update to E-Business Suite 12.2. It can be applied online -- you do not need to take your EBS environment down to apply this update. Our online E-Business Suite Documentation Web Library always contains the latest versions of all of
- [Creating Oracle Linux Virtual Machine through Virtual Box](https://oraclesolutions.pk/creating-oracle-linux-virtual-machine-virtual-box/) - Creating a Linux VM through Virtual Box Virtual Box is a free Desktop VM creation solution provided by Oracle. First download the latest version of Virtual Box from link given below. https://www.virtualbox.org/wiki/Downloads Intalling Virtual Box Go to the directory where virtual box has been downloaded and click the .exe file Creating
- [How to Install Oracle 11g Database On Linux](https://oraclesolutions.pk/install-oracle-11g-database-linux/) - Installation Of Oracle Database Release 11.2.0.3 on Oracle Enterprise Linux(OEL) 6.4 First download the media from below given link: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html For creating a Virtual machine kindly refer to the Blog Creating Virtual Machine in Virtual Box Copy the media in OEL Unzip both the folders by Using Following Given Commands: unzip p10404530_112030_Linux-x86-64_1of7\(DB\).zip unzip p10404530_112030_Linux-x86-64_2of7\(DB\).zip
- [How to Create a Read-Only APPS Schema?](https://oraclesolutions.pk/how-to-create-a-read-only-apps-schema/) - How to Create a Read-Only APPS Schema? We are going to create a schema similar to the APPS schema having only read-only privileges. Step 1. Create the user for the required schema: SQL> connect system/manager SQL> create user identified by default tablespace; SQL> temporary tablespace temp; Step 2. Grant connect and resource privileges
- [Useful Commands For Unix Operating System](https://oraclesolutions.pk/useful-commands-unix-operating-system/) - Useful Commands For Unix Operating System 1.Deleting files older than N number of days ? find . -name '*.trc' -mtime +[N in days] -exec rm {} \; Command will delete files older then N days in that directory 2.Copying file keeping timestamp preserve cp -ip file.txt file_txt_bkp 3.Listing files modified in last
- [Undo Related Queries Part 2](https://oraclesolutions.pk/undo-related-queries-part-2/) - List of All active Transactions SELECT sid, username, t.used_ublk, t.used_urec FROM v$transaction t, v$session s WHERE t.addr = s.taddr; To list all Datafile of UndoTablespace SELECT tablespace_name, file_name, file_id, autoextensible, bytes / 1048576 Mbytes, maxbytes / 1048576 maxMbytes FROM dba_data_files WHERE tablespace_name LIKE '%UNDO%' OR tablespace_name LIKE '%RBS%' ORDER BY tablespace_name, file_name; SELECT tablespace_name, file_name, file_id, autoextensible, bytes / 1048576 Mbytes, maxbytes / 1048576 maxMbytes FROM dba_data_files WHERE tablespace_name LIKE '%UNDOTBS2%' ORDER BY tablespace_name, file_name; col file_name FOR a40 set pagesize 100 SELECT tablespace_name, file_name, file_id, autoextensible, bytes / 1048576 Mbytes, maxbytes / 1048576 maxMbytes FROM dba_data_files WHERE tablespace_name LIKE '%APPS_UNDOTS1%' ORDER BY tablespace_name, file_name;
- [Undo Related Queries Part 1](https://oraclesolutions.pk/undo-related-queries-part-1/) - To check Retention Guarantee for Undo Tablespace SELECT tablespace_name, status, CONTENTS, logging, retention FROM dba_tablespaces WHERE tablespace_name LIKE '%UNDO%'; To show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace SELECT tablespace_name, status, Count(extent_id) "Extent Count", SUM(blocks) "Total Blocks", SUM(blocks) * 8 / ( 1024 * 1024 ) total_space FROM dba_undo_extents GROUP BY tablespace_name, status; Extent Count and Total Blocks set linesize 152 col tablespace_name FOR a20 col status FOR a10 SELECT tablespace_name, status, Count(extent_id) "Extent Count", SUM(blocks) "Total Blocks", SUM(bytes) / ( 1024 * 1024 * 1024 ) spaceInGB FROM dba_undo_extents WHERE tablespace_name IN ( '&undotbsp' ) GROUP BY tablespace_name, status; To show UndoRetention Value
- [SQL Queries to Check ACTIVE / INACTIVE Sessions](https://oraclesolutions.pk/sql-queries-check-active-inactive-sessions/) - SQL Queries to Check ACTIVE / INACTIVE Sessions Total Count of sessions SELECT Count(s.status) TOTAL_SESSIONS FROM gv$session s; Total Count of Inactive sessions SELECT Count(s.status) INACTIVE_SESSIONS FROM gv$session s, v$process p WHERE p.addr = s.paddr AND s.status = 'INACTIVE'; SESSIONS WHICH ARE IN INACTIVE STATUS FROM MORE THAN 1HOUR SELECT Count(s.status) "INACTIVE SESSIONS > 1HOUR " FROM gv$session s, v$process p WHERE p.addr = s.paddr AND s.last_call_et > 3600 AND s.status = 'INACTIVE'; COUNT OF ACTIVE SESSIONS SELECT Count(s.status) ACTIVE_SESSIONS FROM gv$session s, $process p WHERE p.addr = s.paddr AND s.status = 'ACTIVE'; TOTAL SESSIONS
- [Oracle Forms Session Queries](https://oraclesolutions.pk/oracle-forms-session-queries/) - Oracle Forms Session Queries TOTAL FORM SESSIONS SELECT Count(S.sid) INACTIVE_FORM_SESSIONS FROM v$session S WHERE S.status = 'INACTIVE' AND s.action LIKE ( '%FRM%' ); FORMS SESSIONS DETAILS col "Last SQL" FOR a30 SELECT p.spid, s.sid, s.status, s.last_call_et / 3600 last_call_et_hrs, s.sid, t.disk_reads, t.elapsed_time, Lpad(t.sql_text, 30) "Last SQL" FROM gv$session s, gv$sqlarea t, gv$process p WHERE s.sql_address = t.address AND s.sql_hash_value = t.hash_value AND p.addr = s.paddr AND s.action LIKE ( 'FRM%' ) AND s.last_call_et > 3600 ORDER BY spid; col machine FOR a15 col "Last SQL" FOR a30 SELECT p.spid, s.sid, s.status, s.last_call_et / 3600 last_call_et_hrs, S.action, s.process Client_Process, s.machine FROM gv$session s, gv$sqlarea t, gv$process p WHERE s.sql_address = t.address AND s.sql_hash_value = t.hash_value AND p.addr = s.paddr AND s.action LIKE ( 'FRM%' ) AND s.last_call_et > 3600 ORDER BY 4; INACTIVE FORMS SESSIONS
- [Query to Check Oracle Database Growth](https://oraclesolutions.pk/query-to-check-oracle-database-growth/) - This Query Calculate the Datafile Growth on a Yearly Basis SELECT To_char(creation_time, 'RRRR') year, To_char(creation_time, 'MM') month, Round(SUM(bytes) / 1024 / 1024 / 1024) gb FROM v$datafile GROUP BY To_char(creation_time, 'RRRR'), To_char(creation_time, 'MM') ORDER BY 1, 2;
- [Query to Monitor RMAN Backups](https://oraclesolutions.pk/query-monitor-rman-backups/) - SELECT Count(*) FROM v$backup_async_io WHERE status = 'IN PROGRESS'; Session information on backups SELECT s.sid, username AS "User", program, MODULE, action, logon_time "Logon", l.* FROM v$session s, v$enqueue_lock l WHERE l.sid = s.sid AND l.TYPE = 'CF' AND l.id1 = 0 AND l.id2 = 2; RMAN backup overall progress status SELECT Decode(context, 1, 'This Task:', 2, 'Agregate:', '?') Context, sofar, totalwork, Round(sofar / totalwork * 100, 2) "% Complete" FROM v$session_longops WHERE opname LIKE 'RMAN%' AND opname LIKE '%aggregate%' AND totalwork != 0 AND sofar totalwork UNION SELECT Decode(context, 1, 'This Task:', 2, 'Agregate:', '?') Context, sofar, totalwork, Round(sofar / totalwork * 100, 2) "% Complete" FROM v$session_longops WHERE opname LIKE 'RMAN%' AND opname NOT LIKE '%aggregate%' AND totalwork != 0 AND sofar totalwork;
- [How to check online FND_USERS in Oracle Apps](https://oraclesolutions.pk/check-online-fnd_users-oracle-apps/) - How to check online FND_USERS in Oracle EBS R12 SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description FROM icx_sessions icx, fnd_user fu WHERE disabled_flag != 'Y' AND icx.pseudo_flag = 'N' AND ( last_connect + Decode (fnd_profile.Value ('ICX_SESSION_TIMEOUT'), NULL, limit_time, 0 , limit_time, fnd_profile.Value ('ICX_SESSION_TIMEOUT') / 60) / 24 ) > SYSDATE AND icx.counter
- [Query to find workflow services are up and running?](https://oraclesolutions.pk/query-find-workflow-services-running/) - Query to find workflow services are up and running? SELECT fcq.user_concurrent_queue_name container_name, DECODE (fcp.os_process_id, NULL, 'Not Running', fcp.os_process_id ) procid, fcq.max_processes target, fcq.running_processes actual, fcq.enabled_flag enabled, fsc.component_name, fsc.component_type, fsc.startup_mode, fsc.component_status, SYSDATE dates FROM apps.fnd_concurrent_queues_vl fcq, apps.fnd_cp_services fcs, apps.fnd_concurrent_processes fcp, fnd_svc_components fsc WHERE fcq.manager_type
- [Standby Database Queries](https://oraclesolutions.pk/standby-database-queries/) - QUERY TO FIND information of PRIMARY OR STANDBY DATABASE SELECT database_role, db_unique_name INSTANCE, open_mode, protection_mode, protection_level, switchover_status FROM v$database; QUERY TO FIND MESSAGES AND ERRORS SELECT message FROM v$dataguard_status; -- "RUN THIS QUERY ON STANDBY DATABASE" QUERY TO FIND STANDBY DATABASE background processes SELECT process, status, thread#, sequence#, block#, blocks FROM v$managed_standby; -- "RUN THIS QUERY ON STANDBY DATABASE" QUERY TO FIND Received archived logs SELECT registrar, creator, thread#, sequence#, first_change#, next_change# FROM v$archived_log; -- "RUN THIS QUERY ON STANDBY DATABASE"
- [Find and Delete Older Files in Linux](https://oraclesolutions.pk/find-and-delete-older-files-in-linux/) - Delete Older Files in Linux Files older than 1 day find /rman/arch/*.dbf -mtime +1 -exec mv {} /rman/archbkp/ \; Move files older than 25 hours find /rman/arch/*.dbf -mmin +1500 -exec mv {} /rman/archbkp/ \; List files older than 2hours find /rman/arch/*.dbf -mmin +120 -exec ls -ltr {} \; Delete files older
- [Office 365 ProPlus Certified with EBS 12.1 and 12.2](https://oraclesolutions.pk/office-365-proplus-certified-ebs-12-1-12-2/) - Office 365 ProPlus Certified with EBS 12.1 and 12.2 By: Steven Chan| Senior Director Microsoft Office 365 ProPlus versions of Excel, Word, and Outlook are certified with Oracle E-Business Suite 12.1 and 12.2. See: Microsoft Office Integration with Oracle E-Business Suite 11i and R12 (Note 1077728.1) This certification includes 32-bit and 64-bit versions of Office 365 ProPlus running on
- [How To Move Table to Different TableSpace](https://oraclesolutions.pk/move-table-different-tablespace/) - How To Move Table to Different TableSpace SYNTAX ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED); EXAMPLE ALTER TABLE hr.employee_details move TABLESPACE hr; OR ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);
- [What's New in EBS 12.2.7?](https://oraclesolutions.pk/whats-new-ebs-12-2-7/) - What's New in EBS 12.2.7? By: Steven Chan| Senior Director EBS 12.2.7 is the latest update to E-Business Suite 12.2. It includes functionality enhancements, error corrections, and statutory and regulatory updates in a consolidated suite-wide patch set. Release 12.2.7 is cumulative and includes updates released previously for earlier EBS releases including 12.1.3, 12.0, and 11.5.10. It includes bug fixes for
- [What is Oracle E-Business Suite on Oracle Cloud?](https://oraclesolutions.pk/what-is-oracle-e-business-suite-on-oracle-cloud/) - What is Oracle E-Business Suite on Oracle Cloud? By: Nadia Bendjedou| Vice President - EBS Strategy You can think of running Oracle E-Business Suite on Oracle Cloud as running exactly the same Oracle E-Business Suite applications that you run on-premises in your datacenter today – the same E-Business Suite applications you may have customized – on a combination of
- [Oracle's Booming Cloud Business Could Rip And Replace SAP As #1 In Apps](https://oraclesolutions.pk/oracles-booming-cloud-business-rip-replace-sap-1-apps/) - Oracle's Booming Cloud Business Could Rip And Replace SAP As #1 In Apps Bob Evans , CONTRIBUTOR Opinions expressed by Forbes Contributors are their own. Oracle founder and chairman Larry Ellison believes cloud computing gives Oracle the chance to overtake archrival SAP in enterprise apps. (Photo by Ezra Shaw/Getty Images) (Note: After an award-winning career in the
- [ORA-04031: unable to allocate adautoconfig.sh dbTier txkcreateACL.sh exiting with status 1](https://oraclesolutions.pk/ora-04031-unable-allocate-adautoconfig-sh-dbtier-txkcreateacl-sh-exiting-status-1/) - ERROR Checking for existence of the ACL .... DECLARE * ERROR at line 1: ORA-04031: unable to allocate 2032 bytes of shared memory ("shared pool","XDbD/PLZ01TcHgNAgAIIegtw==","qmxlu subheap","qmichdlArrayImg") ORA-06512: at line 16 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options txkcreateACL.sh: exiting
- [RAC Voting Disk](https://oraclesolutions.pk/rac-voting-disk/) - Rac Voting Disk The Voting Disk File is a file on the shared cluster system or a shared raw device file. Voting disk a key component of clusterware and its failure can lead to inoperability of the cluster. In RAC at any point in time the clusterware must know which nodes are member of the
- [Oracle RMAN Commands List](https://oraclesolutions.pk/rman-commands-list/) - Oracle RMAN Commands List Here is the list of key most RMAN commands that are used for Backup and related activities: LIST Commands LIST Commands are generic RMAN commands that will show/list various types of information when executed within RMAN utility. RMAN> list backup; It lists all the backups taken using RMAN utility. RMAN>
- [RapidWiz log files for Oracle Applications Release 12](https://oraclesolutions.pk/rapidwiz-log-files-oracle-applications-release-12/) - RapidWiz log files for Oracle Applications Release 12 During installation of Release 12 using RapidWiz, the following log files are created. In case of any errors during the installation, we can use these log file locations for troubleshooting. Before the installation starts: The Rapidwiz Configuration File is saved in three locations,these are follows. $TMP//conf_.txt
- [Troubleshooting AD Controller](https://oraclesolutions.pk/troubleshooting-ad-controller/) - Fixing a "Failed" worker Whenever a job fails for the 1st time, the job is deferred at the end of the phase and another job is assigned to that worker. What If the Job Fails 2nd Time? If the run time of the job was < 10 min => the job is deferred at
- [August 2017 Update to E-Business Suite Technology Codelevel Checker (ETCC)](https://oraclesolutions.pk/august-2017-update-e-business-suite-technology-codelevel-checker-etcc/) - August 2017 Update to E-Business Suite Technology Codelevel Checker (ETCC) By: Steven Chan| Senior Director The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify application or database tier overlay patches that need to be applied to your Oracle E-Business Suite Release 12.2 system. ETCC maps missing overlay patches to the default corresponding Database Patch Set
- [How To Trace Concurrent Programs](https://oraclesolutions.pk/how-to-trace-concurrent-programs/) - How To Trace Concurrent Programs CASE 1 : Concurrent Program Tracing without bind variables 1) Follow the following navigation to enable logging for Concurrent Program Goto Sysadmin > Concurrent > Program > Define Query the concurrent program Check the trace box to enable trace 2) Execute the concurrent program and note down the request id
- [Oracle AD Controller](https://oraclesolutions.pk/oracle-ad-controller/) - Oracle AD Controller ADCTRL is used to manage worker processes that perform a pivotal role in the function of batch processing for patching and many other Applications activities. ADCTRL is located under $AD_TOP/bin directory with Oracle E-Business Suite. Procedure to Run AD controller Step 1 : Login as Applications Tier user & run
- [PL/SQL Code For Dropping All Objects in Schema](https://oraclesolutions.pk/plsql-code-dropping-objects-schema/) - PL/SQL Code For Dropping All Objects in Schema DECLARE v_itemcount INTEGER; BEGIN SELECT Count(*) INTO v_itemcount FROM all_objects AO WHERE AO.owner = USER AND AO.object_type NOT IN ( 'INDEX' ) AND AO.object_name NOT LIKE 'BIN$%'; WHILE ( v_itemcount > 0 ) LOOP FOR v_cmd IN (SELECT 'drop ' || AO.object_type || ' ' || AO.object_name || Decode(AO.object_type, 'TABLE', ' CASCADE CONSTRAINTS', '') AS DROPCMD FROM all_objects AO WHERE AO.owner = USER AND AO.object_type NOT IN ( 'INDEX' ) AND AO.object_name NOT LIKE 'BIN$%') LOOP BEGIN EXECUTE IMMEDIATE v_cmd.dropcmd; EXCEPTION WHEN OTHERS THEN NULL; -- ignore errors END; END LOOP; SELECT Count(*) INTO v_itemcount FROM all_objects AO WHERE AO.owner = USER AND AO.object_type NOT IN ( 'INDEX' ) AND AO.object_name NOT LIKE 'BIN$%'; END LOOP; EXECUTE IMMEDIATE 'purge recyclebin'; END; NOTE: Be Careful Before Running it On Production Environment
- [PL/SQL Code for Counting Rows In Schema Tables](https://oraclesolutions.pk/plsql-code-counting-rows-schema-tables/) - PL/SQL Code for Counting Rows In Schema Tables DECLARE i INTEGER; BEGIN dbms_output.Put_line('Table Name,Row Count,' || To_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); FOR v_table IN (SELECT ut.table_name FROM user_tables ut) LOOP EXECUTE IMMEDIATE 'select count(*) from '|| v_table.table_name INTO i; dbms_output.Put_line(v_table.table_name || ',' || To_char(i)); END LOOP; END;
- [Concurrent Request Queries](https://oraclesolutions.pk/concurrent-request-queries/) - Concurrent Request Queries HISTORY OF CONCURRENT REQUEST (PROGRAM WISE) SELECT DISTINCT t.user_concurrent_program_name, r.request_id, To_char(r.actual_start_date, 'dd-mm-yy hh24:mi:ss') "Started at", To_char(r.actual_completion_date, 'dd-mm-yy hh24:mi:ss') "Completed at", Decode(r.phase_code, 'C', 'Completed', 'I', 'Inactive', 'P ', 'Pending', 'R', 'Running', 'NA') phasecode, Decode(r.status_code, 'A', 'Waiting', 'B', 'Resuming', 'C', 'Normal', 'D', 'Cancelled', 'E', 'Error', 'F', 'Scheduled', 'G', 'Warning', 'H', 'On Hold', 'I', 'Normal', 'M', 'No Manager', 'Q', 'Standby', 'R', 'Normal', 'S', 'Suspended', 'T', 'Terminating', 'U', 'Disabled', 'W', 'Paused', 'X', 'Terminated', 'Z', 'Waiting') "Status", r.argument_text "Parameters", Substr(u.description, 1, 25) "Who submitted", Round(( ( Nvl(v.actual_completion_date, SYSDATE) - v.actual_start_date ) * 24 * 60 )) Etime FROM apps.fnd_concurrent_requests r, apps.fnd_concurrent_programs p, apps.fnd_concurrent_programs_tl t, apps.fnd_user u, apps.fnd_conc_req_summary_v v WHERE r.concurrent_program_id = p.concurrent_program_id AND r.actual_start_date >= ( SYSDATE - 30 ) --AND r.requested_by=32126 AND r.program_application_id = p.application_id AND t.concurrent_program_id = r.concurrent_program_id AND r.requested_by = u.user_id
- [Can Oracle Label Security be Used with EBS 12.2?](https://oraclesolutions.pk/can-oracle-label-security-used-ebs-12-2/) - Can Oracle Label Security be Used with EBS 12.2? By: Steven Chan | Senior Director Yes, Oracle Label Security (OLS) can be used with EBS 12.2. It can also be used for earlier EBS releases such as EBS 12.1 and 12.0. Oracle Label Security is an optional database-level technology for developing customized security schemes. It is possible to use this
- [What's the E-Business Suite Roadmap for Java?](https://oraclesolutions.pk/whats-e-business-suite-roadmap-java/) - What's the E-Business Suite Roadmap for Java? By: Steven Chan | Senior Director Oracle E-Business Suite uses Java. When discussing EBS's use of Java, it is important to distinguish between server-side vs. client-side certifications. EBS+Java Combinations certified today E-Business Suite 12.1 and 12.2 both require Java at the server tier as well as Java on the desktop client
- [CRS Administration](https://oraclesolutions.pk/crs-administration/) - CRS Administration CRS Administration starting ## Starting CRS using Oracle 10g R1 not possible ## Starting CRS using Oracle 10g R2 $ORA_CRS_HOME/bin/crsctl start crs stopping ## Stopping CRS using Oracle 10g R1 srvctl stop database -d srvctl stop asm -n srvctl stop nodeapps -n /etc/init.d/init.crs stop ## Stopping CRS using Oracle
- [RAC General Administration](https://oraclesolutions.pk/rac-general-administration/) - RAC General Administration Managing the Cluster starting /etc/init.d/init.crs start crsctl start crs stopping /etc/init.d/init.crs stop crsctl stop crs enable/disable at boot time /etc/init.d/init.crs enable /etc/init.d/init.crs disable crsctl enable crs crsctl disable crs Managing the database configuration with SRVCTL start all instances srvctl start database -d -o Note: starts listeners if not already
- [Oracle RAC Daemons and Processes](https://oraclesolutions.pk/oracle-rac-daemons-processes/) - Oracle RAC Daemons and Processes OPROCd Process Monitor provides basic cluster integrity services EVMd Event Management spawns a child process event logger and generates callouts OCSSd Cluster Synchronization Services basic node membership, group services, basic locking CRSd Cluster Ready Services resource monitoring, failover and node recovery LMSn Lock Manager Server process - GCS this
- [RAC Useful Parameters](https://oraclesolutions.pk/rac-useful-parameters/) - RAC Useful Parameters cluster_interconnects specify a specific IP address to use for the inetrconnect _gcs_fast_config enables fast reconfiguration for gcs locks (true|false) _lm_master_weight controls which instance will hold or (re)master more resources than others _gcs_resources controls the number of resources an instance will master at a time _lm_tickets controls the number of message tickets _lm_ticket_active_sendback
- [RAC Useful Views And Tables](https://oraclesolutions.pk/rac-useful-views-tables/) - RAC Useful Views And Tables GCS and Cache Fusion Diagnostics v$cache contains information about every cached block in the buffer cache v$cache_transfer contains information from the block headers in SGA that have been pinged at least once v$instance_cache_transfer contains information about the transfer of cache blocks through the interconnect v$cr_block_server contains statistics about CR block
- [RAC Files and Directories](https://oraclesolutions.pk/rac-files-directories/) - RAC Files and Directories $ORA_CRS_HOME/cdata/ OCR backups (default location) $ORA_HOME/log//client/ocrconfig_.log OCR command log file $ORA_CRS_HOME/crs/log contains trace files for the CRS resources $ORA_CRS_HOME/crs/init contains trace files for the CRS daemon during startup, a good place to start $ORA_CRS_HOME/css/log contains cluster reconfigurations, missed check-ins, connects and disconnects from the client CSS listener. Look here to
- [RAC Acronyms in Used](https://oraclesolutions.pk/rac-acronyms-used/) - Real Application Cluster Acronyms GCS Global Cache Services in memory database containing current locks and awaiting locks, also known as PCM GES Global Enqueue Services coordinates the requests of all global enqueues uses the GCS, also known as non-PCM GRD Global Resource Directory all resources available to the cluster (formed and managed by GCS and
- [Error creating AME rule R12 oracle.apps.per.ame.rules.server.RulesAM](https://oraclesolutions.pk/error-creating-ame-rule-r12-oracle-apps-per-ame-rules-server-rulesam/) - ERROR SOLUTION Change Web HTML value in function "AME_RULE_CREATE_STEP1" Current value : OA.jsp?page=/oracle/apps/per/ame/rules/webui/RuleCreateDetailsPG Correct value : OA.jsp?page=/oracle/apps/ame/rules/webui/RuleCreateDetailsPG Save the Record and Retest the Issue
- [adgentns.pl" exitcode="512" while running AutoConfig](https://oraclesolutions.pk/adgentns-pl-exitcode512-running-autoconfig/) - ERROR Error stack: AutoConfig completed with errors. The log file for this session is located at: /u01/apps/inst/apps/TEST_apps/admin/log/03451250/adconfig.log Autoconfig logfile: The following report lists errors encountered during CVM Phase /u01/apps/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 512 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status 1 The log file for this session is located at:
- [APP-FND-01542 : This Application Server is not authorized to access this system](https://oraclesolutions.pk/app-fnd-01542-this-application-server-is-not-authorized-to-access-this-system/) - ERROR APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your system administrator. SOLUTION This error message pops-up when value for profile "s_appserverid_authentication" is set to "SECURE" in Application Context file. This profile value can be set to three different values, "SECURE, PARTIAL, OFF". To over come this issue set
- [AutoConfig Failing With NegativeArraySizeException After Upgrading To 11gR2 Database](https://oraclesolutions.pk/autoconfig-failing-negativearraysizeexception-upgrading-11gr2-database/) - ERROR Error stack while running autoconfig: Updating Context file...COMPLETED Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -29532: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NegativeArraySizeException has been detected in FND_GSM_UTIL.upload_context_file. oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -29532:
- [ORACLE APPLICATIONS R12 ARCHITECTURE](https://oraclesolutions.pk/oracle-applications-r12-architecture/) - ORACLE APPLICATIONS R12 ARCHITECTURE Oracle E-Business Suite Release-12 have a Multi-tiered Architecture, that supports Oracle Applications products. They are comprised of a Database Tier which manages the Oracle Database and stores all data. An Application Tier hosts various servers, manages communication between the desktop and database tier and contains the application file system. A Client Desktop through which user access Oracle
- [How To Drop Redo Logfiles on Physical Standby Database](https://oraclesolutions.pk/drop-redo-logfiles-physical-standby-database/) - How To Drop Redo Logfiles on Physical Standby Database Step 1. First, Cancel the Standby Recovery Process. SQL> alter database recover managed standby database cancel; Step 2. Check the standby_file_management parameter and set the parameter to MANUAL. SQL> alter system set standby_file_management=manual scope=both; Step 3. Check the status of the Logfiles Before
- [How To Add Redo Logfiles In Standby Database](https://oraclesolutions.pk/add-redo-logfiles-standby-database/) - How To Add Redo Logfiles In Standby Database Step 1. First, Check MEMBER present in Standby Database. SQL> select member from v$logfile; MEMBER ---------------------------------- E:\STANDBYLOGS\REDO03.LOG E:\STANDBYLOGS\REDO02.LOG E:\STANDBYLOGS\REDO01.LOG Step 2. Cancel the recovery Process. SQL> alter database recover managed standby database cancel; Step 3. Check the standby_file_management parameter and set the parameter to MANUAL.
- [Best Practices For Migrating Oracle Database To Oracle's Database Cloud Service](https://oraclesolutions.pk/best-practices-migrating-oracle-database-oracles-database-cloud-service/) - Best Practices For Migrating Oracle Database To Oracle's Database Cloud Service By: Edgar Haren Principal Product Marketing Director Today, I'm pleased to have a guest blogger, Senior Principal Product Manager, Brian Spendolini. Brian's blog below is going to provide you with some technical best practices for migrating your Oracle Database to Oracle's Database Cloud Service. When Oracle
- [Can Nologging Be Enabled for EBS 12.2?](https://oraclesolutions.pk/can-nologging-enabled-ebs-12-2/) - Can Nologging Be Enabled for EBS 12.2? By: Steven Chan | Senior Director The nologging Oracle database feature is used to enhance performance in certain areas of Oracle E-Business Suite. For example, it may be used during patch installation, and when building summary data for Business Intelligence. What are the tradeoffs of using nologging? Use of nologging in
- [Check BI Publisher's Health with BIP Analyzer for E-Business Suite](https://oraclesolutions.pk/check-bi-publishers-health-bip-analyzer-e-business-suite/) - Check BI Publisher's Health with BIP Analyzer for E-Business Suite By: Steven Chan| Senior Director In addition to helping customers resolve issues via Service Requests, Oracle Support also builds over 60 free diagnostic tools for Oracle E-Business Suite 12.2, 12.0, 12.1, and 11i. These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments. They
- [How to compile invalid objects in an APPS Environment](https://oraclesolutions.pk/compile-invalid-objects-apps-environment/) - Compiling Objects Manually Through SQL Commands First find the Invalid Objects in the Database by below given query. SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID'; For a more detailed query, use the following script : SELECT OWNER, OBJECT_TYPE, COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID' GROUP BY OWNER, OBJECT_TYPE; To recompile an individual object,
- [Find the Org and Organization mappings](https://oraclesolutions.pk/find-org-organization-mappings/) - SELECT ood.organization_code Warehouse_code, ood.organization_name Warehouse, ood.operating_unit OU_ID, hou.name OU_Name, hle.name Legal_entity, hle.set_of_books_id, gsob.name SOB FROM org_organization_definitions ood, hr_operating_units hou, hr_legal_entities hle, gl_sets_of_books gsob WHERE ood.operating_unit = hou.organization_id AND hou.legal_entity_id = hle.organization_id AND gsob.set_of_books_id = hle.set_of_books_id
- [How to add System administrator responsibility from backend](https://oraclesolutions.pk/add-system-administrator-responsibility-backend/) - Syntax: fnd_user_pkg.addresp(username => v_user_name ,resp_app => ‘SYSADMIN’ ,resp_key => ‘SYSTEM_ADMINISTRATOR’ ,security_group => ‘STANDARD’ ,description => ‘Auto Assignment’ ,start_date => SYSDATE – 10 ,end_date => SYSDATE + 1000); Usage: BEGIN fnd_user_pkg.addresp (‘OPERATIONS’,’SYSADMIN’,’SYSTEM_ADMINISTRATOR’,’STANDARD’, ‘Add Sysadmin Responsibility to OPERATIONS user using pl/sql’, SYSDATE, SYSDATE + 100); COMMIT; DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line
- [How Extract the trace file of a concurrent program](https://oraclesolutions.pk/how-extract-the-trace-file-of-a-concurrent-program/) - Step 1. Setup the profile value at user level with the following value Profile name: “Initialization SQL Statement – Custom” User: [%User Name from which Concurrent program Runs%] Profile value: BEGIN FND_CTL.FND_SESS_CTL(”,”,’TRUE’,’TRUE’,”,’ALTER SESSION SET TRACEFILE_IDENTIFIER = abc MAX_DUMP_FILE_SIZE = 5000000 EVENTS =’||””||’ 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12’||””);END; Step 2. Find out where
- [This general ledger account is not authorized for use in Treasury](https://oraclesolutions.pk/this-general-ledger-account-is-not-authorized-for-use-in-treasury/) - ERROR This general ledger account is not authorized for use in Treasury. Please authorize this general ledger account for use in Treasury by company: &COMPANY_NAME SOLUTION Following setup of the GL account needs to be done in Treasury: Step 1. In Treasury>SETUP>Journal Entry actions>Select company Step 2. Define: Cash account. Step 3. Save.
- [Error while running AR auto Invoice import program](https://oraclesolutions.pk/error-running-ar-auto-invoice-import-program/) - ERROR Error while running AR auto Invoice import program arcsai() Not all AutoAccounting types are defined Error calling arcdsu_do_setup() Error calling raaini() SOLUTION Setup the Auto Accounting for all the Accounting Types. NAVIGATE: Receivables -> Setup -> Transactions -> AutoAccounting The minimum mandatory types are below: 1.FREIGHT 2.REC 3.REV 4.SUSPENSE (AutoInvoice Clearing) 5.TAX 6.UNBILL
- [Fully paid prepayment showing "Unpaid" Status](https://oraclesolutions.pk/fully-paid-prepayment-showing-unpaid-status/) - ERROR Fully paid prepayment showing "Unpaid" Status SOLUTION Run the following statement to find the issue data select * from AP_INVOICES_ALL where invoice_id =&invoice_id if the invoice is fully paid, the status PAYMENT_STATUS_FLAG should be Y. For implementing the solution, please execute the following steps: Step 1. Ensure that you have backup your system before
- [Not Getting Intercompany transaction notification](https://oraclesolutions.pk/not-getting-intercompany-transaction-notification/) - ERROR Not Getting Inter-company transaction notification from Recipient user for inbound transaction SOLUTION Check your workflow background engine and agent listener status. Follow the below process step to ensure workflow services up and running. Step 1. Start the Workflow Agent listener Service: A. Navigate to Workflow administrator Web Applications Responsibility. B. Click on Workflow Manager. C. Click on Service
- [Customer Interface Issue: Cannot Populate Account_Name In RA_CUSTOMER_PROFILES_INTERFACE](https://oraclesolutions.pk/customer-interface-issue-cannot-populate-account_name-ra_customer_profiles_interface/) - ERROR Customer Interface Issue: Cannot Populate Account_Name In RA_CUSTOMER_PROFILES_INTERFACE You cannot create Account Name using Customer Interface (RACUST) as this column does not exist in RA_CUSTOMER_PROFILES_INTERFACE. SOLUTION You can use TCA API procedure to populate the Account Name: Procedure= HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT Parameter Name = &account_name Please refer the oracle support Notes: Note 189369.1 How To Create A Customer Via
- [APP-SQLGL-08090: Please open the period you have selected for this batch before posting](https://oraclesolutions.pk/app-sqlgl-08090-please-open-period-selected-batch-posting/) - ERROR 'APP-SQLGL-08090: Please open the period you have selected for this batch before posting SOLUTION Step 1. Identify all ledgers affected by this batch being POSTED. Step 2. Make sure they all have the posting period in Open status. Step 3. Retest after opening the needed periods.
- [Not showing  Open Interface Tab in Cash Management Form](https://oraclesolutions.pk/not-showing-open-interface-tab-in-cash-management-form/) - ERROR Not showing Open Interface Tab in Cash Management Form For Matching Open interface transactions for reconciliation. SOLUTION Enable "Use Reconciliation Open Interfaces" check box under "Open Interface Controls" in Bank Account Control screen. Step 1. Navigate to Bank account Inquiry screen : Setup -> Bank -> Bank Account Step 2. Find your bank
- [ORA-16038: log cannot be archived ORA-19809: limit exceeded forrecovery files](https://oraclesolutions.pk/ora-16038-log-cannot-be-archived-ora-19809-limit-exceeded-forrecovery-files/) - ERROR ARC3: Error 19809 Creating archive log file to '+DISKS' Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_6598.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 42687547752 bytes is 100.00% used, and has 0 remaining bytes available. SOLUTION This problem normally occurs when our flash recovery area is full , we have two option to solve this problem: 1. Add size
- [HOW to Verify and Change oc4jadmin password](https://oraclesolutions.pk/how-to-verify-and-change-oc4jadmin-password/) - HOW to Verify and Change oc4jadmin Password Step 1. Run the below command as applmgr user to verify oc4jadmin Password: $ java -jar $IAS_ORACLE_HOME/j2ee/home/jazn.jar -checkpasswd jazn.com oc4jadmin -pw ***** Successful verification of user/password pair. ***** = oc4jadmin password If the message is not successful then password can be changed through system-jazn-data.xml file: Step 2. Shutdown all opmn services :
- [adoafmctl.sh: exiting with status 152](https://oraclesolutions.pk/adoafmctl-sh-exiting-with-status-152/) - ERROR Starting OPMN managed OAFM OC4J instance ... adoafmctl.sh: exiting with status 152 And the log file says: Error --> Process (index=1,uid=457054968,pid=12684564) time out while waiting for a managed process to start SOLUTION Step 1. $rm $ORA_CONFIG_HOME/10.1.3/opmn/logs/states/* Clear the TLD cache: - stop all middle tier services -Make sure there are not background unix processes
- [Check Workflow's Health with Workflow Analyzer](https://oraclesolutions.pk/check-workflows-health-workflow-analyzer/) - Check Workflow's Health with Workflow Analyzer By: Steven Chan| Senior Director In addition to helping customers resolve issues via Service Requests, Oracle Support also builds diagnostic tools for Oracle E-Business Suite. Here's an index to all of these tools: Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Note 1545562.1) What do Support
- [Mobile Approvals 1.6 Now Available for iOS and Android](https://oraclesolutions.pk/mobile-approvals-1-6-now-available-for-ios-and-android/) - Mobile Approvals 1.6 Now Available for iOS and Android By: Steven Chan| Senior Director We are pleased to announce updates for the Oracle E-Business Suite Mobile Approvals 1.6 smartphone app for iOS and Android. These updates are delivered as part of Oracle E-Business Suite Mobile Release 7, which supports both Oracle E-Business Suite Release 12.1.3 and 12.2.3
- [Check Your EBS Database Configuration with Database Parameter Settings Analyzer](https://oraclesolutions.pk/check-ebs-database-configuration-database-parameter-settings-analyzer/) - Check Your EBS Database Configuration with Database Parameter Settings Analyzer By: Steven Chan | Senior Director Database ParaIn addition to helping customers resolve issues via Service Requests, Oracle Support also builds over 60 free diagnostic tools for Oracle E-Business Suite 12.2, 12.0, 12.1, and 11i. These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments.
- [Quarterly EBS Upgrade Recommendations: July 2017 Edition](https://oraclesolutions.pk/quarterly-ebs-upgrade-recommendations-july-2017-edition/) - Quarterly EBS Upgrade Recommendations: July 2017 Edition By: Steven Chan | Senior Director We've previously provided advice on the general priorities for applying EBS updates and creating a comprehensive maintenance strategy. Here are our latest upgrade recommendations for E-Business Suite updates and technology stack components. These quarterly recommendations are based upon the latest updates to Oracle's product strategies, latest support timelines, and newly-certified
- [Oracle Has a SPARC-powered Exadata Configuration Called SuperCluster](https://oraclesolutions.pk/oracle-sparc-powered-exadata-configuration-called-supercluster/) - Oracle Has a SPARC-powered Exadata Configuration Called SuperCluster By: Michael Palmeter Oracle has been shipping an Oracle Exadata configuration that runs Oracle’s T and M-series (SPARC) microprocessors for more than 2 years. This database machine is called Oracle SuperCluster. Technically, SuperCluster has always included every single Exadata feature of note. This is because every SuperCluster configuration is built around
- [CPADMIN Utility Now Available for EBS](https://oraclesolutions.pk/cpadmin-utility-now-available-for-ebs/) - CPADMIN Utility Now Available for EBS 12.2.3, 12.2.4, 12.2.5 By: Steven Chan| Senior Director I recently profiled the CPADMIN utility for EBS 12.2.6 that consolidates various CP management functions into a single menu-based tool. This ADADMIN-style utility can: View Concurrent Manager status Clean CP tables Set Concurrent Manager diagnostics Start, stop, or verify an individual Concurrent Manager Rebuild Concurrent Manager
- [EBS 12.2.4 application tier autoconfig fails with following error](https://oraclesolutions.pk/ebs-12-2-4-application-tier-autoconfig-fails-with-following-error/) - ERROR Oracle EBS 12.2.4 application tier autoconfig fails with following error. WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by directory and phase. The report format is: [PROFILE PHASE] AutoConfig could not successfully execute
- [Using OA framework, it errors With Error 404--Not Found](https://oraclesolutions.pk/using-oa-framework-errors-error-404-not-found/) - ERROR When clearing all cache in Functional Administrator or Using OA framework, it errors With Error 404--Not Found : EBS 12.2.3 SOLUTION $cd $OA_HTML $cd .. $cp - r html html.bak $unzip -o ebsuix-install.zip $cd $OA_HTML/cabo/jsps $$FND_TOP/patch/115/bin/jjspcompile.pl -compile -s 'frameredirect.jsp' --flush $$FND_TOP/patch/115/bin/jjspcompile.pl -compile Now Restart (Cleanup)
- [Transaction type does not have any action types for the rule type selected](https://oraclesolutions.pk/transaction-type-does-not-have-any-action-types-for-the-rule-type-selected/) - ERROR This transaction type does not have any action types for the rule type selected. Ensure you add the selected rule type's action types to this transaction type to use in a rule. SOLUTION Step 1. Navigate to Approvals Management Business Analyst Responsibility > Business Analyst Dashboard Step 2. Navigate to Payables Invoice Approval> Setup Step
- [Supplier Site (VALUE=1002) is not an active and valid purchasing supplier site.](https://oraclesolutions.pk/supplier-site-value1002-not-active-valid-purchasing-supplier-site/) - ERROR Supplier Site (VALUE=1002) is not an active and valid purchasing supplier site. SOLUTION Enable that "RFQ only" check box unchecked at Supplier site level in supplier screen and click apply to save the changes. Now you can be able to create the PO for this supplier.
- [FRM-40735: on-insert trigger raised unhandled exception ORA-01403](https://oraclesolutions.pk/frm-40735-insert-trigger-raised-unhandled-exception-ora-01403/) - ERROR FRM-40735: on-insert trigger raised unhandled exception ORA-01403 Form Path : /u01/APPS/EBSapps/appl/ar/12.0.0/forms/US/ARXTWMAI.fmx Form Version : 12.0.149.12020000.17 Form Last Modified : $Date: 2014/04/02 23:09 $ SOLUTION Step 1. Navigate to Responsibility System Administrator Step 2. Navigation to Profile > System Step 3. Set Profile option HR Security Profile and MO: Security Profile at Responsibility Level. NOTE: These two profiles
- [Oracle Assets Profile Options](https://oraclesolutions.pk/oracle-assets-profile-options/) - Oracle Assets Profile Options Below are the most common profile options used in Oracle Asset Module. FA: Allow Swiss Special Assets FA: Annual Rounding FA: Archive Table Sizing Factor FA: Batch Size FA: Cache Sizing Factor FA: Custom Generate CCID FA: Default DPIS to Invoice Date FA: Deprn Single FA: Enable Depreciation Override FA: Generate
- [APP-SQLAP-10771: Could not reserve record](https://oraclesolutions.pk/app-sqlap-10771-not-reserve-record/) - ERROR APP-SQLAP-10771: Could not reserve record Got this error when trying to pay Full Invoice. This error comes normally due to database lock from another sessions on AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL tables. SOLUTION 1 Step 1. First determine what session has lock this record, please execute the following steps: a) Run the following to query to
- [PERF0005: Oracle error detected in glpsqs()  - ORA-20001:An active sequence assignment is required. ORA-06512](https://oraclesolutions.pk/perf0005-oracle-error-detected-glpsqs-ora-20001an-active-sequence-assignment-required-ora-06512/) - ERROR PERF0005: Oracle error detected in glpsqs() - ORA-20001:An active sequence assignment is required. ORA-06512 SOLUTION Disable the Accounting Sequence required check box as follows :- Step 1. Go to GL > Accounting Set Up Manager > Sequencing (Update) Step 2. Uncheck the option Require Assignment. This will Disable the requirement for assignment.
- [Oracle financials interface tables](https://oraclesolutions.pk/oracle-financials-interface-tables/) - General Ledger Interface Tables GL_BUDGET_INTERFACE GL_DAILY_RATES_INTERFACE GL_DRM_HIERARCHY_INTERFACE GL_DRM_SEGVALUES_INTERFACE GL_IMP_COA_ERR_INTERFACE GL_IMP_COA_NORM_HIER_INTERFACE GL_IMP_COA_SEG_VAL_INTERFACE GL_IEA_INTERFACE GL_INTERFACE GL_INTERFACE_CONTROL GL_INTERFACE_HISTORY GL_REPORT_INTERFACE GL_XFR_INTERFACE Account Payables (AP) Interface Tables AP_INTERFACE_CONTROLS AP_INTERFACE_REJECTIONS AP_INVOICE_INTERFACE AP_INVOICE_LINES_INTERFACE OIE_POL_RATES_INTERFACE Account Receivables (AR) Interface Tables AR_PAYMENTS_INTERFACE_ALL AR_TAX_INTERFACE HZ_PARTY_INTERFACE HZ_PARTY_INTERFACE_ERRORS RA_CUSTOMERS_INTERFACE_ALL RE_INTERFACE_DISTRIBUTION_ALL RA_INTERFACE_ERRORS_ALL RA_INTERFACE_LINES_ALL RA_INTERFACE_SALESCREDITS_ALL AR_INTERFACE_CONTS_ALL AR_PMTS_INTERFACE_HEADER_GT AR_PMTS_INTERFACE_LINES_GT AR_PMTS_INTERFACE_LINE_DETAILS HZ_DQM_SH_SYNC_INTERFACE HZ_DQM_SYNC_INTERFACE RA_INTERFACE_REQID_GT Fixed Assets (FA) Interface
- [Unable to get passwords from Vault](https://oraclesolutions.pk/unable-get-passwords-vault/) - ERROR Completed database cleanup for previous session. Error: Unable to execute statement < Begin ad_jar.get_jripasswords(:l_storepass, :l_keypass); End; > len = 63 AD Administration error: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", line 101 ORA-06512: at "APPS.AD_JAR", line 17 ORA-06512: at line 3 AD Administration error: Unable to get passwords from Vault You should check the file
- [PLS-00201: identifier 'AD_JAR.GET_JRIPASSWORDS' must be declared](https://oraclesolutions.pk/pls-00201-identifier-ad_jar-get_jripasswords-must-be-declared/) - ERROR PLS-00201: identifier 'AD_JAR.GET_JRIPASSWORDS' must be declared AD code level : [B.3] Error: Unable to execute statement < Begin ad_jar.get_jripasswords(:l_storepass, :l_keypass); End; > len = 63 AD Administration error: ORA-06550: line 3, column 1: PLS-00201: identifier 'AD_JAR.GET_JRIPASSWORDS' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored AD Administration error: Unable to get passwords
- [Relink of module "UMX_ENDECA_RBACMigration.sh" failed](https://oraclesolutions.pk/relink-module-umx_endeca_rbacmigration-sh-failed/) - ERROR Relink of module "UMX_ENDECA_RBACAuto.sh" failed. See error messages above (also recorded in log file) for possible reasons for the failure. Also, please check that the Unix userid running adrelink has read, write, and execute permissions on the directory /u01/apps/apps_st/appl/fnd/12.0.0/bin, and that there is sufficient space remaining on the disk partition containing your Oracle Applications
- [TXKRUN.PL Deploying a New Forms .EAR File Error with OPMNCTL Start](https://oraclesolutions.pk/txkrun-pl-deploying-a-new-forms-ear-file-error-with-opmnctl-start/) - ERROR Errors encountered running /u01/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl ... Command error: = 32512, = /u01/apps/tech_st/10.1.3/opmn/bin/opmnctl start STACK TRACE TXK::Error::abort('TXK::Error','HASH(0x82d647c)') called at /u01/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 299 TXK::Common::doError('TXK::Process=HASH(0xb7c81938)','Command error: = 32512, = /u01/apps/tech_...','undef') called at /u01/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 314 TXK::Common::setError('TXK::Process=HASH(0xb7c81938)','Command error: = 32512, = /u01/apps/tech_...') called at /u01/apps/apps_st/appl/au/12.0.0/perl/TXK/Process.pm line 449 TXK::Process::run('TXK::Process=HASH(0xb7c81938)','HASH(0x87408c0)') called at /u01/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl line 1587
- [An attempt has been made to enter a null value into a column that requires data](https://oraclesolutions.pk/attempt-made-enter-null-value-column-requires-data/) - ERROR An attempt has been made to enter a null value into a column that requires data. Please correct to ensure that only valid values are entered for the column. SOLUTION Please Validate the receipt class definition in bank account tab bank charge account is defined properly. Step 1. Navigate to Responsibility: Receivables Manager Step 2. Navigation to:
- [Apps Technical Interview Questions Part 5](https://oraclesolutions.pk/apps-technical-interview-questions-part-5/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="What is Summary columns? " open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] A summary column performs a computation on another column's data. Using
- [Apps DBA Interview Questions Part 4](https://oraclesolutions.pk/apps-dba-interview-questions-part-4/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="What is the difference between alter and FNDCPASS in changing apps password?" open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] FNDCPASS will update some
- [Apps DBA Interview Questions Part 3](https://oraclesolutions.pk/apps-dba-interview-questions-part-3/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="What is adctrl?" open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] Adctrl is one of the ad-utilities, which is used to check the status
- [Apps DBA Interview Questions Part 2](https://oraclesolutions.pk/apps-dba-interview-questions-part-2/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="You are applying a patch , can you open another session and run adadmin ?" open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] Yes,
- [Apps DBA Interview Questions Part 1](https://oraclesolutions.pk/apps-dba-interview-questions-part-1/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="Briefly Describe the architecture of Oracle Applications?" open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] Oracle Applications follow a Three tier architecture: Database Tier
- [Apps Technical Interview Questions Part 1](https://oraclesolutions.pk/apps-technical-interview-questions-part-1/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="What is an ERP?" open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] It is a Packaged Business Software system that lets a company automate and
- [Apps Technical Interview Questions Part 2](https://oraclesolutions.pk/apps-technical-interview-questions-part-2/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="Which is the most commonly used package in apps that uses Autonomous Transaction?" open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] FND_LOG, this is
- [Apps Technical Interview Questions Part 3](https://oraclesolutions.pk/apps-technical-interview-questions-part-3/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="What are ad-hoc reports ?" open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] Ad-hoc Report is made to meet one-time reporting needs. Concerned with
- [Apps Technical Interview Questions Part 4](https://oraclesolutions.pk/apps-technical-interview-questions-part-4/) - [et_pb_section bb_built="1" _builder_version="3.0.52" background_image="http://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg" parallax="on" parallax_method="off" inner_shadow="on"][et_pb_row _builder_version="3.0.52" parallax="on" parallax_method="off" background_position_1="top_left" background_repeat_1="no-repeat" make_fullwidth="on" use_custom_width="on" custom_width_percent="100%" custom_width_px="1702px" use_custom_gutter="on" width_unit="off" make_equal="on"][et_pb_column type="4_4"][et_pb_toggle _builder_version="3.0.52" title="Write down the Form development process?" open="off" use_background_color_gradient="on" border_style="ridge" background_color="#ffffff" title_font="Montserrat|on||on|" title_text_color="#ffffff" body_font="Montserrat||||" body_font_size="15" background_color_gradient_end="#000000" background_color_gradient_direction="181deg" use_border_color="on" icon_color="#0c71c3" title_font_size="18" body_line_height="1em" border_width="3px" background_color_gradient_start="#ffffff" open_toggle_text_color="#ff0000" body_text_color="#ffffff"] Open template form. Save as .fmb Change the form
- [How to create Employee as a customer in AR](https://oraclesolutions.pk/create-employee-customer-ar/) - How to create Employee as a customer in AR Step 1. Set the Profile option AR: Show Parties Without Accounts In DQM at site level. Step 2. Now, Query the Employee Name in the Customer Screen with Person as a header selection.
- [descriptive flexfield with application name iAssets (IA) and name IA Request Headers (IA_REQUEST_HEADERS) is not frozen](https://oraclesolutions.pk/descriptive-flexfield-with-application-name-iassets-ia-and-name-ia-request-headers-ia_request_headers-is-not-frozen/) - ERROR The descriptive flexfield with application name iAssets (IA) and name IA Request Headers (IA_REQUEST_HEADERS) is not frozen. Please contact your system administrator. SOLUTION Step 1. Navigate to Responsibility Fixed Assets Manager. Step 2. Now, Navigate to Setup > Financials > Flexfields > Descriptive > Segments Step 3. Press F11 and Query Application = iAssets and Title
- [Not able to populate retained earning account in ledger setup in 12.2.3 - "Please choose an existing combination"](https://oraclesolutions.pk/not-able-populate-retained-earning-account-ledger-setup-12-2-3-please-choose-existing-combination/) - ERROR Not able to populate retained earning account in ledger setup in 12.2.3 - "Please choose an existing combination" SOLUTION To implement the solution, please execute the following steps: Step 1. Download and review the readme and pre-requisites for Patch:18123067>:R12.FND.C Step 2. Ensure that you have taken a backup of your system before applying
- [How to Setup Asset Impairments in Oracle R12](https://oraclesolutions.pk/setup-asset-impairments-oracle-r12/) - How to Setup Asset Impairments in Oracle R12 Step 1. Setup Cash Generating Unit (CGU): Navigate to Assets responsibility: (N) Setup > Asset System > Cash Generating Units Define or maintain Cash Generating Units for each book that needs Impairment functionality. Step 2. Assign Cash Generating Units to Assets: There are two possibilities to assign
- [Interface Expense Reports from Payables are failing with errors](https://oraclesolutions.pk/interface-expense-reports-from-payables-are-failing-with-errors/) - ERROR PRC: Interface Supplier Costs and PRC: Interface Expense Reports from Payables are failing with errors: 03:46:45: log messages from transaction import 03:46:45: transaction import failed with sqlcode = 03:46:45: -20003 03:46:45: ORA-20003: import1_prog:ORA-01426: numeric overflowIn stage 2 Updated count to T = 0 03:46:45: Within main logic of tieback Error found in code G_adj_item_id
- [Description for Journal Entry Line not Populated in GL_JE_LINES.REFERENCE10](https://oraclesolutions.pk/description-journal-entry-line-not-populated-gl_je_lines-reference10/) - ERROR Description for Journal Entry Line not Populated in GL_JE_LINES.REFERENCE10 SOLUTION Run Journal Import in detail mode. Step 1. Go to Responsibility General Ledger Super User Step 2. Go to Navigation Path : Journal>Import>Run Step 3. Make sure Create Summary Journals checkbox is blank.
- [Please Define a Party Tax Profile for Operating Unit ORG_ID](https://oraclesolutions.pk/please-define-party-tax-profile-operating-unit-org_id/) - ERROR Please Define a Party Tax Profile for Operating Unit ORG_ID SOLUTION To implement the solution, please execute the following steps: Step 1. Navigate to Responsibility: Tax Managers Step 2. Navigation to: Parties > Party Tax > Profiles Step 3. Query: Party Type: Operating Unit Owning Tax Content Party Name: Populate your Operating
- [Not all Auto Accounting types are define](https://oraclesolutions.pk/not-auto-accounting-types-define/) - ERROR while running AR autoinvoice master program given error: Log output error: Not all AutoAccounting types are define SOLUTION Make sure all Auto-Accounting Types accounts under Receivables Manager Responsibility are defined as listed below: Receivables Revenue Tax Freight Auto-Clearing Un-Earned Un-Billed Navigate to Setup> Transactions >AutoAccounting for Defining Auto-Accounting Types Reference: AutoInvoice Error: Not all AutoAccounting
- [Error During Payables Open Interface Import](https://oraclesolutions.pk/error-during-payables-open-interface-import/) - ERROR When attempting to run the Payables Open Interface Import, the following error occurs: ERROR --------------- ZX_PRODUCT_TYPE_NOT_EFFECTIVE This Product Type Code is not valid on the transaction date SOLUTION To implement the solution, please execute the following steps: Step 1. Download and review the readme and pre-requisites for Patch:13814064:R12.ZX.B. Step 2. Ensure that you have
- [FRM-40735: PRE-UPDATE trigger raised unhandled exception ORA-00600](https://oraclesolutions.pk/frm-40735-pre-update-trigger-raised-unhandled-exception-ora-00600/) - ERROR AP: Payables Options Withholding Tax Change Error: FRM-40735: PRE-UPDATE trigger raised unhandled exception ORA-00600. SOLUTION Step 1. Download and review the readme and pre-requisites for the RDBMS Patch 12816846. As this is a database patch, ensure to locate the patch checkin appropriate for your database version. Step 2. Ensure to take a backup of
- [Oracle Fixed assets (FA) Profile Options](https://oraclesolutions.pk/oracle-fixed-assets-fa-profile-options/) - Oracle Fixed assets (FA) Profile Options Account Generator: Purge Runtime Data Always set this profile option to Yes to ensure that Oracle Workflow has finished generating accounting flexfield code combinations. Temporarily set this option to No at the user level if you are debugging the account generator. Running the account generator with
- [An attempt has been made to enter a null value into a column that requires data](https://oraclesolutions.pk/an-attempt-has-been-made-to-enter-a-null-value-into-a-column-that-requires-data/) - ERROR An attempt has been made to enter a null value into a column that requires data. Please correct to ensure that only valid values are entered for the column. SOLUTION Please Validate the receipt class definition in bank account tab bank charge account is defined properly. Step 1. Navigate to Responsibility: Receivables Manager Step 2. Navigation to:
- [APP-ONT-251213: Error: Please enter valid address elements: STATE, CITY.](https://oraclesolutions.pk/app-ont-251213-error-please-enter-valid-address-elements-state-city/) - ERROR APP-ONT-251213: Error: Please enter valid address elements: STATE, CITY. SOLUTION Follow the below step to install this Patch 9294165 and fix this issue. Step 1. Download and review the readme and pre-requisites for Patch 9294165 R12.ONT.B Step 2. Ensure that you have taken a backup of your system before applying the recommended patch. Step 3. Apply the
- [General Ledger (GL) Journals Profile Options](https://oraclesolutions.pk/general-ledger-gl-journal-profile-options/) - General Ledger (GL) Journals Profile Options Journals: Allow Multiple Exchange Rates Controls whether to allow multiple conversion rates within a journal entry. Journals: Allow Posting During Journal Entry Controls whether you can post a manual journal entry from the Enter Journals window. Journals: Default Category Specify the default category for manual journal entries.
- [Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512](https://oraclesolutions.pk/oracle-error-1403-java-sql-sqlexception-ora-01403-no-data-found-ora-06512/) - ERROR Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session is no longer valid. SOLUTION Step 1. Execute the following scripts from $FND_TOP/patch/115/sql: SQL> @AFICXSMS.pls SQL> @AFICXSMB.pls Step 2. Bounce the server. Step 3. Retest the issue. Step 4. Migrate the solution to production
- [Unable To View The Concurrent Request Output](https://oraclesolutions.pk/unable-view-concurrent-request-output/) - ERROR Unable To View The Concurrent Request Output error: Error connecting to database PRODDB: ORA-10 SOLUTION $sqlplus / ' as sysdba' $startup Execute below command: $ALTER PROFILE default LIMIT PASSWORD_GRACE_TIME unlimited;
- [AP invoice import program error (REP-0004, MSG-00001,MSG-00002,MSG-00003,MSG-00007,MSG-00008,MSG-00009)](https://oraclesolutions.pk/ap-invoice-import-program-error-rep-0004-msg-00001msg-00002msg-00003msg-00007msg-00008msg-00009/) - ERROR REP-0004: Warning: Unable to open user preference file. MSG-00001: (Import_purge 1) Check control table for the purge process MSG-00001: (Check_control_table 1) Lock the control table MSG-00003: (Check_control_table 2) Fetch import_requests MSG-00007: (Check_control_table 5) Insert record into control table MSG-00008: (Check_control_table 6) Commit MSG-00002: (Import_purge 2) Updating Org Id to value if Operating Unit is
- [Unable to See the Legal Entity LOV in Bank Account Owner Field](https://oraclesolutions.pk/unable-see-legal-entity-lov-bank-account-owner-field/) - ERROR Unable to See the Legal Entity LOV in Bank Account Owner Field SOLUTION Step 1. Login as System Administrator user and then switch responsibility to User Management. Step 2. Click in Roles & Role Inheritance link Step 3. Do the following search: Type: Role and Responsibilities Category: Miscellaneous Application: Cash Management Choose the Cash
- [Error while Purge the concurrent request - ORA-0001 unique constraint %s.%s](https://oraclesolutions.pk/error-purge-concurrent-request-ora-0001-unique-constraint-s-s/) - ERROR Error while Purge the concurrent request - ORA-0001 unique constraint %s.%s SOLUTION Two patches below are necessary for the workaround to work: Patch 10106197:R12.FND.B Patch 12747284:R12.FND.B Now, Run with FNDCPPUR with same parameters, but with COUNT >= 2. Once completed, you should be able to run it as before with no issue. NOTE: This
- [APP-ONT-251213 Provide a positive integer for minimum customer balance amount](https://oraclesolutions.pk/app-ont-251213-provide-positive-integer-minimum-customer-balance-amount/) - ERROR APP-ONT-251213 Provide a positive integer for minimum customer balance amount or percent when invoice amount is overdue type is amount or percent respectively SOLUTION The issue is caused by missing setup. Step 1. Navigate to Receivables Manager Responsibility. Step 2. Navigate to Customers > Profile Classes Step 3. Query for the profile class (say
- [Account Receivable (AR) Late charge report ended with null output](https://oraclesolutions.pk/account-receivable-ar-late-charge-report-ended-with-null-output/) - ERROR Account Receivable (AR) Late charge report ended with null output SOLUTION Step 1. Navigate to Responsibility: System Administrator Step 2. Navigation to Profile > System Step 3. Query Profile: AR: Use Statement, Dunning, and Late Charges Step 4. Set the profile option to "Yes" at the site level.
- [Customer Not Showing in HTML Form](https://oraclesolutions.pk/customer-not-showing-html-form/) - ERROR Customer Not Showing in HTML Form after creating Customer through Interface SOLUTION Run DQM Staging program with STAGE_ALL_DATA parameter. Once This program finishes , Customer can seen in Customers form.
- [ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL](https://oraclesolutions.pk/ora-03113-end-file-communication-channel/) - ERROR SQL> connect / as sysdba Connected to an idle instance. SQL> startup; ORACLE instance started. Total System Global Area 1987563520 bytes Fixed Size 2214696 bytes Variable Size 1040188632 bytes Database Buffers 939524096 bytes Redo Buffers 5636096 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 5114 Session ID: 191 Serial number: 3 SOLUTION
- [Java Heap Space Error while running Payables Posted Invoice Register](https://oraclesolutions.pk/java-heap-space-error-while-running-payables-posted-invoice-register/) - ERROR When attempting to run Payables Posted Invoice Register , the following error occurs. ERROR ----------------------- Status=Error Completion Text=Java Heap Space SOLUTION Step 1. Set the Java Virtual Memory (JVM) for the report to a higher value. Responsibility: Application Developer or System Administrator Navigate: Concurrent > Program Query the Concurrent Program - query Report which
- [Error In Payables Open Interface Import : PA Flexbuild Failed](https://oraclesolutions.pk/error-in-payables-open-interface-import-pa-flexbuild-failed/) - ERROR (v_check_line_project_info 4) Call pa_flexbuild (PA Flexbuild 1) Check for PA installation and Project Info (PA Flexbuild 1) Get User Id (PA Flexbuild 1) PA_TRANSACTIONS_PUB.VALIDATE_TRANSACTION (PA Flexbuild 1) PA_TRANSACTIONS_PUB.VALIDATE_TRANSACTION Failed :Insert Rejecti on PA_PROJECT_NOT_VALID (Insert Rejections 1) Insert into AP_INTERFACE_REJECTIONS, REJECT CODE:PA FLEXBU ILD FAILED SOLUTION To implement the solution, please perform
- [New CPADMIN Utility for Managing Concurrent Processing Now Available](https://oraclesolutions.pk/new-cpadmin-utility-managing-concurrent-processing-now-available/) - New CPADMIN Utility for Managing Concurrent Processing Now Available By: Steven Chan| Senior Director In Oracle E-Business Suite, concurrent processing simultaneously executes programs running in the background with online operations. When a user runs a report, a request to run the report is generated. The command to run the report is a concurrent request. The
- [Creating Custom Applications in EBS 12.2](https://oraclesolutions.pk/creating-custom-applications-in-ebs-12-2/) - Creating Custom Applications in EBS 12.2 By: Steven Chan| Senior Director The least invasive method of fine-tuning your E-Business Suite environment to your users' needs is via personalizations. If that approach is insufficient, you can create custom applications via Forms, Reports, and other technologies that segregate your customizations from the standard functionality provided with Oracle
- [In Oracle Applications R12.2.x - Forms does not show any menu or you cannot perform any action in forms](https://oraclesolutions.pk/in-oracle-applications-r12-2-x-forms-does-not-show-any-menu-or-you-cannot-perform-any-action-in-forms/) - ERROR In Oracle Applications R12.2.x - Forms does not show any menu or you cannot perform any action in forms SOLUTION Step 1. In Windows 7 (64 bit), go to C:\Program Files (x86)\Java\jre6\lib\security, and Open the file named 'java.policy' in notepad and add these lines to the beginning: grant { permission java.security.AllPermission;}; Step 2. Save the
- [ORA-20008: No Concurrent Manager is defined that can run concurrent program ADZDPATCH](https://oraclesolutions.pk/ora-20008-no-concurrent-manager-defined-can-run-concurrent-program-adzdpatch/) - ERROR adop phase=prepare ORA-20008: No Concurrent Manager is defined that can run concurrent program ADZDPATCH $adop phase=prepare The step halted with the below error: SQL> select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(527131) from dual * ERROR at line 1: ORA-20008: No Concurrent Manager is defined that can run concurrent program ADZDPATCH ORA-06512: at "APPS.AD_ZD_ADOP", line 240 SOLUTION Run
- [ORA-01586: database must be mounted EXCLUSIVE and not open for this operation](https://oraclesolutions.pk/ora-01586-database-must-mounted-exclusive-not-open-operation/) - ERROR ORA-01586: database must be mounted EXCLUSIVE and not open for this operation SOLUTION $sqlplus / as sysdba SQL>shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL>startup mount exclusive restrict; ORACLE instance started. Total System Global Area 2112354232 bytes Fixed Size 2212208 bytes Variable Size 1356068952 bytes Database Buffers 838652800 bytes Redo
- [ORA-02082: a loopback database link must have a connection qualifier](https://oraclesolutions.pk/ora-02082-a-loopback-database-link-must-have-a-connection-qualifier/) - ERROR ORA-02082: a loopback database link must have a connection qualifier SQL>drop public database link APPS; drop public database link APPS * ERROR at line 1: ORA-02082: a loopback database link must have a connection qualifier SOLUTION Rename the global_name of the database before you can drop the database link. SQL>select * from global_name;
- [adapcctl.sh: exiting with status 204/ HTTP_Server~1.log : libdb.so.2: cannot open shared object file](https://oraclesolutions.pk/adapcctl-sh-exiting-status-204-http_server1-log-libdb-2-cannot-open-shared-object-file/) - ERROR adapcctl.sh: exiting with status 204/ HTTP_Server~1.log : libdb.so.2: cannot open shared object file You are running adapcctl.sh version 120.7.12010000.2 Starting OPMN managed Oracle HTTP Server (OHS) instance ... adapcctl.sh: exiting with status 204 --> Process (index=1,uid=1288926491,pid=31768) failed to start a managed process after the maximum retry limit and it referred to HTTP_Server~1.log. SOLUTION Shutdown
- [ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException](https://oraclesolutions.pk/ora-29532-java-call-terminated-by-uncaught-java-exception-java-security-accesscontrolexception/) - ERROR ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException exception in SendMail =ORA-29532: Java call terminated by uncaught Java exception: The PL/SQL to grant this is dbms_java.grant_permission( 'APPS', 'SYS:java.io.FilePermission', '/XXXXXX/sqlcom/out/MISSING_ATTRIBUTE_ITEMS_2111201409:23:51.xls', 'read' ) SOLUTION Login as SYS or SYSTEM user and then assign the required permission $sqlplus / as sysdba SQL>EXEC DBMS_JAVA.GRANT_PERMISSION('APPS','SYS:java.io.File/ Permission','/XXXXXX/sqlcom/out/*','read,write'); PL/SQL
- [Oracle EBS Application R12 Short Keys](https://oraclesolutions.pk/oracle-ebs-application-r12-short-keys/) - Oracle EBS Application R12 Short Keys Function Key Function Key Actions LOV Shift + Ctrl + F8 Help Ctrl + H Block Menu Ctrl + B Insert Record Ctrl + Down Clear Block F7 List of Values Ctrl + L Clear Field F5 List Tab Pages F2 Clear Form F8 Next Block Shift
- [APP-SQLAP-10000: ORA-01403: no data found occurred in  with parameters (Term id = Sequence num = 1)](https://oraclesolutions.pk/app-sqlap-10000-ora-01403-no-data-found-occurred-parameters-term-id-sequence-num-1app-sqlap-10000-ora-01403-no-data-found-occurred-in-with-parameters-term-id-sequence-num-1/) - ERROR Unable to validate invoice where the item line has a withholding tax group due to: APP-SQLAP-10000: ORA-01403: no data found occurred in with parameters (Term id = Sequence num = 1) while performing the following operation: &DEBUG_INFO the following error occurs. SOLUTION Step 1. Navigate to Supplier form through Payables > Suppliers >
- [APP-OFA-48723 You cannot delete setup data from a secured responsibility.](https://oraclesolutions.pk/app-ofa-48723-cannot-delete-setup-data-secured-responsibility/) - ERROR APP-OFA-48723 You cannot delete setup data from a secured responsibility. The data may already be in use by assets or books that you do not have access to. To delete setup data please use a non-secured responsibility. SOLUTION This Error is normally Produced when you try to delete an Unused/Wrong Asset Category from any Secured
- [ERROR ORA-00020 maximum number of processes (%s) exceeded](https://oraclesolutions.pk/error-ora-00020-maximum-number-processes-s-exceeded/) - ERROR ERROR ORA-00020 maximum number of processes (%s) exceeded SOLUTION Connect to sqlplus with sysdba $ sqlplus / ' as sysdba' SQL>ALTER SESSION SET processes = (your desired value);
- [Oracle Account Receivables (AR) Late charge report ended with "no data found"](https://oraclesolutions.pk/oracle-account-receivables-ar-late-charge-report-ended-with-no-data-found/) - ERROR Oracle Account Receivables (AR) Late charge report ended with "no data found" SOLUTION Step 1. Navigate to responsibility: Receivables Manager Step 2. Navigate to Customers > profiles Step 3. Query the profile used on your customers Step 4. Change the 'Late Charge Type' to 'Adjustment'. Ensure you update all customers.
- [Tkprof - Convert Trace .trc to Readable](https://oraclesolutions.pk/tkprof-convert-trace-trc-to-readable/) - Tkprof - Convert Trace .trc to Readable tkprof explain=/ Where, tkprof: is command : is file name of trace file with location (if currently not in same directory) : is output file name explain= /: provide apps user name and password. Example: tkprof /tmp/oracle.trc /tmp/output.tkprof explain=apps/****
- [FRM-92050 failed to connect to Server /forms/servlet -1](https://oraclesolutions.pk/frm-92050-failed-connect-server-formsservlet-1/) - ERROR FRM-92050 failed to connect to Server /forms/servlet -1 SOLUTION Step 1. Go to Internet Option in internet Explorer Step 2. Go to Security Tab and then Click Custom Level button. Step 3. Scroll down to the last and then Disable the XSS Filter and Click OK.
- [Using Patch Wizard to Identify Files Affected by Specific Patches](https://oraclesolutions.pk/using-patch-wizard-identify-files-affected-specific-patches/) - Using Patch Wizard to Identify Files Affected by Specific Patches By: Steven Chan| Senior Director Patch Wizard compares your EBS environment against a list of all recommended EBS patches. It creates a list of high-priority patches that your environment is missing. You can use Patch Wizard to assess the impact of a specific patch on
- [General Ledger Interview Questions Part 7](https://oraclesolutions.pk/general-ledger-interview-questions-part-7/) - 1.What is journal, how many types of journal? Journals it is used to record the business transaction it contains debit and credit lines always debit must be equal to credit. Types of journals are: Suspense Journal or Unbalanced Journal Recurring Journals Reversal journals 2. What is P2P Process & O2C Process Procure
- [General Ledger Interview Questions Part 6](https://oraclesolutions.pk/general-ledger-interview-questions-part-6/) - 1.How many flex fields structures can you create for GL? “N” No of flexfield structures can be created in GL 2.What is a value set? What are the format types? A group of values and related attributes you assign to an account segment or to a descriptive flexfield segment. Values in each value
- [General Ledger Interview Questions Part 5](https://oraclesolutions.pk/general-ledger-interview-questions-part-5/) - 1.List of (any five) Standard reports of G/L. Budget Summary/ Detail. Consolidation Rule. Chart of Accounts Detail list. Inter company transaction Details. FSG- Column set detail listing. FSG- Row set summary listing. Trail Balance- Encumbrances. 2. What you mean by “FSG”? What are the mandatory sets for FSG? Financial Statement Generator (FSG) is a
- [General Ledger Interview Questions Part 4](https://oraclesolutions.pk/general-ledger-interview-questions-part-4/) - 1.What are the steps for Multi Reporting Currencies or MRC ? MRC is used for reporting in any other Currency including functional currency. We use Primary and reporting set of books for MRC, the primary and the reporting Ledger should have the same COA and Calendar but may have different currency. Steps for MRC Define
- [General Ledger Interview Questions Part 3](https://oraclesolutions.pk/general-ledger-interview-questions-part-3/) - 1.Explain the steps for Mass Budget? Mass budget means allocation of budget amounts to the range of accounts. Before going to the mass budget we have to ensure whether Budgetary control is checked at the Budgetary control Tab of Set of Books. Step-1: Define parent segment value and assign the Child segment values. In chart
- [General Ledger Interview Questions Part 2](https://oraclesolutions.pk/general-ledger-interview-questions-part-2/) - 1.Why my cross validation rules not working? The desired combination may be already used. The combination entered manually in account combination. If you un check the cross validate segments in key flex field segment form. If we un check enable check box at define cross validation rule. 2.List any six-validation reports of calendar. The
- [General Ledger Interview Questions Part 1](https://oraclesolutions.pk/general-ledger-interview-questions-part-1/) - 1.What are the different types of value set (or) validation types? Explain each in brief? The validation types are 8 they are Independent : the nature of segment is independent Dependent : this segment depends on independent segment None
- [Query has exceeded 200 rows. Potentially more rows exists, please restrict your query.](https://oraclesolutions.pk/query-has-exceeded-200-rows-potentially-more-rows-exists-please-restrict-your-query/) - ERROR Query has exceeded 200 rows. Potentially more rows exists, please restrict your query. SOLUTION Step 1. Go to the responsibility: System Administrator. Step 2. Navigate to Profiles > System Query the Profile Option FND: View Object Max Fetch Size at Site, Application (Oracle Configurator) and User Level. Step 3.Change the value from 200 to a higher value
- [APP-PAY-06882: Assertion failure detected at location py3vntsetup:2](https://oraclesolutions.pk/app-pay-06882-assertion-failure-detected-location-py3vntsetup2/) - ERROR Error while Payroll processing:- HR_6882_HRPROC_ASSERT LOCATION py3vntsetup:2 APP-PAY-06882: Assertion failure detected at location py3vntsetup:2. SOLUTION Step 1. Run the application Environment file and Relink PYUGEN and PYUVEN. $ adrelink.sh force=y ranlib=y 'pay PYUGEN' $ adrelink.sh force=y ranlib=y ‘pay PYUVEN’ Step 2.
- [Oracle Application Implementation Methodology (AIM) Document List](https://oraclesolutions.pk/oracle-application-implementation-methodology-document-list/) - Oracle Application Implementation Methodology (AIM) Document List 1.Business Process Architecture (BP) BP.010 Define Business and Process Strategy BP.020 Catalog and Analyze Potential Changes BP.030 Determine Data Gathering Requirements BP.040 Develop Current Process Model BP.050 Review Leading Practices BP.060 Develop High-Level Process Vision BP.070 Develop High-Level Process Design BP.080 Develop Future Process Model BP.090 Document
- [Whitepaper: E-Business Suite Upgrade Sizing and Best Practices](https://oraclesolutions.pk/whitepaper-e-business-suite-upgrade-sizing-best-practices/) - Whitepaper: E-Business Suite Upgrade Sizing and Best Practices By: Steven Chan | Senior Director One of the most-common questions we see revolves around sizing for EBS upgrades -- that is, the amount of resources required when upgrading from one EBS release to another. It is difficult to make general statements about these types of requirements
- [APP-OFA-47333: You Cannot Perform this transaction](https://oraclesolutions.pk/app-ofa-47333-you-cannot-perform-this-transaction-because-the-asset-is-fully-retired/) - ERROR APP-OFA-47333: You Cannot Perform this transaction because the asset is fully retired. Choose a book in which you have not yet retired the asset, or reinstate the asset, and then perform the transaction. If you wish to cancel or undo the retirement, Please query it first. SOLUTION Step 1. Navigate to Inquiry >
- [ORA-12645 Parameter does not exist, Oracle error code](https://oraclesolutions.pk/ora-12645-parameter-does-not-exist-oracle-error-code/) - ERROR Translation of the error message from Oracle's support site: ORA-12645: Parameter does not exist. Cause: A sqlnet.ora parameter from which a value was needed does not exist. Action: Set the parameter in the parameter file. SOLUTION In sqlnet.ora the parameter is SQLNET.ENCRYPTION_CLIENT. "oracle.net.encryption_client" is a JDBC parameter.
- [java.io.IOException: ORA-01691: unable to extend lob segment](https://oraclesolutions.pk/java-io-ioexception-ora-01691-unable-extend-lob-segment/) - ERROR Start uploading... Target file: SAF654_XML.rtf Creating a new record in XDO_LOBS: SAF645_XML.rtf java.io.IOException: ORA-01691: unable to extend lob segment XDO.SYS_LOB00001312564V00010$$ by 16 in tablespace APPS_TS_TX_DATA at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:517) at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:214) at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java:144) at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105) at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:133) at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:291) at oracle.apps.xdo.oa.schema.server.LobHelper.createLob(LobHelper.java:778) at oracle.apps.xdo.oa.schema.server.LobHelper.createLob(LobHelper.java:730) at oracle.apps.xdo.oa.util.XDOLoader.processUpload(XDOLoader.java:1163) at
- [Webcast: Maintenance Strategies for Oracle E-Business Suite](https://oraclesolutions.pk/webcast-maintenance-strategies-oracle-e-business-suite/) - Webcast: Maintenance Strategies for Oracle E-Business Suite By: Steven Chan | Senior Director Oracle University has a large collection of free recorded webcasts for Oracle E-Business Suite. Here's an excellent primer for system administrators interested in creating a framework for regular EBS maintenance: Maintenance Strategies for Oracle E-Business Suite (33 mins) Elke Phelps, Senior Principal
- [APP-FND-01542: This Applications Server is not authorized to access this database](https://oraclesolutions.pk/app-fnd-01542-applications-server-not-authorized-access-database/) - ERROR APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator. SOLUTION Step 1. Backup context file . Step 2. Update the context variable: s_appserverid_authentication By default in 11.5.10, this is set to SECURE. In previous 11i versions, this was set to OFF. For debug purposes, you can
- [Webcast: Testing Recommendations for Oracle E-Business Suite Applications](https://oraclesolutions.pk/webcast-testing-recommendations-oracle-e-business-suite-applications/) - Webcast: Testing Recommendations for Oracle E-Business Suite Applications By: Steven Chan| Senior Director Oracle University has a large collection of free recorded webcasts that EBS system administrators might find useful. Here's another webcast on testing EBS environments: Testing Recommendations for Oracle E-Business Suite Applications (27 mins) Prashanti Madiredd, Senior Director Quality Assurance shares best practices
- [What Tools Do You Use to Patch EBS 12.2 ORACLE_HOMEs?](https://oraclesolutions.pk/tools-use-patch-ebs-12-2-oracle_homes/) - What Tools Do You Use to Patch EBS 12.2 ORACLE_HOMEs? By: Steven Chan | Senior Director Oracle E-Business Suite 12.2 has several technology stack components. Each component has its own ORACLE_HOME: Oracle Fusion Middleware Oracle WebLogic Server (WLS) 10.3.6 OHS (WebTier) 11.1.1 and Oracle Common (Common Modules) Application Server (OracleAS) Forms and Reports 10.1.2 Oracle
- [The Center of Excellence in the Era of Self-Service Analytics](https://oraclesolutions.pk/center-excellence-era-self-service-analytics/) - The Center of Excellence in the Era of Self-Service Analytics By: Jake Krakauer With the new generation of visual, self-service analytics software, the traditional role of IT in providing business analysis tools, integration with data sources, data models and reports has changed. Nowadays, the pendulum has swung heavily towards business self-service capabilities. Business people now
- [Webcast: Testing E-Business Suite with Flow Builder](https://oraclesolutions.pk/webcast-testing-e-business-suite-flow-builder/) - Webcast: Testing E-Business Suite with Flow Builder By: Steven Chan| Senior Director Oracle University has a large number of free recorded webcasts that EBS sysadmins might find useful. Here's another good webcast on our testing tools: Testing E-Business Suite with Flow Builder (27 mins) Mazen Arar, Senior Director EBS Quality Assurance, provides an overview of
- [Unable to locate 'make' utility in path](https://oraclesolutions.pk/unable-locate-make-utility-path/) - ERROR Unable to locate 'make' utility in path Issue : bash-3.2$ perl adcfgclone.pl dbTechStack Copyright (c) 2011 Oracle Corporation Redwood Shores, California, USA
- [Is it Possible to Run Patch Wizard Offline?](https://oraclesolutions.pk/possible-run-patch-wizard-offline/) - Is it Possible to Run Patch Wizard Offline? By: Steven Chan| Senior Director Patch Wizard helps you identify useful or critical missing patches for your EBS environment. Many of the largest EBS customers run their environments where external network connectivity is extremely limited or non-existent. The latter architectures are sometimes "air gapped" from external networks
- [Webcast: Advanced Architectures for Oracle E-Business Suite](https://oraclesolutions.pk/webcast-advanced-architectures-oracle-e-business-suite/) - Webcast: Advanced Architectures for Oracle E-Business Suite By: Steven Chan| Senior Director Oracle University has a large number of free recorded webcasts for Oracle E-Business Suite. Here's an excellent webcast for a wide range of architectural options for more-complex deployment requirements: Advanced Architectures for Oracle E-Business Suite (27 mins) Elke Phelps, Senior Principal Product Manager
- [Where Can I Find the Latest Patch Wizard Updates for EBS 12.2?](https://oraclesolutions.pk/can-find-latest-patch-wizard-updates-ebs-12-2/) - Where Can I Find the Latest Patch Wizard Updates for EBS 12.2? By: Steven Chan| Senior Director Patch Wizard helps you identify useful or critical missing patches for your EBS environment. This tool is updated as needed, with patches that are cumulative: they include new updates as well as all fixes released previously. The latest
- [PL/Sql Interview Questions Part 4](https://oraclesolutions.pk/plsql-interview-questions-part-4/) - 1. What will you get by the cursor attribute SQL%FOUND? It returns the Boolean value TRUE if at least one row was processed. 2. What will you get by the cursor attribute SQL%NOTFOUND? It returns the Boolean value TRUE if no rows were processed. 3. What do you understand by PL/SQL packages?
- [PL/Sql Interview Questions Part 3](https://oraclesolutions.pk/plsql-interview-questions-part-3/) - 1. What are some predefined exceptions in PL/SQL? A list of predefined exceptions in PL/SQL: DUP_VAL_ON_INDEX ZERO_DIVIDE NO_DATA_FOUND TOO_MANY_ROWS CURSOR_ALREADY_OPEN INVALID_NUMBER INVALID_CURSOR PROGRAM_ERROR TIMEOUT _ON_RESOURCE STORAGE_ERROR LOGON_DENIED VALUE_ERROR etc. 2. What is a trigger in PL/SQL? A trigger is a PL/SQL program which is stored in the database. It is executed immediately before or after
- [Webcast: Standards-based Desktop Integration in Oracle E-Business Suite](https://oraclesolutions.pk/webcast-standards-based-desktop-integration-in-oracle-e-business-suite/) - Webcast: Standards-based Desktop Integration in Oracle E-Business Suite By: Steven Chan| Senior Director Oracle University has a large number of free recorded webcasts for Oracle E-Business Suite. Here's a useful one on Web Applications Desktop Integrator (Web ADI) and Oracle Report Manager: Standards-based Desktop Integration in Oracle E-Business Suite (37 mins) Padmabrabodh Ambale covers the
- [Providing Limited Patch Wizard Access to EBS End-Users](https://oraclesolutions.pk/providing-limited-patch-wizard-access-ebs-end-users/) - Providing Limited Patch Wizard Access to EBS End-Users By: Steven Chan | Senior Director Patch Wizard helps you identify useful or critical missing patches for your EBS environment. One of the most common questions we get is how to provide Patch Wizard access to end-users without giving them full access to the rest of the
- [PL/Sql Interview Questions Part 2](https://oraclesolutions.pk/plsql-interview-questions-part-2/) - 1. What is PL/SQL? PL/SQL stands for procedural language extension to SQL. It supports procedural features of programming language and SQL both. It was developed by Oracle Corporation in early of 90's to enhance the capabilities of SQL. 2. What is the purpose of using PL/SQL? PL/SQL is an extension of SQL. While SQL is non-procedural,
- [PL/Sql Interview Questions Part 1](https://oraclesolutions.pk/plsql-interview-questions-part-1/) - 1. What are Procedure, functions and Packages? Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or perform set of related tasks. Procedures do not return values while Functions return one Value. Packages provide a method of encapsulating and storing related procedures,
- [Can EBS Nodes Be at Different Operating System Levels?](https://oraclesolutions.pk/can-ebs-nodes-be-at-different-operating-system-levels/) - Can EBS Nodes Be at Different Operating System Levels? By: Steven Chan | Senior Director Oddly, a category of EBS architecture questions that I'd thought long-settled is starting to reemerge. I've recently seen several queries along the lines of: Can EBS database nodes and application tier nodes be on different operating systems? Can multiple EBS
- [Enabling an EBS Global Diagnostics Trace](https://oraclesolutions.pk/enabling-ebs-global-diagnostics-trace/) - Enabling an EBS Global Diagnostics Trace By: Steven Chan | Senior Director Oracle E-Business Suite provides several types of logs. One of the tools you can use is the Logging Framework, which allows you to collect and view log messages in Oracle Applications Manager. The Logging Framework collects debug messages, errors, and alerts. A Global
- [Webcast: "E-Business Suite 12.2 Upgrade Best Practices to Minimize Downtime"](https://oraclesolutions.pk/webcast-e-business-suite-12-2-upgrade-best-practices-minimize-downtime/) - Webcast: "E-Business Suite 12.2 Upgrade Best Practices to Minimize Downtime" By: Steven Chan| Senior Director Oracle University has a large selection of free recorded webcasts for Oracle E-Business Suite. If you're planning to upgrade to EBS 12.2, the following webcast is worth your time: E-Business Suite 12.2 Upgrade Best Practices to Minimize Downtime (40 mins)
- [object '/lib/libcwait.so' from /etc/ld.so.preload cannot be preloaded](https://oraclesolutions.pk/object-liblibcwait-so-from-etcld-so-preload-cannot-be-preloaded/) - ERROR ld.so: object '/lib/libcwait.so' from /etc/ld.so.preload cannot be preloaded: ignored. Changes Check compat-libcwait-2.1-1.i386.rpm was installed if yes SOLUTION 1- Move the "libcwait.so" library from "/usr/lib" to "/lib". 2. Modify the path given in the file "/etc/ld.so.preload" to point to the new location. 3- Download and Install compat-libcwait-2.1-2 of 64 bit with Root user.
- [Unable to locate 'linkxlC' utility in path](https://oraclesolutions.pk/unable-to-locate-linkxlc-utility-in-path/) - ERROR $ adcfgclone.pl dbTechStack Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA Oracle Applications Rapid Clone Version 12.0.0 adcfgclone Version 120.31.12010000.8 Enter the APPS password : no linkxlC in /u01/ebs/db/11.2.0/appsutil/clone/bin/../jre/bin /usr/bin /etc /usr/sbin /usr/ucb /home/oradev/bin /usr/bin/X11 /sbin /u01/ebs/db/11.2.0/bin . Checking for make... found - /usr/bin/make Checking for ld... found
- [Unable to authenticate session in Oracle apps R12 (12.0.4): Login Issue](https://oraclesolutions.pk/unable-authenticate-session-oracle-apps-r12-12-0-4-login-issue/) - ERROR Unable to authenticate session in Oracle apps R12 (12.0.4): Login Issue It is in the following log file: $INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log 15/09/19 05:45:20.601 10.1.3.0.0 Started 15/09/19 05:45:30.769 html: 10.1.3.0.0 Started 15/09/19 05:45:35 .132 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1219349853132 15/09/19 05:45:38.132 html: LeakSetting: global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false ignoring:null 15/09/19 05:45:45.859 html: chain failed javax.servlet.ServletException: java.lang.RuntimeException: Unable to create user session. Please contact your
- [Recommended Database Parameters Updated for EBS 12.2](https://oraclesolutions.pk/recommended-database-parameters-updated-ebs-12-2/) - Recommended Database Parameters Updated for EBS 12.2 By: Steven Chan | Senior Director We publish a definitive list of Oracle Database initialization parameter settings for the optimal performance of Oracle E-Business Suite 12.2, 12.1, and 12.0: Database Initialization Parameters for Oracle E-Business Suite Release 12 (Note 396009.1) This document covers all Oracle Database releases that
- [Login issues in Oracle E-Business Suite R12](https://oraclesolutions.pk/login-issues-in-oracle-e-business-suite-r12/) - ERROR The http error_log had the below error: oc4j_socket_recvfull timed out The Application log has the below error: 15/09/16 05:30:20.511 html: Servlet error java.lang.OutOfMemoryError: Java heap space 15/09/16 05:30:20.503 html: Servlet error The opmn log had the below error: 15/09/16 05:30:20 java.lang.OutOfMemoryError: Java heap space 15/09/16 05:30:20 java.lang.OutOfMemoryError: Java heap space 15/09/16 05:30:20 java.lang.OutOfMemoryError: Java heap space 15/09/16 05:30:20 Exception in thread "Timer-1"
- [Concurrent managers are down with status: System Hold, Fix Manager](https://oraclesolutions.pk/concurrent-managers-status-system-hold-fix-manager/) - ERROR All the concurrent managers are down with a status message: system hold, fix manager. The administer Concurrent manager screen has Actual: 0 and Target: 1 for all managers. SOLUTION 1. Make sure all application services are down. 2.Now, check the system profile Concurrent: GSM Enabled. This should be set to ‘Y’ 3. Execute
- [RC-50221: Warning: Port pool not free in R12 while running adcfgclone.pl](https://oraclesolutions.pk/rc-50221-warning-port-pool-not-free-r12-running-adcfgclone-pl/) - ERROR RC-50221: Warning: Port pool not free in R12 while running adcfgclone.pl I was getting the error below while running adcfgclone in R12.2 for run file system. While selecting the port pool value, i was getting the error saying one of the port pool is not free. upon checking the logs i found out OACORE
- [ORA-00845: MEMORY_TARGET not supported on this system](https://oraclesolutions.pk/ora-00845-memory_target-not-supported-system/) - ERROR SQL> startup nomount; ORA-00845: MEMORY_TARGET not supported on this system SOLUTION [oracle@oel6 ~]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_oel6-lv_root 43G 15G 26G 37% / tmpfs 1001M 212M 789M 22% /dev/shm /dev/sda1 485M 55M 405M 12% /boot .host:/ 245G 126G 119G 52% /mnt/hgfs Change the size of that files System by
- [REP-50125: Caught exception: java.lang.reflect.InvocationTargetException](https://oraclesolutions.pk/rep-50125-caught-exception-java-lang-reflect-invocationtargetexception/) - ERROR REP-50125: Caught exception: java.lang.reflect.InvocationTargetException $ rwdiag.sh -findAll Environment:Environment java.lang.UnsatisfiedLinkError: Can't find library rwu (librwu.a or .so) in sun.boot.library.path or java.library.path sun.boot.library.path=/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin java.library.path=/u01/apps/apps/tech_st/10.1.2/jdk/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/cz/12.0.0/bin:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/sht/12.0.0/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: Can't find library rwu (librwu.a or .so) in sun.boot.library.path or java.library.path sun.boot.library.path=/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin java.library.path=/u01/apps/apps/tech_st/10.1.2/jdk/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/cz/12.0.0/bin:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/sht/12.0.0/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib java.lang.reflect.InvocationTargetException oracle.reports.RWException: IDL:oracle/reports/RWException:1.0 Broadcast mechanism used to locate servers ------------------------------------------ Channel address = 228.5.6.7 Channel port =
- [ORA-01078: failure in processing system parameters ORA-29701: unable toconnect to Cluster Synchronization Service](https://oraclesolutions.pk/ora-01078-failure-processing-system-parameters-ora-29701-unable-toconnect-cluster-synchronization-service/) - ERROR startup of ASM instance failed with error: ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service SOLUTION check services by command: crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type OFFLINE OFFLINE ora....ER.lsnr ora....er.type ONLINE ONLINE orcl01 ora....2C.lsnr ora....er.type ONLINE ONLINE orcl01 ora.asm ora.asm.type OFFLINE OFFLINE ora.cssd ora.cssd.type
- [What is the location of alert.log file in Oracle Database 11g?](https://oraclesolutions.pk/location-alert-log-file-oracle-database-11g/) - What is the location of alert.log file in Oracle Database 11g? SQL> select value from v$parameter where name='background_dump_dest'; VALUE -------------------------------------------------------------------------------- /u0/app/oracle/diag/rdbms/orcl/orcl/trace $ cd /u0/app/oracle/diag/rdbms/orcl/orcl/trace $ ls alert_orcl.log orcl_j001_25686.trm orcl_ora_20641.trc or in SQL *PLUS SQL> show parameter background_dump_dest; To find the location of the diagnostic_dest, can use the following: SQL> select value from v$parameter where name='diagnostic_dest';
- [ORA-01012: not logged on](https://oraclesolutions.pk/ora-01012-not-logged/) - ERROR sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 24 12:32:12 2013 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Connected. SQL> select status from v$instance; select status
- [could not validate asmsnmp password due to following errorora-01031:insufficent privileges](https://oraclesolutions.pk/not-validate-asmsnmp-password-due-following-errorora-01031insufficent-privileges/) - ERROR During Create new database, It shows following errors “could not validate asmsnmp password due to following error ora-01031:insufficent privileges” SOLUTION Step 1. Create Password file for ASM Instance $orapwd file=/u0/app/11.2.0/grid/dbs/orapw+ASM password=anypassword Step 2. $sqlplus / as sysasm SQL>create user asmsnmp identified by password; SQL>grant sysdba to asmsnmp;
- [Enterprise Manager DB Control/DB Console (OEM) is not working after Changing Hostname or IP Address](https://oraclesolutions.pk/enterprise-manager-db-controldb-console-oem-not-working-changing-hostname-ip-address/) - ERROR Enterprise Manager DB Control/DB Console (OEM) is not working after Changing Hostname or IP Address SOLUTION Step 1. Set $ORACLE_HOSTNAME to the old hostname export ORACLE_HOSTNAME=old_name Step 2. De-configure the old DB Console by running the following command: $ORACLE_HOME/bin/emca -deconfig dbcontrol db Step 3. $ORACLE_HOSTNAME to the new hostname: export ORACLE_HOSTNAME=new_name Step 4. Configure the new
- [ORA-39700: database must be opened with upgrade option](https://oraclesolutions.pk/ora-39700-database-must-be-opened-with-upgrade-option/) - ERROR ORA-39700: database must be opened with upgrade option SOLUTION Step 1: Open with Upgrade Option SQL> startup upgrade; Step 2: upgrade database - it means run script $ORACLE_HOME/rdbms/admin/catupgrd.sql SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/catupgrd.sql; Step 3: Shutdown database and Startup SQL> shutdown immediate; SQL> startup; Step 4: Run script $ORACLE_HOME/rdbms/admin/utlrp.sql - for recompile all invalid PL/SQL packages SQL>
- [EBS 12.1 and 12.2 certified on IBM AIX 7.2](https://oraclesolutions.pk/ebs-12-1-12-2-certified-ibm-aix-7-2/) - EBS 12.1 and 12.2 certified on IBM AIX 7.2 By: John Abraham | Director I am pleased to announce that Oracle E-Business Suite Releases 12.1.3 and 12.2.3 (and later updates to those respective releases) are now certified on AIX 7.2, the latest operating system for the IBM AIX on Power Systems (64-bit) platform. Installations of E-Business Suite on these operating systems require specific patches to the
- [Friday Spotlight: Migrate Virtual Machines from VMware to Oracle VM](https://oraclesolutions.pk/friday-spotlight-migrate-virtual-machines-vmware-oracle-vm/) - Friday Spotlight: Migrate Virtual Machines from VMware to Oracle VM By: Simon Coter | Director of Product Management We are very pleased to announce a new whitepaper and tool that help customers migrate virtual machines from VMware to Oracle VM. More and more customers would like to move away from the high cost and proprietary
- [Autoconfig Error after clone in 12.1.3 Instance](https://oraclesolutions.pk/unable-view-new-responsibilities-added-user/) - ERROR Running autoconfig on a cloned instance , the below mentioned error occurred: PL/SQL procedure successfully completed. declare * ERROR at line 1: ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated ORA-06512: at line 32 Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
- [Quarterly EBS Upgrade Recommendations: May 2017 Edition](https://oraclesolutions.pk/quarterly-ebs-upgrade-recommendations-may-2017-edition/) - Quarterly EBS Upgrade Recommendations: May 2017 Edition By: Steven Chan| Senior Director We've previously provided advice on the general priorities for applying EBS updates and creating a comprehensive maintenance strategy. Here are our latest upgrade recommendations for E-Business Suite updates and technology stack components. These quarterly recommendations are based upon the latest updates to Oracle's
- [ERROR While starting OACORE services in R12](https://oraclesolutions.pk/error-starting-oacore-services-r12/) - ERROR ERROR While starting OACORE services in R12 In EBS R12, some Application services does not stopped correctly. So when we start oacore services again it will fail with error code Error:
- [R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 - ORA-29874](https://oraclesolutions.pk/r12-autoconfig-failed-jtfictx-sh-inste8_prf-1-ora-29874-warning-execution-odciindexalter-routine/) - ERROR R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 - ORA-29874: warning in the execution of ODCIINDEXALTER routine Autoconfig completed with errors. ============= DECLARE ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-11422: linguistic initialization failed DRG-11446: supplied knowledge base file /u01/apps/VIS/db/tech_st/11.2.0/ctx/data/enlx/droldUS.dat not installed ORA-06512: at
- [R12: Rapid Cloning Issue : ouicli.pl INSTE8_APPLY 255](https://oraclesolutions.pk/r12-rapid-cloning-issue-ouicli-pl-inste8_apply-255/) - ERROR R12: Rapid Cloning Issue : ouicli.pl INSTE8_APPLY 255 Below are log file contents: =============================================== script returned: **************************************************** .end std out. Perl lib version (v5.8.8) doesn't match executable version (v5.10.0) at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/Config.pm line 46. Compilation failed in require at /u01/apps/VIS/db/tech_st/11.2.0/appsutil/clone/ouicli.pl line 35. BEGIN failed--compilation aborted at /u01/apps/VIS/db/tech_st/11.2.0/appsutil/clone/ouicli.pl line 35. .end err out. **************************************************** Executing script
- [Receipt Workbench Error: Applying Receipt Generates Workflow Notification With Error - Local Event Error: oracle.apps.ar.applications.cashapp.apply](https://oraclesolutions.pk/receipt-workbench-error-applying-receipt-generates-workflow-notification-error-local-event-error-oracle-apps-ar-applications-cashapp-apply/) - ERROR Receipt Workbench Error: Applying Receipt Generates Workflow Notification With Error - Local Event Error: oracle.apps.ar.applications.cashapp.apply On : 12.1.1 version, Receipts Related When attempting to apply a receipt, a notification is generated with the following error: Local Event ERROR : oracle.apps.ar.applications.CashApp.apply Event Error Message: No Event Subscriptions exist for this Event The issue can be
- [There is already an ACTIVE ADOP CYCLE with session id : SP2-0640: Not connected](https://oraclesolutions.pk/there-is-already-an-active-adop-cycle-with-session-id-sp2-0640-not-connected/) - ERROR The below failure while executing : Running perl /u01/apps/oracle/fs2/prodapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/apps/oracle/inst/fs2/inst/apps/PROD_U01ORACLEapp01/appl/admin/PROD_U01ORACLEapp01.xml -servername=AdminServer -promptmsg=hide The Oracle WebLogic Administration Server is up. There is already an ACTIVE ADOP CYCLE with session id : SP2-0640: Not connected adpreclone cannot be run with pending ADOP session. SOLUTION While An active ADOP session , If any cloning
- [ORA-04030: out of process memory when trying to allocate 4088 bytes while ADOP in 12.2.3](https://oraclesolutions.pk/ora-04030-process-memory-trying-allocate-4088-bytes-adop-12-2-3/) - ERROR ORA-04030: out of process memory when trying to allocate 4088 bytes while ADOP in 12.2.3 SOLUTION Restart of the adworker fixed the issue. OR Change the page count to 200000 at the OS level: $ more /proc/sys/vm/max_map_count $ sysctl -w vm.max_map_count=200000 OR Adjust the realfree heap pagesize within the database by setting the following parameters
- [Autoconfig fails with IO Error: The Network Adapter could not establish the connection](https://oraclesolutions.pk/autoconfig-fails-io-error-network-adapter-not-establish-connection/) - ERROR --------------------------------------------------------------- ADX Database Utility --------------------------------------------------------------- getConnectionUsingAppsJDBCConnector() --> APPS_JDBC_URL='null' Trying to get connection using SID based connect descriptor getConnection() --> sDbHost : db sDbDomain : www.erp.com sDbPort : 1521 sDbSid : VIS sDbUser : APPS Trying to connect using SID... getConnectionUsingSID() --> JDBC URL: jdbc:oracle:thin:@pmvtest.evosysglobal.com:1521:PMVTEST Exception occurred:
- [libXtst.so.6: cannot open shared object file: No such file or directory](https://oraclesolutions.pk/libxtst-6-cannot-open-shared-object-file-no-file-directory/) - ERROR While executing rapidwiz for E-Business Suite for Release 12.2.0 installation, facing an error related to jre file: libXtst.so.6: cannot open shared object file: No such file or directory SOLUTION Installed the below packages: xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm binutils-2.17.50.0.6-6.0.1.el5.i386.rpm Recreate the Link below by ROOT user: # unlink /usr/lib/libXtst.so.6 # ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
- [APP-FND-00002: Password must contain at least one letter and at least one number](https://oraclesolutions.pk/app-fnd-00002-password-must-contain-at-least-one-letter-and-at-least-one-number/) - ERROR APP-FND-00002: Password must contain at least one letter and at least one number Workaround to fix while giving weak passwords to application users when changing using FNDCPASS FNDCPASS apps/apps123 0 Y system/manager USER SYSADMIN sysadmin Log filename : L9935689.log Report filename : O8833563.out cat L9935689.log +---------------------------------------------------------------------------+ Application Object Library: Version : 12.0.0 Copyright (c)
- [Unable To Create New Legal Entities - ORA-06512](https://oraclesolutions.pk/unable-to-create-new-legal-entities-ora-06512/) - ERROR Unable To Create New Legal Entities - ORA-06512: at "CTXSYS.DRVDML" , ORA-06512: at "HR.DR$HR_LOCATIONS_N1TC SOLUTION Disable the trigger HR.DR$HR_LOCATIONS_N1TC through APPS user. SQL>ALTER TRIGGER HR.DR$HR_LOCATIONS_N1TC DISABLE; Reference Note: Doc ID 1516486.1)
- [Real Application Cluster(RAC) Interview Questions Part 6](https://oraclesolutions.pk/real-application-clusterrac-interview-questions-part-6/) - 1.What is Partition Pruning ? Oracle optimizes SQL statements to mark the partitions or subpartitions that need to be accessed and eliminates (prunes) unnecessary partitions or subpartitions from access by those SQL statements. In other words, partition pruning is the skipping of unnecessary index and data partitions or subpartitions in a query. 2.What
- [Real Application Cluster(RAC) Interview Questions Part 5](https://oraclesolutions.pk/real-application-clusterrac-interview-questions-part-5/) - 1.What is a diskgroup in ASM? A disk group consists of multiple disks and is the fundamental object that ASM manages. Each disk group contains the metadata that is required for the management of space in the disk group. The ASM instance manages the metadata about the files in a Disk Group in the same
- [Unable to determine SMTP server to use: set FND_SMTP_HOST](https://oraclesolutions.pk/unable-to-determine-smtp-server-to-use-set-fnd_smtp_host/) - ERROR Unable to determine SMTP server to use: set FND_SMTP_HOST Outpost Processor has encountered the below error. This error can be found in OPP logs: ---------------------------------------- [GC 14000K->8905K(20284K), 0.0074280 secs] ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST at oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66) at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91) at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176) ---------------------------------------- SOLUTION 1. Log into System Administrator responsibility. 2. Navigate
- [Error Occurred While Attempting to Establish an Applications File Server Connection](https://oraclesolutions.pk/error-occurred-attempting-establish-applications-file-server-connection/) - ERROR " An error occurred while attempting to establish an Applications File Server connection. There may be a network configuration problem, or the TNS listener may not be running on " Solutions to Check SOLUTION 1. Is this a Multinode Install or a Single Node Install. - If this is a Multinode Install, you will need
- [Unable To Create New Legal Entities - ORA-06512: at "CTXSYS.DRVDML"](https://oraclesolutions.pk/unable-create-new-legal-entities-ora-06512-ctxsys-drvdml/) - ERROR Unable To Create New Legal Entities - ORA-06512: at "CTXSYS.DRVDML" , ORA-06512: at "HR.DR$HR_LOCATIONS_N1TC SOLUTION Run The Following Query SELECT TRIGGER_NAME, STATUS FROM all_triggers WHERE TABLE_NAME in ('PER_ADDRESSES', 'HR_LOCATIONS_ALL') ORDER BY table_name; If you see triggers with name DR$HR_LOCATIONS_N1TC or DR$PER_ADDRESSES_N4TC please drop these, then see if you can now create the Legal
- [Introduction to Oracle Applications](https://oraclesolutions.pk/introduction-oracle-applications/) - Introduction to Oracle Applications https://youtu.be/tfgOgginolc
- [Real Application Cluster(RAC) Interview Questions Part 4](https://oraclesolutions.pk/real-application-clusterrac-interview-questions-part-4/) - 1.What is dynamic remastering? When will the dynamic remastering happens? Dynamic Remastering is ability to move the ownership of resource from one instance to another instance in RAC. Dynamic Resource remastering is used to implement for resource affinity for increased performance. Resource affinity optimized the system in situation where update transactions are being executed in
- [An Introduction to An ERP](https://oraclesolutions.pk/an-introduction-to-an-erp/) - An Introduction to An ERP https://youtu.be/dOq1TqnYZLQ
- [Real Application Cluster(RAC) Interview Questions Part 3](https://oraclesolutions.pk/real-application-clusterrac-interview-questions-part-3/) - 1.How would to find location of OCR file when CRS is down? If you need to find the location of OCR (Oracle Cluster Registry) but your CRS is down. Look into “ocr.loc” file, location of this file changes depending on the Operating System On Linux: /etc/oracle/ocr.loc On Solaris: /var/opt/oracle/ocr.loc If CRS is UP and Running
- [Oracle AD Controller](https://oraclesolutions.pk/oracle-ad-controller-introduction-and-usage/) - AD Controller is ad utilities used to monitor/ control the workers execution. Running AD controller. Step 1 : Login as Applications Tier user & run the environment file. Environment file is located in APPL_TOP directory. $ cd /prod/ebs/apps/apps_st/appl Or $ cd $APPL_TOP $. ./ APPSebs_example.env Step 2 :
- [Apps DBA Interview Questions Part 5](https://oraclesolutions.pk/apps-dba-interview-questions-part-5/) - 1.What is Online Patching? Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while the system is up and running, and the users are working as normal. 2.Which Oracle E-Business Suite releases Online Patching feature is available? Online patching is used with Oracle E-Business Suite
- [Output Post Processor is Down](https://oraclesolutions.pk/output-post-processor-is-down/) - Output Post Processor is Down with Actual Process is 0 And Target Process is 1 SOLUTION: If you see OPP is Down with Actual Process is 0 And Target Process is 1 then do the following 1. Shutdown concurrent server via command adcmctl.sh under $COMMON_TOP/admin/scripts/ 2. To ensure concurrent manager down; check there is no
- [Database Interview Questions Part 1](https://oraclesolutions.pk/dba-interview-questions-part-1/) - 1.What is BLOB datatype? A BLOB data type is a binary string with a varying length which is used in storing two gigabytes memory. Length should be stated in Bytes for BLOB 2.What is NULL value in Oracle? NULL value represents unknown or missing data. It is used as a place holder or represented
- [Database Interview Questions Part 2](https://oraclesolutions.pk/database-interview-questions-part-2/) - 1.Which Table spaces are created automatically when you create a database? - SYSTEM tablespace is created automatically during database creation. - It will be always online when the database is open. Other Tablespaces include: - SYSAUX tablespace - UNDO tablespace - TEMP tablespace - UNDO & TEMP tablespace are optional when you create a database.
- [Database Interview Questions Part 3](https://oraclesolutions.pk/database-interview-questions-part-3/) - 1.What is a full backup and name some tools you use for full backup? A full backup is a backup of all the control files, data files, and parameter file (SPFILE or PFILE). You must also backup your ORACLE_HOME binaries which are used for cloning. A full backup can be performed when our database runs
- [ORA-20001:FND_CANT_INSERT_USER_ROLE WHEN ATTACHING RESPONSIBILITY TO USER](https://oraclesolutions.pk/ora-20001fnd_cant_insert_user_role-has-been-detected-in-fnd_user_resp_groups_api-insert_assignment/) - ERROR “ORA-20001:FND_CANT_INSERT_USER_ROLE has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT” SOLUTION Run concurrent program “Workflow Directory Services User/Role Validation” After Request completed normal and this, assign the responsibility Now to rectify the error.
- [JAVA.SQL.SQLEXCEPTION: GOT MINUS ONE FROM A READ CALL IN APPLICATION.LOG](https://oraclesolutions.pk/adadmin-multiple-sets-books-not-compatible-multiorg/) - ERROR Check the alerts.log file you will get the below error: ORA-00020: maximum number of processes (200) exceeded ORA-20 errors will not be written to the alert log for the next minute. Please look at trace files to see all the ORA-20 errors. SOLUTION Increase the processes & Session in DataBase alter system set
- [Real Application Cluster(RAC) Interview Questions Part 2](https://oraclesolutions.pk/real-application-clusterrac-interview-questions-part-2/) - 1. What is RAC? RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance failover, media failover features. 2.How is it different from non RAC databases? Cluster is the key component and is a collection of servers operations as one
- [BI Publisher (formerly XML Publisher) Requests Are Failing With Error "OPP Error Oracle.apps.xdo.XDOException: Error Creating Lock File](https://oraclesolutions.pk/bi-publisher-formerly-xml-publisher-requests-are-failing-with-error-opp-error-oracle-apps-xdo-xdoexception-error-creating-lock-file/) - ERROR BI Publisher (formerly XML Publisher) Requests Are Failing With Error "OPP Error Oracle.apps.xdo.XDOException: Error Creating Lock File oracle.apps.xdo.XDOException: Error creating lock file at oracle.apps.xdo.oa.util.FontCacheManager.createLockFile(FontCacheManager.java:363) at oracle.apps.xdo.oa.util.FontCacheManager.getFontFromDB(FontCacheManager.java:412) at oracle.apps.xdo.oa.util.FontCacheManager.getFontFilePath(FontCacheManager.java:221) at oracle.apps.xdo.oa.util.FontHelper.createFontProperties(FontHelper.java:432) at oracle.apps.xdo.oa.util.ConfigHelper.getFontProperties(ConfigHelper.java:166)
- [ORA-07445: EXCEPTION ENCOUNTERED](https://oraclesolutions.pk/ora-07445-exception-encountered-core-dump/) - ERROR While Running Supplier Payment History in Oracle E-Business Suite R12, we are getting following error. Error: ORA-07445: exception encountered: core dump [qopidsa()+480] [SIGSEGV] SOLUTION To fix this in database include the below in initial parameter file and restart the database. _replace_virtual_columns= false
- [ORA-29273: HTTP request failed, ORA-06512: at "SYS.UTL_HTTP"](https://oraclesolutions.pk/ora-29273-http-request-failed/) - ERROR ORA-29273: HTTP request failed, ORA-06512: at “SYS.UTL_HTTP”, ORA-12545: connect failed because target host or object does not exit, ORA_06512: at “APPS.HR_LOCATION_API” SOLUTION Go to System Administrator responsibility Navigate to Profile > System Query the System Profile Option ‘IRC: Geocode Host’ at ‘Site’ Level Update its value to null, and save changes.
- [Real Application Cluster(RAC) Interview Questions Part 1](https://oraclesolutions.pk/real-application-clusterrac-interview-questions-part-1/) - 1.What are the types of Oracle Cluster-Ware process for 10g on Unix/Linux? Cluster Synchronization Services (ocssd) Manages cluster node membership and runs as the oracle user, failure of this process results in Cluster restart. Cluster Ready Services (crsd) The Cluster Ready Services process manages cluster resources (that could be a Database, an Instance, Service, Listener, Virtual
- [COMPILE JSP IN R12](https://oraclesolutions.pk/compile-jsp-in-r12/) - In Linux/Unix cd $FND_TOP/patch/115/bin perl ojspCompile.pl –compile –flush -p 2 In Windows cd %FND_TOP%\patch5\bin perl -x ojspCompile.pl –compile –flush Restart the Apache services or Middleware services. compile individual JSP manually in R12: 1: cd $COMMON_TOP/_pages 2: Delete the class files (xxxxx.class) for the JSP that you want to compile manually. Eg. JSP File xxxxx.jsp Class File: xxxxxx.class
- [Forms Not Launching](https://oraclesolutions.pk/formsnotlaunching/) - LOAD: CLASS ORACLE/APPS/FND/FORMSCLIENT/FORMSLAUNCHER.CLASS NOT FOUND. ERROR Forms not open, see the error message in java console. load: class oracle/apps/fnd/formsClient/FormsLauncher.class not found. java.lang.ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source) at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source) at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Exception: java.lang.ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class SOLUTION Launch
- [adstrtal.sh exits with status 150](https://oraclesolutions.pk/adstrtal-sh-exits-status-150-adformsctl-sh-exiting-with-status-150/) - adstrtal.sh exits with status 150 We may get this error when we start all apps tier services. [oracle@erp scripts]$ ./adstrtal.sh You are running adstrtal.sh version 120.13 Enter the APPS username: apps Enter the APPS password:**** Executing service control script: /d01/oracle/PROD/inst/apps/PROD_erp/admin/scripts/adopmnctl.sh start script returned: **************************************************** You are running adopmnctl.sh version 120.4 Starting Oracle Process Manager (OPMN)
- [RW-50015: ERROR AFTER INSTALLATION](https://oraclesolutions.pk/rw-50015-error-installation/) - ERROR During Installation of Oracle APPS you might face error in validating system configuration on HTTP, loginpage, Help Directory and JSP. All services starts except web server. checking status of OPMN managed processes… Processes in Instance: PROD_www..ebs.com ———————————+——————–+———+——— ias-component | process-type |
- [ORA-00205: ERROR IN IDENTIFYING CONTROL FILE](https://oraclesolutions.pk/ora-00205-error-in-identifying-control-file/) - ERROR Error in Alertlog file: ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Thu Mar 12 10:15:15 2015 alter database mount ORA-00210: cannot open the specified control file ORA-00202: control file: ‘/u01/apps/db/apps_st/data/cntrl03.dbf’ ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory SOLUTION set
- [Database Interview Questions Part 4](https://oraclesolutions.pk/database-interview-questions-part-4/) - 1.Define read-only replication and its uses? Read only replication creates local copy of table data originating from one or more remote master tables. An application can query the data in a read-only table snapshot, but cannot insert, update, or delete rows in the snapshot of the data. USAGE: Can be treated as back ups of
- [How to Install Oracle 12c Database On Linux](https://oraclesolutions.pk/how-to-install-oracle-12c-database-linux/) - Today we will learn how to install Oracle Database Release 12.2.0.1 on Oracle Enterprise Linux(OEL) 6.4 First download the media from below given link: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html For creating a Virtual machine kindly refer to given below link: Creating Virtual Machine in Virtual Box Then, copy the media in OEL Unzip both the folders unzip linuxx64_12201_database.zip Pre-Requisite
- [What is An ERP Software ?????](https://oraclesolutions.pk/what-is-an-erp-software/) - https://www.youtube.com/watch?v=6qys-562kp4

## Pages

- [Home](https://oraclesolutions.pk/) - OracleSolutions.pk shares practical Oracle DBA, Apps DBA, EBS, RAC, Data Guard, Fusion, OCI and middleware guides for real-world IT professionals.
- [User Listing](https://oraclesolutions.pk/user-listing/) - Authors On Oracle Solutions Search By Username Email Display Name Website First Name Last Name Nickname Biographical Info Sort By User ID Username Email Display Name Website Registration Date First Name Last Name Nickname Biographical Info ASC DESC Reset Syed Saad info@oraclesolutions.pk https://SyedSaadAli.com View Profile , Syed Saad Syed Raheel syrara@hotmail.com https://www.linkedin.com/in/syedraheel1980/ View Profile ,
- [Aboutme](https://oraclesolutions.pk/aboutme/) - Syed Saad Hi there! I’m Syed Saad Ali, the Founder of Oracle Solutions . OracleSolutions.pk is not just a blogging website — it’s a mission.A community-powered knowledge-sharing platform built for all Pakistani Oracle experts to share learning through blogging , real-world troubleshooting , best practices , and career growth insights . If you’re a DBA, Oracle Apps
- [Need Assistance](https://oraclesolutions.pk/remote-dba-support/) - 💼 Oracle Solutions Remote Oracle DBA Services 🚀 Our Remote Oracle DBA services are perfect for companies looking to maximize their Oracle databases , E-Business Suite, Oracle Fusion Middleware 📊 without the cost and hassle of hiring full-time employees. ✨ What We Offer: 🕒 Flexible Hourly Basis Support Plans for all Remote Oracle DBA, E-Business Suite Apps DBA
- [Dashboard](https://oraclesolutions.pk/dashboard/) - [wpuf_dashboard]
- [Add Post](https://oraclesolutions.pk/add-post/) - [wpuf_form id=”2825″]
- [Authors](https://oraclesolutions.pk/authors/) - Oracle ACE PRO Award To Syed Saad Ali 2026 Cannot identify any valid application tier nodes in ADOP_VALID_NODES EBS Application Services Failed to Start After Server Crash HTTP Service Issue After Sudden Power Shutdow txkCfgUtlfileDir.pl Error in getUtlFileDir Mode Copy Password File from Primary to Standby ASM Implement SignOn Password Custom Profile Restrict Applications Users
- [Profile](https://oraclesolutions.pk/profile-2/) - [wpuf_profile type="profile" id="2806"]
- [Login](https://oraclesolutions.pk/loginpage/) - Login [wpuf-login]
- [Edit](https://oraclesolutions.pk/edit/) - [wpuf_edit]
- [Contact Me](https://oraclesolutions.pk/contact-me/)
- [Oracle Autonomous Database](https://oraclesolutions.pk/oracleautonomousdatabase/)
- [Oracle Database 19c](https://oraclesolutions.pk/oracle-database-19c/)
- [Account](https://oraclesolutions.pk/account/) - [wpuf_account]
- [Profile](https://oraclesolutions.pk/profile/) - [wpuf_profile type="profile" id="2806"]
- [Oracle Database 11g](https://oraclesolutions.pk/oracle-database-11g/)
- [Subscription](https://oraclesolutions.pk/subscription/) - [wpuf_sub_pack]
- [Checkout](https://oraclesolutions.pk/checkout/)
- [Courses](https://oraclesolutions.pk/courses/)
- [Become a Teacher](https://oraclesolutions.pk/become-a-teacher/)
- [Payment](https://oraclesolutions.pk/payment/) - Please select a gateway for payment
- [Thank You](https://oraclesolutions.pk/thank-you/) - Payment is completeCongratulations, your payment has been completed!
- [Order Received](https://oraclesolutions.pk/order-received/) - Hi, we have received your order. We will validate the order and will take necessary steps to move forward.
- [Password Reset](https://oraclesolutions.pk/lost-password/)
- [Complete Registration](https://oraclesolutions.pk/complete-registration/)
- [FA](https://oraclesolutions.pk/fa/) - Coming Soon..............................
- [GL](https://oraclesolutions.pk/gl/) - Coming Soon..............................
- [Oracle Database 10g](https://oraclesolutions.pk/oracle-database-10g/) - Coming Soon..............................
- [Oracle APPS DBA](https://oraclesolutions.pk/oracle-apps-dba/)
- [Installations/Configurations-Applications](https://oraclesolutions.pk/installationsconfigurations-applications/)
- [Errors/Workarounds12c](https://oraclesolutions.pk/errorsworkarounds12c/)
- [Errors/Workarounds11g](https://oraclesolutions.pk/errorsworkarounds11g/)
- [Oracle Database 12c](https://oraclesolutions.pk/oracle-database-12c/)
- [Installation/Configurations12c](https://oraclesolutions.pk/installationconfigurations11g/)
- [Installation/Configurations11g](https://oraclesolutions.pk/installationconfigurations-2/)
- [Installation/Configurations10g](https://oraclesolutions.pk/installationconfigurations/)
- [Oracle Functional](https://oraclesolutions.pk/oracle-functional/)
- [Scripts](https://oraclesolutions.pk/scripts/)
- [Oracle Database Materials](https://oraclesolutions.pk/oracle-database-materials/)

## Categories

- [Uncategorized](https://oraclesolutions.pk/category/uncategorized/)
- [beginers](https://oraclesolutions.pk/category/beginers/)
- [Oracle APPS DBA](https://oraclesolutions.pk/category/oracle-apps-dba/)
- [Errors/Workarounds-Applications](https://oraclesolutions.pk/category/errorsworkarounds-applications/)
- [Installations/Configurations-Applications](https://oraclesolutions.pk/category/installationsconfigurations-applications/)
- [Database Scripts](https://oraclesolutions.pk/category/database-scripts/)
- [AppsDBA Scripts](https://oraclesolutions.pk/category/appsdba-scripts/)
- [Configurations-CM](https://oraclesolutions.pk/category/configurations-cm/)
- [Errors/Workarounds-CM](https://oraclesolutions.pk/category/errorsworkarounds-cm/)
- [Configurations-GL](https://oraclesolutions.pk/category/configurations-gl/)
- [Errors/Workarounds-GL](https://oraclesolutions.pk/category/errorsworkarounds-gl/)
- [Configurations-FA](https://oraclesolutions.pk/category/configurations-fa/)
- [Errors/Workarounds-FA](https://oraclesolutions.pk/category/errorsworkarounds-fa/)
- [Configurations-AP](https://oraclesolutions.pk/category/configurations-ap/)
- [Errors/Workarounds-AP](https://oraclesolutions.pk/category/errorsworkarounds-ap/)
- [Configurations-AR](https://oraclesolutions.pk/category/configurations-ar/)
- [Errors/Workarounds-AR](https://oraclesolutions.pk/category/errorsworkarounds-ar/)
- [Installation/Configurations12c](https://oraclesolutions.pk/category/installationconfigurations12c/)
- [Errors/Workarounds12c](https://oraclesolutions.pk/category/errorsworkarounds12c/)
- [Installation/Configurations10g](https://oraclesolutions.pk/category/installationconfigurations10g/)
- [Errors/Workarounds10g](https://oraclesolutions.pk/category/errorsworkarounds10g/)
- [Installation/Configurations11g](https://oraclesolutions.pk/category/installationconfigurations11g/)
- [Errors/Workarounds11g](https://oraclesolutions.pk/category/errorsworkarounds11g/)
- [Oracle Functional](https://oraclesolutions.pk/category/oracle-functional/)
- [Interview Questions](https://oraclesolutions.pk/category/interview-questions/)
- [Database Interview Questions](https://oraclesolutions.pk/category/interview-questions/database-interview-questions/)
- [Apps DBA Interview Questions](https://oraclesolutions.pk/category/interview-questions/apps-dba-interview-questions/)
- [ERP Functional Interview Questions](https://oraclesolutions.pk/category/interview-questions/erp-functional-interview-questions/)
- [Oracle Database Material](https://oraclesolutions.pk/category/oracle-database-material/)
- [Scripts](https://oraclesolutions.pk/category/scripts/)
- [APPS DBA](https://oraclesolutions.pk/category/apps-dba/)
- [Real Application Cluster (RAC)](https://oraclesolutions.pk/category/real-application-cluster-rac/)
- [NEWS AND UPDATES](https://oraclesolutions.pk/category/news-from-oracle/) - Here We will share the moments and events by Oracle about their latest Technologies.
- [General Ledger](https://oraclesolutions.pk/category/general-ledger/)
- [Accounts Payables](https://oraclesolutions.pk/category/e-business-suite/accounts-payables/)
- [Cash Management](https://oraclesolutions.pk/category/cash-management/)
- [Accounts Receivables](https://oraclesolutions.pk/category/e-business-suite/accounts-receivables/)
- [Fixed Assets](https://oraclesolutions.pk/category/fixed-assets/)
- [General Ledger Interview Question](https://oraclesolutions.pk/category/general-ledger-interview-question/) - General Ledger Interview Question
- [APPS Technical Interview](https://oraclesolutions.pk/category/apps-technical-interview/) - APPS Technical Interview
- [Fusion Middleware](https://oraclesolutions.pk/category/fusion-middleware/) - Oracl Fusion Middleware Components
- [Oracle Identity Management](https://oraclesolutions.pk/category/fusion-middleware/oracle-identity-management/) - Oracle Identity Management
- [Oracle Weblogic](https://oraclesolutions.pk/category/fusion-middleware/oracle-weblogic/) - Oracle Weblogic
- [Installation/Configurations19c](https://oraclesolutions.pk/category/installation-configurations19c/) - Installation/Configurations19c
- [Errors/Workarounds19c](https://oraclesolutions.pk/category/errors-workarounds19c/) - Errors/Workarounds19c
- [EXADATA](https://oraclesolutions.pk/category/exadata/) - EXADATA
- [ODA](https://oraclesolutions.pk/category/oda/) - Oracle Database Appliance
- [MySql](https://oraclesolutions.pk/category/mysql/) - MYSQL
- [Oracle Access Manager](https://oraclesolutions.pk/category/fusion-middleware/oracle-access-manager/)
- [Oracle Internet Directory](https://oraclesolutions.pk/category/fusion-middleware/oracle-internet-directory/) - Oracle Internet Directory
- [Uncategorised](https://oraclesolutions.pk/category/uncategorised/)
- [E-Business Suite](https://oraclesolutions.pk/category/e-business-suite/) - E-Business Suite
- [Oracle Discrete Manufacturing](https://oraclesolutions.pk/category/e-business-suite/racle-discrete-manufacturing/) - Oracle Discrete Manufacturing
- [APEX](https://oraclesolutions.pk/category/apex/) - APEX
- [ACE Program](https://oraclesolutions.pk/category/ace-program/) - ACE Program

## Tags

- [o](https://oraclesolutions.pk/tag/o/)
- [APPS DBA](https://oraclesolutions.pk/tag/apps-dba/)
- [AppsDBA Scripts](https://oraclesolutions.pk/tag/appsdba-scripts/)
- [Installations/Configurations-Applications](https://oraclesolutions.pk/tag/installations-configurations-applications/)
- [Oracle APPS DBA](https://oraclesolutions.pk/tag/oracle-apps-dba/)
- [Scripts](https://oraclesolutions.pk/tag/scripts/)
- [Datapump Oracle DB](https://oraclesolutions.pk/tag/datapump-oracle-db/)
- [Oracle](https://oraclesolutions.pk/tag/oracle/)
- [Oracle apex](https://oraclesolutions.pk/tag/oracle-apex/)
- [SQL](https://oraclesolutions.pk/tag/sql/)
- [PL/SQL](https://oraclesolutions.pk/tag/pl-sql/)
- [Reports](https://oraclesolutions.pk/tag/reports/)
- [Data](https://oraclesolutions.pk/tag/data/)
- [Performace](https://oraclesolutions.pk/tag/performace/)
- [Optimization](https://oraclesolutions.pk/tag/optimization/)
- [Techniques](https://oraclesolutions.pk/tag/techniques/)
- [apex](https://oraclesolutions.pk/tag/apex/)
- [session state](https://oraclesolutions.pk/tag/session-state/)
- [paeg items](https://oraclesolutions.pk/tag/paeg-items/)
- [global items](https://oraclesolutions.pk/tag/global-items/)
- [application items](https://oraclesolutions.pk/tag/application-items/)
- [oracleace](https://oraclesolutions.pk/tag/oracleace/)

## Media Categories

- [12.2.0 Installation](https://oraclesolutions.pk/media_category/12-2-0-installation/)
- [VirtualBoxInstallation](https://oraclesolutions.pk/media_category/virtualboxinstallation/)
- [11g Installation](https://oraclesolutions.pk/media_category/11g-installation/)
- [12c Installation](https://oraclesolutions.pk/media_category/12c-installation/)
- [POST_MAY2023](https://oraclesolutions.pk/media_category/post_may2023/)
- [12.2.12](https://oraclesolutions.pk/media_category/12-2-12/)
- [12.2.12-Part1](https://oraclesolutions.pk/media_category/12-2-12-part1/) - 12.2.12-Part1
- [12.2.12-Part3](https://oraclesolutions.pk/media_category/12-2-12-part3/) - 12.2.12-Part3
- [Oracle_Internet_Directory](https://oraclesolutions.pk/media_category/oracle_internet_directory/) - Oracle_Internet_Directory
- [Oracle Access Manager](https://oraclesolutions.pk/media_category/oracle-access-manager/)
- [Banners](https://oraclesolutions.pk/media_category/banners/) - Banners