Sales Order Update
Below is the standard API to update sales order deliver to information based on shipment method. Shipment method & deliver to information are maintaining in custom table. oe_order_pub.Process_Order is the…
Read MoreOAMessageChoiceBean
Based on the condition we need to disable message choice in CO. OAMessageChoiceBean DispButtonValue = (OAMessageChoiceBean)webBean.findChildRecursive(“Disposition”); String DispValue = DispButtonValue.getText(pageContext); if (DispValue != null) { DispButtonValue.setDisabled(true); pageContext.writeDiagnostics(DispValue, “DispValue——>!!!!!!> = “,…
Read MoreJPX Import Error
When we do import, sometimes we are facing error as Exception in thread “main” java.lang.NoClassDefFoundError: Then you need to change jpximport.bat and import.bat files as below. Path —> \jdeveloper\jdevbin\oaext\bin You…
Read MoreAn Introduction to Report Manager in Oracle EBS R12
Description This article describes Report Manager functionality in Oracle R12 which allows users to primarily publish and store Financial Statements/reports that are written using Financial Statement Generator (FSGs). Note that Report Manager…
Read MoreQuery to Fetch Invoice details, HSN Code, Third party Registration number and GST Details.
Introduction: The below query fetches the details of an Invoice along with the HSN Code of a respective item present in an Invoice. GST details can also be fetched. SELECT…
Read MoreDelivery Challan with GST Details
Introduction This Post is Described about the Delivery Challan with GST Details in ebs r12 Query retrieves data of those inventory items which are used for promotional purposes or…
Read MoreTAX INVOICE RCM(REVERSE CHARGE MECHANISM) – GST
The below query fetches the details of a tax invocie where in Reverse charge mechanism(RCM) is applied in order to claim the extra tax paid by an organization along with…
Read MoreReturn To Vendor Summay-GST
Introduction The below query fetches the data of purchase order wherein those items present in purchase order needs to be returned to Supplier because of some damage caused to goods…
Read MoreRMA Receipt Query-GST
Introduction This Post Is Described about the RMA Receipt Query-GST In oracle apps R12. select orgid,ORGCODE, ORGNAME, account_number, party_name,city, LINE_NUMBER, trx_number,trx_date, location, src_number,src_date,rma_gross,TAX_RATE_PERCENTAGE, interface_header_attribute2,reason_code,CGST,SGST,IGST,VAT,CST,(nvl(rma_gross,0) + nvl(CGST,0) + nvl(SGST,0) +…
Read MoreGL Account analysis for PA Expenditure & Event query
Introduction This Post illustrates the steps required to get the General ledger analysis for PA Expenditure & Event in oracle Apps Script for GL Account analysis for PA Expenditure &…
Read More