To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
Provision for electing report parameters in OTBI Agents while subscriptionSummary: Content (please ensure you mask any confidential information): Hi Oracle, We have received a requirement from client to create agent having report with prompts.… -
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 … -
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…
-
Need to Pull Final Approver on BI Report.Summary: We have a request to pull the Final Approver on a BI Report. The report has been built using SQL and is pulling from the fa_fusion_soainfra.wftask to get the ne…
-
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): -
We want to provide a deep link in email to supplier for purchase order acknowledgementSummary: We want to provide a deep link in email to suppliers for purchase order acknowledgement so that supplier can click on the URL and PO acknowledgement page opens …
-
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_…
-
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…
-
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…
-
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… -
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… -
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…
-
OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing…
-
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…
-
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…
-
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 …
-
Numbers format purchase order standard report issueDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…
-
Can we customize the Inventory BIP reports grid and save the view for the user?Summary: Need the ability to customize the grid and query, then save the layout so it is available as a favorite layout. Content (required): Version (include the version… -
Need help for getting Average cost of an item column in OTBI Subject areaHello experts, I need some quick help in for my OTBI Analysis which is for supply chain module. I want to calculate the Sum of Debits and Credits in Inventory. For that …
-
Cost Accounting subject areaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Daniel North - Orafinapps 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle
-
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 …
-
Missing column in Subject Area for ReservationsSummary: Missing column (Subinventory) in Subject Area for Reservations Content (please ensure you mask any confidential information): I am trying to create a report, ba…
-
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
-
Regarding po receipt invoiced is 0I need to extract those receipt line invoiced column having 0. Could anyone please help me on that. Below screenshot for reference purpose.
-
SQL query to get the Item Category HierarchySummary: SQL query to get the Item Category Hierarchy Content (please ensure you mask any confidential information): Version (include the version you are using, if appli…
-
Is it possible to access ATP DB table in AnalyticsSummary: Could access ATP DB table in Report Analytics catalog to build SQL Query data model Content (please ensure you mask any confidential information): Version (incl…
-
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…
-
How do I find the Submit Request Window to run a Buyer ListingI need to submit a Buyer Listing but I do not know how to get to the Submit Request Window?
-
Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?
-
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…