OTBI
Discussion List
-
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 22 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 536 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 61 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 900 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 203 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 181 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 32 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… -
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …Birley Varghese 564 views 4 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
R13 How to generate a Trial Balance from OTBISummary R13 How to generate a Trial Balance from OTBIContent Hello : I was wondering if you can share with me any document how to create a trial Balance from OTBI . As f…gabriel kinovisques-163562 138 views 3 comments 3 points Most recent by TBIRD1 General Ledger & Intercompany
-
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…KDR 273 views 6 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Can conditional formatting be applied to the total cell in BIP pivot layout?Summary: Can conditional formatting be applied to the total cell in BIP pivot layout? Content (please ensure you mask any confidential information): Hi Experts, I could …Volodymyr Faranosov 1 view 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Chart of Accounts Hierarchy Sort Order Field NameSummary: I'm building a custom BIP data model and report and I'm looking for the User-Defined hierarchy Sort Order field name info (table, field) schema = FUSION Content…Emile Helegbe 51 views 3 comments 0 points Most recent by Emile Helegbe General Ledger & Intercompany
-
People Group Segments Subject AreaSummary People Group Segments Subject AreaContent Hi All, In which subject Area I can find assignment people group segments while creating analysis ? Thanks.
-
Unable to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (please ensure you mask any confidential information): The…Sudhir Behera 11 views 1 comment 0 points Most recent by Yann Consolin-Oracle Supply Chain Planning and Collaboration