Public Sector
Discussion List
-
Add Segment Description to OTBI ReportSummary: We have a report that uses the subject area General Ledger - Journals Real Time subject area, and we want to add the segment description for our 5 segment. We k… -
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work… -
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 345 views 3 comments 3 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d…Abhilash K - Deloitte USI 53 views 0 comments 1 point Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Is the Oracle Analytics Cloud Professional Government is specific to the Government Cloud?Summary: Trying to determine its applicability to city government. Content (required): Is the Oracle Analytics Cloud Professional Government is specific to the Governmen…
-
Restricting a record if its already sent - Oracle Fusion ERP Cloud BI Report Requirement.Summary: We have a report requirement that once payments exceed $600 during a calendar year, we report to the downstream app within 20 days. Also, once a supplier has be…Abhilash K - Deloitte USI 51 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 40 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
How the system of Oracle Cloud save de period close information?Summary: I want to know if the system save the information of earning or loss of each period. Content (required): In our other system when we create the statement of fin…Jessica Yamilet Valdes Romero 41 views 1 comment 0 points Most recent by Jessica Yamilet Valdes Romero Reporting and Analytics for ERP
-
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 137 views 2 comments 3 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP -
Project Manager project reportSummary: We would like to build an OTBI report parameter that defaults to the current user as a prompt. Content (required): If i am signed in, I would like the report to… -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
Has anyone use SplashBi or Orbit Analytics before?Summary: We are reviewing some external vendor tools to work with Oracle EBS and want to know if anyone has used this before and can make some recommendations. Content (…michael.cordova 111 views 0 comments 0 points Started by michael.cordova Reporting and Analytics for ERP
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 239 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP -
General Ledger Transaction Listing ReportSummary Lists down all Journal Entries along with corresponding subledger detailsContent This is one single consolidated view of all the transactions in ERP. This report… -
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 312 views 0 comments 1 point Started by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
OTBI Costing - Receipt Accounting Real Time subject area missing a transaction type on filterSummary I am trying to create a report in OTBI to record items I can see withing Supply Chain Execution > Receipt Accounting > Review Receipt Accounting DistributionsCon…Sarah Munro 12024679 59 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve…
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 708 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…Sushan Peiris 98 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv…
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 48 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 210 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
Projected Cash Balances with Selected Installment Report KitContent The Projected Cash Balances with Selected Installments sample report provides Public Sector Entities visibility into their Projected Cash Balances once a Payment…Anne Wong -Oracle 45 views 2 comments 5 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo…
-
Substring Function in FRSContent Is it possible to use a Substring function in FRS reports? We have a requirement to Substring the Cost Centre values on one of our reports so I was just wonderin…
-
Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
-
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 26 views 1 comment 0 points Most recent by User_4A8FM Reporting and Analytics for ERP
-
Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersSummary Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersContent Need Logic to create below KPI's for Purchase RequisitionsWe have been trying to c…RAJESH M-226898 77 views 2 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…Nageshwaran1 111 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP