Public Sector
Discussion List
-
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 44 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
-
Budgetary Control Purchase Order Life Cycle Custom ReportSummary Use this report to analyze a purchase order life cycle and its impact on budgetary control balances.Content The Budgetary Control Transaction Life Cycle report i…Anne Wong -Oracle 134 views 0 comments 4 points Started by Anne Wong -Oracle 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 26 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 28 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 79 views 2 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Unable to view the Export option while accessing the OTBI report via infoletsSummary Unable to view the Export option while accessing the OTBI report via infoletsContent Hi Guys, I had created the independent OTBI Report with the report links and… -
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 52 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
List of all the recurring scheduled processes?Summary How to get a list of all the recurring scheduled processes?Content How to get a list of all the recurring scheduled processes?Yasmin Kennedy 61 views 3 comments 0 points Most recent by SankarBalu Reporting and Analytics for ERP -
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…
-
Table which captures the User-Defined Fiscal Classification CodesSummary I am looking for the back end table which captures the Manage Transaction-Based Fiscal Classifications Task DetailsContent Setup and Maintaince > Search Manage T…
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 36 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP
-
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …Doron de Jong-57089 165 views 9 comments 1 point Most recent by Ed Higgins Reporting and Analytics for ERP
-
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti…Koteswararao Yenikepalli 55 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX tableNageshwaran1 67 views 5 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudSummary Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudContent Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudNageshwaran1 21 views 1 comment 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Need Help with a Deep Link for RequisitionSummary Trying to Create Drill down from a Simple OTBI report to the Requisition ScreenContent Hello. Looking for some help on what we think is a simple deep link from a… -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site…Sarah Munro 12024679 94 views 2 comments 0 points Most recent by Sarah Munro 12024679 Reporting and Analytics for ERP -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Supplier Registration Requests Error tableSummary Supplier Registration Requests Error tableContent We are trying to build a BI Report to send out a notification to the Supplier creation requester whose Supplier…SRINIVAS JAMPANI 28 views 1 comment 2 points Most recent by Piyush Singh-Oracle Reporting and Analytics for ERP
-
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
Adding comments to FRS reportsSummary Add comments to specific cells in an FRS reportContent Hi All, Hopefully someone out there can help me with this, as its driving me slowly mad. We are currently … -
Security Role for Access to Payable Invoice Register ReportSummary I'm looking to setup a custom role that gives access to the Payables Invoice Register ReportContent It seems like I've given permissions that should be sufficien…David Rabalais 29 views 2 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
How to create custom XML output formatSummary How to create custom XML output formatContent Hi All, We have to generate a custom .xml output file from ERP cloud . How can we generate XML output file from BIP…Najeeb_ACN 89 views 5 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Electronic Purchase Order Submission ReportSummary Purchase Order submitted ElectronicallyContent hi Guys, I am creating a report for Purchase Order submitted Electronically. How do I identify PO is submitted ele…
-
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 64 views 3 comments 1 point Most recent by rajArun Reporting and Analytics for ERP