Reporting and Analytics
Discussion List
-
Can i link 2 report in a dashboard that has 2 different subject area?In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report fil…Omran Zeaiter 32 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
Requirement send standard GL Trial Balance Report output to Sftp server directorySummary: We have a requirement that the standard GL Trial Balance report output will be uploaded directly to more secure sftp server directory. There will be separate fi…Naga Peddiraju Chennu 11 views 7 comments 0 points Most recent by Prassanna_Srinivasan Reporting and Analytics for SCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 114 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM
-
Need help locating "Trading Partner ID" fieldSummary: Need help locating "Trading Partner ID" field, to include in either BIP or OTBI reports. Content (required): Need help locating "Trading Partner ID" field, to i…Andrew_Schmitz 228 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM -
Is there any standard Oracle reports for reconciling Receiving Inspection account?Summary: Content (required): We're looking to see if there's any standard Oracle reports to help reconcile receiving inspection account and review whether there are any …User_Z9TD7 23 views 2 comments 2 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Can I create a dashboard using multiple Oracle BI Publisher reports ?Can I create a dashboard in Oracle BI Publisher that combines data and visualizations from multiple BI Publisher reports? Specifically, I'd like to include graphs and ba…
-
Delay in BOL Report generation in production environmentSummary: One of the user (UserA) is encountering a delay in BOL report generation in the production environment and it is taking more than an hour to generate the BOL re…
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
How do people manage REACH reporting outside Oracle Cloud Fusion ERP?Summary: We are required to provide Regulatory reporting requirements such as REACH and Plastic Tax as a company. Oracle Cloud Fusion ERP has no standard solution, so we…
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 41 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 44 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Not able to view the BI publisher report under supply planning work areaSummary: We created BI report for Supply planning and loaded and created a new folder Supply Chain Planning under /Shared Folders/Custom/ and saved the report there. But…Adhavan 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to calculate Location capacity in Web reportHi, We are looking for best approach to get Available location capacity in Web report. For example:- If location 30% space occupied with inventory, than we will show the…Vijay11891 31 views 1 comment 0 points Most recent by Dhavaleshchandra Sukesh-Support-Oracle Warehouse Management
-
PROCUREMENT CONTRACT REPORT CREATIONSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables…Ranganathan Siva 1 view 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Fusion warehouse calendar querySummary: Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does no…kalyan gade 53 views 1 comment 0 points Most recent by Geno Hawkins- Support -Oracle Warehouse Management
-
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is it possible to access ATP DB table in AnalyticsSummary: Could access ATP DB table in Report Analytics catalog to build SQL Query data model Content (please ensure you mask any confidential information): Version (incl…
-
On Update 23.R4 SQM is noted as future roadmap itemSummary: On Update 23.R4 SQM is noted as future roadmap item. Is timeline available for this functionality? Content (please ensure you mask any confidential information)…AVorster-Oracle 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Need Query to get error data which is shown in review cost distribution processSummary: Need a query to get the warning/error for cost distribution process which ever ends in warning or error. As the create cost distributions process is scheduled i…Sukanya Mukherjee 11 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Reporting and Analytics for SCM
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 11 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM
-
Is requisition approval history available in BICCSummary: We are looking for a data store that contains approval history for Purchase Requisitions. Is this available in BICC? Content (please ensure you mask any confide…Holly Wells 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Tables related to Demand ManagementSummary: Hi, I need to extract all tables with data related to SCM Fusion Demand Management, but when I look into either data lineage or fusion PVO list I do not see any…Viswanath-Oracle 111 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Is there a way to report who last updated a price on a sales order?Summary: Is there a way to report who last updated a price on a sales order line? I don't believe this 'price last updated by' field is within the Fulfillment Lines real…Andrew_Schmitz 1 view 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM
-
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
Need to display transaction details present under Review Production Transaction History ScreenSummary: I Need to display all the transaction details present under Review Production Transaction History Screen. Please let me know the table that stores Production Tr…
-
How to modify the alignment in the PO Terms and condition setupSummary: Term and condition pulling from the purchasing setup in PO PDF report but We needs to do the alignment changes as per the business requirement. Please let us kn…Thanigainathan R 9 views 2 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for SCM
-
Multiple join in Procurement - Purchasing Real Time subject area - Need helpSummary: I am trying to create a very simple analysis from the start. But when I add colums from other folders, the rows multiply and the data is convoluted. Content (pl…