Fusion Supply Chain Management reporting
Discussion List
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter …Rashmi M-Oracle 21K views 89 comments 26 points Most recent by Dave Kekish Reporting and Analytics for ERP -
Bi Publisher - How to read the content of an attachment using sql script in data modelHi, We have a requirement in BI Report, to check for the attachment at Supplier Profile and if the attachment is present then we need to read the content of the attachme…Nepal Bhumireddy 59 views 8 comments 0 points Most recent by Nepal Bhumireddy Reporting and Analytics for ERP
-
"FAWService" Oracle Account is consuming Oracle Cloud Fusion LicenseWe have ran order built "UserPrivilegesByService" report and found "FAWService" which is an Oracle Account is consuming licenses due to "Supply Chain Planner" role. Plea…SUDHIRNARAHARISETTI 12 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 32 views 3 comments 0 points Most recent by User521494-Oracle Reporting and Analytics for ERP
-
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 22 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…user12240811 11 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
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 48 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 53 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 72 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 14 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 72 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…
-
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 66 views 10 comments 2 points Most recent by Shyam_Patel Reporting and Analytics for ERP -
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 132 views 2 comments 0 points Most recent by Farooq H Syed Reporting and Analytics for ERP -
Is there any Supplier Statement Report?Summary: Is there any Suppliers Statement Summary Report? including Opening and closing balance paid and unpaid invoices. Content (required): Supplier transactions Versi… -
Can multiple trees/hierarchies for the same segment be use in a single report?Summary: We are currently converting from PeopleSoft to Oracle ERP/EPM and are trying to understand the reporting and any potential limitations. We have multiple hierarc…Shannon Short 33 views 3 comments 0 points Most recent by Rakhi narayanan-Oracle Reporting and Analytics for ERP
-
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce…
-
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 2 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 2 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Reporting and Analytics for ERP
-
Adding a parameter to custom data model of a seeded reportSummary: We need to customize a seeded report and add a new parameter. But when we create a copy of seeded Data model and add a parameter in the custom data model, it gi…Ashu Raj-Oracle 55 views 3 comments 0 points Most recent by Bhaskar Konar 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…
-
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 50 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 45 views 8 comments 4 points Most recent by Andrew_Schmitz 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 2 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 939 views 13 comments 15 points Most recent by AnimeshAgrawal-Oracle 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 120 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP