BI Publisher
Discussion List
-
Health and Safety incident photo table fieldSummary: How can I query a photo inserted on a Healthy and Safety incident? Content (please ensure you mask any confidential information): Hi, I have inserted the follow…Matteo Pacchiana 17 views 1 comment 0 points Most recent by Glen Walton-Oracle Human Capital Management -
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i…Simiao Oliveira 8 views 2 comments 0 points Most recent by Simiao Oliveira Reporting and Analytics for HCM -
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i… -
Embed BI Publisher report without Fusion HeaderSummary: Hi - I am trying to embed a BI Publisher report into a page for our Learning admin to use but when I embed the report using the link provided within the catalog…
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdip Chavada 34 views 5 comments 0 points Most recent by Indushree Reporting and Analytics for HCM
-
Add a hyperlink to an image in a BI Publisher Interactive reportSummary: In an interactive report, it is possible to add a link to text using the appropriate icon, but how do you do it on an image? Thank you Content (please ensure yo…Guido Masciello 8 views 2 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM -
DocumentsOfRecordEO psValue Meaning/ MappingSummary: Mapping/ Meaning for DocumentsOfRecordEO psValue Content: Support doc https://support.oracle.com/epmos/faces/DocumentDisplay?id=2692905.1 refers to different fu…Jan Barz ACN 18 views 1 comment 1 point Most recent by Ravinder Namsani-Oracle Human Capital Management
-
SQL Query to retrieve employee evaluation in performance documentSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query retrieving the employee overall rating in performance d…Valerio Curzi 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
SQL query to fetch the list of values for each value setSummary: Business requirement is to fetch the list of active values for each value set code in excel. Need to develop SQL query to fetch Each segment Value set code valu…Badripalli Archana-Oracle 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 187 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to change 'TO' email address in workflow approval email notifications BIP TemplatesSummary: We have a requirement to change the "TO" email address when approving /rejecting workflow emails. We need to replace it with organization email address. Then it… -
BI report: how to differentiate between learning outcomes and prerequisitesHello, is it possible to differentiate between learning outcomes and prerequisites? which table can we use to retrieve learning outcomes and what table for prerequisites…Alessandra T. 3 views 1 comment 0 points Most recent by Elaine Berrick Reporting and Analytics for HCM
-
What table that holds actual work schedule of employee ?I want a query that gets the actual work schedule of employee in this screen
-
Values being truncated at 240 characters in the non-Excel output formatsHow to address those values being truncated at 240 characters in the non-Excel output formats. -
Building a BIP Report for User Access TrackingSummary: Dear Customer Connect Community, I hope this message finds you well. I am looking to create a BIP Report using standard SQL to track user access within specific…Matheus Roberto 16 views 0 comments 0 points Started by Matheus Roberto Reporting and Analytics for HCM -
Consolidated List of OTBI and BI Publisher Reports Posted (14 April 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * OTBI: Employee Salary and Performance Ratin…Julian Challenger-Oracle 286 views 3 comments 3 points Most recent by Ms_Oracle Reporting and Analytics for HCM -
Can any one share sql query to fetch employee contacts details(contact person_id,date of birth)Summary: I have a requirement to fetch employee conatct details(Children),contact person Id, date of birth and their marital status, can anyone help me? Content (please …Lakshmi Devi Bathala 18 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
2717700.1Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Prasad Singamaneni-Oracle 7 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
We need to get Timecard reason on like WFH or Client Site and so onWe need to get Timecard reason on like WFH or Client Site and so on please help with relevant tables
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…
-
How we can determine which report an employee has downloaded on PCSummary: Hello all , Can we get the information which report is been downloaded by employee on there PC Content (please ensure you mask any confidential information): Ve…
-
Required List of all custom and seeded BIP report having xls output formatSummary: Can Oracle provide list of all custom and seeded report having xls output format from fusion bi publisher? Content (please ensure you mask any confidential info…Punam Roy Karmokar-272206 20 views 7 comments 0 points Most recent by Punam Roy Karmokar-272206 Reporting and Analytics for HCM -
-
Transaction Approvers Comments ReportSummary I am preparing a report to fetch Transaction details along with Approver comments which we can see in Transaction console.Content Hi Team, I am facing a problem … -
SQL query for interview reminder, collect feedback & LINKEDIN ID from candidates resume on ORCSummary: Hello Experts, I need your help to query two BIP notification that needs to go out along with a message and link for Job Posting, resume in below scenarios: Cus…Ashwini Pundle 11 views 0 comments 0 points Started by Ashwini Pundle Reporting and Analytics for HCM
-
Transaction Console -> Error Description and Error Resolution (hrc_txn_error)Summary: I have a requirement to get the data related to the transaction console when the transaction fails I need to get the error description and error resolution as d…Mohab Ehab-Oracle 31 views 2 comments 0 points Most recent by Mohab Ehab-Oracle Reporting and Analytics for HCM
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 446 views 7 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Issue with Report Changes Not Reflecting After Clicking SaveWe encountered an unexpected behavior with one of our reports. We made some updates to the bursting, clicked the save button, but when we checked the bursting again, the…Michael Angelo Lucena 35 views 4 comments 0 points Most recent by Thri Gaadi Reporting and Analytics for HCM