Category 174
Discussion List
-
Reports for Product ManagementWhat are the Reports available for Product Management and from where we can see all that. -
Issue with Subquery/Outer Query with BOM LEVEL - Results Messed UpSummary: Hi everyone, I would greatly appreciate any suggestions or help regarding the use of outer queries or subqueries. I want to use multiple subqueries and join the…
-
Subject Area to get details related to Maintenance Work definitionSummary: We try to create an analysis in Maintenance module to capture the Maintenance program with Work definition and operations and materials required for the Work or…
-
Print Page Number of Total PagesSummary: Case 1: In an analysis, how to print Page # of total pages? Case 2: Same analysis embedded in a Dashboard, how to print all lines from the analysis in PDF forma…VDM_IM 15 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
BI publisher report SQL error ; joining INV_TXN_REQUEST_HEADERSI'm creating report SQL, but when I executed the SQL I got an error. When I executed the SQL I got an error. There were no errors before I joined INV_TXN_REQUEST_HEADERS…
-
How to print all lines returned in dashboard from analysis in a PDF print format or PDF export?Summary: I created an analysis, embeded in a Dashboard. I also created a Report under Print & export options in the section Custom Print & Export Layouts. I added date &…
-
How to call pages from different moduleSummary: Hi All, I am working on a Idea to call pages from different modules. Here is how it should work Navigation>Order Management>Manage fulfilment lines. On this pag…Manohar Cheelangi Swamy 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
in subject area "Inventory Transfer Order Real Time" Actual Ship Date is not accurateSummary: in subject area "Inventory Transfer Order Real Time" under shipment details group we added in the report Actual Ship Date and confirmed date but we found it is …Mohamed Attia-Allah 1 view 0 comments 0 points Started by Mohamed Attia-Allah Reporting and Analytics for SCM -
How to Join 'Inventory - Inventory Transactions Real Time' & 'Shipping Real Time' subject areaSummary: Hi Gurus, We are trying to build a report which show the Inventory Transcations with the 'Waybill Number' & 'Tracking Number' field. So is there a way to join t…Amrish_Amradkar 1 view 0 comments 0 points Started by Amrish_Amradkar Reporting and Analytics for SCM
-
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…
-
Extract DFF/EFF for Transfer Orders/Sales OrderSummary: Hi, We have a reqiurement to extract the DFF and EFF information for Transfer Orders and Sales order using BICC. We could able to find the below PVOs for extrac…Yash Jain 261 views 16 comments 0 points Most recent by Neha Aishwarya Reporting and Analytics for SCM
-
How to Insert/modify targets in main dashboard OTMSummary: Hi, I'm opening this ticket by suggestion from OTM CCC discussion: Is it possible to insert or update targets values in the main dashboard page? We have try to …Pablo Moreno 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
while creating the custom roles, getting unwanted subject areas in analysisSummary: Hello Experts, Our client has a requirement to create a custom role for restricted access to business users. While doing so, we could see in reports and analyti…Balaji Midhun Kumar Sanagapalli 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 149 views 2 comments 0 points Most recent by Jazmin Gutierrez Reporting and Analytics for SCM
-
How can we create a custom events to trigger the integration flowSummary: How can we create a custom events to trigger the integration flow. if we click a release button for a project the integration need to trigger but i am unable to…Veera venkata satya Ranga Prasad 21 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI ERP Integrations
-
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 24 views 3 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM -
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to rollback customized PDF templateSummary: How to rollback customized PDF template? Content (please ensure you mask any confidential information): Hi Experts, I got this requirement to rollback the custo…Liwen Chiu 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
PDH Item Structure Structure Component audit database tablesSummary: I have a request to develop a custom audit report for PDH Item Structure and Structure Component. I'm looking for the database tables where I can sql data and c…Carlos Benassi 3 views 2 comments 0 points Most recent by Carlos Benassi Reporting and Analytics for SCM -
How to Split Rows in Excel BI Publisher Output (Nested Rows Inside One Row)Sure, here's a more polished version of your message: Hello Community, I am working on a scenario where I need to display data in multiple rows within a single row in an…
-
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…
-
Help adding fields to Requsition templateSummary: Need guidance on adding specific fields to the Requisition template. We are trying to add to the template at the distribution level, the project name and task n…Ellen Manthei 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Item revision for onhand analysis reportSummary: Item revision for onhand analysis report. Content (please ensure you mask any confidential information): Created an analysis report using Inventory - Inventory …
-
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…Akankshya Jena 11 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Which table in Oracle fusion stores the error messages while Importing sales Order using FBDIIn which table, can I find the error messages for any error occured during the Import Sales Order using FBDIRishabh33Maithani 582 views 3 comments 0 points Most recent by Murali01Jairaj Reporting and Analytics for SCM
-
Which BICC lineage sheet has details for AccountContactResponsibility?Which BICC lineage sheet has details for below PVO- FscmTopModelAM.FinArCustomersPublicModelAM.AccountContactResponsibility
-
How can I add suggested start date of a maintenance program generated work order to an OTBI report.?Summary: I am trying to add the suggested start data of a work order to an OTBI report. Work orders that are created by maintenance programs have a suggested start date.…Phillip_Shearer 1 view 1 comment 0 points Most recent by Ezra Anderson Reporting and Analytics for SCM
-
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanksAhmed Abdelaziz 31 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Conditional Formatting to display field in redHi, In the PO template if the amountMohammed Rafi 21 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for ERP -
How to keep search panel available when search result shows?Summary: How to keep search panel available when search result shows? Content (please ensure you mask any confidential information): Hi Experts, May I ask how to have th…