A billion-dollar Manager Services Provider, based in the US, offers multiple products and services to their clients. It provides database management and migration to Cloud, among other services. The company…
Read MoreDECLARE CURSOR C1 IS SELECT (upper(A.item_code)) ITEM_CODE, A.ORGANIZATION_ID ORG_ID, A.sales_account FROM hs_item_sales_account_conv A WHERE A.ORGANIZATION_ID=111 AND A.ITEM_CODE IN() AND EXISTS (SELECT 1 FROM MTL_SYSTEM_ITEMS_B MSI WHERE MSI.ORGANIZATION_ID=111 AND MSI.SEGMENT1=(upper(A.item_code))); BEGIN…
Read Morecreate or replace PACKAGE xdmc_release_hold_pkg AUTHID CURRENT_USER AS PROCEDURE call_fnd_global ( p_user_id NUMBER, p_resp_id NUMBER, p_resp_appl_id NUMBER ); PROCEDURE xdmc_release_hold ( errbuf OUT VARCHAR2, retcode OUT NUMBER, p_order_number IN NUMBER…
Read MoreGetting the following error applying a patch running Adop: adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context :…
Read MoreObjective. The objective of the below API is used to increase the onhand quantity in Inventory through Miscellaneous Receipt. Sample Code. set serveroutput on declare l_api_version NUMBER := 1.0; l_init_msg_list…
Read MoreThe “Accounts Payable Trial Balance” / “Open Account Balances Data Manager” report having severe performance issues. The rebuild it self taken more than 4 hours. Also there was too much…
Read MoreIn today’s time, technology is at the core of the smooth functioning of organizations. Such is the dependence that it is hard to imagine a day without it. However, it…
Read MoreIssue : GoldenGate Error Queue For Apply Process “OGG$RNDDEV_A” Contains New Transaction With ORA-904 Observation : *** ACTION NAME:(OGG$RNDDEV_A – Apply Server) 2016-06-01 15:50:47.102 dbkedDefDump(): Starting a non-incident diagnostic dump…
Read MoreEmployees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreCause: The current session has exceeded the INIT.ORA open_links maximum. To find: ——— SQL> show parameter open_links; NAME …
Read More