Public Sector
Discussion List
-
Amending SQL slightly brings me: ORA-01427: single-row subquery returns more than one rowSummary ORA-01427Content I am using Oracle Fusion, the finance/payables reporting side of things I have the following code: SELECT DISTINCT PHA.SEGMENT1 FROM AP_INVOICES…
-
Drill to Fusion from a BI Publisher ReportContent Hi, I have created a very useful data model that will allow our users to search for payments, what I would like to do is link the invoice numbers to oracle fusio…User_QEU3G 87 views 9 comments 4 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Public Sector - budget to actualsSummary Budget to Actuals reports in Public SectorContent Hello, Have any other public sector Oracle Cloud users developed a good budget to actuals report? We have one t…
-
Receiving Error When Prompting Values from Field Created from a Case StatementSummary Cannot function ship the following expression: EVALUATE. (HY000)Content I have created a Dashboard Analysis and Prompt from the following subject area: Subledger…User_2025-02-05-07-37-39-271 23 views 0 comments 1 point Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP
-
Access for General Ledger DashboardsSummary Cannot view data for seeded GL Analytics DashboardsContent Hello, What security role do I need to access the General Ledger Dashboards: Account Analysis, General…User_2025-02-05-07-37-39-271 55 views 4 comments 0 points Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP
-
Report to show all invoices, amounts, VAT and attachmentsSummary A report that will identify all invoices, with invoice amount and VAT amount along with a field that pick up the file attached name (including extension i.e. .pd…
-
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with…User_2025-02-05-07-37-39-271 88 views 14 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
Get the correct PO Number for an Invoice NumberContent Hi, We had some consultants in they wrote a large piece of SQL, of which the below is a small part. It's looking to get the correct PO number for a specific invo…
-
Multiple Parameter List - With 2 Column Values Concatenated (BI Publisher)Summary ORA-00909: invalid number of arguments message when executing report with multiple parms.Content It is a business requirement to have Cost Centre code and Descri…
-
Listing name of purchase order attachments in a reportSummary OTBI subject areas do not provide the filenames of attached documentsContent I need to produce a report that lists the names of all the attachments for purchase …User_2025-01-28-20-19-02-475 57 views 5 comments 0 points Most recent by MadhuVitta Reporting and Analytics for ERP
-
Data provided in subject Area Procurement - Purchasing Real timeSummary Data from Purchase Order Pre-processing Days inconsistentContent I am having difficulty obtaining metric information. I am working with OTBI and trying to get th…User_2025-01-28-20-19-02-475 83 views 0 comments 1 point Most recent by User_2025-01-28-20-19-02-475 Reporting and Analytics for ERP
-
OTBI - COA HierarchysSummary Only child level of hierarchy's are visible in OTBI - General Ledger - Balances Real Time Subject AreaContent Hello, I want to use the General Ledger - Balances …
-
Cost Center DescriptionSummary Link from GL_CODE_COMBINATIONS table to Cost Center DescriptionContent Using BI Publisher I need to get from the GL_CODE_COMBINATIONS Table to a Table which cont…User_2025-01-22-19-25-44-650 197 views 5 comments 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
How to extract Registration Number on OTBI?Content Hi I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'Firs…Aaron Leggett 61 views 2 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
How to Calculate MTD and YTD in Oracle BI Analysis ReportsSummary How to Calculate MTD and YTD in Oracle BI Analysis Reports using Project Costing Actual Costs Real Time and Project Control Budgets Real TimeContent Hi, I am try…Avesh Ganodwala-57885 246 views 2 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
Add Account Parmeter to Custom BI Puslisher ReportContent Hi Friends, I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create paramet…User_2025-02-03-21-33-20-159 52 views 0 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
Hide Operator (is LIKE (pattern match)) from dashboard promptSummary How to hide operator (is LIKE (pattern match)) appearing on Dashboard PromptContent Hi Experts, I have a requirement in my report to just show the heading and hi…
-
Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Summary Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Content Hello All Is there any Task to search (or) Report in oracle fusion …User_2025-02-03-21-33-20-159 45 views 2 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
Need Outstanding Purchase Order Details Report in oracle fusion R13Summary Need Outstanding Purchase Order Details Report in oracle fusion R13Content Hello All Is there any report in oracle fusion r13 to display outstanding purchase ord…User_2025-02-03-21-33-20-159 707 views 2 comments 1 point Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
PO Encumbrance Journal DetailsSummary PO Encumbrance Journal DetailsContent Hello All I need script to extract PO encumbrance and related journal line details in oracle fusion. Required Columns in qu…User_2025-02-03-21-33-20-159 44 views 0 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
Trial Balance report ends in error and no report is generatedSummary Trial Balance report ends in error and no report is generatedContent Hi All We regularly run the Trial Balance report for the entire financial year from schedule…
-
How to create a custom read online role to allow users to self serve reports that are segregatedContent Hi All I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segrega…User_2025-01-29-02-09-34-137 59 views 1 comment 1 point Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
Preparing a custom fixed asset reportSummary Custom report designContent Hi, I would like to create a custom fixed asset report.What data model should I select or create or how can I do that ?(BI Publisher,…Armagan Sahin-57534 201 views 1 comment 0 points Most recent by Jennifer Sherbrook - CNL Reporting and Analytics for ERP
-
OTBI Analysis merging columns when exporting to Excel 2010Summary OTBI has starting merging columns since R12 upgradeContent Hi Hopefully someone can help - since our recent R12 patch was applied, a number of our custom OTBI re…JennyB 143 views 2 comments 0 points Most recent by User_2025-01-30-21-01-20-715 Reporting and Analytics for ERP
-
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…
-
Uk compliant VAT report in r12Content All,We are trying to find a uk compliant report or processes/white paper that we can use to run our vat returns from, are you please able to point me in the righ…User_2025-01-29-02-09-34-137 41 views 1 comment 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
Customizing a standard reportSummary Customize option is not visibleContent Hi, I'm trying to customize "General Ledger Trial Balance Report ".I want to copy and save it under my custom folder for e…Armagan Sahin-57534 211 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Running an uploaded .RTF reportSummary Edited report cannot be run in the financial reporting centerContent Hi, I've downloaded a standard trial balance report and edited it.But when I try to run it I…Armagan Sahin-57534 35 views 1 comment 2 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP