OTBI
Discussion List
-
Customization of Purchase Requisition Approval EmailI am currently trying to customize the purchase requisition approval email template. I need to add additional text to the email body and modify the subject line of this … -
Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data…Mohit Gupta-45440 996 views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Supply Chain Cost Rollup Real TimeSummary: Customer enabled the Perform Standard Cost Rollup Across Multiple Organizations feature and created supply chain cost rollup enabled cost scenario. A cost rollu… -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…Julian Challenger-Oracle 45.9K views 97 comments 121 points Most recent by MukeshBabu-Oracle Reporting and Analytics for HCM -
Join GL and RCV_TRANSACTIONS in Fusion/ERP CloudSummary: HI All, We are looking a solution to create a SQL query for BIP report to Drill down Join from GL To RCV_TRANSACTIONS in Fusion/ERP Cloud where JE_Source='Recei… -
Is there any way to track Tile clicks by Users in HCM ?Hello Experts, Has anyone implemented or come across a supported method in Oracle Fusion HCM to track how often Home page tiles (e.g. Team Activity center) are accessed … -
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 532 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 13 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