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
-
In OTBI Report Date is not displaying correctly as per the date mentioned in front endSummary: In OTBI Report Date is not displaying correctly as per the date mentioned in front end Content (please ensure you mask any confidential information): Subject Ar… -
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…
-
The specified criteria didn't result in any data for Inventory transaction real timeSummary: receiving result "The specified criteria didn't result in any data" User has a custom role that has been assigned "Inventory Transaction Analysis Duty" and has …
-
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…
-
Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero (rounded down)Summary:Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero but Excel export shows correct value. Analytics > Run Standard Cost Details seeded report…Maria Angelica Mendoza 21 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle -
How to obtain xml for Supplier Negotiation PDF ReportSummary How to obtain xml for Supplier Negotiation PDF ReportContent Hi All When I look at the bip template layout for Supplier Negotation PDF Report it is not linked to…User_2025-01-31-15-11-25-562 243 views 2 comments 0 points Most recent by Melissa Carrick - Oracle-Oracle -
Where is the Organization Name on the SCM BICC Extracts?Summary: In the BICC Extracts for Sales Orders Transfer Orders Purchase Orders Shipments On Hand Installed Base We need to Find the Organisation Name but can only find a…
-
Equivalent report for Israeli Localization Withholding Tax Certificates Expiry Date reportSummary: Hi, We are in middle of migration to cloud and we are looking to see the equivalent report for the 11i report "Israeli Localization Withholding Tax Certificates…
-
Does anyone know how to find Journal Entries Details in Cost Transactions?Hi Everyone, Does anyone know a query to get Journal Entries Details in Cost Transactions?
-
Upload excel for search criteria to find on hand dataSummary: One of my customer has huge number of SKUs (6 million SKUs). The user would like to query the on-hand quantity for SKU's by uploading an excel. The excel file h…Vishnuvarth Subramanian-Oracle 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle
-
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…
-
Find related field in frenchHi, Could you please advise in which database table can I find the Purchase order status in french or the requisition status in french. (Procurement → Purchase Order → M…
-
Extracting Booking History Details - Demand ManagementSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …
-
Item attribute values by revisionsHello, we are trying to extract an attribute value from ego_item_eff_b in all revisions of a specific item. This means that we want to extract data with the following st…
-
Create tables(DDL) from PVO metadata provided by REST APIWe are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata) Url: https://{server_name}/biacm/rest/meta/da…
-
Locator Name in Receiving - Purchase Receipts Real Time Subject AreaSummary: We have an OTBI report built using the subject area "Receiving - Purchase Receipts Real Time" and we have almost all the required columns except for the Locator…
-
How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…
-
Attributes not available for Extract designSummary: Added 'ABS_EXT_ABSENCE_ENTRY_UE' User Entity as root DG in extract design. User Entity Query has the record name 'ANC_PER_ABS_ENTRIES', from which few fields ar…
-
What all standard reports are available in oracle fusion for Procurement and Supply Chain ManagementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Supplier Owned Consigned Items valuationSummary: Does Period Inventory Valluation Report consider the inventory value for consigned items those are owned by supplier? Content (please ensure you mask any confid…
-
How to check the error message in Manage PO when funds status is failedHi All, Could you please let us know where does the error message of Funds Status gets stored. The ask is to show the Error message of an PO when it's Funds Status is fa…
-
how to pass the parameter Item/Change notice to our DM based BIP reportSummary: We have a Report on which we want to pass the Item number/Change Number to the BIP Report, However the report is not passing the parameter which we are passing …
-
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…
-
IssueSQL query to fetch rows from a BICC PVO created/updated after a certain dateWhat would be the syntax of an IssueSQL query to fetch data from a BICC PVO (eg. FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstPeriodicAvgCostsExtractPVO) with where c…
-
Can't found the "objType" deep link for SCM - Confirm Pick Slip pageWe seeking to create a deep link that connects between BI report and the "Confirm pick slip" page from the Inventory management page, also we searched through this docum…
-
Consigned Inventory ValuationSummary Consigned Inventory ValuationContent Our healthcare organization is new to Oracle Cloud Fusion SCM. I ran inventory valuation reports (from scheduled processes) …Pattianne Belitz-Children's Hosp Omaha 60 views 3 comments 0 points Most recent by Pattianne Belitz-Children's Hosp Omaha -
Availability of sales order tax information (DOO_ORDER_TAX_DETAILS) in PVOs?For SCM analytics, I am looking for information on tax details at the sales order level (which table-wise seems to be in DOO_ORDER_TAX_DETAILS), for calculations pertain…
-
OTBI Report for collaboration messaging historySummary: User requires an OTBI report scheduled on a daily basis for the errored out Purchase Orders and Invoices to keep him notified. Can you please suggest the subjec…
-
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are…