OTBI
Discussion List
-
Cannot attach OTBI analysis for Learning InitiativesSummary: Hello there, I created an analysis but it's not appearing when I'm trying to attach. Can you pls help me on this? What am I doing wrong? Is there a process I'm … -
Housekeeping and purging processes for old files in UCM/WebCenterSummary: purge program is just purging records from interface table and not purging anything from Webcenter(UCM). we need to check with Oracle, does actually any of the … -
How to Refresh this analytics view MSC_ANALYTIC_FACT_ORD_V in Oracle fusion cloudSummary: Hi, We have created a custom report based on the analytics view MSC_ANALYTIC_FACT_ORD_V, however not all the plan records are retunred in this view. What proces…Gurujothi D 40 views 3 comments 0 points Most recent by Catherine Alequin Supply Chain Planning and Collaboration
-
SQL query to get the result of Recalculate Payroll for Retroactive ChangesSummary: SQL query to get the result of Recalculate Payroll for Retroactive Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Ca…Parag Hiremath 22 views 1 comment 0 points Most recent by Rutvija Butlekar Reporting and Analytics for HCM -
In an OTBI analysis, results are different for different usersSummary: In running an OTBI analysis, my manager and I get one set of full results. The user gets only the results that they created (expense reports). How can I see whi…JamesNau_OH 14 views 3 comments 0 points Most recent by Hitesh Jasuja-Oracle Reporting and Analytics for ERP -
OTBI Catalog - Application roles Not found on permissions screenSummary: We are trying to secure certain catalog folders to only be visible for Incentive Compensation Analyst, but that role is not available in the Application roles o… -
26D Quarantine Reports System UpdateSummary: The new process in 26D that quarantines reports with a 50% failure rate over a 24-hour period does not specify whether the user will still be able to view and u…MMS 10 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
BIP Report: How to set different decimal point based on countrySummary: How to set different decimal point based on country Content (please ensure you mask any confidential information): Is it possible to change the decimal point on… -
Report on Time zone Setting in Set PreferencesSummary: Is it possible to pull a report on the time zone setting within Set Preferences > Regional > Time zone Dropdown for a set of users? If it is possible to pull th…Nick Henderson 31 views 2 comments 0 points Most recent by Mohammad Afghanul Reporting and Analytics for HCM -
Bulk report to identify users and roles with access to custom BI Publisher reports.We have over 100+ custom BI Publisher reports across different folders under /Custom . We need an audit extract showing each report’s catalog path, directly assigned and…Sawan Choudhary 84 views 2 comments 1 point Most recent by Malik_Sikandar Reporting and Analytics for ERP -
Disciplinary and GrievanceSummary: I have a report meant to capture both active and inactive records for a specific value in the subject area of personal real time. Because the criteria is set to… -
OTBI Folder DisappearanceSummary: Is anyone experiencing folders disappearing in the catalog? I pulled a report to see what happened to the folder, and there is no record of it being moved or de… -
SQL Query to get Work Definition and resourcesSummary: Hi, Can anyone provide SQL query which will fetch Work Definition and the Resources linked to it? We have Work Definitions defined in Maintenance Cloud and want… -
OTBI–How to Display Only One Row per Learning Record Number When Multiple Assignment Statuses Exist?Hi Experts, We are developing an OTBI report using the subject area Workforce Learning – Learning Management Real Time. We are facing an issue where the same employee's … -
Is it possible to switch the display of an OTBI report to the Redwood view?Summary: I want the reports we create in OTBI to be displayed in the Redwood format. Content (please ensure you mask any confidential information): I want the reports de…SERGIO BARRETO 21 views 1 comment 0 points Most recent by Nathan CCC Reporting & Analytics for Sales
-
How to drilldown from GL Balances into GL Journal Analysis?Summary: The target analysis is not displaying the corresponding journal lines despite configuring Accounting Period, Ledger Name, and Concatenated Segment filters as “I… -
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr… -
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
What subject areafolder can I find details to report on Self Paced Learning-Event details?Summary: What subject area and folder can I find details to pull into an OTBI report on Self Paced Learning - Event details? We have our Events tied to a Course but when… -
Row limit for OTBi report extractSummary: As per our understanding current limit for rows in OTBi report is 25,000 rows in case of Excel output and 75,000 rows in case of CSV output. Is this limit has b…Mihir Shah 45 views 1 comment 0 points Most recent by HD - Fusion ERP-Oracle Reporting & Analytics for Sales -
How to create custom folders under General Ledger – Transactional Balances Real Time subject areaSummary: Hi All, There are custom folders created & included like '****_BANK' , '****_ACCOUNT' under the General Ledger – Transactional Balances Real Time subject area. …VenkatesanR-Oracle 29 views 2 comments 0 points Most recent by VenkatesanR-Oracle Reporting and Analytics for ERP -
Row limit for OTBi report extractSummary: As per our understanding current limit for rows in OTBi report is 25,000 rows in case of Excel output and 75,000 rows in case of CSV output. Is this limit has b…Mihir Shah 41 views 2 comments 0 points Most recent by Shiv.Singhal Payables, Payments & Cash Management -
Learning assignments not created from OTBI-based assignment profileHi Team, We built an OTBI analysis and used it for a learning assignment profile. The learners appear correctly in the OTBI analysis report, but no learning assignments … -
subject area for getting open pick slip detailSummary: subject area for getting open pick slip detail for OTBI report Content (please ensure you mask any confidential information): Version (include the version you a… -
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't…User_2025-01-31-00-25-12-234 501 views 9 comments 0 points Most recent by Ankur003 Reporting and Analytics for HCM