Category 174-2
Discussion List
-
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 …Ibrar Hussain 41 views 1 comment 1 point Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
How to grant read-only access to "Costing - Inventory Valuation Real Time" without UI AccessSummary: How to grant read-only access to "Costing - Inventory Valuation Real Time" without Application access. Content (required): We have a requirement where we need a…
-
Equivalent Oracle Cloud table/view for the EBS 11i entity MTL_INTERCOMPANY_PARAMETERS_VSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity MTL_INTERCOMPANY_PARAMETERS_V? Content (required): Version (in…Nagendrababu Kanuru 51 views 2 comments 0 points Most recent by Nagendrababu Kanuru Reporting and Analytics for SCM
-
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 41 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…
-
Equivalent Oracle Cloud table for the EBS 11i table WIP_LINESSummary: Could you please help us to provide the equivalent Oracle Cloud table for the EBS 11i table WIP_LINES? Content (required): Version (include the version you are …Nagendrababu Kanuru 41 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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, Julia -
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 114 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle 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…Neela.Voduguru 71 views 1 comment 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How do you export a list of custom reports from OTBI?Summary: I need to export the list of custom reports created in OTBI, to manage the content and clean up the list of reports available. Content (required): Is it possibl…Jim Forsythe 803 views 6 comments 1 point Most recent by Jim Forsythe Reporting and Analytics for SCM
-
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 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
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…
-
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…
-
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 21 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 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
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 61 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 91 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
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 211 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
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… -
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…
-
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 41 views 1 comment 0 points Most recent by Rohan Kamat Reporting and Analytics for SCM
-
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 71 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 41 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Reporting and Analytics for SCM
-
OTBI - Locating 5th occurrence of characterSummary: Several fields have been migrated into one field and need to split into separate columns into OTBI Content (required): We need to pick the department from the c…Sai Revanth-Oracle 41 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Reports and Analysis tab is blank in SCM Work areaSummary: The reports and Analysis tab is blank in all Work areas of SCM Content (required): The reports and Analysis tab is blank in all Work areas of SCM like Purchasin…
-
How to add the Supplier Site Attribute information to the Requisition PDF ReportSummary: I want to add the Attribute Information from the Supplier Site to the Requisition PDF Report. Based on the attachment from Doc ID 2595071.1 (RequistionPDF Attri…Hendra_innopia 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM
-
Error while loading Sales order through FBDISummary: Getting error while loading sales order. This error occurs in source order 1103-F65660TEST, on source order line 1, source item name 846581, source item 300,000… -
work order fetch based on asset number and asset work center nameSummary: Hi Experts I want to create a BIP report to fetch work orders with parameters asset number, asset work center name, item number and work order work center name.…Sharmava 11 views 1 comment 0 points Most recent by Aravindan Sankaramurthy -Oracle Reporting and Analytics for SCM
-
Documentation on Complete list of available pre-built KPI/metrics in Fusion SCM Analytics (FAW)?Summary: Can you please let us know the link where we we can get to know the complete list of metrics/KPI available in SCM Analytics for OM, Procurement and Inventory? C…SIVA.G 321 views 4 comments 1 point Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM