CSS 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 MoreBackground The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval of the purchasing…
Read MoreWITH PARAMETER AS (SELECT :PERIOD_NAME AS PERIOD_NAME FROM DUAL) SELECT distinct prj.project_id,prj.segment1, (SELECT ROUND(SUM(tot_burdened_cost),2) FROM apps.pa_txn_accum WHERE project_id=prj.project_id AND gl_period =PARAMETER.PERIOD_NAME — and…
Read More