Reporting and Analytics
Discussion List
-
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 31 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 184 views 6 comments 0 points 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 -
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…
-
Is there any way that we get Inventory transaction details with Serial numbers using Inventory SubjeSummary Is there any way that we get Inventory transaction details with Serial numbers using Inventory Subject AreaContent Is there any way that we get Inventory transac…Pavan Pemmaraju-132869 76 views 3 comments 1 point Most recent by Prasanth Senthivel-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 181 views 5 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
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…
-
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 61 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 31 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 121 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
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 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM
-
PO Change order History TableSummary SQL/Table to fetch Purchase order change historyContent Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was…Sahil Makhiza 101 views 7 comments 0 points Most recent by Anjana Das-Oracle Reporting and Analytics for SCM
-
UCM vs Object Storage for BICCSummary: UCM vs Object Storage for BICC Content (required): What is the recommended approach? Our end goal is to load the extracts into a database. Version (include the …sanjam1130 242 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for SCM
-
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…Yogesh Nemchand 36 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
How to schedule a job which will autogenerate a report on monthly basisSummary: We have a business requirement where we need to create a job that will automatically schedule and fetch the data from previous month on the first week of every …Gauri Lande 31 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Is it possible to create new/custom infolets ?Content Is it possible to create new/custom infolets ? Version 19CCaio Zioli-Oracle 87 views 5 comments 0 points Most recent by Manishsrf7 Reporting and Analytics for SCM -
How to Remove Edit Option for OTBI Report.Summary: Content (required): Hello Friends We have made a custom role and added duty role -"Receiving Transaction Analysis Duty". Assigned this role to a user. But I do …Ashish_Kumar 143 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for SCM -
Plan to Produce Infolets are not appearing on Home PageSummary Plan to Produce Infolets are not appearing on Home PageContent Hi All, We are not able to see any infolets on Plan to Produce Infolets section. Please let us kno…Siva Kumar-Oracle 36 views 1 comment 0 points Most recent by CumminssCP Reporting and Analytics for SCM -
Table and column for Firm DateSummary: The supply planning UI shows Firm Date as a column in the supplies and demands table. This date reflects when the product is expected to arrive. What is the tab…
-
OrderChargeComponentExtractPVO extract contains duplicates for primary key while extraction.Summary: OrderChargeComponentExtractPVO extract(via DataSync) contains duplicates for primary key. Content (required): We are extracting data using the OOTB PVO 'FscmTop…Jahnavi-Oracle 11 views 0 comments 0 points Started by Jahnavi-Oracle Reporting and Analytics for SCM -
Report services are not working post 22A upgradeSummary: REST services related to OTBI are failing in the system which worked fine until the 22A upgrade. Content (required): One of them is 'runDataModel' which we use …Goutham.Manthri 11 views 1 comment 0 points Most recent by Goutham.Manthri Reporting and Analytics for SCM
-
How to run a customised seeded bip report from the Report and Analytics folder/catalog folder.Summary: Greetings, Team — Is there a way to make the 'Open' hyperlink button enabled for a customised BIP Report? We customised the PO PDF Report for two different clie…Sameer Malhotra 1 view 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
The BIP Catalog page search box is inoperable.Summary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…Sameer Malhotra 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …MANISH KUMAR-145787 11 views 0 comments 1 point Started by MANISH KUMAR-145787 Reporting and Analytics for SCM
-
How to give access to Reports & Analytics but not to the UISummary: Hello, We would like to create a user with ONLY access to Reports & Analytics. The user should not have access to any module in the User Interface (UI). Is it p…Eric Serra I Paradis 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
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 21 views 0 comments 0 points Started 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 …