Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
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… -
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…
-
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…
-
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… -
How to CAST Char to DateSummary CAST Presentation Variable of Text to Date Prompt in FormulaContent Age Band on Line Manager Dashboard is based on CURRENT_DATE rather it should based on Dashboa…
-
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…
-
BI Publisher Excel Template preview failsSummary BI Publisher Excel Template preview failsContent I am new to the use of BI Publisher Desktop in Word and Excel to create templates for BI reporting. I have a rep… -
Defined Flex Field (DFF) & Person Count and Head CountContent We have created a defined flex field (DFF) for gender as we use different values from the default HCM gender field. The DFF has been placed into Workforce Manage…
-
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…
-
How to add any OTBI/BIP report in Simple User Interface - Analytics SectionSummary How to add any OTBI/BIP report in Simple User Interface - Analytics SectionContent Please suggest. How to add any OTBI/BIP report in Simple User Interface - Anal… -
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… -
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… -
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…
-
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 … -
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…
-
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 …
-
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…
-
Report for reverse terminationsSummary Report for reverse terminationsContent We are currently looking to build a report that has those who may have been processed as termination but then had the term…
-
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…
-
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…
-
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…
-
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…
-
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… -
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, …