What are the different reporting tools available in Oracle Fusion

Oracle Fusion provides several reporting tools that cater to different reporting needs. Here are some of the key reporting tools available in Oracle Fusion:

1. Oracle Transactional Business Intelligence (OTBI): OTBI is a powerful self-service reporting tool that allows users to create and run ad hoc reports against transactional data in Oracle Fusion. It provides a user-friendly interface and a wide range of prebuilt reports and dashboards.

2. Oracle Business Intelligence Publisher (BI Publisher): BI Publisher is an enterprise reporting solution that enables the creation, management, and delivery of highly formatted documents and reports. It allows users to design pixel-perfect reports using various data sources and formats like PDF, Excel, Word, and more.

3. Oracle Smart View for Office: Smart View is an Excel-based reporting tool that provides ad hoc analysis and reporting capabilities for Oracle Fusion data. It allows users to retrieve and analyze data from multiple sources, create interactive reports, and share them with others.

Different subscription methods in Oracle Fusion

 Oracle Fusion, also known as Oracle Fusion Applications, is a suite of business applications designed to integrate and streamline various aspects of enterprise operations. When it comes to subscription methods for Oracle Fusion, there are primarily two options:

1. Cloud Subscription:

Oracle offers its Fusion Applications as a cloud-based Software-as-a-Service (SaaS) solution. In this subscription model, customers access and use the applications hosted on Oracle's cloud infrastructure. They pay a recurring subscription fee based on factors like the number of users, modules used, and the level of service required. This model eliminates the need for on-premises infrastructure, reduces maintenance efforts, and provides flexibility in scaling the application usage based on business needs.

Overview of Oracle Fusion Cloud Application

Oracle Fusion Cloud Applications is a suite of integrated cloud-based business applications developed by Oracle Corporation. It encompasses a wide range of enterprise resource planning (ERP), customer experience (CX), human capital management (HCM), supply chain management (SCM), and enterprise performance management (EPM) solutions.

Here's an overview of the key components and features of Oracle Fusion Cloud Applications:

1. Oracle Fusion ERP: This module covers financial management, procurement, project portfolio management, risk management, and more. It enables organizations to streamline their financial operations, automate processes, and gain real-time visibility into financial data.

2. Oracle Fusion HCM: This module focuses on managing human resources functions, including talent management, workforce management, benefits management, payroll, and employee self-service. It helps organizations optimize their HR processes, improve employee engagement, and enhance workforce productivity.

Oracle eTRM details of PO ASL tables

Table: PO_APPROVED_SUPPLIER_LIST

Description:	Approved supplier list

Primary Key: PO_APPROVED_SUPPLIER_LIST_PK

1. ASL_ID

Foreign Keys from this table:

Foreign Key Column	Foreign Table
PO_APPROVED_SUPPLIER_LIST.VENDOR_SITE_ID	PO_VENDOR_SITES_ALL
PO_APPROVED_SUPPLIER_LIST.VENDOR_ID	PO_VENDORS