Category 81
Discussion List
-
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 11 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM -
Records missing in OTBI Report for Purchase RequisitionsSummary: We in the process of creating a OTBI report for a customer and when we try to query all requisition data irrespective to the type( external/Internal) , all stat… -
How can we add Rehire column status in OTBI report? Is there any filed is there ?Summary: In a report we need to add rehire column status but there is no field to add this in OTBI report Content (please ensure you mask any confidential information): …
-
Historic values for pay_bank_accounts tableSummary: Historic values for pay_bank_accounts table Content (please ensure you mask any confidential information): This table has MASKED_IBAN field but when I change it…Stefano_Mazzocca 11 views 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
Navigate to the Connections Web Page from OTBIHi, is it possible to create an interaction in an OTBI column to link to the Connections page of a specific employee? I've tried passing the Profile ID parameter but doe…Francesco Cerioni 26 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there any SQL to help me identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
Workforce Performance - Performance Rating Real Time is not fetching ex-employeesSummary: "Workforce Performance - Performance Rating Real Time" subject area is not showing any ex-employees when i try to see their performance document info. When i ch…
-
otbi calculation only displaying whole numberSummary: Calculation is not showing the correct actual number (incl. decimals) Content (please ensure you mask any confidential information): Hi All Unless I'm doing som… -
Oracle FDI: Predictive Analytics for attritionsSummary: In FAW/FDI , any examples for predictive analytics for exit risk using HR Core subject areas? We see diversity analysis in demos but there is no catalog exists …
-
Need help finding OTBI Reports in Oracle Financials. List of report names provided in Summary.Trend indicator DSO(day’s outstanding) o Average days outstanding by month Average Invoice Day’s Current Average Invoice Days Overdue Average Invoice Dollars Current Ave…
-
AbsenceTimeEntryPVO - AncAbsenceType missing some valuesSummary: AbsenceTimeEntryPVO - AncAbsenceType missing some values that exists in base table HWM_TM_REP_M_ANC_ATRBS_V Content (please ensure you mask any confidential inf…Prakash Maram 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Few Absence records missing for an Employee in OTBISummary: Some of the scheduled absences are not showing up in the report. We cannot find June absence record but can see August absence record for the same person. Ran t… -
do we have any process for Area of Responsibility ?Summary: when we change the employee status from Active to Inactive under Area of Responsibility (RUI/Redwood )section , the employee access is still Active. But as we c…Shwetha_01 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to pull balances and carryover on a specific dateHi experts, we need to generate a report that would display/ pull the balances and carryover as of specific date (Jan 1 2025). Currently, analysis is not able to do that…
-
How to disable the download option of Increment Letter posted in DORSummary: We have requirement to post the Increment letter from custom BIP via extract to post in the DOR of employee. However we would like to have the option of downloa…
-
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…jpar 105 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Export to XLSX and avoid limitation for 65k rowsSummary: Content (please ensure you mask any confidential information): Hi there, I use Learning reports in Fusion. When I export a BI report that has more than 65K rows…Bobby Jourdan 97 views 12 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need sql for all Content including Catalog Item the Content is tied to from Learning moduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sivaram Injeti 22 views 3 comments 0 points Most recent by Sivaram Injeti Reporting and Analytics for HCM
-
Retrieve Department Hierarchy per User Assignment (with Effective Date)Summary: Hi everyone, I'm wondering if anyone has a query that returns the organizational department structure for users based on their assignment, while properly consid…Matheus Roberto 21 views 0 comments 1 point Started by Matheus Roberto Reporting and Analytics for HCM -
How to Find the Pension Scheme Name from the 'Benefits and Pensions' (BnP) Calculation Card in a BIPHello Experts, I am building a BI Publisher report to show employee pension details. I had a requirement, were I need to retrieve the Pension Scheme Name from the employ…
-
Repeat section in RTF and add total on each pageI have the following two tables in an RTF document: The first table displays data from the DM Header. The second table displays data from the DM Lines. The client has re…
-
Can anyone suggest me how can I pull Requisition Hierarchy in Report in fusion HCMSummary: I want to capture all approver in the report. Can anyone suggest me how can I move. Content (please ensure you mask any confidential information): Version (incl…
-
What is the specific report template to which 'Edit Work Relationship' transaction points ?Could someone please confirm which seeded report template and data model (DM) are being automatically utilized for the 'Edit Work Relationship' transaction? There are tw…Aseem Bhawalkar 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Participant Feedback Report RequestSummary: Does anyone have a good way to report on 360 participant feedback within a performance document? We've tried to use the Workforce Performance - Performance Rati…Anton Rzhanov 18 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Report Query to Fetch Participant (Matrix Manager ) as Reviewer in Perfofmance DocumentSummary: Can anybody Please share the query to Fetch details of Participant Name as Matrix Manager as Reviewer along with Review Period and Performance Documents in Perf…MilanMohanty 102 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query to fetch overall rating from Performance documentSummary: Hi All, Can you help me in sql query to fetch overall rating from the performance document? TIA Version (include the version you are using, if applicable): Code…ShawShankk 2K views 5 comments 0 points Most recent by Vikas.puppala Reporting and Analytics for HCM
-
Learning Records Real Time - Reporting on RecommendationsSummary: Trying to report on recommendations using the Learning Records Real Time subject area. It appears that a recommendation is an event which doesn't appear in the …Rob F 1 view 3 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
I embedded a BIP report in front end. But refresh button is causing problem.I embedded a BIP report in front end. But refresh button is causing problem. First I have to click apply and then refresh button (green higlighted) then only report is a…
-
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 20 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM