Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
Resubmission Reason and Resubmission Status values in Manage Time cardsContent Hi All, In which column and table holds "Resubmission Reason" and "Resubmission Status" values. Navigation:Navigator--> My Client Groups-->Time Management--> Man… -
How to divide 2 column values from different group in rtf templateHi Experts, I have below xml file in which in want to divide (gender/empcount) from 2 different groups(G_1 and G-2) in simple we want to divide 2193/3399 and 1201/3399 t…
-
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…
-
OTBI Report to get capacity rule's booked seat from Learning ModuleHello Expert's, Want OTBI Report to get Booked seats from Capacity Rule in HCM Learning Module. Please check below navigation and Image. My Client Groups> Learning Catal…
-
Manage Administrator Profile Values ReportSummary: We are trying to Fetch the Module Name (Meaning) Can anybody Please advise for fetching the Module Name of Manage Administrator Profile Values Content (please e… -
How can give condition Sysdate betwee effective start date and effective end date in OTBI analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Oracle Payroll fast formula to fetch from VbyC tables?Summary: Can we access our own VBC records with a Oracle Payroll fast formula to fetch from VbyC tables? ex. PAY_VBC_VALUE_IDENTS_VL OR below picture list. thank you Con…
-
Query to get delayed payroll flowsSummary: Query to get delayed payroll flows - the ones which did not start on scheduled time Content (please ensure you mask any confidential information): Hi Team, Gree… -
OTL Audit Report HelpI am trying to create an analysis in OTBI to show the different versions of an employees timecard. I need to see the trail of the changes and when they were done. We are…
-
Workforce Management - Workforce Trends Real Time subject area data dictionarySummary: Workforce Management - Workforce Trends Real Time - metrics calculation We are using the Workforce Management - Workforce Trends Real Time subject area for tren…
-
Looking for System Usage MetricsSummary Reporting on who/when/how/what users are accessing in HCMContent Need to report on system usage and adoption rates for our HCM system with a focus on Employee an… -
Enrollment effective end date meaningSummary: Enrollment effective end date meaning Content (please ensure you mask any confidential information): Hello experts, I've created a report with the Learning Reco… -
how to report learners in waitlist otbiSummary: how to report learners in waitlist otbi Content (please ensure you mask any confidential information): Hello experts, we would like to create an OTBI analysis t…
-
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include… -
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne… -
How to set in OTBI report the difference between a variable (an input parameter) and a fieldSummary: How to set in OTBI report the difference between a variable (an input parameter) and a field Content (please ensure you mask any confidential information): Hi, …
-
CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank nameSummary: CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank name Content (please ensure you mask any confidential information): Hi Team, Greetings! …
-
How to run the report USOnlinePayslip from BI PublisherHi All, I need to run the report USOnlinePayslip from BI Publisher. I am not able to get the output whatever parameters I pass. I need to get the xml data of the output …
-
BICC VO for PAY_COSTS linking to XLA tableSummary: We are looking for a BICC VO that links the PAY_COSTS Table with XLA tables. This VO should bring in the segment details. Currently we are using PAY_XLA_COSTS_V…
-
We need fetech the status of Exist survey report how can i get in OTBI May I know subject area?Summary: Hi Team, We need fetech the status of Exist survey report how can i get in OTBI May I know subject area? Thanks, ajay Content (please ensure you mask any confid… -
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn…
-
Fetch competency catalog from subject area "Workforce profiles – Library objects Real time”Summary: Hi experts, we're trying to fetch the whole competency catalog using an OTBI analysis in the subject area "Workforce profiles – Library objects Real time". The …
-
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):… -
Transpose rows to columns for RatingsSummary: I want to show the ratings of two specific performance document section names in columns. I named the header like the section name. I used a "CASE WHEN" stateme…
-
Chart functionality in Word's BIP add-inSummary: I want to display data from different time periods on a radar graph, but I don't know the necessary setting Content (please ensure you mask any confidential inf…
-
How to Embed an HTML Page in XSL for Report Generation?Hello everyone, I'm seeking guidance on how to embed an HTML page within an XSL file to include it in a report. I have attached the HTML for context to facilitate unders… -
FAW native analysis with external dataHi, I was wondering whether or not we could use the native/pre-configured analysis provided by Oracle in the FAW console adding external data to these pre-configured rep…
-
to insert dynamic images in rtf template horizontallyHi, We have a requirement to insert the dynamic images in an RTF template horizontally. we are fetching the image from PER_IMAGES table, but currently the images are fet…
-
Is it possible to create an OTBI report that will show payment details by payment date and employee?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Multiple Values in PIVOT tableSummary How to have multiple values in Pivot tableContent Hi I want to have a pivot table where i want to show the Competencies in measure with competency type as Column…