create 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 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 MoreIntroduction: This Post illustrates the steps to Update the schedule ship date in Order Lines using API. Script to Update the Scheduled Ship Date in Order Lines DECLARE p_scheduled_ship_date DATE…
Read MoreUsing the below query we can track the DML operations made on Supplier’s.It is useful script for Auditing and Tracking purposes. select DISTINCT a.segment1 vendor_number,A.VENDOR_NAME,c.name org_name,a.creation_date supplier_creation_date, (select user_name…
Read MoreIntroduction This blog explains how to get pricelist details for an item #Code# SELECT QLH_TL.NAME “List Price” ,QLH_TL.DESCRIPTION “Description” ,QLH_TL.VERSION_NO “Version” ,QLH_B.LIST_TYPE_CODE “List Type” ,QLH_B.CURRENCY_CODE “Curr Code” ,MSI.SEGMENT1 “Item Number”…
Read MoreSELECT ( SELECT organization_name FROM org_organization_definitions WHERE organization_id = msi.organization_id ) org_name, msi.segment1 item_number, msi.description item_description, msi.primary_unit_of_measure, –msi.item_type, ( SELECT flv.meaning FROM apps.mtl_system_items_b msb, apps.fnd_lookup_values flv WHERE lookup_type = ‘ITEM_TYPE’…
Read MoreSELECT gjjlv.period_name “Period Name”, gjb.name “Batch Name”, gjjlv.header_name “Journal Entry For”, gjjlv.je_source “Source”, gjjlv.je_category “Category”, glcc.concatenated_segments “Accounts”, nvl(gjjlv.line_entered_dr,0) “Entered Debit”, nvl(gjjlv.line_entered_cr,0) “Entered Credit”, nvl(gjjlv.line_accounted_dr,0) “Accounted Debit”, nvl(gjjlv.line_accounted_cr,0) “Accounted Credit”, gjjlv.currency_code…
Read MorePass the from and to date parameter. select USER_CONCURRENT_PROGRAM_NAME,REQUEST_DATE,CNTPERDAY,week_no, case when week_no=1 then sum(CNTPERDAY) OVER (PARTITION BY USER_CONCURRENT_PROGRAM_NAME,week_no) else 0 end week_no_1, case when week_no=2 then sum(CNTPERDAY) OVER (PARTITION BY…
Read MoreIntroduction This blog explains how to create user and add responsibility for a user from the backend. #Code# DECLARE lc_user_name VARCHAR2(100) := RAJAN_TEST’; lc_user_password VARCHAR2(100) := ‘Oracle123′; ld_user_start_date DATE :=…
Read More