To display the date in DD-Mon-RRRR format, please use below in your SQL query: to_char(date_of_birth,’DD-Mon-RRRR’, ‘nls_date_language=American’) Use below condition to get current user id: fnd_global.USER_GUID — Use below function to convert the amount in Arabic: <?xdoxslt:toCheckNumber(‘ar-SA’, TOTAL, ‘AED’,’CASE_UPPER’)?> — Using LISTAGG to show multiple rows into a single cell: — Getting Person Id of logged…
Sometimes it is required to delete the uploaded phones data from Fusion HCM. Below query can be used to create a BIP report which in turn can be used to generate HDL file to delete phones data. The query can be modified to delete phones data for contacts as well as for other person types….
In HR Helpdesk (HRHD), workers are assigned as resources. Below SQL query can be used to get the details of workers who are assigned as resources:
While creating an HCM extract based on a BIP report, there is a common requirement where the BIP should retrieve “Changed Only” data. This can be achieved using a BIP report data model which is based on globalReportsDataModel (/shared/Human Capital Management/Payroll/Data Model). Use the below query in the data set to extract last run date…
