OTBI
Discussion List
-
BI - Seeded and Custom Folders Mirroring Each Other?!Summary: We are experiencing several custom template issues and have noticed that our Custom and Seeded Folders are mirroring each other without human intervention. Cont… -
Create a report that shows invoice data on day it was loaded?Summary: Hi everyone. I am curious if there is a way to create a report that allows me to collect data from an invoice on the day it was created. Such as Problem Type. I…User_2025-02-10-15-06-52-222 12 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the… -
What tables hold the project costs expenditure batch workflow details for creator and approverSummary:Does anyone know if this information can be reported on using BI Publisher or OTBI to view the approval workflow for project cost expenditure batches? This infor…Rich Merkel 256 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Restrict OTBI report data(using subject area) to logged in userSummary How to restrict OTBI report data(using subject area) to logged in user. Currently it shows all data. Data access given at Business Unit level for the role.Conten… -
What is Difference Between Secured and Unsecured Assignment Manager Folders in Workforce ManagementSummary: What is Difference Between Secured and Unsecured Assignment Manager Folders in Workforce Management - Worker Assignment Real Time Content (required): What is Di…Vijay Gorania 23 views 2 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for ERP
-
Invoices Report acccessSummary: creating have created a report using Payables Invoices - Transactions Real Time and Payables Invoices - Installments Real Time Content (required): creating have…User_2025-02-10-15-06-52-222 32 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OBIEE / OTBI Pivot Table Calculated % VarianceSummary: Need the equivalent of ABS in pivot table calculated column Content (required): In a pivot table presentation; - I have a calculated column; Variance which is e…User_2025-02-10-15-12-48-631 72 views 2 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP
-
Tax Registration from Supplier Address out of Supplier Real Time OTBISummary Looking for Supplier's Tax Registration Linked to AddressContent I'm building a supplier report inside the Supplier - Supplier Real Time subject area and attempt…Conrad the Supplicant 65 views 3 comments 2 points Most recent by Vikas Kanodia Reporting and Analytics for ERP -
How to get action link to pass parameter to 'Is Prompted' column when source column is calculated?Summary: Content (required): In Fusion Financials subject area; "General Ledger - Balances Real Time" I have been following the white paper to develop a dashboard based …User_2025-02-10-15-12-48-631 22 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 11 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Folder/Report Last Modified DateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 170 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Projects-Labor distribution Cost analysis is missing exception information for error rowsSummary: Projects-Labor distribution Cost analysis is missing exception information for error rows Content (required): We have analysis built on Projects-Labor distribut…Mona Mantry 11 views 1 comment 0 points Most recent by Mike Bartoletti-Oracle Reporting and Analytics for ERP -
Is it possible to have manual input option with LOV menu?Summary: Researching the ability to manually input bulk values while keeping LOV search functions. Content (required): When you open the search box for dropdown paramete…
-
How are you managing OTBI AgentsSummary: We have some analysis/dashboards that we want to schedule and send out as specific times using agents. Question is there any best practices around the managemen…amy hardtke 11 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…
-
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…
-
Account Description is as the code in General Ledger Analysis and error when the columns are addedSummary: Content (required): Trying to build up an analysis report but when extracting the account description it is the same as the account code. But in the value sets …Dian Minshan 42 views 1 comment 0 points Most recent by Dian Minshan Reporting and Analytics for ERP -
Document Number in OTBI Receivables - Transactions Real TimeContent I am building an OTBI report using Receivables - Transactions Real Time, and I'm looking for the column for 'Document Number'. Does anyone know if this column is…Brian Todd-Oracle 32 views 1 comment 0 points Most recent by Robert G Wilkinson Reporting and Analytics for ERP
-
OTBI - Convert Entered Amount to USD for Non Usd LedgerSummary: Is it possible to convert an Accounted Amount to USD for Non USD Ledger in OTBI (General Ledger Journals Real Time)? Content (required): I have business require…Hannah Dorman 232 views 2 comments 0 points Most recent by Hannah Dorman Reporting and Analytics for ERP
-
Need the table name for SOA Suite Audit Policy configurationSummary: There is a bug in the Transaction Console that allows someone to enable / disable approvals via the Bypass Approvals and this activity is NOT included any of th…Jeff Hare CPA CISA CIA 11 views 2 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly excuted) Is there any way to find. ThanksMohammed Rafi 31 views 2 comments 3 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Table(s) for Enabled / Not Enabled Functional Audit PoliciesSummary: Is there a table that contains the full list of functional Audit Policies that can be enabled / have been enabled already? Content (required): See PDF for scree…Jeff Hare CPA CISA CIA 11 views 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP
-
OTBI_EXM: No data for Transaction/Billed/Posted Amount Columns on corporate card expenseSummary: When querying corporate card expenses that have not been added to an expense report, no data is populated for fact columns Transaction Amount, Billed Amount, an…
-
In OTBI Report, can we have details in single row per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 33 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
Details about PrivilegesHi Team, Am looking for a report/ query to find details about privileges. We are looking for finding a what is the exact purpose of a privilege. Example: AP_MANAGE_PAYAB…Swapnil Kashid 12 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to audit the consumption of reportsHello, Is there a way we can view who is consuming OTBI and BIP reports? is there some sort of usage stat or which user is running the reports? Many thanks, JamesJames Coles 32 views 2 comments 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
R13 Higher Ed and Public Sector Cloud OTBI subject area to database lineage mapping spreadsheetSummary: This spreadsheet documents R13 Higher Education and Public Sector Cloud OTBI subject areas to database lineage mapping and subject area security Content: This s…Noelle Bartlam-Oracle 399 views 0 comments 1 point Started by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
BI publisher report show blank pageSummary: Hello i have customize report in BI and this report is work perfect with all user using windows and Firefox browser , but have one user is have MAC and Safari b…Mahgoub S.Mohamed 94 views 6 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
OTBI - General Ledger - Data extraction of Journal description details not populating for some linesSummary: OTBI - General Ledger - Data extraction of Journal description details not populating for some lines Content (required): A query is used to extract data from OT…User_2025-02-04-15-40-21-120 52 views 0 comments 0 points Started by User_2025-02-04-15-40-21-120 Reporting and Analytics for ERP