EBS Technical

Validate Third Party Registration

INTRODUCTION This blog explains how we validate Third Party Registration in oracle apps –****************************************************** — Checking Third Party Registration(GST) –****************************************************** BEGIN SELECT DISTINCT TRIM (TO_CHAR…

Validate Bill to customer

INTRODUCTION 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 …

Sales Order Details

INTRODUCTION 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 …

Resolve API error — (hz_cust_site_uses cannot be locked as it has been updated by another user)

Objective: 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…

Query to fetch the Records from AP Expense to GL

Introduction 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,…

Onhand Inventory by Revision Report

Onhand 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…

OPMNCTL startall Fails with “unexpected exit: status 4200”

While 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…

Autoinvoice Program Error correction Script on Duplicate Invoice Number

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 :…

Autoinvoice Program Error correction Script on Offset Account and Revenue Account

please_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…

Autoinvoice Program Error correction Script on Rule Start date