OTBI
Discussion List
-
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 2 views 3 comments 0 points Most recent by Saliha MAACHA Reporting and Analytics for HCM -
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…KirolosMagdy 121 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Can you help me to adding the name of the employee in this SQL query?Summary: Hello team! I have this code, but I don't know how to add the name of the employee. Could you please help me with that? Content (please ensure you mask any conf…Claudia Linares L 21 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Busting with OTBI as DataSource in a DatamodelSummary Error on Busting with OTBI as DataSource in a DatamodelContent Hi All, I am trying to use a OTBI Analysis/OBIEE sql as a source in a BI Datamodel. The Bursting i…User_2025-01-22-19-45-49-284 53 views 2 comments 0 points Most recent by Asif_T Reporting and Analytics for HCM -
How to display new EFFs in BI reports?Summary: I have made new EFFs in PIM to see datas in BI reports. So I marked the BI Enabled check-box from setup and maintenance, but still cannot display them in the re…Nano Kanazawa 41 views 4 comments 0 points Most recent by Nathaniel.Wilcox Product Master Data Management -
OTBISummary: Hello Everyone, Unable to access OTBI reports data, able to access BI reports using her current roles Thanks Krishna Content (please ensure you mask any confide…Krishna Sigilipalli 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Does User Interface Text affect OTBI/Notification labels?Summary: I'd like to confirm the range of impact when using the User Interface Text. Does it also affect the field names of OTBI or workflow notifications?Kana Kutsukake-Oracle 11 views 2 comments 0 points Most recent by Kana Kutsukake-Oracle Self Service Procurement -
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 21 views 3 comments 0 points Most recent by Thulasipriya K-Oracle Reporting and Analytics for ERP -
SQL Query to identify transactions stuck in Pending interface to costingSummary: Users had done Cycle Count Adjustment and before the transactions could get accounted the items were made 'Inactive' this was done across organization in past p…Rahul_M8SG8 576 views 6 comments 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
Arabic Text in PDF Output Not Bold and Font Does Not ChangeSummary: Hello everyone, I am facing an issue with generating PDF output where the Arabic text does not appear in bold, and the font does not change as expected. • The b… -
Subject area to pull checklist questionnaire in OTBISummary: We are trying to develop reports on questionnaires that have been configured for checklist. But when we are using "Workforce Management - Checklist Real Time", …Priyanka Ray 64 views 4 comments 0 points Most recent by Priyanka Ray Reporting and Analytics for HCM -
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can … -
How to change currency code language in Manage Project Budget?In manage project budget page, under Overview option, budget amount is showing in Arabic currency instead of English (as SAR). Please guide me how to change the currency… -
How to apply "Group By" Condition on a column - in OTBI Analyis?Content Hello Everyone, I have a requirement to apply "Group By" condition on OTBI analysis. I am applying this condition in under Advanced tab - Advanced SQL Clauses. B…Anil Pillaresetty 898 views 6 comments 1 point Most recent by gclampitt Reporting and Analytics for HCM -
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…Mostafa AboElhassan 201 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP -
report otbi general balances real time with hierarchieshow can i create a report balances with hierarchies in subject area? i can t see hierarchy -
SQL to get number of Grades in a Grade laddersSummary: I need SQL to get number of grades contains in all the grade ladders that organization is having. If anyone having it please share Content (please ensure you ma…Smitashree Pradhan 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to auto-increment the accounting period on Trial balance report in BIPSummary: We have General Ledger Trial Balance in BIP and every month, end user needs to change the accounting period. Is there a way to auto-increment the accounting per…TBIRD1 11 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Supplier PO Acknowledgment email customizationWe have implemented Supplier PO Acknowledgment email notifications via the BPM Worklist Task (DocumentAcknowledgmentRequestForAction). This task works as expected, but w… -
Custom OTBI report under "Open Table, Graph or Tile Set"Summary: Need the ability to view a custom OTBI report under "Open Table, Graph or Tile Set" Content (please ensure you mask any confidential information): I can see the…starsniper_11 11 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration