Blog / Category
EBS
210 articles in this category
WIP Job Close via Apex Application
Introduction / Issue Closing a WIP job in EBS normally means going through the Discrete Jobs form manually — checking if all transactions are done, confirming t…
Oracle EBS OAF vs Forms Personalization
Oracle EBS OAF Personalization vs Forms Personalization – Understanding the Difference Introduction Oracle E-Business Suite (EBS) provides multiple ways to cust…
API to create party and link to the Supplier
Introduction / Issue As part of TCA, the supplier needs to be linked to the party. This API establishes the link between the Party and the Supplier. Why We Need…
Managing REST Service Activities in Oracle E-Business Suite Using Ant Scripts
Introduction Oracle E-Business Suite (EBS) provides the Integrated SOA Gateway (ISG) to expose business logic as REST and SOAP web services. As organizations pr…
ADOP Prepare Phase Failure
Issue Summary While executing the ADOP Prepare phase in Oracle E-Business Suite, the process fails because the Internal Concurrent Manager (ICM) status cannot b…
EBS on OCI vs EBS On-Prem: What Actually Changes for an Apps DBA
Introduction: Migrating Oracle E-Business Suite from on-prem to OCI is often sold as a lift and shift and technically, a lot of it is. The application code, pat…
Resolving PDB PLUG IN VIOLATION Wallet Key Needed Error When Opening Encrypted PDB
Introduction When attempting to open a plugged-in pluggable database (PDB) that contains encrypted tablespaces, the following error is raised: “TEST(5):ALTER PL…
ORA-01000: Maximum Open Cursors Exceeded – Causes and Solutions
Introduction ORA-01000: maximum open cursors exceeded is a common Oracle Database error encountered when a session opens more cursors than allowed by the OPEN_C…
ORA-04021: Timeout Occurred While Waiting to Lock Object – How to Find the Blocker
Introduction ORA-04021: timeout occurred while waiting to lock object occurs when Oracle tries to get a lock on an object, but another session is already using…
Creating a BOM Item in Oracle apps R12
Creating a BOM Item Creating a Bill of Materials (BOM) item in Oracle Apps R12 involves defining the parent assembly and its components within the Bills of Mate…
API to create Quality samples and the results
Introduction/ Issue: This blog contains an API and that can be used in Oracle EBS to create Quality samples and the corresponding results. Why we need to do / C…
Why OACORE Slows Down: A JVM Health Monitoring Guide for EBS 12.2
1. Background & Architecture Context In Oracle E-Business Suite 12.2, OACORE is the primary Java container responsible for handling: OA Framework pages Forms se…
Installing Oracle E-Business Suite Integrated SOA Gateway
Descripton: Configuring Oracle E-Business Suite REST Services on Oracle Cloud Infrastructure. Steps: 1.EBS version: Must be Oracle E-Business Suite Release 12.2…
Unable to Launch the Application: JAR Resources in JNLP File Are Not Signed by the Same Certificate
Description: Getting the Error when try to open R12.2 application form Cause: There are cached expired certificates or JAR files from an earlier version. Soluti…
Oracle EBS Patching Cycle — “Prepare” Phase Stuck
Issue: During an Oracle E-Business Suite (EBS) patching cycle, the Prepare phase was observed to be stuck and not progressing further. The process continued to…
AutoConfig Failure Due to Custom Template Version Mismatch
Introduction: During an adop apply cycle in an Oracle E-Business Suite (R12.2) environment, the patching process failed during the AutoConfig phase on the appli…
Managing Security Grants to User Using an Ant Script
Introduction This document describes the procedure for managing Security Grants in Oracle E-Business Suite (EBS) using the Ant utility. It outlines the automate…
Managing REST Service Activities Using an Ant Script
Introduction This document outlines the procedure for managing REST service configurations in Oracle E-Business Suite (EBS) using the Ant utility. It details th…
ECC Menu Configuration Fix for Data Set Authorization Errors
Introduction: While accessing Oracle E-Business Suite Embedded Command Center (ECC), users may encounter the error “400 Bad Request: Current user not authorized…
Resolving JVM Startup Failures in Tomcat: Invalid Heap Size and Unsupported Class Version Errors
Introduction: Java-based middleware components such as Apache Tomcat and ORDS are highly dependent on correct JVM configuration. Misalignment between Java versi…
Standardizing Custom Table Development for Oracle EBS R12.2 Online Patching
With the transition to Oracle E-Business Suite (EBS) R12.2, the technical landscape for customizations shifted significantly. The introduction of Online Patchin…
Pre-requisite for the Sales Orders purging
Introduction In the oracle EBS the concept of Purging and before purging the order management related tables, pre-requisite to be done for the smooth purging pr…
OPM Uncompleted batches query
Introduction/ Issue: This SQL query is designed to extract Batch Header and Material Details from Oracle Process Manufacturing (OPM). It consolidates informatio…
Configuring Work Orders to Align with Resource Requirements in Fusion Supply Chain Planning
Issue: The Work Orders for a specific item loaded from EBS into Fusion Supply Chain Planning are appearing in the Buyer Material Plan within the supply plan. Ho…
Troubleshooting EBS 12.2 adcfgclone Failure: JAVA_HOME Issue in commEnv.sh
EBS 12.2 Cloning Issue – adcfgclone Fails Due to Incorrect JAVA_HOME in commEnv.sh Background During one of my Oracle E-Business Suite (EBS) 12.2 cloning activi…
Oracle Table Partitioning Strategies
Managing Partitions in Oracle Database – A Complete Guide for DBAs Partitioning in Oracle Database offers a powerful way to improve performance, manageability,…
Item Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based…
Procedure to create Quality Spec INV Validity Rule in OPM through API
Introduction: This blog has PLSQL query that can be used to create Quality Spec INV Validity Rule using oracle seeded API. Cause of the iss…
The Oracle Migration Challenge – Datatype Conversion Nightmares
When Database Migrations Go Wrong: Snowflake to Oracle Every database migration project starts with optimism: “We’ve mapped the tables, the data looks similar –…
Invalid APPS Database User Credentials in txkPostPDBCreationTasks After PDB Creation in Oracle EBS 12.2
Introduction: When performing a Post-PDB Creation Task in Oracle EBS 12.2, you may encounter the following error while running the txkPostPDBCreationTasks.pl sc…
Oracle EBS Front-End Inaccessible After AD-TXK Delta 15 Upgrade Fixed by Updating Mod-security Rules
Introduction: After upgrading our Oracle E-Business Suite environment to AD-TXK Delta 15, we encountered a front-end access issue the application URLs were not…
Resolving the “Missing PATCH FS CONTEXT FILE” Error in FND_OAM_CONTEXT_FILES
When running the ADOP fs_clone command during an Oracle E‑Business Suite patch upgrade, you might encounter an error related to a missing PATCH FS CONTEXT FILE…
What New In ECCV9?
Getting Smart with Your Business Data: Inside Oracle EBS Enterprise Command Centers (ECC) V9 In Oracle E-Business Suite (EBS), it can be tough to quickly unders…
Diagnosing oacore stuck thread Issues in Oracle EBS 12.2
Overview: In Oracle EBS 12.2 environments, it’s not uncommon to face login failures or form loading issues. These are often caused by oacore server anomalies in…
Not able to submit the Print statement in AR
Issue :- Not able to submit the Print statement in AR Cause of the issue: Statement Periods are not defined for the New Year. How do we solve: We need to defin…
Need to delete the incorrect receipt entry from Account receivables
Introduction/ Issue: Need to delete the incorrect receipt entry from Account receivables User has mistakenly made Receipt entry by selecting wrong customer now…
Update the Project Status using API
Introduction: This blog has the SQL Script to update the Project Status using API along with each task. Cause of the issue: To update status of the proje…
Oracle PLSQL to Generate XML Tag Using Standard Functionality
declare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true…
Oracle R12 SQL Query – Price List or Fee Schedule for Customer
select HP.PARTY_NAME “Customer Name”,HCAA.ACCOUNT_NUMBER,HCAA.ACCOUNT_NAME,qph.name “Price List Name”,HCSUA.SITE_USE_CODE,HCSUA.LOCATION from qp_list_headers qp…
Purchase Invoice GL to AP Drill down for Account Analysis Reconciliation
Introduction: This document outlines how to reconcile Oracle General Ledger (GL) and Oracle Payables (AP) for Purchase Invoice analysis by using a specific SQL…
AP: Create Accounting Completed In Warning with Offsets Error
Issue Overview: The error “The accounting program cannot create this journal line because the debit or credit that offsets it cannot be found” occurs when attem…
Delete the concurrent programs
Delete the concurrent programs Prerequisites: If the concurrent program is not in use, the program details need to be entered in the lookup and then this concur…
Multi-Node EBS with DMZ Setup
Many of you have asked about the best storage options for a multi-node EBS setup involving a DMZ server with a public load balancer. Here are some insights and…
Resolving ORA-20001: Synonym Does Not Point to an Editioning View in ADOP Phase of Oracle EBS
Introduction During the ADOP (Online Patching) process of Oracle E-Business Suite (EBS), you might encounter the following error message while running Autoconfi…
Resolving Port Conflicts During ADOP Validation in Oracle E-Business Suite
Introduction: The ADOP (Autonomous Database Operations) process is a crucial component of the Oracle E-Business Suite (EBS) used during patching, cloning, and u…
oacore_server1- failed to startup with javax.naming.NameNotFoundException Error
DESCRIPTION: Getting oacore_server1- failed to startup Error when starting EBS R12.2.5 after clone. CAUSES: oaea_server1 is not registered in cloned Weblogic co…
Removing node name in EBS R12.2
DESCRIPTION: After EBS Test Clone EBS Prod URL Redirecting to EBS Test URL. CAUSES: EBSTEST Node Name is Added into EBS PROD’s Node table. SOLUTION: Remove the…
View Output/Log returns “Authentication Failed/File server could not identify source file ” error Concurrent Program – R12.1.3
In Oracle E-Business Suite R12.1.3, when you try to view a report output/log, the following two errors are displayed: File server could not identify source file…
Concurrent Program Failure with Error “FDPSTP failed due to ORA-20100”
User Submitted concurrent Program “XXFM TBI DEBIT CONTROL” in DEV environment after Clone. Program failure happening with Below Error. Oracle Database 19…
Shipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; x_return_statu…
Ship Confirm of multiple deliveries Using API in EBS
PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2) IS –Standard Parameters. p_api_vers…
Orcale EBS-Query to get active users along with their active responsibilities
LIST OF ALL ACTIVE USERS ALONG WITH THEIR ACTIVE RESPONSIBILITIES Introduction: This query is used to get all active users along with their active responsibilit…
Oracle EBS-Query to get Service Contract Details
Query to get the Service Contract Details Introduction: This query is used to fetch the service contract details.In this we will be passing contract_numb…
Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group
Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and re…
PO SHIPMENT LINE UPDATE USING API
PO SHIPMENT LINE UPDATE USING API Objective: The purpose of this document is to provide a comprehensive guide on how to update or split Purchase Order (PO) ship…
Delete ITEM Category in EBS using API
Delete ITEM Category in EBS using API. Introduction: To delete an Item Category in Oracle E-Business Suite (EBS) using an API, you’ll typically interact with an…
Managing EBS Concurrent Processing and Cleaning concurrent processing tables
Managing Oracle E-Business Suite Concurrent Processing and Cleaning concurrent processing tables Introduction: Oracle E-Business Suite (EBS) is a comprehensive…
Transitioning from Screen to tmux on Linux 8
Introduction In the demanding environment of database administration, managing multiple tasks efficiently is vital. For Oracle DBAs working on Linux systems, tm…
Unable to apply the receipts getting Error ACC DATE NOT IN OPEN PD
Unable to apply the receipts getting Error ACC DATE NOT IN OPEN PD Error message:- This error appears when Accounting Periods are not open in Payables Please ma…
Delete icon Grayed out in AR Transaction
delete-icon-grayed-out Delete Button Does Not Appears On Transaction Page And Not Able To Delete An Invoice In Receivables STEPS ———————– The issue can be repro…
Preventive Maintenace Work Order
Breakdown Maintenance A.1 N> Enterprise Asset Management > Work Order Sub Menu > Work Order Definition >Open A.2 Click NEW for creation of New work order…
R12 Oracle General Ledger Setup
r12-oracle-general-ledger-setup
Country wise Catalog and Non Catalog Po’s in Oracle EBS
Introduction:- Using the below SQL script we can get the Catalog and Non Catalog Po’s details from country wise. Code:- SELECT P.SEGMENT1 “PO Number” ,PL.LINE_N…
Oracle Internet Of Things (IoT)
Dear Readers I would like to explain more about the Oracle IoT Cloud services. Will provide continues blogs on this technology. In this block we will explore wh…
Query to Display the Concurrent Program’s which has are modified at XML Data_Defination_level or LOB’level
Introduction: This query is used to fetch the list of concurrent program names which are having the changes at XML Publisher level (Data_Definition or Template…
FNDLOAD command to download and upload LDT file for a Concurrent Program
FNDLOAD command to download and upload LDT file for a Concurrent Program Introduction: It is generally time-consuming process and task to create same setup data…
Auditing in Oracle E-Business Suite
Navigating Auditing in Oracle E-Business Suite: Introduction: Oracle E-Business Suite (EBS) is a powerful enterprise resource planning (ERP) solut…
Active EBS users and their respective responsibilities in Oracle E-Business Suite
Every time a customer or client asks for a list of EBS Users and their responsibilities, the DBA team would generally execute the “Active Users” Concurrent Prog…
Enhancing Log and Output File Management in Oracle E-Business Suite 12.2
Introduction: Effectively managing large log and output files is crucial for maintaining optimal performance in Oracle E-Business Suite 12.2. Despite the availa…
Identify versions of components in EBS
Useful commands to find the versions of various components used in Oracle E-Business Suite Find Apache Version or Oracle Application server version in R12 Log i…
How to Expose Custom PL/SQL API as a REST Webservice?
How to Expose Custom PL/SQL API as a REST Webservice? Oracle E-Business Suite Integrated SOA Gateway (ISG) provides an infrastructure to deploy, consume, and ad…
R12 – Accounting Setup Manager Checklist
r12_setup_check_list Accounting Setup Manager Checklist The following table describes the steps to create accounting setups using Accounting Setup Manager. Each…
Query to fetch Routing Details
Introduction: Routing is a set of operations that will be performed in sequence to manufacture an assembly Item. The below query will give the operation sequenc…
How to overcome ORA-01102: cannot mount database in exclusive mode?
Introduction: While starting the Oracle database in the mount stage was failed (ORA-01102: cannot mount database in exclusive mode) with the below error Error:…
Adop hot patch failed with unexpected Error in EBS 12.2.8
Introduction: This blog is intended for DBA’s who may pass off with the below error message on applying a patch as hot patch in the instance. While applying ado…
WebLogic AdminServer Error-“unable to get file lock, will retry”
Cause: When WebLogic Server Starts,it creates a lock file with .lok extension under $DOMAIN_HOME/server/<Server_Name>/tmp location It cleans .lok file when webl…
CAUSE AND FIX for MISSING RESPONSIBILITIES issue in EBS R12
CAUSE AND FIX for MISSING RESPONSIBILITIES issue in EBS R12 =================================================== 1) Run the Concurrent Program “Workflow Director…
Steps to apply EBS12_2 CPU July 2023 with AD and TXK 14 upgrade
REFERENCES :- ============ Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1) Document 1594274.1, Or…
EBS-R12.2.5:adpreclone.pl Fails with Error Message – Edit session is enabled in domain
Getting ”edit session is enabled error” when running adpreclone.pl command in ebs R12.2.5 Cause: Lock&Edit session is enabled in weblogic console. Solution: Log…
Oracle Service Contract Cycle in Oracle EBS R12
oracle-service-contract-cycle-in-oracle-ebs-r12
Automatic Modifier is Not Applying to Service Contract
automatic-modifier-is-not-applying-to-service-contract
Explore/Explore BOM components for a config item
PROCEDURE xxbom_explode_bom_for_abc(i_item_id IN NUMBER, i_organization_id number, i_num_so_line_id number) IS g_chr_excp_msg VARCHAR2(4000); g_chr_log_msg VARC…
Transfer file from PL SQL to third party system using java concurrent program
Transfer the CLOB variable to third party system using https protocol and java concurrent program. package xxpo.ebs; import java.io.IOException; import oracle.a…
Sales Daily Pick Report
1.Overview This document talks about getting the sales daily stock pick report in oracle apps r12 2.Technologies and Tools Used The following technologies have…
TXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin Th…
Adop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found
AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome th…
Oacore & Forms Servers Are Stuck at ADMIN State in EBS R12.2.5
Not able to bring up oacore and forms managed servers after clone. These managed servers are stuck at ADMIN state while trying to start the services. CAUSE: Cre…
adcfgclone.pl error :RC-50014: Fatal: Execution of AutoConfig was failed in R12
While R12.2.5 cloning autoconfig failed with the below error AutoConfig is exiting with status 1 ERROR: RC-50014: Fatal: Execution of AutoConfig was failed Rais…
SYS and SYSTEM Password no longer needed in E-Business Suite
Introduction: R12.2 is being modernized with many new functionalities and changes in architecture. We, as a DBA, rely on SYS and SYSTEM passwords for any activi…
Triage E-business Suite Performance tuning
Performance issues in the application are the most common thing in every organization, almost in every product. Oracle performance issues are prevalent in E-bus…
Resolving autoconfig issue with patch file system “adgendbc.sh INSTE8_SETUP”
Problem: In the execution of autoconfig in the patch file system. we faced the following error. [SETUP PHASE] AutoConfig could not successfully execute the foll…
12.2 E-Business Suite FS_CLONE / ADPRECLONE.PL Fails With Error ‘CLONE-20435 Some of the Oracle Homes are excluded during copy operation’
ERROR: SEVERE : Sep 8, 2021 16:51:36 – ERROR – CLONE-20435 Some of the Oracle Homes are excluded during copy operation. SEVERE : Sep 8, 2021 16:51:36 – CAUSE –…
AP Invoice To GL Link Query with additional attribute values
This query to Trace an AP Invoice to the GL. There is an Invoice in AP which is correctly Validated, Accounted, Approved etc. This will useful To find the GL He…
AP Bank details query with additional attributes values
The supplier (or External) bank account information are stored in the table called ce_bank_accounts. The bank and bank branches information are stored in CE_BAN…
Workflow Script Deassign user from role
Oracle Workflow delivers a complete workflow management system that supports business process based integration. Its technology enables modeling, automation, an…
GL Flexi ield Query with additional details
GL module used to maintain credit and Debit details in oracle. Gl code combinations are used maintain details of company with respect to legal entity level. Thi…
Item Ranging – Oracle Retail Merchandising System Module
Item Maintenance RMS is responsible for the creation and maintenance of all items. RMS uses a flexible data hierarchy for an item, with levels that allow…
AP PO Vendor Creation interface with additional attributes
Payables modules are used to create supplier related information in oracle. In this module we can create supplier invoice bank etc will be maintained. This scri…
Inventory Lot Creation Interface
Inventory module used to create items in oracle. This module will link with AP, PO, GL modules. In inventory we have lot concepts where we will create lots , so…
Employee As Supplier creation -page error
Employee as Supplier creation page error-Alternative Solution proposed Follow this process for first time creation for employee as supplier Enter expense report…
Auto Reversal Journal Setup
Auto reversal in oracle means , We will create some rules and setups for some GL journal source which will automatically reverses the GL journals for that Sourc…
Setup a new store in Oracle RMS
To Setup a new store in RMS follow the steps given below Step 1: First open the browser and type the given URL: http://shk-oratestapp02.hk.oracle.se:7783/Retail…
Data Migration and Conversion Strategy
Data migrations generally result from the introduction of a new system. This may involve an application migration or consolidation in which one or more legacy s…
How to Change the Default Request Group in E-Business Suite Support Analyzer Bundle Menu
It is possible to change the default request group for a given Analyzer at the individual analyzer level. 1.Start the menu with “perl Menu.pl” 2,Select a Produc…
ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError – ecx_utils.INITIALIZE
When trying to submit one of GL report end with error. The error message shows ORA-29532: Java call terminated by uncaught Java exception. select * from *******…
FNDLOAD SYSNTAX FOR ALL APPLICATION OBJECTS IN EBS R12.2
Description: Following steps are used to upload the application objects using FNDLOAD. FNDLOAD Syntax These are the extensive list which can be done through FND…
FORMS COMPILATION IN EBS R12
Description: Following steps are used to compile the forms in EBS R.12. Steps: Step 1: Login to application user in application server through winscp and go to…
perl adcfgclone.pl appsTier dualfs ERRORS and SOLUTION
1) perl adcfgclone.pl appsTier dualfs ERRORS and SOLUTION ============================================ ERROR 1 ========= StackTrace: java.lang.Exception: oracle…
Query To Check Concurrent Program Run History in EBS
The following query will help you to find the history of concurrent programs run in your EBS environment. You should connect to ‘apps’ user for executing this q…
Hold Pending Concurrent Requests and release them
Here is an easy way to put all the Pending Concurrent requests in hold, if we are going through any situation(Mostly any Production Cutover/Go live scenarios).…
Oracle R12 Query To Find Customer Notes
SELECT hca.account_number, ( SELECT hp.party_name FROM apps.hz_parties hp WHERE hp.party_id = hca.party_id ) customer_name, jnb.creation_date notes_creation_dat…
Oracle R12 GL To AR Transaction Details
SELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account…
Oracle R12 AR Lockbox Query
SELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch…
Oracle SQL Query To Find Square Root For A Number
Syntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5
Oracle SQL Query To Find Power Of A Number
Syntax: POWER(<base number>, <exponent number>) Query: select POWER(3,3) from dual; Output: This function return base number raised to the exponent’s power. 27
Oracle SQL Query To Return Negative Numbers Within Bracket
Syntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>
Collecting OSWatcher Logs for a Particular Period of Time
1. As <ROOT_USER>, log in to Node 1 and cd to the “/tmp” directory. # cd /tmp 2. Use “vi” or editor of your choice, to create the “osw_capture” script as shown…
ADOP STATUS – FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] Solution.
Problem : [ebsprd@myebstes01 ~]$ adop -status Enter the APPS password: *******FATAL ERROR******* PROGRAM : (/u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl…
ADOP Status – Error FUNCTION: ADOP::GlobalVars::_ValidateArgs [ Level 1 ] – Solution
ADOP Status – Error FUNCTION: ADOP::GlobalVars::_ValidateArgs [ Level 1 ] – Solution Problem: [ebsprd@myebstes01 ~]$ adop status *******FATAL ERROR******* PROGR…
Gather Schema Statistics fails with ORA-20005
Gather Schema Statistics fails with “ORA-20005: Object Statistics Are Locked (Stattype = ALL)” Log file shows the following error, ORACLE error 20005 in FDPSTP…
How to disable field based on parameter value
By using following script we can get parameter value in page level. Based on value we can set rendered property for the fields as follows: public void processRe…
How to terminate instance number in Install Base
Using below script we can terminate instance number in Install Base. UPDATE csi_item_instances SET active_end_date = SYSDATE WHERE instance_id = l_instance_id;
Java script validation in OAF
By using below java script in OAF. we can validate based on field value and can throw error. var colspt2 = ‘quoteValidate’.split(\”^\”); for (var k = 0; k < col…
In EBS R12.2 ‘adop phase=fs_clone’ session may appear to hang (or) Following Exception thrown “Thread-1” java.lang.OutOfMemoryError: Java heap space (or) Fails with “[UNEXPECTED]Error running adadminsrvctl command.
CAUSE: The issue is caused by lack of Java heap resources to run the process. SOLUTION: To implement the solution, please execute the following steps: 1. Issue…
How to fix INVALID status for RAC component in dba_registry
Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below . SQL> select comp_nam…
Shell script to check and test printer.
Description Below script is used to check the printer, IP status and testing the printer. Script : #!/bin/bash con() { if [ $choice -eq 1 ] then echo “Give ip a…
Calendar creation
Path: General ledger super user > Setup > Financials > Calendars > Types Step 1: Creating calendar type S1: while entering into types it will open automatically…
How to Create the boot.properties in IDCS Asserter
Problem: When you are running the weblogic in production mode and when you try to start the weblogic using nohup then there is no chance to enter the username a…
Working Efficiently with Oracle Support
As an Oracle consultant, there will be many times you will need to raise Oracle support for multiple issues. When there is tight schedule, you will look for qui…
EBS R12.2 Weblogic Managed Servers are crashing frequently
ISSUE ====== EBS R12.2 Weblogic Managed Servers are crashing frequently . Weblogic Managed Servers crashing frequently due to “weblogic.socket.MaxMessageSizeExc…
Output Post Processor (FNDOPP) is not Staring
The Output Post Processor (FNDOPP) Manager is not starting, process status is shown as Actual with 0 and the Target is 1 The OPP logfile shows the following exc…
Setting A Discoverer Preference At A User Level
For Discoverer 10g: 1. On the Discoverer 10g Server machine, please set the environment variables by running the following script, . ./$OH/discoverer/discwb.sh…
Period Opening
Open and close accounting periods to control journal entry and journal posting, as well as compute period- and year-end actual and budget account balances for r…
Bank branch creation
Navigation: Accounts payables >> Setup >> Payment >> Bank and Bank Branches Step 1 : once enter into Bank and Bank branches it will open Cash management…
How to Cancel the Request from the backend if frontend not helping to Cancel.
Problem: when we try to cancel a concurrent request using frontend “Cancel Request” button from the Administer > Concurrent > Manager form. We are getting the f…
ADOP ERROR with Following “package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute)”
Problem: [ERROR] Failed to execute SQL statement: select AD_ZD_ADOP.GET_INVALID_NODES() from dual [ERROR] Error Message: [ERROR] ORA-04063: package body “APPS.A…
[Security:090295]caught unexpected exception, No such object in Weblogic Remote managed Server.
Problem: <[Security:090295]caught unexpected exception, No such object> <[Security:090303]Authentication Failed: User weblogic weblogic.security.providers.authe…
Diagnostic test to validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup
This diagnostic test will validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup and do an initial data collection of frequently requested information. 1…
WORKFLOW NOTIFICATION MAILER ISSUE
when emails are struck and not send by workflow notification mailer perform the following. 1) Login into EBS applications and send a “TEST MAILER” to yourself t…
APP-FND-01542: This Applications Server is not authorized to access this database.
By default in Oracle Applications R12, users are not able to access Forms directly via the following url: http://hostname:port/forms/frmservlet The following er…
FRM-92102 Errors when Accessing a Forms Module
When attempting to access E-Business Suite Forms on a cloned E-Business Suite instance the following error occurs: FRM-92102 A network Error has occurred. The F…
Sometimes the Formsapp.ear deployment fails on Application startup after applying Patches
Error while executing the perl script txkChkFormsDeployment.pl We have determined that you need to redeploy Forms (using txkChkFormsDeployment.pl). But could no…
BI Publisher program failed due to opp
Error: “Post-processing of request 4667897 failed at 30-Apr-2021 15:54:50 with the error message: One or more post-processing actions failed. Consult the OPP se…
Step by step Creating a Custom Application top for EBS 12.2 Using AD Splice
Introduction: This post is to guide to Create a Custom Application top for EBS 12.2 Using AD Splice. Steps to create a Custom Application top for EBS 12.2 Using…
How to add FA Locations In Oracle R12
Navigation >> FA responsibility >> assert >> Location add location and Save.
Data Fix -Delete records – Customer Interface Table
Execute the below scripts for Backup Table Step1:- “CREATE TABLE scratch.RA_CUST_INT_INC0054156 as select * from apps.RA_CUSTOMERS_INTERFACE_ALL where org_id =*…
How to Update the Employee Details in Oracle apps R12 ?
Updating the Employee Details/Location/Address Responsibility: HRMS Manager Navigation:Personnel->employees->query with employee last name Step1: Update…
How to add Cross validation Rule In GL ?
Navigation -> GL –> Setup -> Financials -> Flexfields -> Key -> Rules Search Application Names. Query the CVR Name Enter the Code Combination values. Click on S…
How to add security Rules In GL ?
Define Security Rules: Navigation: General Ledger –> Setup –> Financial –> Flexfields –> Key –> Security –> Define. To define security rules: 1. Navigate to Def…
How to give the approval limits by user in AR
How to give the approval limits by user in Increase decrease in AR Navigation :- AR Responsibility >>> Transaction>>> approval limits… mandatory parameters: Use…
HOW TO ADD UNAPPLIED RECEIPTS REASON CODES TO BE ADDED SETUP IN ORACLE APPS
To achieve this we need to follow the below steps: Login with AR SuperUser Navigation: Collections>>Account Details Click on Account Details . One New Window wi…
AP Payment status showing unprocessed in oracle apps
AP Payment status showing unprocessed in oracle apps 1>>> Check account status unprocessed ,it showing period exception reports 2>>> Check invoice…
How to Assign a Concurrent Program to a Responsibility
Suppose you want to run a Program, lets take an example of “Autoinvoice Import Program” from Order Management Super User. Navigate to this responsibility > View…
Account details are not able to see from the customer search window.
The one of the customer record under the IE Operating unit is having some data corruption, the customer account details are not able to see from the customer se…
How to add Chart of account mapping code combinations In GL ?
Navigation :- GL Role >> Accounts >> Chart of Account mapping Choose Mapping name:- Ex IM CZ Local GAAP Mapping click on Account Rules field Click on New and en…
Could not initialize the Service Manager FNDSM__ Verify that has been registered for concurrent processing
Cause The issued was found to have been caused by the FND_NODES table having incorrect node entries (old node from the source instance) and that no Service Mana…
Oracle R12 Customer TaxPayer ID Update API
/*Upload the customer data that needs to be updated in a temp table*/ CREATE TABLE scratch.RITM0669580 (account_number VARCHAR2(30), tax_payer_id VARCHAR2(20),…
Oracle R12 Customer Remittance Email Update API
DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR…
Oracle R12 Customer Site Remittance Email Update API
DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR…
Oracle R12 AP Invoice Extract With PO And CHECK Details
select aia.INVOICE_NUM ,aia.INVOICE_AMOUNT ,aia.CREATION_DATE,aia.INVOICE_DATE,aia.SOURCE,aia.INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE, (select aca.STATUS_LOOKUP_C…
Oracle R12 Expense Type Master Based On Operating Unit
SELECT ( SELECT hou.name FROM apps.hr_operating_units hou WHERE hou.organization_id = aerpa.org_id ) operating_unit, aerpa.prompt expense_type, aerpa.flex_descr…
Oracle R12 Item Master Extract With Other Essential Details
select (select category_concat_segs from apps.mtl_item_categories_v where inventory_item_id = msib.inventory_item_id and organization_id = msib.organization_id…
Oracle R12 GL Code Combination With Segment Description
select SEGMENT1 Company, apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id 1, —– Position of segment segment1 —- Segment va…
Oracle R12 Customer Extract Based On Operating Unit
SELECT TO_CHAR(hca.account_number) account_number, ( SELECT name FROM apps.hr_operating_units hou WHERE hou.organization_id = hcasa.org_id ) organization_name,…
Oracle R12 Supplier Master With All Supplier Details
select (SELECT hou.NAME FROM apps.hr_operating_units hou WHERE 1 = 1 AND hou.organization_id = aps.org_id ) ou_name, (SELECT paym.payment_method_code FROM APPS.…
Oracle R12 AR Invoice With Tax Lines and Tax Description Query
SELECT DISTINCT rcta.trx_number invoice_number, –gd.gl_date, hp.party_name customer_name, rctla.line_number, rctla.description, rctla.uom_code, rctla.quantity_i…
Oracle R12 Journal Details Query
SELECT gjst.user_je_source_name source, ( SELECT gjct.user_je_category_name FROM apps.gl_je_categories_tl gjct WHERE gjh.je_category = gjct.je_category_name AND…
Oracle R12 Internal Bank Account Query
SELECT hou.name operating_unit, xep.name legal_entity, cebb.bank_name, cebb.bank_number, cebb.bank_branch_name, cebb.bank_branch_number, cebb.bank_branch_type,…
Stale Data Error in OAF
Sometimes when we perform multiple transactions to EO, we may get error like below. Solution: Open the EO of the table. Navigate Attribute property of the prima…
EBS R12.2 Log file locations
Category Location Start/Stop Logfiles $INST_TOP/logs/appl/admin/log Log files for OPMN and OHS processes $IAS_ORACLE_HOME/ instances//diagnostics/logs Weblogic…
R12.2 EBS Application Services
Group Services Scripts Purposes Root Services Node Manager adnodemgrctl.sh WLS Node Manager controls server instances within a domain providing automatic restar…
Difference between R12.1 & R12.2
Category 12.1 12.2 Forms & Reports, Developer Home, Tools Home 10.1.2 – ORACLE_HOME 10.1.2 ORACLE_HOME OC4J/OHS/OPMN 10.1.3 – IAS-ORACLE_HOME OPMN, oacore-oc4j,…
Clone 19c Oracle Home
a. Create a gold image of the 19c Oracle Home. $ cd $ORACLE_HOME/ $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent $./runInstaller…
OPMNCTL startall Fails with “unexpected exit: status 4200”
While trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1…
Autoinvoice Program Error correction Script on Duplicate Invoice Number
Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number…
Autoinvoice Program Error correction Script on Offset Account and Revenue Account
please_complete_offset_account_ra_interface_lines_all Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from c…
Autoinvoice Program Error correction Script on Rule Start date
Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number…
Oracle GL Transaction Register Report
Header : Outbound details from oracle general ledger Usage of Heading : Useful to get General ledger transaction details information data Description of post :…
Form Personalization on Purchasing Receipt Standard Form
Header : How to apply Form Personalization on Purchasing Receipt Standard Form Usage of Heading : Useful in the purchasing module in receipt of goods Descriptio…
adpatch Fails After Restart With Error: “Unable to read file format id from file adainit.rf9”
Error: adpatch Fails After Restart With Error: “Unable to read file format id from file adainit.rf9” Solution: cd <$APPL_TOP>/admin/AXMD/restart/ Rename the fil…
How to Enable DFF in Bank Account Transfer Page
Header : How to Enable DFF in Bank Account Transfer Page Usage of Heading : Useful in the cash management module in banking page Description of post : DFF means…
How to add Jar files to JDeveloper
In this post we are going to discuss how to add jar files to JDeveloper. First we need to download required jar file, after that you need to follow the below st…
getting ebs R12.2 web logic url from os level
This os level command used to get the oracle EBS R12.2 web logic url. echo “http://”$(cat $CONTEXT_FILE | grep s_webhost | cut -d ‘>’ -f2 | cut -d ‘<‘ -f1)”.”$(…
How to run Active user in concurrent Request to check the performance.
How to run Active user in concurrent Request to check the performance. Step – 1 – Once log into the browser. Go to “System Administrator” Go to co…
How to rectify the error – Ora 150(This error occur due to abnormal shutdown on application).
Error facing – While facing the 150 error(This error occur due to abnormal shutdown on application). Please stop the application with sh ADSTPALL.sh and use bel…
How to Start the Application in EBS
How start the Application in EBS? Step 1- Go into oracle log-in In EBS you will get the ENV file with default installation and you need to go with that E…
Concurrent request receiving Could Not Lock Request when canceling
After submitting concurrent request, the phase of the request is RUNNING and never completing. When we search for the database session, it is not having any ses…
Third party Registration Validation
create or replace procedure xx_Thirdpart_reg_validation(P_CUSTOMER varchar2) as LV_ERR_MSG VARCHAR2 (4000); LV_STATUS_FLAG VARCHAR2 (1); LV_CUSTOMER_ID NUMBER;…
Mobile First strategy with Oracle CX Mobile App
Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals.…
To recover Concurrent Manager – Concurrent Manager recovery Wizard – EBS 11i/R12
Concurrent Manager Recovery Wizard – Oracle Applications Manager Troubleshooting and Diagnostics Follow the below steps to use the Concurrent Manager Recovery W…
Customer Bill_To Address in Oracle Apps R12
Please find below query to get customer Bill_To Address SELECT DECODE (hcsua.site_use_code, ‘BILL_TO’, hl.address1 || ‘, ‘ || hl.address2 || ‘, ‘ || hl.c…
How to Delete ‘INCOMPLETE’ and ‘APPROVED’ Purchase Order (PO) using API in Oracle Apps EBS R12 – API to delete purchase Orders
Below Pseudocode, DECLARE L_RESULT BOOLEAN; L_PO_HEADER_ID NUMBER; — := <PO_HEADER_ID> ; L_TYPE_LOOKUP_CODE VARCHAR2(20); — := <LOOKUP_CODE> ; L_VALIDATI…
How to Convert Comma Separated Values into Table using ‘REGEXP_SUBSTR’
WITH csv AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD.MM,GG’ AS csvdata FROM DUAL) SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char FROM DUAL, csv CONNECT…
Convert the Amount into the Word using Function in Oracle Apps R12
Create or Replace Function AMT_IN_WORDS ( P_TOT_AMT float, P_TRANSACTION_CURR Varchar2) return varchar2 IS InvalidNumberFormatModel EXCEPTION; PRAGMA EXCEPTION_…
QUERY TO FIND THE DETAILS OF CONCURRENT REQUESTS WAIT FOR MORE THAN ONE HOUR
Description: QUERY TO FIND THE DETAILS OF CONCURRENT REQUESTS WAIT FOR MORE THAN ONE HOUR. Query: set head on; set feed off; set pages 0; set verify off; set fe…
Shrink FND_LOG_MESSAGES table size for gain more space
Description: Shrink FND_LOG_MESSAGES table size for gain more free space. Steps: select owner, segment_name, bytes/1024/1024/1024 gb from dba_segments where seg…
Steps to perform “Alter Table Move” on FND_LOBS table.
a. Find the Size of the FND_LOBS table and its associated lob_segment size. SQL> select owner, table_name, column_name, segment_name, tablespace_name from dba_l…
Steps to export/import FND_LOBS table – Standard method
a. Analyse FND_LOBS table collect the table size, lob segment size, no of rows in FND_LOBS table, respective LOB Segment associated with FILE_DATA column etc. b…
Reorganizing FND_LOBS table in Oracle EBS R12.1.3
Reorganizing FND_LOBS table in Oracle EBS R12.1.3 FND_LOBS is usually one of the top 10 table in an EBS environment. It stores all the attachments that have bee…
EBS Weblogic Admin Console When Not Accessible After CPU Patching
By applying recent CPU patches on Oracle E-Business suite R12.2, many customers faced issues while accessing weblogic admin console from browser. This security…
adcfgclone issue – ORA-28040: No matching authentication protocol
ERROR: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database 12c Database: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database…
.apachectl issue after cloning
Error: Autoconfig could not process the following files: Directory: $ORA_CONFIG_HOME/10.1.3/Apache/Apache/bin .apachectl BINCPY .apachectl BINCPY AutoConfig is…
Unlink a FND_USER user account that is linked to an SSO Account
Unlink a FND_USER user account in Oracle EBusiness Suite that is linked to an SSO Account as follows, $ cd $FND_TOP/patch/115/sql/ $ ls -ltr fndssouu.sql $ sqlp…
Add node in R12.2
Steps to add second node to an Application Tier in R12.2. 1. Start the admin server in the run file system of the applications first node and execute txkManageD…
adcfgclone failed with no linkxlc error
adcfgclone.pl failed in the application tier with no linkxlc error as follows, no linkxlC in BASE_PATH/apps/apps_st/comn/clone/bin/../jre/bin /usr/bin /etc /usr…
Cost Manager Concurrent request failed
Cost Manager concurrent request failed with the following errors, APP-FND-01564: ORACLE error 60 in cmlacm() Cause: cmlacm() failed due to ORA-00060: deadlock d…
Control Purchasing Period (India Local Purchasing)form was not opening.
In EBS R12.1.3 the “Control Purchasing Period” was not opening for users and the following error was noticed, oracle.apps.fnd.framework.OAException: Application…
How to Audit particular table in database?
To set audit: AUDIT [option] [BY user|SESSION|ACCESS] [WHENEVER {NOT} SUCCESSFUL] For example: SQL > audit select on dba_users by access whenever not successful…
Script to Update Preparer/ Requester in Requisitions using API
Get data to be modified from customer and load it into a staging table. Use this table in the below script to update Preparer/ Requester for PO Requisitions. DE…
Extract for Payments – Check and EFT
SELECT papf.employee_number employee_number , aps.vendor_name payee_name…