What is iSetup: iSetup is a tool that supports initial implementations of the Oracle E-Business Suite. iSetup mainly supports the ongoing maintenance of setup data. This includes simplifying the migration of setup data – from […]
Introduction:- Oracle GRC term is relatively new word compared to Oracle E Business Suite, but it is getting hot day by day. Where GRC Stands for Governance – Risk Management – Compliance. GRC takes cares […]
This article discussed how the accounting flexfield is generated in Oracle iExpenses when employee submits his or her expense report. For simplicity sake, let’s assume the expense report does not have any multi-currency or credit […]
This feature is called “Authorized Delegate”. To have the ability to enter expense reports, withdraw expense reports, etc. for other individuals, do the following: Authorization Preferences (Self-Service Delegate Assignment) Users can now maintain their own list […]
Use the Expense Report Number client extension to generate custom expense report numbers. You can, for example, customize the format of the expense report number to match your company’s numbering system. You create custom expense […]
Once the Expense Repot is converted to Invoice using the standard ‘Expense Report Export Program’ The invoice date is nothing but ‘week_end_date’ column populated on the ap_expense_report_headers_all table. Below is the logic used behind the screens […]
Below are queries for Oracle iExpense to find out the Policy violation detail for iExpense reports. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 […]
First create a temp table to hold user responsibilities to be inactivated. 1 2 3 4 CREATE TABLE xxcb_user_resp ( user_name VARCHAR2(240), resp_name VARCHAR2(240) ) Then insert record into temp tables, you may prepare these […]
Payroll journal entries are used to record the compensation paid to employees. These entries are then incorporated into an entity’s financial statements through the general ledger. The key types of payroll journal entries are: Initial […]
If you have ever worked with multiple workbooks in Excel, you know that it can sometimes cause issues if all of the workbooks are open in the same instance of Excel. For example, if you […]
Enterprise Resource Planning and Integrations BlogSpot 