INTRODUCTION This blog explains how we cancel approved requisition in oracle apps PROCEDURE CANCEL_REQUISITION (P_BATCH_RUN_ID IN NUMBER,P_REQUISITION_NO IN VARCHAR) AS X_REQ_CONTROL_ERROR_RC VARCHAR2(500); LN_USER_ID NUMBER; …
Read MoreINTRODUCTION This blog explains how we validate Third Party Registration in oracle apps –****************************************************** — Checking Third Party Registration(GST) –****************************************************** BEGIN SELECT DISTINCT TRIM (TO_CHAR…
Read MoreINTRODUCTION This blog explains how we validate Bill to customer in oracle apps –****************************************************** — Bill To Customer Address Validation –****************************************************** BEGIN SELECT hcas.cust_acct_site_id –hcsu.site_use_id …
Read MoreINTRODUCTION This blog explains how we get complete order details about the for a sales order in oracle apps CODE SELECT OOH.ORDER_NUMBER , OOH.FLOW_STATUS_CODE HEADERSTATUS , OOH.ORDERED_DATE ORDER_DATE , OTT.NAME …
Read MoreObjective: Intent to publish this blog to get rid of this below common API Error while updating the Customer site uses. Error: hz_cust_site_uses cannot be locked as it has been…
Read MoreIntroduction This Query will help to Fetch Records From AP Expense to GL SQL Query: SELECT aerha.invoice_num expense_invoice_number, papf.full_name employee_name, aerha.SOURCE, aerha.description expense_header_description, aerha.attribute_category, aerha.expense_status_code, aerla.start_expense_date, aerla.distribution_line_number, aerla.item_description line_description, aerla.amount,…
Read MoreOnhand Inventory by Revision Report Introduction This Query will help to generate the On-hand Inventory by Revision Report Script: Step 1: Create Package Spec CREATE OR REPLACE PACKAGE xxxx_inventory_pkg AS…
Read MoreWhile trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1/bin/opmnctl startall opmnctl startall: starting opmn and all managed…
Read MoreHeader : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post :…
Read Moreplease_complete_offset_account_ra_interface_lines_all Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post…
Read More