To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
What happened to OTBI Web Query(iqy)Summary What happened to OTBI Web Query(iqy)Content In older releases if we edit analysis and go to advanced tab we used to have option to download Web Query (iqy) for t… -
Static Financial Reports - Using Smartview FunctionsSummary Using Functions in Smartview for Static Formats Ex: BS, IS,CF etc.Content When we look at reporting tools available in fusion for financial reporting (based on G…
-
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleSummary After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleContent After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry… -
Oracle Smartview #MissingSummary Oracle Smartview #MissingContent Hi Does anyone know why I get #Missing in Oracle smartview? I am trying to query year 2014, actual from out of the box data and … -
OTBI - ApproverSummary OTBIContent In OTBI, using the General Ledger - Journals Real Time subject area, under what subfolder would I find the Approver details of an entry? Specifically… -
Enhancements listSummary Where to find the Enhancements listContent Where to find the Enhancements list for the coming releases?User_2025-01-28-07-47-26-775 44 views 5 comments 2 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF
-
showing project reference details in OTBIContent We are trying to union both Project Costing - Actual Costs Real Time and Payables Invoices - Transactions Real Time or Project Costing - Actual Costs Real Time a… -
Securing OTBI/BIP ReportsSummary Securing OTBI/BIP ReportsContent Hi All, One of our client has a requirement where they would like to give "Read only access"(no edit/create/delete even from BI …
-
Open/Close Ledger ReportContent Is there a report that can show when ledgers were opened and by whom? If not, is there a way to build this? Thanks, Dan
-
Out-of-box reports in all modules and customizing themSummary Out-of-box reports in all modules and customizing themContent Hi , In financials cloud,what type of reports are provided as out-of-box for all modules?Where can …
-
How does Oracle push pdfs from the cloud?Summary How does Oracle push pdfs from the cloud?Content The Oracle system is exporting PDF files but they come down with a .TMP file extension instead of a PDF extensio…User_2025-01-28-07-47-26-775 47 views 1 comment 0 points Most recent by User_2025-01-28-07-47-26-775
-
Setting Tab Names in Excel When Downloading an FRS ReportSummary Setting Tab Names in Excel When Downloading an FRS ReportContent I have 60+ Company (Balancing Segment) values. When I generate a report in FRS and then download…
-
Overall – New Multiple Pillar Oracle Cloud Implementation White Paper - November 2 , 2017, 10:00 a.mContent Submit your questions for the Overall – New Multiple Pillar Oracle Cloud Implementation White Paper session to have them answered during the live event. Post you… -
Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…
-
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle).Content This note provides information about Fusion OTBI R12 PB10 (… -
Account analysisContent Has anyone developed account analysis that shows the project number from April invoice line? i am not able to link GL , subledger and AP subject areas in OTBI to…
-
Invoice Approval and Notification InformationSummary Cannot find the table name for Invoice Approval and Notification InformationContent We want to extract details of Invoice Approval and Notification Information b…User_2025-01-22-19-25-44-650 69 views 3 comments 0 points Most recent by User_2025-02-05-11-38-57-253
-
Intercompany out of balance reportContent Hello Gurus we looking at developing the following report we are not using AGIS and we have one ledger only. we would like to get the account balance twice on th…
-
Payables - Reports & AnalyticsSummary Cannot view analysis created in draft sectionContent Hi , I've created an analysis,called Payables Trial Balances Real Time on a demo environment but I cannot vi…
-
Expression: Project Currency error when using dashboard prompt for project cross subject area real tSummary Error Codes: OAMP2OPY:G689FFB3:SDKE4UTF Expression: Project CurrencyContent wonder if anyone encountered the same issue when developing a new OTBI report using p…
-
how can you link project subject area to GL company hierarchySummary trying to link projects - cross subject area Real time to General Ledger Transactional Balance Real timeContent Checking if you know someone who can guide us on …
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…
-
Learn about the Executive Cloud Services (ECS) ProgramContent The ECS team is part of the Production Engineering & Operations organization and sponsored by Thomas Kurian, Steve Miranda, and Campbell Webb and engages with th…
-
Content Pack - Oracle Fusion Cloud (Financials, Supply Chain and Manufacturing)Summary Where can I find Content pack for Data Visualization / OAC for Oracle Fusion CloudContent hi there, Does anyone know where to find the content packs for data vis…User_2025-01-28-08-30-45-744 96 views 0 comments 0 points Most recent by User_2025-01-28-08-30-45-744
-
Filtering Out Zero Values in OTBI Pivot TableSummary Filtering Out Zero Values in OTBI Pivot TableContent I have a pivot table in OTBI that contains some zero balances. Is there a way to filter them out of the pivo…User_2025-01-30-00-16-17-628 48 views 1 comment 0 points Most recent by User_2025-01-28-01-14-15-052
-
Struggling to Find Expense Report Line DetailsSummary Can't Find Receipt Date and Number of Days in "Expenses - Expense Transactions Real Time"Content We are seeking the following fields for Expense Report Items: -R… -
FA Depreciation TimingSummary Post sub-ledger activity to a different periodContent Hello - Is there a way to force sub-ledger activity in one period to post in the GL in a future period? I h…
-
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re…
-
Tips and Tricks: Fetch Large Volume of Data using BIP in Oracle CloudSummary Tips and Tricks: Fetch Large Volume of Data using BIP in Oracle CloudContent Hi Experts, Recently I encountered a situation where I was trying to fetch entire Wo… -
BI Publisher Report Linking Account with NodeContent I'm trying to create a report in BI Publisher that displays account (Segment2 in the GL_CODE_COMBINATIONS table) with the account tree node. I can't find a table…