OTBI
Discussion List
-
Viewing secured views for Oracle delivered reportsContent I am reviewing some of our delivered reports and am noticing what I believe to be an issue with our secured views. Specifically, I noticed that users can see the…Evan Lehrhoff 30 views 3 comments 0 points Most recent by Evan Lehrhoff Reporting and Analytics for HCM -
MATERIAL TRANSACTION: REFERENCE SOURCE TYPESummary INV_GENERIC_DISPOSITIONS HAS NO DATAContent Hi All, I need to get the reference number for each transaction. like for example sales order and it is reference num… -
How to add bin as prompt?Summary How to add bin as dashboard prompt?Content We have created a column, Position Status, on a position management analysis based of a calculated measure we created,…Aja Nealley 43 views 5 comments 2 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 969 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
Unable to fetch OTL Data from "Workforce Management - Worker Compliance Results Real Time" SubjectSummary Unable to fetch OTL Data from "Workforce Management - Worker Compliance Results Real Time" Subject area.Content Hi , I am trying to fetch the data from "Workforc…Dharmendra Jha 17 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
Create a ORC Report with Records having hyperlink to ORCSummary Hyperlink to candidate ProfileContent Hi All, I have a requirement where I need to create an ORC report with candidate data. This report should have a hyperlink …Vibha Pandey - Oracle 48 views 4 comments 0 points Most recent by User_GIUF2 Reporting and Analytics for HCM
-
Application Composer helpSummary Display BOM components on custom pageContent Hi, We have a requirement to show the component items for user entered BOM on a custom page and perform some update …
-
Report of Assignments in a flowContent I was hoping to have a report of assignments within a flow so that we can use that as the basis to check whether people will be paid during the calculate payroll…Sharon Harper 35 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,…User_KOLMZ 1K views 7 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Conditional Format - a detail field to a summarized fieldContent I have an analysis report where I list all the active positions and their FTE along with the employees assigned to those positions and their FTE. I want to compa…Annette M 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Training Needs AnalysisContent Anyone can share the Training Needs Analysis samples report developed in Oracle HCM?Chris Ding 167 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Price override and adjustments are not working on sales order lineSummary Price override and adjustments are not working on sales order lineContent Price override and adjustments are not working on sales order line. Though I did a pric…
-
Address Audit ReportSummary Looking for a report with employee address changesContent Hi, Does anyone have a report that shows all address changes for an employee? Would want to see before …
-
How to delete an asset with Change in Cost Bonus rule tagged to the asset?Summary How to delete an asset with Change in Cost Bonus rule tagged to the asset?Content Hi Experts, Any suggestions on "How to delete an asset with Change in Cost Bonu…
-
'Import Projects' ESS job is not coming in Search ResultsSummary 'Import Projects' ESS job is not coming in Search ResultsContent HI TYeam, We are importing Budgets using FBDI File for which we need to submit 'Import Projects'…
-
Folder permissions in OTBIContent Hi there, Does anyone have any documentation to summarise each of the folder permissions in OTBI (Full Control, Modify, Open, Traverse, No Access, Custom) and wh…JosieAppleby 325 views 5 comments 0 points Most recent by JosieAppleby Reporting and Analytics for HCM
-
Cloud Financials on Macbook / Mac OSSummary Is Oracle Cloud Financials supported on Macbooks/MacOS?Content Hi, I'm posting to find out what level of support is offered for Cloud Financials on Macbooks/MacO…Rehan Yusuf 89 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP -
Unable to see data correctly after combining multiple subject areas in OTBIContent I have combined 2 subject areas and from the Advanced Tab and clicked on dimensionality and applied SQL. But the data is not showing up correctly.Vatsala Bharadwaj-Oracle 28 views 1 comment 1 point Most recent by Krushna Sahoo-Oracle Supply Chain Planning and Collaboration -
OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysSummary OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysContent Hi Friends, I have been working on this report and finally get it working now. …Mansur Khalil 89 views 7 comments 2 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Sample OTBI Dashboards and Reports - Supporting VideosSummary 4 videos to explain how to get the most value from the sample contentContent For anyone new to OTBI or familiar with the sample pack of dashboards and reports th…Caroline Gladwin-Oracle 998 views 23 comments 9 points Most recent by Anita Reporting and Analytics for HCM -
Employee Hierarchy - Fixed Hierarchy Level is always zeroContent We have loaded employees' and managers' data populated in the resource object and running the ESS job to populate the employee hierarchy. I see manager hierarchy…Srinivas Malyala-Oracle 38 views 2 comments 0 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales
-
Multiple Conditions CASE StatementSummary Build a case statement to include ELSE conditionContent Hi, Please see the attached formula logic. I am trying to build out this formula for multiple locations b…User_2025-01-25-03-46-43-745 292 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM