WEB ADI Performance Issue When Data Entry Rows is High
WEB ADI Performance Issue When Data Entry Rows is High While updating the Data Entry Rows in the Lines section to 30000, then the upload takes a long time (10…
Read MoreUpdate the Item Status using API
Introduction: This Post illustrates the steps required to update the Item Status using API. Script to Update the Item Status DECLARE p_item_number VARCHAR2 (300); p_organization_id NUMBER; p_inventory_item_id NUMBER; p_org_id NUMBER;…
Read MoreConcurrent request failed with the following error password verify function error
Issue : Concurrent request failed with the following error password verify function error Error: java.sql.SQLException: ORA-28001: the password has expired applmgr@of200:/FINOECD1/inst/apps/FINOECD1_of200/appl/fnd/12.0.0/secure $ FNDCPASS apps/apps4doyen 0 Y system/manager SYSTEM APPLSYSPUB PUB…
Read MoreADCFGCLONE fails in Autoconfig with gentns error in DB node
Issue: ADCFGCLONE fails in Autoconfig with gentns error in DB node. Error : StackTrace: java.lang.NullPointerException at oracle.apps.ad.tools.configuration.DataModelHandler.getDBName(DataModelHandler.java:912) at oracle.apps.ad.tools.configuration.NetServiceHandler.registerDbNode(NetServiceHandler.java:981) at oracle.apps.ad.tools.configuration.NetServiceHandler.registerNode(NetServiceHandler.java:1208) at oracle.apps.ad.tools.configuration.NetServiceHandler.processNode(NetServiceHandler.java:2307) at oracle.apps.ad.tools.configuration.NetServiceHandler.main(NetServiceHandler.java:3182) Closing connection Connection Closed instantiate…
Read MoreORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ
ISSUE:XML reports complete in warning. Error: ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ ORA-06512: at “APPS.FND_CP_OPP_IPC”, line 85 This is a freshly cloned instance and all managers and…
Read MoreSend the Email in Autonomous Data Warehouse
Introduction: This Post illustrates the steps required to Send the Email in Autonomous Data Warehouse. Script to Send Email CREATE OR REPLACE PROCEDURE xx_sample_send_mail ( p_to IN VARCHAR2, p_from IN…
Read MoreAdd Multiple user/Responsibility through backend
With the following we can add multiple user name and multiple responsibilities through backend. set define off; declare res_user_name varchar2(100); res_app_sn …
Read MoreQuery for Item with BOM Details
Introduction: This Post illustrates the steps required to Fetch Item with BOM Details. Script to Fetch the Item with BOM Details SELECT msi.segment1 item, msi.description item_description, msi.organization_id, msi.primary_unit_of_measure primary_uom, msi.item_type,…
Read MoreForms memory consumption
The Following query is to get the memory consuming forms sessions. #!/bin/sh ALLPROCS=`ps -ef|grep “f60webmx webfile=” | grep -v grep | tr -s ” ” | cut -f3 -d” “`…
Read MoreMandatory checklist – post clone of EBS
The following query will give the values of some important parameters to be considered post clone. SELECT e.profile_option_name Profile, e.profile_option_id, f.user_profile_option_name User_Profile_Name, c.application_short_name, decode(a.level_id,10001,’Site’,10002,’Application’,10003,’Resp’,10004,’User’) LevelSet_At, decode(a.level_id,10001,’Site’,10002,c.application_short_name, 10003,b.responsibility_name,10004,d.user_name) LValue, nvl(a.profile_option_value,’Is Null’)…
Read More