Fusion Procurement reporting
Discussion List
-
Manage Internal Supplier Profile Change ApprovalsCannot find Underlying Oracle Tables For The Setup And Maintenance Task - approval management Looking for the underlying Oracle tables for the Approval Management tasks,…NZ-user999 54 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
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 2.3K views 14 comments 15 points Most recent by User_2025-10-31-00-30-05-350 Reporting and Analytics for ERP -
How to create a BIP Report in excel with a drill down option?Summary: I would like to create a BIP Report of the list of the BPAs. Click on BPA I would extract the list of the POs linked, click on PO I would extract the lines and …Giuseppe Galluzzo 24 views 2 comments 0 points Most recent by Giuseppe Galluzzo Reporting and Analytics for ERP -
Is there a way to create a deep link from OAC into the invoice attachments in ERP?We've created a dashboard in OAC for invoice details. Users are able to click a deep link in that dashboard that will open an invoice in ERP. They are then able to click…Steven Woods 36 views 2 comments 1 point Most recent by Steven Woods Reporting and Analytics for ERP -
how to fetch current schedule process start time of any Oracle Fusion scheduled reportSummary: I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive sc…Grab.saurabh 91 views 2 comments 0 points Most recent by Grab.saurabh Reporting and Analytics for ERP -
How we get difference of two sum from the same table?Summary: Content (please ensure you mask any confidential information): Hi, We would create a column in a report who get a difference of two sum from the same table. Wha…Ylenia Gentile 29 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H… -
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…Thanigainathan R 422 views 4 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP -
User Role Memberships Report - possible location in OTBI?Apart from the scheduled process, the report can be seen. Is it also possible to locate this in OTBI? -
In Maternity Leave - Absence Type Balance is not Showing for the EmployeeSummary: Created a Maternity leave with Qualification Plan. But Absence Type Balance i am not able to see the number of balance days. -
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 585 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP -
Unable to find Award Open and Close date, and Award Approval Date in OTBIHello, I am working on an OTBI report that requires the following fields: Award Approval Date Award Open Date Award Close Date I was unable to locate them in the Procure… -
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 543 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP -
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha…
-
formatting currency through DM or RTF?Summary: when customizing a DM and RTF, I need to format the currency into $****,****.XX format. Content (please ensure you mask any confidential information): Should I … -
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report fileNageshwaran1 30 views 1 comment 0 points Most recent by Mahmoud Abdulghany Reporting and Analytics for ERP -
Oracle Social Network Cloud Service (OSN)Summary: Oracle Social Network Cloud Service (OSN) Content (please ensure you mask any confidential information): With oracle retire the Oracle Social Network Cloud Serv… -
retrieve latest entry from table OKC_K_HEADERS_TLSummary: I am trying to get only the entry that has the most recent creation date from this table. Content (please ensure you mask any confidential information): Creatio… -
Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsSummary Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsContent Hello Team, I am looking for the source code or Data base tables w…SandeepPaspunuri 116 views 4 comments 0 points Most recent by Murthym123 Reporting and Analytics for ERP -
query for rejected invoices and rejector commentSummary: We're looking for a query that will show rejected invoices and the reason they were rejected as well as the cost center and creator. Content (please ensure you … -
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 344 views 11 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
Does OTBI Scheduler return report in non-English?Summary: When we run OTBI in UI, it returns a report with all the colums in Japanese as we set the language preference to Japanese. However, when OTBI scheduler runs, th…CHIZURU SHIGA 21 views 4 comments 0 points Most recent by CHIZURU SHIGA Reporting and Analytics for ERP -
ESS Print Job Queue - Oracle Fusion CloudSummary Accessing the ESS Print Job Queue from Oracle Fusion Cloud.Content Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, cus… -
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… -
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo… -
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…Dineshkumar.A-Oracle 5 views 1 comment 1 point Most recent by KISHAN BUSSA Reporting and Analytics for ERP -
How can I create an event trigger in a data model with subject area?I have created a report with a data model with subject area and this report works fine, but I want to create an event trigger so that the report is only generated if it …Vanessa Garma 14 views 0 comments 0 points Most recent by Vanessa Garma BI Publisher Learning Center -
Getting an error while trying to open Supplier Master OTBI reportSummary: Unable to open Supplier Master report created in OTBI Content (required): Hi, I have created a supplier master report in OTBI with the fields such as Supplier N… -
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…Tawfeeq.Khan 11 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP