OAuth 2.0 Setup from OCI
Introduction: Step by step process of creating OAuth 2.0 instance from OCI. Why we need to do: OAuth 2.0 is essentially a secure permission-granting framework — it lets one…
Read MorePersonalization Migration: ADF to Redwood Page
Introduction: Migrating personalization from ADF page (Classic UI) to Redwood UI Why we need to do: Oracle is modernizing its Fusion Applications UI/UX, and ADF pages are being phased…
Read MoreAR Transaction Type Mapping from Sales Orders
Issue: The AR transaction types are being wrongly picked up from the Sales order. Case 1: Sales order type “SAMPLE-TOYS” should generate AR transactions with Invoice-No charge receivables transactions type.…
Read MoreProcedure to create Quality Test & Quality Test Values in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Test & Quality Test Values using oracle seeded API. Cause of the issue:…
Read MoreStreamlining Oracle EBS Application Tier Patching with ETPAT-AT
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
ERP 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 MoreOracle PLSQL to Generate XML Tag Using Standard Functionality
declare 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 MoreOracle R12 SQL Query – Price List or Fee Schedule for Customer
select 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 MoreBlob File Move From DB to Directory
Introduction/ 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 MoreFile Store From Client to DB
Introduction/ 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 More