Tip
Discussion List
-
issue query filter BICCSummary: We're trying to filter specifc data from VO at BICC , but log returns query error at where clause. Content (please ensure you mask any confidential information)…Hbsampa 45 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM -
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…Kasthuri.S 20 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Can a dynamic hyperlink be programmatically embedded within text in BI publisher report?We have a requirement to print attachments links in PO PDF report. The report should have the attachment name as a text, upon hovering over the text the hyperlink to the… -
Need a query to fetch planned order and demand due datesSummary: Hello, We need a query to fetch planned order due dates and corresponding pegged sales order/forecast need by dates for a certain category of items. We would li…SharathBiz 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
System Performance Health CheckSummary: We are seeking a solution that will help us monitor the health of our ESS Jobs. Something that would alert us of long run times, threads getting hung up etc. We…Schneider.Mark 21 views 3 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration -
Sales Order Report CustomizationContent Good People, Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM . Any one customized …Soumya Prakash Parhi 459 views 11 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
PROCUREMENT CONTRACT REPORT CREATIONSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables…Ranganathan Siva 1 view 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Temporary Side Table and Reporting FunctionalitySummary: Hello experts, I have a question, perhaps a bit naive, but I would appreciate your guidance and assistance. In Oracle EBS (E-Business Suite), my client has a Bu…
-
FBDI Import -Items (FBDISummary: High volume data in Products while loading Inventory Orgs Content (required): Hi Folks, We are in process of Loading Items in our projects we have 11 lakh recor…Lucky Sharma 42 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
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… -
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…User_2025-02-05-12-20-44-163 38 views 5 comments 2 points Most recent by Sahithi Kolasani-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 98 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 153 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for SCM -
OTBI Report view as Transpose RowsSummary: Content (required): Hello Friends, How I can get a Transposed view display for OTBI report (based on subject Area)? For Example: Currently I am getting output a…
-
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee…Koteswararao Yenikepalli 57 views 4 comments 0 points Most recent by User_KM4LK Reporting and Analytics for SCM -
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 182 views 8 comments 0 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…User_2025-02-05-12-20-44-163 195 views 1 comment 0 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
Remove merged cells from report in reports & analyticsSummary Remove merged cells from report in reports & analyticsContent Hello, Please note that we have a report : Scott Marketing report which has merged columns B & C AN…User_2025-02-05-12-20-44-163 205 views 7 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Create Infolet through BI analysis to get PO count created for the daySummary Need to create an analysis to get today's PO created count based on userContent I created a analysis to get the buyer wise PO count. But it gives the as at date …
-
Inventory OnHand Balance ReportSummary Inventory OnHand Balance ReportMahgoub S.Mohamed 93 views 1 comment 0 points Most recent by User_2025-02-07-08-26-19-537 Reporting and Analytics for SCM -
Net Available Item QuantitySummary Subject area for Reserved Quantity and Net Available QuantityContent Hello Team, We have to update our analysis report, please suggest which subject area in Inve…Saurabh Sharma_HCL 59 views 4 comments 0 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
Need A SQL query to get the supplier contact address detailsSummary Need A SQL query to get the supplier contact address detailsContent Need A SQL query to get the supplier contact address details Here I have attached the screens…Koteswararao Yenikepalli 295 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM
-
How to display only most recent records in an analysisSummary How to output only the most recent records in "Inventory - Onhand Balance" analysisContent In OBIEE, Is there a way to modify the pre-built analysis "Inventory -…User_2025-02-06-00-08-33-553 52 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
Need A Report To Find Out The PR Is Pending With Whom And Its HistoryContent We are looking for some SQL query to find out the requisition is currently pending with whom and what is the history of the approval To achieve this requirement …Koteswararao Yenikepalli 42 views 1 comment 4 points Most recent by User_2025-01-30-02-57-36-931 Reporting and Analytics for SCM