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
-
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet… -
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi… -
SUPPLIER AND PER [ERSO JOINING QUERYSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
What is the fast formula definition for Enterprise Hire dateSummary: I'm building a fast formula that will pull the Enterprise Hire Date of an employee for an eligibility profile. Need your help please. Content (please ensure you…
-
Total earnings inaccurate based on positions in Gross Earnings ReportI created an OTBI report include employees' 'Name', 'Position' and 'Gross earnings'. For prompt of time range, I use 'Pay period start date' and 'Pay period end date'. A…
-
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin… -
Position Grade Code and Position Grade Name not being populated in OTBIHi all, We have an issue that the Position Grade Code and Position Grade Name is not being populated in OTBI. The only field that is populated is "Valid Grades" and this…
-
HDL - DeleteSummary We are trying to remove Matrix Managers via HDL; but DELETE removes all historyContent Hello! We are implementing Matrix Managers and I've been tasked with updat… -
In Oracle Fusion HCM, eText template with UTF-8 character set converting space to special character.Hi Community, I am facing an issue in eText template with UTF-8 character set, whenever for a field if it has space as a value it's converting space to special character…
-
Need to get Original Start Date on Report with Data ModelSummary: We have a Change Report but need to add Orig. Start Date - OSD. The report is based on a Data Model and I'm not sure what the coding is for OSD or how to get th… -
Convert numbers to Arabic in wordsContent Hi, We have a requirement to convert salary numbers to Arabic. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, Nivya Version …
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…
-
Busting OTBI Myths - Reporting current and previous values side by sideContent Myth: You can't report current and previous values side by side One common example is reporting the current assignment values and the previous ones after an assi… -
Some Employee missing of the Reports on certain dateSummary: I want to explain the issue we encountered. On December 10, the HR team uploaded a change affecting all employees in a specific department, effective December 1… -
Query Regarding Adding a Secured List Table to Oracle BI Data ModelSummary: Query Regarding Adding a Secured List Table to Oracle BI Data Model Content (please ensure you mask any confidential information): Hello, I am working on a BI d…
-
sql query to get job level in oracle fusionSummary: 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 is Business_Group_Id in PER_ALL_PEOPLE_F a foreign key to HR_ORGANIZATION_UNITS which is a view?How does the BUSINESS_GROUP_ID column in the PER_ALL_PEOPLE_F table function as a foreign key to the HR_ORGANIZATION_UNITS view, given that the view is not a physical ta…
-
Copying OTBI reports in bulkSummary: Copying OTBI reports in bulk Content (please ensure you mask any confidential information): Hi Team, Greetings! There is a requirement to copy multiple OTBI Rep…
-
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …
-
BIP Query to get only base elementsSummary BIP Query to get only base elementsContent While creating elements, there will be shadow elements that will get created automatically. Is there anyway to get onl… -
Absence Calendar Details Real Time - Reporting on employee absences by daySummary This is a white paper to enable the customers to generate and render worker absences breakdown by day using the absence calendar details real time subject area.C… -
OTBI Analysis, Payroll - Calculation Cards Real Time - PAE - How do I show each linked assignment?Summary: I'm trying to create an analysis to report on employee Calculation Cards using Payroll - Calculation Cards Real Time and in the case of employees with multiple … -
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…
-
HCM Workflow ReportSummary All HCM transactions current status of the workflow and approval detailsContent Hi, I'm trying to create a report to display all HCM transactions Current status … -
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava…
-
Passing the parameter at run time from the URLI am creating a BIP report and want to pass parameters from the URL. For example, I have a report with a parameter for Assignment ID. When I open the report, it should l… -
How can I create a JSON file using BI PublisherSummary: How can I create a JSON file using BI Publisher Content (required): I want to create a JSON file using BI Publisher. I am able to generate the JSON format in th…