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
-
Newly created prompt by one user not seen for other userWe wanted all BUs to be by default selected when LM Dashboard is opened up. So we modified the existing prompt by removing the filter of selecting the topmost BU. When c… -
Unable to get the Enterprise Seniority Date Person level in OTBISummary: Hi all, I am not able to find the field related to Enterprise Seniority Date Person Level in OTBI using the subject area Workforce Management – Worker Assignmen… -
Filter null values on a DashboardSummary: Hi, I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example. If I use… -
Scheduled absences not showing in Absence OTBI ReportSummary: Hi All, Scheduled absences ("Workforce Management - Accrual Real Time"."Front-Loaded Plan"."Scheduled Absences") not pulling any data in my OTBI report. Could a…
-
How to bulk update location namesSummary: Need to bulk change location names and location codes. We have thousands of records but have not found an effective way to make these updates. Content (please e…
-
NULL values in OTBISummary: I think it is generally best practice to suppress NULL values in OTBI, but client wants to keep them in report. But in their case, it's selective. Can we enable…
-
How to find Legal Full Name in OTBISummary: Hi Team, we have Legal Full Name column in person details page but unable to find out in person real time ad worker real time. Please help me any one . Thanks, … -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
Headcount value 0 for some employeesSummary: I was comparing the headcount (the built-in fact) against the employee detail row wise data and the counts did not match. I noticed that some employees had the …
-
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…
-
Restrict insertion of salary records with no changesSummary: Whenever we do transfers, promotions, and local/global transfers that do not have any changes to salary, salary records get inserted and the inserted record app…
-
BI Publisher report that shows learning activities scoreSummary: Activity score not showing in BIP Content (required): Hi, I'm trying to build a BI Publisher Report with information about learning activities inside courses. I…
-
How to remove extra rows in report?Summary: Hello, I need help on removing these extra rows. These are my filters. Can you help to check what's wrong? Content (please ensure you mask any confidential info…
-
Element Entries Reports No Results on OTBISummary The specified criteria didn't result in any data ErrorContent Hello. I'm trying to report element entries on OTBI using the "payroll - element enteries history r… -
Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaSummary Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaContent Hi Expert, Not able get information in "Workforce Succ… -
Smartview Error - "Unable to get property 'open' of undefined or null reference'Summary: I get the following error when running a macro to generate a report in smartview: "Unable to get property 'open' of undefined or null reference. Any assistance …
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …
-
Drill down in OTBI Dashboard does not work correctlySummary: Drill down in OTBI Dashboard does not work correctly Content (please ensure you mask any confidential information): Hi, we created a Dashboard based on a OTBI R…
-
How to fetch attachment report from document of recordsSummary: Hi Team, How to fetch report for attachments of each employee. Content (required): Documents of records - Documents type- COVID 19 Version (include the version …
-
How to enable dynamic password while generating the payslipSummary: Hi All, Requirement: I need to make payslip dynamic password protected. For Example - Date of birth of the employee. Thanks. Content (required): I followed the … -
OTBI to BIP Table Mapping DocumentGood Day Experts, Are there any Oracle links which I can check and download the latest version of each OTBI Subject Area to BIP table/column mapping like: - HCM OTBI to …
-
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 … -
HR own position data not appearing for HR rolesSummary: Position Report is showing positions to the HR teams but its not showing their data Content (please ensure you mask any confidential information): I have a posi… -
How can we add Date Prompt to DB prompt without using column from Subject areasSummary: We need to add a Dashboard prompt for Start Date and End Date. These two fields are just a Date parameter. We dont want to use any OTBI analysis column. How can…
-
How to get the details like employee user name, person number and employee statusHi Team, We have requirement to see employee user name, person number and employee status in a report. Can anyone help me on this. Regards, Ravi -
Query to get Goal Approval StatusHello, For our report, we already have performance goals being listed in each row for every person. For each goals, we would require their approval status. However, when… -
what does below hint mean?Summary: SET VARIABLE OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_complex_view_merging'',''false'') GATHER_PLAN_STATIS…
-
Ability to submit Multiple Custom Bi reports(HCM) based on a single schedule (dynamic date param)Summary: We have multiple BI reports that take similar date parameters as input and produce different txt files as output. Since there around 60 unique scenarios we are …
-
Offer details are not getting stored in transaction table (HRC_TXN_HEADER)When an offer is sent for approval and after approval if the offer is "Re drafted" and edited then the table "IRC_OFFERS" is storing the latest data. Whereas i need to f…
-
How to add manager’s manager in OTBIWorking on a requirement to setup a report for any managers with incomplete performance documents. Eventually this will be sent as an alert to the manager and the 2nd le…