OTBI
Discussion List
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 371 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce…Yordan Oliveira 23 views 4 comments 0 points Most recent by Yordan Oliveira Reporting and Analytics for ERP -
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu…Yogesh Mhalgi 823 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…Sushan Peiris 71 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Count of attribute column in Learning Real TimeContent Hi there I want to have a count of an attribute column in Learning Real Time. For instance, I have a table with the names of the users and a course name. I want …Bobby Jourdan 20 views 0 comments 1 point Most recent by Bobby Jourdan Reporting and Analytics for ERP -
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 80 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ…
-
Cross subject area - on which facts are they joined?Content Hi there I have joined two subject areas - Expenses - Expense Transaction details real time - Workforce Management - Work Relationship Real time to get level 2 d…Anders W. Langholm 41 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …Sushan Peiris 1.2K views 3 comments 3 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for ERP
-
Risk Management Entitlements ReportSummary A listing of entitlements and the access points they are composed of.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file…Stephanie Golly-Oracle 82 views 2 comments 2 points Most recent by Matt Luscombe Reporting and Analytics for ERP -
Risk Management Results by Control Summary ExtractSummary For a specified control, show the last time it was run, by who and how many results it returned.Content * Download the zip file attached to this post * Unzip and…Stephanie Golly-Oracle 166 views 3 comments 3 points Most recent by Matt Luscombe Reporting and Analytics for ERP
-
Subledger Details resulting in Duplicate LinesContent I've created a subledger with details, but am noticing the lines are duplicating for my results. I've built the results in a normal table format as well in a piv…User_2025-02-11-07-08-23-440 65 views 1 comment 1 point Most recent by User_2025-02-11-07-08-23-440 Reporting and Analytics for ERP -
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…User_5F4G3 537 views 10 comments 0 points Most recent by User_2025-02-11-18-46-39-346 Reporting and Analytics for ERP
-
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh…Abhilash K - Deloitte USI 57 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…Vinod Kumar Mohanraj 37 views 2 comments 1 point Most recent by Vinod Kumar Mohanraj Reporting and Analytics for ERP
-
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking …Dhruvjoshi23 18 views 0 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei…Henry Cabrera 40 views 0 comments 1 point Most recent by Henry Cabrera Reporting and Analytics for ERP -
How to give an access to specific users to custom ess jobSummary How to give an access to specific users to custom ess jobContent Hello All, We have one custom report and we have created a ess job to it and now wats to give an…Koteswararao Yenikepalli 49 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Highlight duplicate values based on a value in another columnContent Could somebody help me with the following issue, please: In an OTBI report with data from the Enterprise Contracts module, I would like to highlight (eg. with co…
-
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic… -
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…Vinod Kumar Mohanraj 63 views 1 comment 1 point Most recent by SimonTomey Reporting and Analytics for ERP
-
What Role/Privilege grants access to edit Scheduled Agent "RUN AS" in OTBI?Content Does anyone know what Role/Privilege allows access to update the "Run As" field in a Scheduled Agent for an Analysis in OTBI? I've assigned the following to a te…Mike Burnett 28 views 1 comment 2 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for ERP -
Receiving - Purchase Receipts Real Time returns no data for ReceiptContent Hi, We have a requirement to create a report that provides details for Receipts. I'm trying to build the report using the Receiving - Purchase Receipts Real Time…User_2025-02-06-06-53-48-161 77 views 3 comments 3 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Add new permission to existing custom folder in BI CataglogSummary Error when adding new permission to existing custom folder in the BI catalogContent 'Assertion failure: !tAccountId.isEmpty() at line 282 of project/websecurity/…Hannah Dorman 34 views 5 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying …
-
BI Publisher report in Oracle fusion not completing after 21B upgradeSummary BI Publisher report in Oracle fusion not completing after 21B upgradeContent Hello Peers- Posting our experience with one of the BI Publisher reports after upgra…Dhruvjoshi23 74 views 11 comments 2 points Most recent by Dom Galano Reporting and Analytics for ERP
-
Analysis BI displays duplicate values in parametersContent This problem appeared on May 5th and disappeared with update 21B. All Analysis BI in our production instance showed the same behavior. We validated that the anal…
-
Invalid Subject Area Error in OTBI report creationSummary Invalid Subject Area Error in OTBI report creation using Create Analysis from simple logical sqlContent Hi, We are getting an Invalid Subject Area Error while cr…
-
Restrict users from sending reports to external email addressesContent Hi, As we know, Oracle allows to include the email address when adding a Destination for a report output in both OTBI and BIP reports. Is there a way to restrict…Madhu Chalamalasetty 196 views 6 comments 1 point Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP -
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…User_2025-01-30-20-59-13-989 70 views 2 comments 0 points Most recent by User_2025-01-30-20-59-13-989 Reporting and Analytics for ERP