OTBI
Discussion List
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…Gail Langendorf-Oracle 531 views 9 comments 4 points Most recent by Naveen_CCC Reporting and Analytics for HCM -
HCM subject area "Workforce Profiles - Library Objects Real Time" join questionHello. Any advice on how to join the HCM subject area workforce profiles - library objects real time to workforce profiles - person profile real time ? Not finding commo…Rich R. 11 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…Shahid Qureshi 01 11 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
SQL query to extract UDT tableHello, We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following. Can anyone suggest a …Ioannis Adamou 6.9K views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
GL Analytics dashboard in OTBIHas anyone created a GL analytics dashboard that they are wanting to share? I am trying to create a dashboard that gives our finance department/CFO all the information w…
-
Chart Labels mashing with line valuesSummary: Chart Labels mashing with line values Content (please ensure you mask any confidential information): I am building a dashboard using the BIP Online template bui…
-
Effective date for OTL Absences issueSummary Although an effective date is set via presentation variable values are counted by a different dateContent Hi everybody, I'm struggling with the following report …User_2025-01-31-17-16-46-301 86 views 8 comments 0 points Most recent by CHRISTINA TSIGKAKOU-Oracle Reporting and Analytics for HCM -
OTBI Report Access Issue – “Workforce Management - Processed Time Cards Real Time” Subject AreaHi Team, We are encountering the attached error when a user attempts to run an OTBI report developed using the subject area “Workforce Management - Processed Time Cards …Vignesh_Rajasekaran-Oracle 31 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec…
-
How do I view the cost center tied to a subinventory?Summary: The user wants to be able to view subinventories within Supply Chain Execution and view what cost center is tied to each. What is the navigation to see cost cen…
-
Funnel percentage Graph change to 100%Summary: How I change the Funnel view to have 100% percentage in each phase? As below in the first phase I have 5395, where I've expect o have until 100% percentage Cont…
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr …HRJon 71 views 4 comments 0 points Most recent by Saptadip Datta - DXB Reporting and Analytics for HCM -
How to restrict users from accessing cost centers that doesn't belong to them in FRS?I enabled a Segment Value Security Rule to restrict users from seeing cost centers that don’t belong to them. The users are correctly restricted in the Journals area — t…Jibin 11 views 1 comment 0 points Most recent by Global Oracle Support-Oracle General Ledger & Intercompany
-
OTBI Historical Talent RatingsHow do we report on Historical Talent Scores (Potential) in OTBI? I see that Workforce Talent Review - Talent Review Meeting Real Time subject area can be used to report…
-
will the goal setting date in UI reflect in OTBI reporting after 26ASummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr… -
User can't run Print Maintenance Work Definition Report from Scheduled ProcessesSummary: Content (please ensure you mask any confidential information): User is assigned the seeded role Maintenance Manager and has access to maintenance organizations.…
-
Payment method details in the tables on the providersSummary: I need to identify which Oracle Cloud Fusion table stores the “Default” and “Payment Method” attributes within the Payments section of a supplier's main site (s…Cristian Rojas 31 views 3 comments 0 points Most recent by Md_Anees-Oracle Payables, Payments & Cash Management
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeAs per the business custom requirement OTBI subject areas to be used are Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real time which is cc…Shahid Qureshi 01 11 views 0 comments 0 points Started by Shahid Qureshi 01 Reporting and Analytics for ERP
-
SQL query to get position in performance documentSummary: SQL query to get position in performance document Content (please ensure you mask any confidential information): Could you please advise on the SQL query needed…
-
While selecting Level XX values in FDI or OTBI it is populating cumulating values of preceding valueWhen we select Level 29 value in OTBI /FDI it shows 29 th level values and If we select Level 28 values it cumulates and shows previous values namely level 29 values als…Tanguturi Ajay kumar 1 view 0 comments 0 points Started by Tanguturi Ajay kumar General Ledger & Intercompany
-
OTBI: How do I use a non fact column in the Column Filter.Summary OTBI: How do I use a non fact column in the Column Filter.Content Hi, I have a requirement where i need to use a non-fact column which is Standard Working Hours … -
What is the recommended way to extract item data in bulk from Fusion Cloud(PDH) by External SystemSummary: What is the recommended way for an external system to extract item data in bulk from Oracle Fusion Product Data Hub (PDH) to be used with OIC. Content (please e…
-
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 482 views 7 comments 0 points Most recent by Aditi Sehgal Reporting and Analytics for HCM -
How to report on comments for Checklist QuestionnaireSummary: In OTBI, Workforce Management - Checklist Real Time, I am trying to find the column that shows what comments were made in the "Comments" field in the questionna…S. Johnson 91 views 13 comments 1 point Most recent by Alissa O'Sullivan Reporting and Analytics for HCM
-
When using Journals real time subject area the amount for a journal is getting doubledSummary: When I add the Journal Batch details folder columns, especially the 'Created By' field to the OTBI analysis, the amount gets doubled for the journal. This is ha…