OTBI
Discussion List
-
OTBI Reporting Performance issueI am using two subject areas Order Management - fulfilment lines real time & Shipping real time for oracle fusion OTBI report, as per the business requirement, inspite o…Shahid Qureshi 01 2 views 0 comments 0 points Started by Shahid Qureshi 01 Reporting and Analytics for SCM -
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 14 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM
-
Assets Descriptive Flexfield history trackingSummary Assets Descriptive Flexfield history trackingContent Can anyone confirm if the Assets Descriptive Flexfield values are history tracked. We have some asset attrib…User_2025-03-08-03-49-56-344 76 views 8 comments 0 points Most recent by Nakul Buradkar-Oracle Maintenance
-
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 …
-
dashboard for CXOSummary: is there any dashboard available by delivered for HR basis of AOR, they can data trends for all modules including core HR , Absence , Talent including learning … -
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 953 views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates?Summary: How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates. Content (please ensure you mask any confidential information): To…
-
Candidate Extensible Flexfields recruiting for Job Application specific candidate profileSummary: Hello - 26A release the ability to report off Candidate Extensible Flexfields in OTBI subject area - Recruiting - Recruiting Real Time under the Candidate > Can…Shanna Oppenheim 12 views 2 comments 0 points Most recent by Shanna Oppenheim 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 44.4K views 97 comments 120 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 486 views 9 comments 4 points Most recent by UchihaItachi 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. 14 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 8 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Annualized TurnoverSummary: Does anyone have a report for annualized turnover? I see questions from the past on this same topic and have not found one in the shared reports. The seeded fie…
-
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.5K views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
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 88 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 19 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 789 views 13 comments 11 points Most recent by UchihaItachi Reporting and Analytics for ERP -
Issue in fetching review_user_access column from PER_ALL_ASSIGNMENTS_M tableI’m trying to fetch the REVIEW_USER_ACCESS column from the PER_ALL_ASSIGNMENTS_M table in Oracle Fusion HCM, but I’m not seeing it populated. While terminating an employ…User_DNVLS 5 views 1 comment 0 points Most recent by Peeyush Chandel 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…