Posts by Venkatesh Balasubramanian

Approve and Review iExpense Reports in oracle apps

Description For both the manager approval and expense report audit/review, any credit card transactions designated as personal expenses will be listed as a separate negative line item on the expense…

Read More

iExpense report audit/review in oracle apps

Introduction: This post detailed about the Steps required for i-expense Report audit/review in oracle application. Responsibility: – Internet Expenses Audit Manager Ø Log into Oracle and go to Internet Expenses Audit…

Read More

iExpense with Business and Personal expense validate and submit for approval

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 More

I Expense Related Issue Release R12

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

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 More

An 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 More

Query 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 More

Delivery 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 More

TAX 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 More

Return 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 More