Category 174
Discussion List
-
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… -
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…Mary Jane Sariba 14 views 1 comment 0 points Most recent by Mary Jane Sariba Reporting and Analytics for SCM -
sample xml file to add column for workflow email notification not workingSummary: sample xml file to add column for workflow email notification not bringing columns to add to the email notification report Content (please ensure you mask any c… -
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… -
BIP ESS Job ErrorSummary: create ESS Job For BIP Report ,Go error when run Schedule Process Content (required): Version (include the version you are using, if applicable): Code Snippet (… -
How to retrieve data from Item 'History' tabSummary: I need to extract data from Item 'History' tab, like which Field(s) are Updated/Inserted with Old and New values and Date of action. If anyone having such sampl…Shamsul_Wzd 90 views 2 comments 0 points Most recent by Sachin SCM-Oracle Reporting and Analytics for SCM -
REST API services feature for Oracle BI PublisherSummary: We are trying to access BI report through rest API. When we try the Oracle BI Publisher REST resources using the following URL structure https://:/xmlpserver/se…Kannan Ranganathan 546 views 8 comments 0 points Most recent by Sukanya Mukherjee Reporting and Analytics for SCM -
Need Guidance on BI Report Performance Discrepancy (AR Invoices) - 25D PatchHi everyone, We’re running into a puzzling issue with a BI report based on AR Invoices and hoping for some advice or shared experience. Scenario: Our report joins ra_cus… -
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…Catherine Alequin 22 views 1 comment 0 points Most recent by Catherine Alequin Reporting and Analytics for SCM -
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…Shiva Kumar Bandaru 38 views 6 comments 0 points Most recent by Catherine Alequin Reporting and Analytics for SCM -
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 743 views 6 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM -
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… -
Transfer Orders enabled - table fieldSummary: Transfer Orders enabled - table field Content (required): I am looking for what the correct database table field is for the below highlighted field in the UI un…KDR 55 views 5 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for SCM -
inventory aging preview feature in FDI--how to fully enable?I have enabled the feature inventory aging in the preview section of Fusion Data Intelligence. We are running version 25.2. But I don't see a new subject area called SCM… -
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… -
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…Anjali Dcruz 11 views 1 comment 0 points Most recent by Anjali Dcruz Reporting and Analytics for SCM -
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line … -
FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO- Duplicates for primary keyACTUAL BEHAVIOR Running BICC extract to extract information from PVO FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO in BICC. PERFOBLIGATIONLINEDIST…Prabhjeet Kaur 42 views 0 comments 0 points Started by Prabhjeet Kaur Reporting and Analytics for SCM -
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 …Sudeepto 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin… -
Need query for Change Order History TabSummary: I need query to extract these columns as mentioned in the screenshot. -
BI Publisher Service UnavailableWe are getting the message 'Service Unavailable' when attempting to access BI Publisher. All our automated reports are also impacted by this. They are not being sent. -
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 25 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM -
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 9 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
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…shaikh123 46 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
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 orgsDhilip Kumar P. 1 view 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
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 Reporting and Analytics for SCM -
Work Order DFF not visible in OTBI Subject AreaSummary: Work Order DFFs are not visible in OTBI Subject Area We have run the process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" also…