Category 174
Discussion List
-
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 32 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 26 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 53 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 142 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 158 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 240 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 11 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 115 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…
-
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 51 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 329 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
BIP Excel output removing zeros from decimalSummary: BIP Excel output removing zeros from decimal Content (please ensure you mask any confidential information): I have a BIP Data Model and Report with Excel (.xls)…KDR 7 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM
-
Need Tables for Cost Transactions Depletion Layer DetailsSummary: I'm looking for tables for Cost Transactions Depletion Layer Details as in the screenshot below. Content (please ensure you mask any confidential information): …Kunal Verma 208 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need to maintain imagesSummary: For fusion SCM Is there any way we can maintain employee signature images to be displayed on reports Content (please ensure you mask any confidential informatio…
-
how to update/change Attributes in Fusion base table called "Inv_material_txns"Summary: Any rest api to update/change custom attributes in Fusion base table called "Inv_material_txns" Content (please ensure you mask any confidential information): V…mohamedaz 13 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Is there a way to report who last updated a price on a sales order?Summary: Is there a way to report who last updated a price on a sales order line? I don't believe this 'price last updated by' field is within the Fulfillment Lines real…Andrew_Schmitz 1 view 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM