Description iExpense is an Oracle module used to report and seek reimbursement of expenses paid by employees. This powerful application empowers companies to capture data at various stages of expense reimbursement, a few of them…
Read MoreWhile employee Submitting expense reports, he will face the issues. Which means, expense report will get stuck up with the status as Pending with System Administrator Action Points: a. Check…
Read MoreWhat 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 MoreDescription 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 MoreIntroduction: 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 MoreIntroduction 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 MoreThe 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 More