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
-
How to use the BIP Report Data Set (Sql queries) into the OTBI Subject AreaSummary: We have created a custom HCM OTL Roster report on the monthly basis based on the scheduler profile. We have to use these Data Set (SQL Queries) directly into th… -
Issues experienced when using agentsHi everyone, We have a reporting team member has raised a few issues when using agents for reporting. Below are the symptoms of the problem. The agent failing The agent …
-
Incomplete Time Card ReportSummary: The Business is running into issues with employees submitting time off through the Absence module that automatically transfers to the Time Card, but the employe…
-
BI Publisher report errors while running from Scheduled ProcessesSummary: Hello Team, Our technical team has developed a BI publisher report under Reports and Analytics—>Custom—>HCM folder. But when a user tries to run the same from T…
-
Calculate number of DAYS between two dates in XX YEARS XX MONTHS XX DAYS format in OTBISummary: We have a requirement in OTBI analysis to calculate the number of days between 2 dates in the following format – XX YEARS XX MONTHS XX DAYS. We have tried some …
-
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull… -
OTBI filter - Two columns don't matchSummary: Is it possible to create a filter (maybe a new column to calculate?) to only provide results if two columns don't match? I can't imagine it's a common thing, bu…
-
SQL Behind the Package FUSION.PAY_BALANCE_PKG.GET_VALUE_DBIWe are trying to debug one the issue in BIP SQL where they have used the FUSION.PAY_BALANCE_PKG.GET_VALUE_DBI to bring the data from this column. But wea re not able to …
-
Hide catalog and home options to usersSummary: Hide catalog and home options to users Content (please ensure you mask any confidential information): Hi Team, I have a requirment, in my organization under me …
-
When the employee open a report we need to send one email to same employeeSummary: When the employee open a report we need to send one email to same employee Content (please ensure you mask any confidential information): Hi Team, We have a req…
-
How do I join WLF_SKILL_CENTER_ITEM_DN to WLF_ASSIGNMENT_RECORDS_F?Summary: In HCM work life, I need to join a skill name to an assignment. WLF_SKILL_CENTER_ITEM_DN has SKILL_CENTER_ITEM_DN_ID and PROFILE_ID as possible keys to join to …
-
Workforce Management Subject Areas (Historical Role & Manager Data)Morning Everyone, I'm investigating a quirk with an OTBI report that we've recently developed for viewing various articles of information for new starts within our organ…
-
Report to get the Listing the existing reports with the subfoldersSummary: Report to get the list of all existing seeded and custom BIP reports Content (please ensure you mask any confidential information): Hi All, Greetings! Is there … -
document recordSummary: If I upload documents to document records, I want a report to show me the details of the document as entered into Oracle, the ability to filter by document type…
-
Can we use Line Manager Dashboard to build HR Dashboard by removing securityWe want to build HR Dashboard, however most of the metrics are already available in Line Manager Dashboard. So can we re-use Line Manager Dashboard by removing security …
-
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… -
How to remove null values in OTBI? If I change choice list to SQL, the Limit Values disappears.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…
-
How to Get Response Text for Performance Document QuestionnaireSummary: Have a report I pulled from Shared Reports as it gets me closer to what I am trying to pull, but it still leaves a blank in the Response Text section. I am tryi… -
OTBI external identifier not appearing when Department is selectedHello I am trying to get a specific external id type through OTBI. I've managed to do this using MAX (there are multiple types), but when I add the Department, position … -
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…
-
effective date dashboard promptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Run Payroll Costing Results - load column into FDI?Hello, Is there a way to take a column from the seeded Run Payroll Costing Results report and move that into FDI for reporting use? The need for it is stemming from payr…
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…
-
Can I make the parameters more dynamic so they show only values relevant to the management hierarchySummary: Can I make the parameters more dynamic so they show only values relevant to the management hierarchy in line manager dashboard? Content (please ensure you mask …
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
Trying to add a telephone number hyperlink like "tel:###" to an RTF template for BI email burstingSummary: I'm trying to add a clickable telephone number hyperlink like "tel:###" to an RTF template used for BI-Publisher email bursting. According to this, it should be…
-
Person security profile to restrict hourly employees in BIP reportsSummary: We have created a data role and person security profile created to display only Hourly employees In person security profile provided -- secure by AOR -- Respons…
-
Historical Date Reporting - BIPWhat would be the equivalent OTBI's SET VARIABLE PARAM_EFFECTIVE_DATE='2006-05-18'; in a data model. I am trying to create a BIP report where users can enter an as of da… -
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re…