Public Sector
Discussion List
-
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…Kamran Butt-161785 25 views 10 comments 2 points Most recent by Kamran Butt-161785 Reporting and Analytics for ERP
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like …Dev Thota 103 views 6 comments 2 points Most recent by Mohamed AttiaAllah-Oracle Reporting and Analytics for ERP
-
SQL gives me wrong purchase order number for invoiceContent Hi, When I go into the front end of Fusion, I can see that an invoice number of 26427 only has 1 purchase number matched against it which is PO 911753 When I do …
-
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 67 views 9 comments 4 points Most recent by SantoshKumarB 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…Kamran Butt-161785 13 views 0 comments 1 point Started by Kamran Butt-161785 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…Kamran Butt-161785 35 views 4 comments 0 points Most recent by Kamran Butt-161785 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…Kamran Butt-161785 27 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…
-
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess …Koteswararao Yenikepalli 37 views 1 comment 3 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
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 …
-
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…
-
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…
-
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…
-
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 40 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…
-
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 …
-
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…
-
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…
-
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…Doron de Jong-57089 49 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 119 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 48 views 2 comments 0 points Most recent by Animesh Agrawal-79521 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…Doron de Jong-57089 19 views 1 comment 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP