WebAdi Download Is Failing Intermittently performance issue
The download of WEBADI is taking too long and has a Performance issue. It takes 1 minute to 8 minutes when users expect 8 seconds to 30 seconds. The user…
Read MoreUpgrade Excel To 2013 64-bit Error ‘The code in this project must be updated for use on 64 bit systems’ Uploading Data To WEBADI Template
After upgrading Microsoft Excel to version 2013 64bit, when uploading data to the template WEBADI, the template is blank. However when looking at the Excel Macro Information, the following Error…
Read MoreWEB 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 More