Bursting query for BIP report(HCM) in Fusion
Introduction : The below queries will help us to upload the output file in UCM server and send mail to respective mail id in fusion. Upload file to UCM: select…
Read MoreAP Invoice Validation
create or replace PROCEDURE XX_VALIDATE_DEBIT_INVOICE(errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_batch_run_id IN NUMBER, p_org_id IN NUMBER, P_stg_id IN NUMBER, p_debit_memo_num IN VARCHAR2) IS L_ORG_ID NUMBER:=p_org_id; L_SOB_ID NUMBER; L_USER_ID NUMBER; l_resp_id…
Read MoreItem Category Creation R12
Introduction An Item category is a logical classification of items that have similar properties. A category set is a distinct group scheme and consists of categories. The flexibility of category sets allows…
Read MoreHow to call Workflow from OAF
We can call Workflow in 2 ways from the OAF 1) Using PL SQL Procedure, call procedure from OAF page using callable statement. CREATE OR REPLACE PROCEDURE start_wf_prc IS l_itemtype…
Read MoreHow to raise bundle exception in OAF
If we want to display multiple error messages in OAF page. We need to use the code as follows: arraylist errmsg = new ArrayList(); if(pageContext.getParameter(“Type”).equals(“”)) { errMsg.add(new OAException(“Type cannot be…
Read MoreGL Budget Upload Interface Program
Introduction: This Post illustrates the steps required to upload the GL budget data using the interface program. Steps Create the Staging Table. Compile the given Package. Register the Concurrent Program…
Read MorePopulating TDS Tax Category through Form Personalizations
Objective: Populate TDS Tax Category for multiple lines through the custom procedure for an invoice before doing the validation and at the time of Action button clicked. Seq 10 Description…
Read MoreRecognizing Doyensys’ Corona Warriors
The ongoing pandemic and the following lockdown came upon us almost unexpectedly. It brought a transformative change in our lives. The world came to a grinding halt even before we…
Read MoreORA-01153–solution
Want to enable flashback on DR but getting the error. Reason is because MRP process is running. So we stop MRP process and then try enabling flashback. After that start…
Read Moredisplays all unusable indexes
SET VERIFY OFF LINESIZE 200 COLUMN owner FORMAT A30 COLUMN index_name FORMAT A30 COLUMN table_owner FORMAT A30 COLUMN table_name FORMAT A30 SELECT owner, index_name, index_type, table_owner, table_name table_type FROM dba_indexes…
Read More