Total Pageviews

Showing posts with label EBS: Oracle PLSQL. Show all posts
Showing posts with label EBS: Oracle PLSQL. Show all posts

Monday, 10 April 2023

EBS : Oracle PLSQL : File Handling using UTL

 File Handling using UTL in Oracle PLSQL


  • How to check file avilabilty in the directory

UTL_FILE.fgetattr(v_dir_path, v_file_name, v_exists, v_f_len, v_bsize);

  • remove the existing file from the directory 

 UTL_FILE.fremove (v_location,  v_file_name )

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...