Category 81
Discussion List
-
Create a message before running a BIP ReportSummary: Hi, Is there any way we can create a message to show before running a BIP report with prompts in OTBI Content (required): Version (include the version you are u… -
Is there a provision to hide the formatted or Data option in OTBI?Summary: Feature to hide or unhide the formatted or Data option in OTBI Content (required):We have developed a report with the Pivot option. While exporting the data if …Venkateswaran Murali-Oracle 23 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Subject Area Contents/GlossarySummary: Is there such a document or Resource as a Glossary of what measures, attributes etc are available in each subject area. Content (required): I am constantly stru…Peter Downer 52 views 4 comments 0 points Most recent by Peter Downer Reporting and Analytics for HCM
-
Candidate Success of Hire ReportThis analysis displays candidate information such as past employers, education, certifications, and termination data like last position held and length of service. To ad…Dishti Malhotra-Oracle 53 views 3 comments 1 point Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
OTBI Publisher Report Job Skips even if there is data in the trigger and modelSummary: Oracle BI Publisher Report Job which is scheduled every 30 minutes gets skipped even if data is returned by the trigger Content (required): I have a scheduled r…User_2025-02-07-06-48-53-251 408 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
The specified criteria didn't result in any data.Good afternoon experts, could you help me with the following: An employee analysis is being created, when I consult some employee data, such as name, employee number it …
-
Changing Font color dynamically in rtf template is not workingSummary: Changing Font color dynamically in rtf template is not working Content (required): I am trying to change text font color dynamically. but it is not working. For…Manoj_Singh 240 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Where Close date is stored in tables?Summary: Hello, do you know where Close date is stored in tables? See image Content (required): Payroll Version (include the version you are using, if applicable): N/A C…Nicola Petri 26 views 3 comments 0 points Most recent by Tim Hopkins Reporting and Analytics for HCM
-
How to get Department of Level1 , level2 and level 3 position in position HierarchySummary: We have a requirement to fetch following fields in OTBI, Person Number Assignment Number Position Name Level1 Org: Populate department of the position One level…Raghavendra M 538 views 10 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "SET". (HY000)Summary: I am trying to create 2 reports: 1) Workforce Management - Worker Assignment Event Real Time:- Picking all person numbers with action names and effective date b…
-
BI Publisher Solution ? - Start Excel Preview only open: falseSummary: Hello R&A forum: Start Excel Preview only open: false mTemplate: C:\Users\john.white\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\tmp\tmp.xls mT…User_2025-02-12-15-41-59-245 1.6K views 0 comments 0 points Started by User_2025-02-12-15-41-59-245 Reporting and Analytics for HCM
-
Query to fetch existing and proposed information of pending transaction in oracle hcmSummary: We have a requirement to develop a BIP report to display the existing and proposed information of pending transaction like Promotion. Content (required): Need t…Meenakshi K 531 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Join multiple subject areas in AnalyticsSummary: Join multiple subject areas to have an outer joint result. Content (required): My users want a dashboard to show the percentage of the employees who set up annu… -
How to join two subject areasSummary: Hi we need to join worker assignment real time and documents of real time and may i know what are the join columns of two subject areas Content (required): Vers…AjayKumar Maddipati 43 views 2 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Fusion 22A/22B : Post P2T Issues in BISummary: Oracle has brought a big change in OTBI/BIP configurations during P2T where configurations will be copied to the Non-Prod instances from the Prod instances. Thi…User423246 74 views 3 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Max Effective Date Record on a Combined Subject Area ReportSummary: I need to be able to report on most recent employee addresses (HOME and MAIL) based on their maximum effective date from the Person Real Time Subject Area in an…Rohan Fernandes 15 views 4 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Bind OTBI Report to Requisition ID and Candidate IDSummary: BInding OTBI report to Requisition ID and Candidate ID Content (required): We have developed a report which calculates and displays the average score the candid… -
Agents sending out from test instanceSummary: We just received our 22A and received our first refreshes since. We applied the administrative settings to override the email and set notifications to none but …Shanna Oppenheim 24 views 6 comments 0 points Most recent by Gaurav F Reporting and Analytics for HCM -
OTBI Absence report shows different end dates on different browserSummary: Content (required): We have an absence reports which shows the employees absence. Absence type, start date and end date. However depending on which browser I us…Nicolas Vahman 65 views 9 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
OTBI Analysis > Time Displayed IncorrectlySummary: Hello All, I will appreciate your support on the following issue: The Start Time and Stop Time reported from the Time Device Machine are displayed correctly on …Bernard T 22 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
CASE when help for balance valueSummary: I have an OTBI analysis where I need to pull the sum of balance values for specific balance type between two dates. If an employee does not have that balance ty…Greg Rank 23 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Termination Headcount causing errorSummary: Reporting Experts - We are trying to build a simple OTBI that should list the managers (Any level: Level 1 or level 2) with the direct and indirect reports. Whe…Vijay Rajendran 43 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI formula needed for multiple IF THENSummary: I have a simple report that uses the subject area Workforce Management - Worker Assignment Real Time. The report contains Person Name, Job Code, Job Name, Depar…
-
Embed Report in UI AppSummary: Content (required): I am trying to add a report in the UI in the onboarding App- Is this possible to do? see image I tried using page composer but it doesn't gi…
-
How to map multiple columns from 2 different subject areas to one dashboard promptSummary: Hello everyone, I have 2 different OTBI analyses - 1 that refers to the Workforce Management - Worker Assignment Event real time and the other one refers to Wor…Vijay Rajendran 22 views 1 comment 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Dashboard Embedded into HCM Not ResponsiveSummary: Issue with dashboard running/completing that are embedded in HCM. The dashboards were working until a recent patch after 22A. Content (required): Hi there, We h…
-
Matrix ReportSummary: We have a created a matrix report using BI Publisher report.The requirement is to have the drill down also to view the deatils. Can someone please suggest how c…minati_behera-Oracle 12 views 0 comments 0 points Started by minati_behera-Oracle Reporting and Analytics for HCM
-
I am trying to learn how to determine what SQL is being issued in a Subject AreaSummary: I am trying to learn how to determine what SQL is being issued in a Subject Area. Any guidance is much appreciated. Thank you! Content (required): Specific anal…
-
Resume/CV extract from work history fields Using BI PublisherSummary: Has any one created a formatted resume report using BI publisher? I have a request to extracted work history entered by our employees who do not have resumes in…Charles Egegbara 1 view 0 comments 0 points Started by Charles Egegbara Reporting and Analytics for HCM -
Split OTBI analysis to multiple worksheet depending on certain columnSummary: Is there a way we can split an existing OTBI Analysis into multiple worksheet for each location Content (required): Version (include the version you are using, …