Category 174
Discussion List
-
SQL query for Manage negotiation Template for Sourcing moduleSummary: Hi Team, We need a table where Manage negotiation Template information stores Content (please ensure you mask any confidential information): Version (include th… -
How to filter out duplicate value for multi-rows attributes in OTBI analysisSummary: The OTBI analysis shows duplicate value for multi-rows attributes. I need a way to filter them out in analysis. Content (required): I have two multi-rows attrib…
-
How to setup FTP server on PDH and send files from PDH to PDH FTP serverSummary: We have a requirement of sending Item and Cost master information from PDH to CPQ via SOA middleware. We need to enable and setup FTP server on PDH so that SOA …Kajal Dhawral 22 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM -
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 43 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Not able to view the BI publisher report under supply planning work areaSummary: We created BI report for Supply planning and loaded and created a new folder Supply Chain Planning under /Shared Folders/Custom/ and saved the report there. But…Adhavan 22 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to extract BOM explosion report for multiple items at one go?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Madhupa 12 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
How to filter out duplicate rows with same values in BI report.Summary: I need to create one BI report where I need columns like Item_Number, Item_Description, Prc_BU_Name, Order_Num (PO_num), PO_Quantity, Invoice_quantity, Invoice_…Rishabh702 13 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Query to extract Change order details of PO'sSummary: Need to extract all Change orders associated to a PO in Oracle Fusion Procurement Content (please ensure you mask any confidential information): Version (includ…KalyanC 1.7K views 1 comment 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM
-
how to add dff to subject areaSummary: We are using some DFF's in Transaction History under Inventory and DFF and enable the same for reporting. There is no DFF's are available under this subject are… -
How to calculate Location capacity in Web reportHi, We are looking for best approach to get Available location capacity in Web report. For example:- If location 30% space occupied with inventory, than we will show the…Vijay11891 31 views 1 comment 0 points Most recent by Dhavaleshchandra Sukesh-Support-Oracle Warehouse Management
-
when OTBI export extraction limit will increaseSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Manoj Rawat1 31 views 1 comment 0 points Most recent by Dawn Stockdale-Support-Oracle Warehouse Management
-
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 -
How can I identify Items which have common Structure with another item in different org?Summary: Goal is the extract list of item with with common structure. We have gone through the two subject areas below elated to Item Structure but did not find any comm…
-
R13 Financials 24A OTBI subject areas to database lineage mapping Spread SheetSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…vnalluri 28 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
OTBI dsahboard not visibleSummary: We are trying to build dashboards,what access(role) we need to create a dashboard , we alreday have the BIAdmin role Content (please ensure you mask any confide…joelroshan92 21 views 6 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
What web service for BIPublisher to use to download output of scheduled report (ScheduleService)Summary: We use the SOAP web service interface "/xmlpserver/services/v2/ScheduleService". Using Operation "scheduleReport" it is possible to launch an execution of a BI …Renato Baietta 26 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Fusion warehouse calendar querySummary: Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does no…kalyan gade 51 views 1 comment 0 points Most recent by Geno Hawkins- Support -Oracle Warehouse Management
-
Can we get Accrual Account details from "Distribution Detail by Account" seeded OTBI reportSummary: Business needs to view Accrual Account details from "Distribution Detail by Account" seeded OTBI report is that possible. If I query I can not view the details …Naga Varma 11 views 1 comment 0 points Most recent by Mohamedtaha-Oracle Reporting and Analytics for SCM
-
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 150 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Neha Aishwarya 11 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to sum (group by) more than one column on OTBII need to create a custom column that aggregates WIP balance by both WO and Cost element. I can create sum(wip balance by wo) and sum(wip balance by cost element) but th…G.Engelmann 155 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How To restore Deleted Folder Under Shared Folders Within BI PublisherSummary: One of the users deleted a folder under Shared Folders→ Custom. Please let us know how can we retrieve the deleted folder Content (please ensure you mask any co…Susmitha Arepally-Oracle 252 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need Query to get error data which is shown in review cost distribution processSummary: Need a query to get the warning/error for cost distribution process which ever ends in warning or error. As the create cost distributions process is scheduled i…Sukanya Mukherjee 12 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Reporting and Analytics for SCM
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 18 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM
-
Can i get the Database lineage document for 23DSummary: Can i get the FSCM Database lineage document for 23D Content (please ensure you mask any confidential information): Version (include the version you are using, …SKanWes 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Is requisition approval history available in BICCSummary: We are looking for a data store that contains approval history for Purchase Requisitions. Is this available in BICC? Content (please ensure you mask any confide…Holly Wells 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Tables related to Demand ManagementSummary: Hi, I need to extract all tables with data related to SCM Fusion Demand Management, but when I look into either data lineage or fusion PVO list I do not see any…Viswanath-Oracle 114 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to default an Inspection plan when entering inspection details ?Summary: How to default an Inspection plan when entering inspection details Content (please ensure you mask any confidential information): How to default an Inspection p…
-
Inspection Plan doesnt come in drop downSummary: Have defined inspection plans yet not able to search/select any while trying to do inspection Content (please ensure you mask any confidential information): Ins…