Fusion Supply Chain Management reporting
Discussion List
-
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…
-
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…A Dineshkumar-Oracle 1 view 1 comment 1 point Most recent by KISHAN BUSSA Reporting and Analytics for ERP
-
Query to bring the BU to which a Customer Account Site is associated toSummary: Content (required): I need a query to retrieve the BU name associated to the Account Site . Thanks. Version (include the version you are using, if applicable): …Michal Shaked 103 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 186 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme…kalyan gade 91 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 336 views 3 comments 3 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Print Receipt Traveler Report erroring outSummary: We have got a requirement to customize Standard report "Receipt Traveler Report". I have customized the standard report in custom folder. I'm unable to run the …
-
Requires to create a role to create reports onlySummary: We have a requirement to create a role that have access to create reports only. Where any Financials or SCM or any other modules are not given access to create …Janitha Perera 176 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 1.3K views 5 comments 0 points Most recent by Hugo Martínez 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 352 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 61 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 71 views 3 comments 0 points Most recent by User521494-Oracle 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…Nageshwaran1 40 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 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 222 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 122 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 197 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 231 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 85 views 10 comments 2 points Most recent by Shyam_Patel Reporting and Analytics for ERP
-
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 130 views 3 comments 0 points Most recent by Rakhi narayanan-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
-
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…
-
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 117 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 75 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 21 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP