Depreciation is a common accounting concept that helps adjust the value of a deteriorating asset over time as it becomes less efficient. A business can depreciate an asset with an expected useful life of more […]
Oracle by default does not maintain future depreciation information (Accumulated or YTD) as depreciation could change as per cost adjustment, addition or asset retirement. Often there will be requirement to write a function or package […]
Normally when we came across the difference between function and procedure, we say that function always returns value(e.g single) where as procedure may or may not. But we can use OUT parameter to return multiple […]
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 […]
