Using functions in WITH clause in Oracle 12c
The WITH Clause, or Subquery Refactoring If you haven’t heard of the WITH clause, let me take a moment to explain what it is. The WITH clause is a clause in SQL that allows you […]
Month: August 2017
How to Replace Special Characters in Oracle SQL
Options for Replacing Special Characters In Oracle SQL, you have three options for replacing special characters: Using the REPLACE function Using the REGEXP_REPLACE function Using the TRANSLATE function Each of them has their pros and […]
Spreadsheet Guidelines for EIB Spreadsheet Templates in Workday
Spreadsheet Guidelines for all EIB Spreadsheet Templates Always generate a spreadsheet template in Workday for the upload. Keep the template in its original XML Spreadsheet 2003 format. Do not save a template to any other format. Add […]
Net book value
Net book value is the amount at which an organization records an asset in its accounting records. Net book value is calculated as the original cost of an asset, minus any accumulated depreciation, accumulated depletion, accumulated amortization, and […]
What is negative depreciation in regard with fixed assets?
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 […]
Accumulated depreciation or YTD depreciation projection as of specific period end.
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 […]
Return multiple value from a function in oracle plsql
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 […]
Query to find if the Expense Report Preparer and Award Manager are Same
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 […]
Query to find whether a product is installed/licensed or not.
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 […]
Important GRC Metalink Notes
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 […]
Enterprise Resource Planning and Integrations BlogSpot 