Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. SELECT rct.trx_number…
Read MoreCSS Plan Creation Process for Migration Configuration: Inventory – Receiving Options Steps 1. Connect with Server wherein the CSS (ConfigSnapshot) is installed 2. Log-in on to ConfigSnapshot 3. Connect with…
Read MoreCSS Plan Creation Process for Migration Configuration: Inventory Organization Steps 1. Connect with Server wherein the CSS (ConfigSnapshot) is installed 2. Log-in on to ConfigSnapshot 3. Connect with the Source…
Read MoreCREATE OR REPLACE PROCEDURE XX_GL_EXTRACT_ENABLE_ACCOUNT AS v_set_id number; v_position_account_type number:=3; v_acc_flex_value_set varchar2(240):=’XXX_COA_ACCOUNT’; /**Pass the COA name/ flex_value_exeception EXCEPTION; v_upd_count number:=0; BEGIN SELECT …
Read MoreThis script can be used to remove junk characters from a string CREATE OR REPLACE FUNCTION xx_Replace_Junk_Chars_func (p_string IN VARCHAR2) RETURN VARCHAR2 IS lv_string VARCHAR2 (1000); …
Read MoreGet 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. DECLARE l_msg_data…
Read MoreUpload catalogue item Images in iProcurement Oracle iProcurement module is widely used by oracle users to raise catalog and non-catalog Purchase Requisitions. iProcurment module is very user…
Read MoreEnabling Link to access Excel file in iProcurement Oracle iprocurement module is widely used by oracle users to raise catalogue and non-catalogue Purchase Requisitions. IProcurment module is very…
Read MoreWhat is Oracle Process Manufacturing? How many modules are covering Oracle Process Manufacturing? What are the Major Functionalities in Product Development? Is Co-Product and By Product are different? Setup Step:1…
Read MoreIntroduction Procurement Team would like to use “Upload” or Excel sheet options to update the Global Blanket Purchase Agreement (GBPA). Using the functionality in R12 has changed. Hence this document…
Read More