OTBI
Discussion List
-
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 25 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 574 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 901 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 -
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…Naga Varma 183 views 6 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for SCM -
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo… -
How can I export procurement contract rules?Summary: I need a SQL query to export procurement contract rules Content (please ensure you mask any confidential information): Version (include the version you are usin… -
What are the tables to view the Invoice Account Coding ID 2507811.1Summary: Which fusion table will have information of Initiate Account Coding, to write a SQL query Content (please ensure you mask any confidential information): Initiat…Ravi Kumar N 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Billing Dashboard OTBI AnalysisSummary: Can one of you share the OTBI Analysis shown in screenshots in new feature (23B) documentation (link below) ? Content (please ensure you mask any confidential i…