OTBI
Discussion List
-
Cross-Subject Area Report with 'Security - Roles and Privileges Real Time'Content We are in search of a report that would require a cross-subject area analysis using Worker Assignment Real Time and Security Roles and Privileges Real Time. I am…User_2025-02-08-03-57-26-191 57 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
schedule a OTBI Report when data is thereContent Hi, I want scheduler to run only when report has data. I have developed OTBI Report. Can you please tell me how I can do it in BI and OTBI. Thanks, VijayUser_2025-02-07-19-03-14-525 23 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Update Customer Tax Profile - Fiscal Classification CodeSummary Update Customer Account's Tax Profile - Fiscal Classification CodeContent Hi All, To give you a background: We have new customer accounts created in our AR Syste…
-
Is there any OTBI report that I can run to validate the number if Item importedSummary Is there any OTBI report that I can run to validate the number if Item importedContent Hi, I used the FBDI template to load thousands of items. Is there any OTBI… -
Workforce Management - Workforce Trend Real Time pulling current employee typeContent Hello, I'm working on making a headcount report using the Workforce Trend Subject Area, but I've noticed the subject area is pulling the current employee type ra…User_2025-01-31-00-25-12-234 23 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Business Unit Headcount vs recognitionContent I am trying to create a pivot table to show headcount of business unit against our recognition values which employees have been awarded. So I can clearerly see a…User_2025-02-06-11-18-47-896 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to identify loops in the line manager hierarchyContent Hello, Does anyone have a report that they could share that identifies a loop in the line manager hierarchy i.e. an employee lower down in the hierarchy also man…Esther Hess 118 views 8 comments 2 points Most recent by Esther Hess Reporting and Analytics for HCM -
Report with null data between tablesContent Hello experts I've managed to make an interaction between 2 tables in OTBI DataModel. Then I need to create a report. The problem is the report does not show the…Pedro Teixeira 14 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Summary Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Content Hi, We have a requirement were we need to hide a Performance Ti… -
Query Absence Pending TransactionsContent Hello experts. I'm trying without success to create a report that gives me the history of transactions. Category - Status - to whom - initiated at - Approver (As…Pedro Teixeira 334 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need Training Calendar Report FormatSummary Need Training Calendar Report FormatContent We have a requirement where we need to present a training calendar to employees for upcoming ILT offerings month wise… -
Reporting on reversed terminationsContent Hi all, I have searched on this topic but have not found a working example of this report or confirmation that it can be done. Can anyone advise whether it is po… -
SCM – Using Manufacturing Cloud’s Library of REST Services, 13 January 2021, 8 a.m PT - Submit QuestContent Submit your questions for the SCM – Using Manufacturing Cloud’s Library of REST Services session to have them answered during the live event. Post your questions… -
How to Create an initiative with a dummy destination objectSummary Need a dummy initiative with a linked analysis(in OTBI) so that we can use this initiative in migrating midstream assignments from legacyContent We are trying to… -
How to modify existing OTBI analysis built using Logical SQL?Summary I am new to Logical SQL OTBI reports and want to know how to make modifications to an analysis once I created it using logiical? I have to add a new column and p…User_2025-02-05-23-02-13-475 297 views 10 comments 2 points Most recent by User_BUU5W Reporting and Analytics for HCM -
Change the language of the text in RTF template.Content Hi Experts, I am looking for a function for RTF template using which I can change the Language of the text. for eg: Orignal Data- English: One Thousand Two Hundr…Jaswant Prajapati 388 views 3 comments 1 point Most recent by Misbahul Khair Reporting and Analytics for HCM -
Who hasnt submitted a TimecardContent Hi all We have been live with HCM for a year and i have been tasked with providing a report that shows who has not submitted a time card. The seeded reports dont…Dawn Cawston - CPS 83 views 1 comment 0 points Most recent by SameerJain Reporting and Analytics for HCM -
Unable to access reports and analytics after userid changes in OTBISummary User no longer is able to access reports and analytics. Receives error 'Unable to reconnect (after 3 tries) to BI Presentation Server using the connection Id =BI… -
Number of receipts made in a periodContent Hello I am trying to find out the number of receipts made between certain dates, but I am struggling to find the correct subject areas, or BI tables which contai…Helen Thomas 33 views 2 comments 3 points Most recent by Helen Thomas Reporting and Analytics for SCM -
Unable to Combine 2 Subject Areas throws error.Summary I am trying to combine Compensation salary history and payroll element history Subject area it throws me error. If someone can help out or would appreciate if th…User_2025-02-07-09-10-02-492 53 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Converting what pulls through as text to a numberContent I have created a report in OTBI but the 'Displayed Input Value Meaning' is coming through as a text field rather than a number field and ideally I would like to …User_2025-02-06-11-18-47-896 936 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Invalid Payroll Transactions in the SubledgerContent We have been up for a year on Oracle and have had a very rocky go of it. We have about 50k (yep thats right) invalid transactions for 2020 in the subledger from …Rebecca McArthur 30 views 2 comments 0 points Most recent by Rebecca McArthur Reporting and Analytics for HCM -
Field School Empty in Subject Area “Workforce Profiles – Person Profile Real Time”Content Hello All, We have created the following report “Report Degree” which uses the subject area “Workforce Profiles – Person Profile Real Time” and the following col…Bernard T 76 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM