CROSS VALIDATION RULE EBS R12
What are Cross Validation Rules Cross Validation Rules are used to restrict the combination between the segments of a particular Chart of Accounts. As per our Example, we have the…
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 MoreCheck Data type using JavaScript
Introduction This Post is Explain About to Check Data type using JavaScrip. Use the below script to perform duplicate data validation along with numeric data type validation in Javascript.…
Read MoreHow to Define a PROJECT in FUSION Applications
Description Step how to Define a PROJECT in FUSION Applications. Define the Implementation Project. Please find the below steps to define a project Step1: Login as Application User. Step2: you will be…
Read MoreAssign Offerings and options to a Project and How to Assign Project tasks to the Users
Step1: Click on Next button to assign Offerings and Options. Which we have planned to implement. we will navigate to Select offerings to implement window as below Step2: we are assuming…
Read More