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
-
Fusion OTBI Drill Down to different subject area, linking on column with different name in each areaSummary: Hi, Oracle Fusion OTBI. I'm attempting to drill down from and OTBI Report on "Procurement - Procure to Pay" Subject Area to another report based on "Payables In… -
MSC_SYSTEM_ITEMS vs. EGP_SYSTEM_ITEMS_BI have a need to cross reference MSC_SYSTEM_ITEMS and EGP_SYSTEM_ITEMS_B to abstract away query complexity for certain users. This is a Data Warehousing scenario. How ca…
-
Item number update in PROD for existing item having transactionsSummary: Is it advisable to update item number of existing item already in use in PROD? Content (please ensure you mask any confidential information): Customer has exist…
-
BIP report use '_vl' view cannot switch language by user language preferenceUse '_vl' view to extract data in BIP report, but it didn't display in correct language based on user's BIP preference session language. Given that, I selected :xdo_user…
-
Redwood: Purchase Document E-mail ReportSummary: Redwood: Purchase Document E-mail Report Content (please ensure you mask any confidential information): Hi Team, We are getting new feature in 25D :Redwood: Use…
-
ESS Job for BIP Report – Error During Scheduled Process ExecutionSummary: Hi Team, We have created an ESS job for the BIP report and assigned the appropriate ESS privilege to the custom role. However, when a user with this role attemp…
-
Clarification on PIM business Events in NIR and Change ordersSummary: Clarification on PIM business Events in NIR and Change orders Content (please ensure you mask any confidential information): We are developing the Integration w…
-
How to reuse RTF of Packing slip report in BOL report which has different data models and parametersWe have one requirement with below 2 reports 1 . Packing Slip report -------- /Supply+Chain+Management/Warehouse+Operations/Shipments/PackingSlip.xdo 2. BOL report. ----…
-
Can REST API be used to run ESS BIP Job Type? It returns Request Id = -1Summary: Can REST API be used to run ESS BIP Job Type? Why does the REST API return Request Id = -1? Content (please ensure you mask any confidential information): Oracl… -
How to get the approval history for Claims?Hello. I am trying to build a custom report that would get the approval history for claims (approvers, latest date of submission, etc.). Does anyone have any idea on wha… -
Parameter names with values does not appear on the custom ESS jobSummary: We've created a custom job mirroring the standard ESS process - Release Pause Tasks. The only change is that we have made the order field as a required field an… -
BIP Report issueSummary: Hi I am trying to extract Item master data . Count is huge and getting below error. What is way to extract all records in csv Content (please ensure you mask an…
-
We have enabled Audit report for Approval changes via BPM as per oracle suggestionSummary: We have enabled Audit report for Approval changes via BPM as per oracle suggestion, is there any impact on the performance while it is enabled? Content (please …
-
Sales order report customization and availability under Action MenuSummary: How to Edit the sales order Report to include Eff Details and utilize it under Action Menu dropdown on Sales order UI? Content (please ensure you mask any confi…
-
FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO- Duplicates for primary keyACTUAL BEHAVIOR Running BICC extract to extract information from PVO FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO in BICC. PERFOBLIGATIONLINEDIST…
-
Why certain BICC Public VOs do not support Incremental Load?Hello Team, We noticed that certain BICC Public View Objects do not support Incremental Load. Below are names of some of the VOs and screenshot showing 'Supports Increme…
-
BI publisher: EText Condition Fails with Slanted Apostrophe in XML TagsSummary: I'm encountering an issue where my EText template condition does not work as expected due to a mismatch between straight single quote and slanted apostrophe in …
-
Create sequential number for each row in OTBIneed help generate a sequential number for each row when we run or open Result in OTBI.
-
Need query for Change Order History TabSummary: I need query to extract these columns as mentioned in the screenshot. -
Table to get "Reference Type" in depletion layer?Summary: I am looking for a table that contains the "Reference Type" field in the depletion layer as in the screenshot below. thanks in advance! Content (please ensure y… -
Need SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsNeed SQL query or table details in Oracle Fusion when item structures are loaded in reference orgs
-
we have requirement item import map load in UCM server and integration team take the file and loadSummary: we have requirement item import map load in UCM server and integration team take the file and load in oracle cloud Content (please ensure you mask any confident…
-
Will the Redwood upgrade will impact our existing Analysis reports and/or DashboardsSummary: Will the Redwood upgrade will impact our existing Analysis reports and/or Dashboards that use Analysis reports? We are trying to schedule and prioritize project…Bill Stearns at Essex Grove Consulting 41 views 4 comments 0 points Most recent by Bill Stearns at Essex Grove Consulting
-
Query to get Receipt Accounting Transaction StatusHi Team, Please let me know from where we can get the Receipt Accounting - Transaction status column from backend. ( Navigation - Supply chain execution → Receipt accoun…
-
ARCredit Memo Comments: Attribute CreditMemoComments in view object CreditMemoHeader1 cannot be set.Summary: I'm trying to update the AR Credit Memo Comment field using REST API. It is throwing, Credit Memo Comments: Attribute CreditMemoComments in view object CreditMe…
-
Error when running report using REST apiSummary: Error when running/calling the report using REST api. Content (please ensure you mask any confidential information): Hello Experts, Is there a way to call or ru…
-
How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to SiteSummary: Hello All, Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query… -
Operation Status columnSummary: Operation Status column Content (please ensure you mask any confidential information): Hi, On which Manufacturing subject area I can find operation status (Read…
-
We have a requirement to fetch the Pending change order amount for a particular projectWe are fetching the change order amount from 'Procurement- Pending change Orders Real Time' subject area but we are not getting the exact amount changed column. Kindly l…
-
BIP report to get the ESS job error details based on process idSummary: Hi Experts Does anybody have a BIP report sql query to get the details of error ESS process encounters in fusion post running the ESS scheduled process . Please…