Fusion Supply Chain Management reporting
Discussion List
-
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess …Koteswararao Yenikepalli 138 views 2 comments 3 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP -
SUM each Payment row Running Total (YTD) by Vendor ID/Name?Summary: My code succeeds when my query for one Vendor, but needs to be reset for the whole report (muliple Vendors) A running total ( YTD Amount) for each group of Vend… -
Fusion UI personalization not reflected immediatelySummary: Fusion UI personalization not reflected immediately Content (required): Hi Experts, We created one DFF for GST number and this field should be mandatory when th… -
Supplier site bank account inactive date field in OTBIContent Hello, Could somebody assist me with the following problem, please: In an OTBI report, I would like to add the end date of a supplier site bank account. These va…User_RI0MI 224 views 4 comments 0 points Most recent by Shabharish, Pasupula Reporting and Analytics for ERP
-
Is there an option to update Oracle or Vision logo once to reflect in all seeded reports?Summary: Client is asking for one single update of oracle or vision logo so the users doesnt see Oracle /vision logo in out of the box report when run. Client requests t…Abhilash K - Deloitte USI 121 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…Sushan Peiris 241 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 252 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP
-
A report for print options for AR customers - Missing FieldSummary: A report is required to detail the print options for AR customers The issue I am having is location the tables that hold Statement Preferred Delivery Methods fr…User_2025-02-11-10-53-01-866 41 views 2 comments 0 points Most recent by User_2025-02-11-10-53-01-866 Reporting and Analytics for ERP -
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh.Kumarasamy-Oracle 85 views 10 comments 2 points Most recent by Shyam Patel Reporting and Analytics for ERP -
positioning FAW on top of Supply Chain Planning Cloud (Demand Management Cloud, Supply Planning ClouSummary: Has anyone built FAW analytics using Supply Chain Planning Cloud and EBS (Procurement, Financials, Inventory, Order Management) data with drill down/deep link c…Vishnuvarth Subramanian-Oracle 21 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Reporting and Analytics for ERP
-
positioning FAW on top of Supply Chain Planning Cloud (Demand Management Cloud, Supply Planning ClouSummary: Has anyone built FAW analytics using Supply Chain Planning Cloud and EBS (Procurement, Financials, Inventory, Order Management) data with drill down/deep link c…Vishnuvarth Subramanian-Oracle 21 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Reporting and Analytics for ERP
-
Access OTBI Data without Job RolesSummary For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?Content Hey Guys, We were checking to see if…User_2025-01-30-04-49-10-284 127 views 4 comments 0 points Most recent by IIGC Reporting and Analytics for ERP
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 123 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
Custom ESS jobs error outSummary: We have 7 custom reports where created a related ESS job definitions and created custom role (with appropriate Privileges) to run those custom ESS jobs. Job is …AnilJaMI 24 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 940 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…Sushan Peiris 342 views 3 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece…Mike Burnett 43 views 10 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…User_2025-02-11-03-09-13-126 26 views 2 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP
-
Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to FuContent Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most rece…User_2025-01-28-16-10-52-033 25 views 1 comment 3 points Most recent by User_2025-02-06-21-15-08-830 Reporting and Analytics for ERP
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 48 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 355 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 73 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 218 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…Hari Thyagaraj 49 views 2 comments 0 points Most recent by Ahmed Eldemerdash Reporting and Analytics for ERP
-
BICC - Selecting Columns from Data Stores Impacts other reportsSummary How to configure BICC reportsContent We are currently working on our migration to Oracle Fusion. I am tasked with looking at extracting data via BICC. How can I …User_2025-02-11-01-36-32-048 153 views 1 comment 2 points Most recent by User_2025-02-11-01-36-32-048 Reporting and Analytics for ERP
-
OTBI data modelSummary Is there a place where we can understand the data model (tables) for OTBI reports?Content Is there a place where we can understand the data model (Tables) for OT…Jeff Hare CPA CISA CIA 99 views 5 comments 3 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…Rohit Soni-259808 541 views 6 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 236 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP