Fusion Procurement 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 …Rohan Lobo-Oracle 7.1K views 51 comments 19 points Most recent by Pawan Lakhotia-Oracle Reporting and Analytics for ERP -
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi… -
Procurement Dashboard is not showing the correct informationSummary: My Procurement dashboard is not showing the correct information against the PR. The PR has been converted into the PO and system is showing it but Dashboard is …
-
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…
-
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 23 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…
-
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 975 views 37 comments 18 points Most recent by User_H52DZ Reporting and Analytics for ERP
-
oracle report to google sheet directlyis there any way to connect oracle BI and OTBI reports with online google sheet or offline excel file ? ThanksSandeep Nihalani 11 views 2 comments 0 points Most recent by Melissa G 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 50 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
PRC: SQL to get the Cost Center Owner approver's email address on RequisitionsSummary: We are currently investigating the process of being able to extract the Cost Center Approver email address. The cost center owner approval is setup in the secon…
-
OTBI-Report-Supplier Portal - Invoice Real Time-Roles RequieredSummary: OTBI-Report-Supplier Portal - Invoice Real Time-Roles Requiered Content (required): Hello The following document state the role required to run the Supplier Por…Cesar Saveedra 21 views 3 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…Eren Göktepe-155015 19 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the…
-
ERP Cloud list of payables invoice approversSummary: You can go into BPM and see, for a given invoice, the full list of approvers showing who submitted the invoice for approval, who the invoice is currently with f…User_AJ9D1 11 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Restrict OTBI report data(using subject area) to logged in userSummary How to restrict OTBI report data(using subject area) to logged in user. Currently it shows all data. Data access given at Business Unit level for the role.Conten… -
OTBI report - export to Excel limitationSummary: We have OTBI reports that will exceed the 50,000 field limitation for exporting to Excel. Content (required): Can you "schedule" an OTBI report to get around th…Kathy King 31 views 2 comments 0 points Most recent by Ghanshyam M-Oracle 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… -
Payables Invoices - Withholding Real Time - OTBI Not getting resultsSummary: Payables Invoices - Withholding Real Time - OTBI Not getting results Content (required): We are tying a build a quick OTBI analysis on the seeded subject area P…
-
OTBI Costing - Receipt Accounting Real Time subject area missing a transaction type on filterSummary I am trying to create a report in OTBI to record items I can see withing Supply Chain Execution > Receipt Accounting > Review Receipt Accounting DistributionsCon…Sarah Munro 12024679 19 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Procurement Agent ListSummary: Content (required): Is there a report that will show a list of our procurement agents and the permissions they have been assigned? We feel like many of them are…Annette M 4 views 2 comments 1 point Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
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 …User_ROPYL 3 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Is supplier audit report available in fusion?Summary: We are looking for standard report to track old value and new value when supplier name, supplier bank number, etc is changed. Please let us know is there any st…
-
Finally Closed Lines are shown as Cancelled in PO Archive LinesSummary: Some of the finally Closed lines on Change Orders are coming as cancelled in the Po archive lines Content (required): Version (include the version you are using…
-
Finally Closed Lines are shown as Cancelled in PO Archive LinesSummary: Some of the finally Closed lines on Change Orders are coming as cancelled in the Po archive lines Content (required): Version (include the version you are using…
-
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 769 views 14 comments 15 points Most recent by AnimeshAgrawal-Oracle Reporting and Analytics for ERP -
Procurement > Dashboards > Procure-to-Pay no 'Period' list of valuesSummary There is no value in the list of values for 'Period'Content Hi, I'm trying to open the seeded dashboard Procurement > Dashboards > Procure-to-Pay But with any us… -
How to get 'Payment date' on the Procure to Pay Real Time subject areaSummary: How to get 'Payment date' on the 'Procure to Pay Real Time' subject area Content : I am trying to build a report using the 'Procurement - Procure to Pay Real Ti…Sergio F Oliveira 1 view 3 comments 1 point Most recent by Sergio F Oliveira Reporting and Analytics for ERP -
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie…Mike Burnett 2 views 4 comments 4 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP