Category 174-2
Discussion List
-
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 43 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 111 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 801 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 213 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
-
How to Send Multiple files in one mail using Bursting(BI Report-EText template).Summary: Trying to Send Multiple files in one mail using Bursting(BI Report-EText template). How can we achieve this? Version (include the version you are using, if appl…Suman123 21 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM