1 2 3 4 5 6 7 8 9 10 SELECT Decode(Count(*), 0, 'false', 'true') FROM apps.ap_expense_report_headers_all WHERE report_header_id = :transactionId AND employee_id IN (SELECT ap_web_ame_pkg.Getawardmanagerid(award_id, sysdate) FROM apps. ap_exp_report_dists_all dist WHERE report_header_id = :transactionId […]
Lists all products and their Installation Status 1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT fat.application_name, fa.application_id, fpi.patch_level, Decode(fpi.status, ‘I’, ‘Licensed’, ‘N’, ‘Not Licensed’, ‘S’, ‘Shared’, ‘Undetermined’) STATUS FROM […]
GRC Suite Certification Matrix (Doc ID 741001.1) GRC Application Suite Architecture and Product Deployment Overview (Doc ID 782850.1) Governance Risk and Compliance (GRC) Product Information (Doc ID 1084596.1) Upgrade Paths to Oracle Enterprise Governance and […]
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 […]
Oracle Services Procurement – Complex Purchase Orders – Oracle Services Procurement is part of Oracle Advanced Procurement Suite and provides state-of-the-art functionalities to strategically procure services that deals with various procurement aspects such as Prepayment, Retainage […]
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 […]
Enterprise Resource Planning and Integrations BlogSpot 