Category 81
Discussion List
-
How do I create an aged report for open transfer orders in OTBISummary: I am trying to create an OTBI Analysis for Open Transfer Orders. We would like to see a count by destination, date, cost of inventory item and possibly the GL A… -
Difference between 2 dates - BI PublisherSummary: Hello, I'm trying to get the difference between 2 dates in BIP data model. The difference should present number of days between cmp.DATE_FROM and cmp.LAST_UPDAT… -
Data security grant assigned to a custom role is not workingSummary: I created a custom Hiring Manager role and assigned the data security policy "Hiring manager can choose position for positions in their position security profil…
-
SQL to fetch the Target Proficiency field in the Performance DocumentHello Experts, I am currently creating a report for Core Competencies, and I am having a hard time searching for this specific field in the performance document page Doe…Joliver Caangay 17 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Performance Management
-
Oracle criteria to identify BIP reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our BIP reports which are using ‘ORIGINAL_DATE_OF_HIRE’ column from 'P… -
Oracle criteria to identify OTBI reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our OTBI reports which are using ‘Enterprise Seniority Date’ column. S…
-
How to add oracle cloud url in RTF templateSummary: Am trying to add login url( oracle cloud url) from ask_deployed_domains table. when we click on link it is throwing error. {COLUMN_NAME} using this in address o…
-
"Taken Absences" field in "Front-Loaded Plan" shows not-yet-taken as well as taken absencesSummary: We have front-loaded accrual plans for annual leave and have a requirement to report on taken absences at the end of each month. The "Taken Absences" data item …Michelle Hughes 9 views 2 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Redwood: Can we make Title mandatory in Refer Candidate Page under Opportunity MarketplaceSummary: Redwood: Can we make Title mandatory in Refer Candidate Page under Opportunity Marketplace Content (please ensure you mask any confidential information): Under …Twinkle Dudani 10 views 1 comment 0 points Most recent by Sherin S-Oracle Recruiting, Opportunity Marketplace
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
OTBI report is erroring outSummary: An OTBI report is giving error. Would appreciate if anyone can share your inputs. Content (please ensure you mask any confidential information): Version (includ…Global Support Desk 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI report for compensation plan is giving errorSummary: An OTBI report developed for a compensation plan is giving below error for few users. For other users, it says there is no data. But in edit mode, the report is…Swetha Kesireddy 17 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 68 views 2 comments 0 points Most recent by Eric-Oracle Reporting and Analytics for HCM
-
Role assignment historySummary We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that user was term…Srihari Manian 13 views 2 comments 0 points Most recent by Srihari Manian Reporting and Analytics for HCM
-
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…Sovan Mishra-Oracle 537 views 10 comments 0 points Most recent by Lakshmi Neelima Gollapalli Reporting and Analytics for HCM
-
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t…Thulasi Ram 487 views 6 comments 0 points Most recent by Lakshmi Neelima Gollapalli Reporting and Analytics for HCM -
I am looking for a report to validate or find missing goals in PerformanceSummary: I am looking for a report where it has Employee number, Name, Performance Document Name, Goal Period Name, manager, and Goals Status(Has goals or No goals ) Con… -
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu…Vishal Purohit 8 views 1 comment 0 points Most recent by NamrataPhukan Reporting and Analytics for HCM -
Saved but not submitted Promotability assessment questionnaire responses from Talent assessmentWe are trying to report on 'saved but not yet submitted' Talent Assessment Manager evaluation responses, using multiple avenues but not getting intended results. Subject…
-
Absence Plan: Monthly Accrual That Expires at Month-EndHi, I want to create an absence plan where each employee receives 1 day of leave every month (this part is clear for me). The requirement is that if the employee does no…
-
Populate if an employee is a Manager in HCM OTBISummary: I'm trying to create a report in OTBI with the subject area Worker Assignment Real. And in the Worker Assignment folder there is Manager Flag. However all our p…
-
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette… -
SQl query to find Default and Override Formula in HCM Compensation planSummary: SQl query to find Default and Override Formula in HCM Compensation plan Content (please ensure you mask any confidential information): Version (include the vers…Annam Rama Krishna 7 views 0 comments 0 points Started by Annam Rama Krishna Reporting and Analytics for HCM
-
How to create custom employee role that only gives read-only access to payroll documents of record?Summary: We have a requirement, for a specific group of employees, to create a custom employee role that solely gives read-only access to payroll Documents of Record (th…Michelle Hughes 11 views 2 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Convert Double Data Type to Words in OTBISummary: I am trying to build a report (OTBI analysis) where a double data type field (the Amount column) needs to be displayed in words. For example, if the amount is 3…Nur Anisa Zulkhairi 29 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Generate Payslip - Archive Information and Generate Report ErrorSummary: When i ran Generate Payslip, The Archive Information and Generate Report log status are Error. Content (please ensure you mask any confidential information): I …Pablo Calizo 137 views 5 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM
-
Logical SQL not returning dataSummary: I have built a report using logical SQL is not returning expected data - possible subquery issue Content (please ensure you mask any confidential information): …Helen Thomas 46 views 13 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Custom report is not triggering automatically after the Make EFT Payment process is completedSummary: Actual Behavior: Custom report is not triggering automatically after the Make EFT Payment process is completed (following upgrade to 25C). Expected Behavior: Re… -
Can you help me with sql query to fetch performance feedback comments ?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…VenuJayanth_21 10 views 2 comments 0 points Most recent by VenuJayanth_21 Reporting and Analytics for HCM
-
Unable to show the image file from UCM server in BIP report in pdf output (in html its comming )Summary: We are storing signatures in Document of records and we need to pull these signatures in the report output which is in pdf format. Content (please ensure you ma…