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
-
BI Report on candidate interaction date as per applicationNeed BI Report on candidate interaction date as per application. Code Snippet (add any code snippets that support your topic, if applicable): -
FTE and Headcount no longer in per_all_assignments_m tableSummary: Is there a reason why FTE and Headcount no longer in per_all_assignments_m table? Content (please ensure you mask any confidential information): Version (includ… -
Issue with number of direct reportees in OTBI reportHi All, Facing issue with number of direct reportees, its showing inaccurate direct reportees. Logic for direct reportees →COUNT("Assignment Manager List Unsecured"."Per…
-
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
Query to join BEN_PRTT_ENRT_RSLT to Payroll Tables (PAY_RUN_BALANCES)Summary: Hi experts, Just wondering if there's a way to connect the benefits table BEN_PRTT_ENRT_RSLT to payroll table (ex. PAY_RUN_BALANCES). We have a BIP report requi…
-
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says …
-
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in…
-
City, County names are not matching in wage basis rules page with the manage geographies.We have tried to create a report to fetch the details(city, county, primary and secondary classification) from the wage basis rules page but when tried to fetch particul…
-
Where can I find CFDI data for ReportingSummary: I want to know subject area and fields for the following data . This is for Mexico localization CFDI Contract Type CFDI Work Schedule Type Social Insurance Redu…
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…
-
How to obtain a drill down OTBI bar chartSummary: How to obtain a drill down OTBI bar chart Content (please ensure you mask any confidential information): Hi, we created a dashboard based on a OTBI Report. The …
-
Is it possible to use an EFF in a case statement in OTBI?Summary: I am working on a report trying to calculate days between LOA End Date and the Estimated RTW Date (EFF) in the system. The case statement is producing an error,…
-
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…
-
Extract name field from transaction console pageTransaction table for extracting the Name field in transaction console. Please assist
-
BI Publisher Sending a report to FTP Server with SSHSummary: How do I schedule a report to be delivered to a destination configured with SSH authentication? Content (please ensure you mask any confidential information): H…
-
Issue with formatting totals in OTBI Analysis TableSummary: I have a simple analysis coming out of the Benefits - Enrollments Real Time Subject Area. I have set the Department Name as a Table Selection. I have formatted … -
Fast Formula for Matrix Manager in Compensation Plan HierarchySummary: Hi, We have the below requirement for Compensation hierarchy: If Country of the Employee is Poland, the hierarchy should be the other manager type (Comp manager…
-
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…
-
Drill Down in the OTBI does not work correctlySummary: Drill Down in the OTBI does not work correctly Content (please ensure you mask any confidential information): Hi, we created an OTBI report. The extracted data …
-
Benefits Override Eligibility reportSummary: Is there a way to report on the employees and benefits that have been Overridden using the Override Eligibility in Benefits please. Content (please ensure you m…
-
OTBI skills proficiency levelHi all, We need to take the gap between the Proficency Rating and the Required Proficency Level for the employees. We are looking for this fields in the OTBI: We are usi…
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…
-
AAP Promotions ReportSummary: We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current p…
-
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a… -
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def…
-
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'… -
How can I get the Home Address from the Person Management\Person area on a ReportSummary: I have the mailing address, but need the home address. Content (please ensure you mask any confidential information): Version (include the version you are using… -
SQL query will not return an expected row in larger reportSummary: I have a report that returns employees who were referred and by whom, connected to their application and based on the referral to a specific job. There is an od…
-
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊