OTBI
Discussion List
-
Apply customer hierarchy to receivables subject areasSummary We are trying to build reports from the Receivables subject areas that can rollup values based on the CDM Customer HierarchyContent We have established hierarchi…User_2025-01-28-18-21-52-276 53 views 2 comments 0 points Most recent by Anjula Mittal Reporting and Analytics for ERP -
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.… -
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Approval Hierarchy and Position Tree ReportHi everyone, I'm looking to build a report that includes approval hierarchies based on position trees defined in the Manage Position Trees setup, along with the related …
-
Assignment Category was Limbo (PRN) for entire yearSummary: I have a requirement to identify employees with an Assignment Category of Limbo (PRN) throughout the entire year 2025 or until their termination date in 2025. I…
-
Is there an easy way to add the infolets from classic Inventory Management page to Redwood page?We are going through the process of enabling Redwood pages for Inventory Management. We have enabled the Redwood Inventory Management landing page but noticed that the i…
-
Job Offer DFF values not appearing in OTBISummary: We are trying to pull a Job Offer Descriptive Flexfields (DFFs) OTBI report for India, the values are appearing blank. Interestingly, we can see the correct val…
-
OTBI Learning Records Real Time Subject Area: Example reportshttps://community.oracle.com/customerconnect/discussion/647682/learning-records-subject-area Summary: Workforce Learning - Learning Records Real Time Subject Area Provid…Abdul Rauf Mohammad-Oracle 5.6K views 51 comments 21 points Most recent by Abdul Rauf Mohammad-Oracle Learning
-
How to Obtain History of Last Updated Date and Owner for ReportsSummary: How to Obtain History of Last Updated Date and Owner for Reports Content (please ensure you mask any confidential information): Is there a way to obtain a list …
-
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 593 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Syntax Error in OTBI AnalysisSummary: Syntax Error in OTBI Analysis Content (please ensure you mask any confidential information): Hi, I'm trying to create a new OTBI Analysis. I selected "Workforce…Barile Alberto 3 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for HCM
-
Explain Differences in Payroll Balance Core Assignment and Core Relationship RunsSummary: When reporting using Subject Area Payroll - Payroll Balances Real Time, could an expert please explain the differences in the following Base Dimensions: Core As…
-
Notification upon Assigning Expense Report to AuditorContent Hi All, Does anyone know if there's a task notification sent to either BPM or email once a user has an expense report assigned to them for auditing? I don't see …
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Requisition PDF Report With Data Model Not Showing in the email notificationSummary: We have customized the RTF file for Requisition PDF Report With Data Model and can view the customizations in the Purchase Requisitions/My Requisitions/View PDF… -
track the Non catalog request history in Learning Assignment pageSummary: Hi Team, User able to request for the non catalog request and learning team able to edit the assignment and change the non catalog request to the catalog and ac…
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. …Pranita S 98 views 3 comments 0 points Most recent by Judith COLLONGUES Reporting and Analytics for ERP
-
Analysis - subject area : “Compensation - Workforce compensation Real Time” -Summary:I’ve created a analysis with the subject area : “Compensation - Workforce compensation Real Time” to retrieve compensation worksheet information. The amount disp…Olivier Guillouf 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Why I am not able to see prompts when I navigate through Reports & AnalysisI created an OTBI report in Accounts Receivable with prompts. When I access the report through Browse Catalog, the prompts appear as expected. However, when I navigate v…
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.5K views 11 comments 0 points Most recent by Alok Suraj-Oracle Reporting and Analytics for HCM
-
Error while downloading BIP Report in Excel FormatSummary: We are getting error while run a BIP report and try to export in Excel and other formats. When we do the same in Interactive mode no error is coming IO Exceptio…Sanglap Kundu 21 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Catalog object privilege validation failed for userSummary: Catalog object privilege validation failed for user Content (please ensure you mask any confidential information): Have downloaded a seeded report for HCM. When…Junade_Shujaat 23 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Modify New Hire State Report Template for USSummary: We have a requirement to include few extra columns in the delivered New Hire State Report for US. I would like to understand if we are allowed to that? Previous…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…
-
Report to compare Supplier encumbrance + spend?Summary: Has anyone had luck creating a report of total encumbrance (PO amount) against supplier + total spend against supplier? I tried utilizing OTBI Purchasing Real t… -
Reporting on SCORM & HACP Learner Interactions in Oracle LearningSummary: Learning departments often want to understand how learners are responding to questions included in their SCORM-based courses, to assess whether there are proble…