Fusion Query to find Default company values assigned in Legal Entity
1. Link Between Legal Entity & Ledger along with Default Company Assigned in Legal Entity SELECT flex_segment_value ,gll.* FROM gl_legal_entities_bsvs gleb…
Read MoreProject wise PO details Reports
Project wise PO details Reports SELECT ipd.project_number PROJECT_NUMBER, ipda.asset_tag_id TAG_NUMBER, translate(ipd.description,’ä’,’a’) Project_Desc, Translate(ipda.asset_desc,’ä’,’a’) Asset_Desc, — prh.segment1 req_number, …
Read MoreHow to add expense items type in expense template
Add Expense type in Expense template Navigation AP setup user à Setup à Invoice à Expense Report Templates Name Expense Category Tax Code GL Account Projects Expenditure Type Policy Schedule…
Read MoreAR Invoice PDF email (Alternative of BPA Process)
<?xml version=”1.0″?> <dataTemplate name=”XX__AR_INVPRINT” description=”TW Invoice Printout for United States” defaultPackage=”XX_AR_INVPRINT_PKG” version=”1.0″> <parameters> <parameter name=”P_Report_Level” dataType = “character”></parameter> …
Read MoreProgram for Return to Vendor in Oracle purchasing
Return to Vendor of Purchase Order Receipts Script: Oracle EBS R12 Return to Vendor is done in two steps: “Return to Receiving” and then “Return to Vendor”. Follow below steps…
Read MoreProgram to create receipts for approved Purchase order
DECLARE ln_user_id NUMBER:=1318; ln_po_header_id NUMBER; ln_vendor_id NUMBER; lv_segment1 VARCHAR2(20); ln_org_id NUMBER; ln_line_num NUMBER; …
Read MorePassword of Application User
CREATE OR REPLACE PACKAGE get_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2; END get_pwd; CREATE OR REPLACE PACKAGE BODY get_pwd AS …
Read MoreAPI to Update the category description
DECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data VARCHAR2(80); …
Read MoreAPI to Delete Valid Category Set
DECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; …
Read MoreAPI to Create Item Category in Oracle Inventory
DECLARE l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE; l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data VARCHAR2(80); l_out_category_id NUMBER; g_prem VARCHAR2(10); BEGIN …
Read More