Reports (BIP) – Query to get assigned payroll details
Use the below query to extract assigned payroll details from Fusion HCM:
-
-
Reports (BIP) – Implementing Digital Signature in PDF BIP reports
Oracle Fusion reports and analytics provides the capability of implementing digital signatures with in BIP. However there are some limitations: Only one digital signature can be used across all reports. For a report with multiple templates, the same signature will be applicable for all the templates. Digital signature can be tested only using the BIP…
-
Reports (BIP) – Customizing a standard BIP report
Many a times, consultants are required to modify the standard BIP reports. This is very much applicable in case of workflow notifications which are based on BIP reports. Both data model as well report can be customized to include/exclude any additional fields. Follow the below steps: Login to your pod using below url: https://xxzzaa.fa.bb.oraclecloud.com/xmlpserver/ (note…
-
Reports (BIP) – Tips/ Shortcuts
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…