Category 174-2
Discussion List
-
How to schedule an OTBI report output in excel/ csv format to the intended usersSummary: Hi we need to schedule an OTBI report output in csv format to the users. Is there any document for this. Thanks Content (required): Version (include the version… -
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 3 views 0 comments 0 points Started by Swapnil Kashid Reporting and Analytics for SCM -
Need Query to pull the item costs for the refurbished SKUsSummary: Have a requirement to find the item costs for refubrished SKUs Content (required): Query to pull the item costs for the refurbished SKUs Version (include the ve…
-
Physical Inventory Adjustment ReportHello, Has anyone created a Physical Inventory Adjustment report for Oracle Fusion? We're on version 23A. Any guidance on the query would be appreciated. Thank you, JuliaJulia Looi 12 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
How to invoke a BIP report with parameters from Oracle cloud ERPSummary: Can we invoke a custom BIP report with parameters from the items application page. Content (required): We want to call the report in the same way as how the Gen…
-
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 32 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 12 views 1 comment 0 points Most recent by Giuseppe Galluzzo Reporting and Analytics for SCM
-
How to deliver the OTBI report content to a destination server ex - A FTP serverSummary: Hi, Pl let me know how to deliver the OTBI report content (anlaysis) to a destination server ex - an on-premise FTP server. Where can we setup this in agent con…sanjiiv.chavaan 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. …Ramamurthy Shankarachetty-Oracle 7.1K views 42 comments 33 points Most recent by Chris Pfeifer Reporting and Analytics for SCM
-
Need to report which Orgs have a common BOM added in OTBI reportSummary: When I run a BOM report in OTBI only brings up the master org when other orgs have the common BOM added Content (required): We have a group of products where th…ALASTAIR BURNS 11 views 2 comments 0 points Most recent by ALASTAIR BURNS Reporting and Analytics for SCM
-
Interconnect Oracle fusion and Azure databasesSummary: We seek information to interconnect Oracle Application Fusion and Microsoft Azure databases. We need step by step process to connect these databases. Content (r…Sravana Pydimarry 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows SCM OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was available in …
-
SCM Dashboard ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 41 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
BI publisher for Demand Plan custom measures.Summary: Hi all, please I would thank for any help with the following. We need the query below this Demand Plan screens. Example 1. Example 2. We have noticed some table…Juan Jesus 13 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Navigate to Installed base Assets page using action links in OTBISummary: Issue with Navigating to specific Asset summary page from OTBI analysis for IB assets Content (required): I am trying to click to view, and navigate to IB asset…Suresh Kampati 11 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Need to see BPM Approval Flow in OTBISummary: I am trying to create an OTBI report and would like to see the BPM approval flow from OTBI report. When trying to figure out who approved the requisition, since…
-
Get latest revision of sales order in OTBISummary: Get latest revision of sales order in OTBI Content (required): Hi Team, A sales order may have more than one revision. We are trying to create a OTBI analytics …ShantanuP 41 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…Pandiyan 83 views 5 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
How to replicate values from a calculated column to all table rows in an OTBI analysis?Summary: I have a table that shows columns related to Innovation Management Proposal's instances like Proposal name, profit, proposal type, proposal squad, proposal trib… -
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…
-
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever… -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
Supplier Statement ReportSummary: Any OTBI or Seeded Supplier Statement Summary & Details report including transactions details and opening closing balances. Content (required): Any OTBI or Seed…Bilalemail 22 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User-Summary: Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User Content (required): Hi, We have a requirement for a report which…Aman Chaturvedi 31 views 1 comment 0 points Most recent by Rohan Kamat Reporting and Analytics for SCM
-
Product Development Change Order Audit history reportSummary: Need sql or database tables to generate Change Order Audit history report Content (required): As of today, there is no decent Audit history report of change ord…
-
Is there any subject area with the Planned Delivery Date on the shipment?Summary: We have to create a report on the shipments and need the Planned Delivery Date that appears in the shipment. We cant seem to find it. Content (required): Versio…
-
How to give access to a custom dashboard and data within itSummary: How to give access to a custom dashboard and data within it Content (required): Hi, We have some custom dashbaords developed and each dashboard has multiple ana…Abhishek Gattu 31 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM
-
Filter Planned Completion Date Based on Current DateSummary: Content (required): Hi, We have created an OTBI report with the column "Planned Completion Date" using Maintenance Management - Work Order Performance Real Time…Sheneli98 11 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle 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 52 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM