Workflow From Scratch
Download the Standard Workflow for creating a new workflow item type: To download the workflow file we can download using wfload or from Oracle Workflow Builder. Navigation: File –>…
Read MorePerformance Tuning
Tip 1 – Monitor Wait Times Oracle provides wait events that allow you to understand the total time a query spends in the database. Start your tuning efforts with the…
Read MorePO Interface Based on Project ,Task, Expenditure Type
PO interface based on project, Task, Expenditure type Staging.sql CREATE TABLE APPS.XX_NEW_PO ( ROWNUMBER NUMBER, SUPPLIER_NUMBER VARCHAR2(30 BYTE), SUPPLIER_SITE VARCHAR2(30 BYTE), SUPPLIER_NAME VARCHAR2(240 BYTE), PO_NUMBER VARCHAR2(30 BYTE), SHIP_TO_LOCATION…
Read MoreUser Wise Menu, Responsibility, Function Extraction
SELECT men.* FROM( SELECT main_query.responsibility_name “Responsibility”, main_query.user_menu_name “Main Menu Name”, main_query.entry_sequence “Seq”, main_query.prompt prompt, main_query.user_function_name “Function”, main_query.func_descrip “Function Descrip”, main_query.sub_menu_name “SubMenu Name”, main_query.sub_seq “Sub Seq”, main_query.sub_prompt “SubPrompt”, main_query.sub_func “SubFunction”, main_query.sub_func_descrip…
Read MorePO Dumps Extraction
SELECT pov.segment1 supplier_number, povs.vendor_site_code supplier_site, pov.vendor_name supplier_name, poh.segment1 po_number, hrls.location_code ship_to_location, poh.currency_code, hrlb.location_code bill_to_location, poh.comments header_desc, poh.creation_date po_date, poh.authorization_status approval_status, pol.line_num po_line_no, pol.purchase_basis line_type, pp.segment1 project_code, pt.task_number task_code, expenditure_type, msib.segment1…
Read MoreTax Insert Function for IRISO
/*Tax*/ FUNCTION add_gst_tax_req (p_req_id NUMBER) RETURN VARCHAR2 AS CURSOR c IS /* SELECT prla.requisition_header_id, prla.requisition_line_id, prla.source_organization_id, prla.destination_organization_id, prla.item_id FROM po_requisition_lines_all prla, jai_tax_det_factors jtd WHERE 1 = 1 AND prla.requisition_header_id =…
Read MoreWeb ADI for Integrating PO using Code Combination Separator
By using batch mode and COA setups with separator defined in system custom Web ADI been developed in EBS application and integrated with custom template using PO interface. Pre-…
Read MoreInternal Requisition/ Internal Sales Order Integration
This integration will integrate IR/ISO based on upload file from APEX application that has been created as custom.Once file been uploaded lot based data based on FIFO basis will be…
Read More