-
-
HRHD – Query to get Service Request Details
Use below query to get service request details from Fusion BIP: SELECT ssr.sr_id,ssr.title,ssr.problem_desc,to_char(ssr.open_date,’RRRR/MM/DD’) sr_opening_date,ssr.primary_contact_party_id,ssr.sr_number,ssr.status_cd,(SELECT flv.meaningFROM fnd_lookup_values flvWHERE flv.lookup_code = ssr.status_cdAND flv.lookup_type = ‘ORA_SVC_SR_STATUS_CD’AND flv.LANGUAGE = ‘US’) sr_status_meaning,ssr.severity_cd,(SELECT meaningFROM fnd_lookup_values flvWHERE flv.lookup_code = ssr.severity_cdAND flv.lookup_type = ‘ORA_SVC_SR_SEVERITY_CD’AND flv.LANGUAGE = ‘US’) sr_severity_meaning,sc.category_name category,sq.queue_name queue,to_char(ssr.last_resource_assign_date,’RRRR/MM/DD’) sr_last_resource_assigned_onFROM svc_service_requests ssr,svc_queues sq,svc_categories scWHERE ssr.queue_id = sq.queue_idAND ssr.category_id = sc.category_id–AND ssr.status_cd in…
-
Reports (BIP) – Query to extract Worker disability details
Below query can be used to extract disability details of a worker:
-
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…