Sample HDL files for Work schedule Assignments
In this article, we will go through steps to create and manage work schedule assignments using HDL Goal HDL files to create work schedule assignments for employees Solution ScheduleAssignment.dat file…
Fusion BI – Useful queries
I am maintaining a repository of the code snippets/templates/queries, that I feel useful for whoever is working on Fusion BI - Adhoc reporting. Logged in user details The user information…
Secure PII data in Fusion SAAS – using Data Masking techniques
Using data roles secures PII data such as National Identifiers, Ethnicity, Home Address etc... In Production instance this PII data is secured using VPD policies applied at database level. Where…
ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
At times, while fixing performance issues in Oracle database or after Oracle data base 11g upgrade, the following ORA error occurs: ORA-20001: invalid column name or duplicate columns/column groups/expressions in…
Conversions in Oracle Apps
This article concentrates on Data Conversion and Data Migration, and Interfaces. Data conversion/migration/interfaces are the mechanisms we use to load data to/from Oracle apps. When we need to enter data…
Useful SQL queries in Oracle Apps
To know the database version : select * from v$version; The below query displays all the locked tables in the given session: SELECT owner || '.'…