Patching Oracle E-Business Suite (EBS) application tier technology components has always been a delicate balance of precision, downtime planning, and repeatability. To ease this process, Oracle provides a specialized utility:…
Read MoreERP Cloud Financials Fusion – Cash Management Auto Reconciliation Introduction Bank Statement Reconciliation – Match Statement Lines and Transactions – Automatic and Manual Reconciliation – 1 to 1, 1 to…
Read Moredeclare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true,dbms_lob.session); :g_clob := dbms_xmlquery.getXml(l_ctx); end;
Read Moreselect HP.PARTY_NAME “Customer Name”,HCAA.ACCOUNT_NUMBER,HCAA.ACCOUNT_NAME,qph.name “Price List Name”,HCSUA.SITE_USE_CODE,HCSUA.LOCATION from qp_list_headers qph,APPS.HZ_CUST_ACCOUNTS_ALL HCAA,APPS.HZ_CUST_ACCT_SITES_ALL HCASA,APPS.HZ_CUST_SITE_USES_ALL HCSUA,APPS.HZ_PARTIES HPWhere hcaa.account_number = –Customer Account Numberand HCAA.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_IDand HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_IDAND HCSUA.PRICE_LIST_ID = QPH.LIST_HEADER_IDAND HCAA.PARTY_ID=HP.PARTY_ID
Read MoreIntroduction/ Issue: CSV blob file to raw file move from database table blob column to database directory. Why we need to do / Cause of the issue: We can move from blob to raw CSV file from database table blob column to database directory. How do we solve: Step 1: Create one database procedure PROCEDURE P_FILE_TO_DBSER (p_blob IN BLOB, p_dir IN VARCHAR2, p_filename IN VARCHAR2) AS l_file UTL_FILE.FILE_TYPE; l_buffer RAW(32767); l_amount BINARY_INTEGER := 32767; l_pos INTEGER := 1; l_blob_len INTEGER; BEGIN l_blob_len := DBMS_LOB.getlength(p_blob); — Open the destination file. l_file := UTL_FILE.fopen(p_dir, p_filename,’wb’, 32767); — Read chunks of the BLOB and write them to the file until complete. WHILE l_pos <= l_blob_len LOOP DBMS_LOB.read(p_blob, l_amount, l_pos, l_buffer); UTL_FILE.put_raw(l_file, l_buffer, TRUE); l_pos := l_pos + l_amount; END LOOP; — Close the file. UTL_FILE.fclose(l_file); …
Read MoreIntroduction/ Issue: CSV file move from client local machine to database table blob column. Why we need to do / Cause of the issue: We can store the CSV file from client local machine to database table blob column. How do we solve: Step 1: Create new table in database CREATE TABLE TB_FILE_UPLOAD (ID NUMBER, FILE_DATA BLOB); Step 2: Create new sequence in database CREATE SEQUENCE FILE_UPLOAD_SEQ START WITH 1 MAXVALUE 999999999999999999999999999 MINVALUE 1 INCREMENT BY 1 NOCYCLE CACHE 20 NOORDER NOKEEP GLOBAL; Step 3: In oracle form builder create on button and write the below code in WHEN-BUTTON-PRESSED trigger. DECLARE v_seq number; v_file_path varchar2(500) := ‘C:\test_file.csv’; v_bool boolean; BEGIN SELECT FILE_UPLOAD_SEQ .NEXTVAL INTO v_seq FROM DUAL; INSERT INTO TB_FILE_UPLOAD (ID, file_data) VALUES (v_seq, NULL); IF v_file_path IS NOT NULL THEN…
Read MoreIntroduction: Splitting of order lines, this can be done during shipping last part of sales order, generally we come across this scenario, when we want to ship partial quantity when…
Read MoreMany of you have asked about the best storage options for a multi-node EBS setup involving a DMZ server with a public load balancer. Here are some insights and best…
Read MoreIn Oracle E-Business Suite R12.1.3, when you try to view a report output/log, the following two errors are displayed: File server could not identify source file. or Authentication failed. In…
Read MorePROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2)IS–Standard Parameters.p_api_version NUMBER := 1.0;p_init_msg_list VARCHAR2(30);–Parameters for WSH_DELIVERIES_PUB.Delivery_Action. p_action_code VARCHAR2(15);p_delivery_id NUMBER:= p_delivery_id_s;p_delivery_name VARCHAR2(30);p_asg_trip_id NUMBER:=p_trip_id;p_asg_trip_name VARCHAR2(30);p_asg_pickup_stop_id NUMBER;p_asg_pickup_loc_id NUMBER;p_asg_pickup_loc_code VARCHAR2(30);p_asg_pickup_arr_date DATE;p_asg_pickup_dep_date DATE;p_asg_dropoff_stop_id NUMBER;p_asg_dropoff_loc_id NUMBER;p_asg_dropoff_loc_code…
Read More