Steps involved in creating an Oracle Transactional Business Control (TBC) report in Oracle Fusion

To create an Oracle Transactional Business Control (TBC) report in Oracle Fusion, you would typically follow these steps:

1. Log in to Oracle Fusion: Access the Oracle Fusion application using your credentials.

2. Navigate to the Reports and Analytics Work Area: Use the Navigator menu to locate the "Reports and Analytics" work area. Click on it to enter the reporting environment.

3. Create a New Report: In the reporting environment, select the option to create a new report. This might be labeled as "New" or "Create Report" depending on the specific version of Oracle Fusion you are using.

What are the steps involved in creating an Oracle Smart View for Office report

To create an Oracle Smart View for Office report, you can follow these general steps:

1. Install Oracle Smart View for Office: Download and install the Oracle Smart View for Office software on your computer. Ensure you have the necessary permissions and access to the data sources you plan to connect to.

2. Launch Oracle Smart View: Open Microsoft Excel and launch the Oracle Smart View add-in. You should see the Smart View toolbar or ribbon in Excel.

3. Connect to Data Source: Click on the "Connect" button on the Smart View toolbar to establish a connection to your data source. This could be an Oracle Essbase cube, Oracle Hyperion Planning application, or other supported data sources.

What are the steps involved in creating an BI Publisher report in Oracle Fusion

To create an Oracle Business Intelligence Publisher (BI Publisher) report in Oracle Fusion, you can follow these general steps:

1. Access BI Publisher: Log in to your Oracle Fusion application and navigate to the BI Publisher section.

2. Create a Data Model: Start by creating a data model that defines the data source for your report. This involves connecting to the appropriate database or data source, defining queries, and mapping the result sets to the report fields.

3. Design the Layout: Once the data model is created, you need to design the layout of your report. BI Publisher provides a template builder that allows you to create report layouts using a drag-and-drop interface. You can add tables, charts, images, and other components to the layout as needed.

Steps involved in creating an Oracle Transactional Business Intelligence (OTBI) report in Oracle Fusion

To create a sample Oracle Transactional Business Intelligence (OTBI) report in Oracle Fusion, you can follow these steps:

1. Access the OTBI application: Log in to your Oracle Fusion instance and navigate to the "Business Intelligence" area. Depending on your setup, you may find it under "Tools," "Analytics and Reporting," or a similar menu option.

2. Create a new analysis: Once in the OTBI application, locate the option to create a new analysis or report. Click on it to begin building your report.

3. Select subject area: In the analysis creation wizard, you'll be prompted to select a subject area. A subject area defines the data you can access in your report. Choose the appropriate subject area that contains the data you want to include in your report. For example, if you want to create a report on sales, select the "Sales - CRM" subject area.

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

Oracle eTRM details of PO Accrual Tables

 Table: PO_ACCRUAL_ACCOUNTS_TEMP_ALL

Description:	Accrual accounts temporary table

Comments

PO_ACCRUAL_ACCOUNT_TEMP_ALL is a temporary table used by Oracle
Purchasing to generate the Accrual Reconciliation Report.
.

Oracle eTRM details of PO Bid tables

Table: PON_BID_HEADERS_EXT_B

Description:	Stores the UDA attributes of header level data for a response to a negotiation

Primary Key: PON_BID_HEADERS_EXT_B_PK

1. EXTENSION_ID

Comments

For future use

Oracle eTRM details of the PO Auction Tables

Table: PON_AUCTION_HEADERS_EXT_B

Description:

Comments

This table stores the data for User Defined Attributes linked to the Solicitation Header. Corresponding to each solicitation header record, there will be one record per attribute group associated for single row Attribute groups. For multi row attribute groups (such as addresses) there will be one record per row of the multi row attribute group. Extension_id (sequence generated) is the primary key for the table. For single row attribute groups, the combination of auction_header_id and attribute_group_id will also be unique. For multi row attribute groups, the uniqueness will be on auction_header_id, attribute_group_id + the database columns which map to the attributes which are part of the unique key for that attribute group.

Oracle eTRM Table Details PO_ACCEPTANCES

Table: PO_ACCEPTANCES

Description:	Purchase order acceptances

Primary Key: PO_ACCEPTANCES_PK

1. ACCEPTANCE_ID

Foreign Keys from this table:

Table Details - PO_AGENTS

Table: PO_AGENTS

Description:	Buyers table

Primary Key: PO_AGENTS_PK

1. AGENT_ID

Foreign Keys from this table:

Oracle Apps R12 - Order Management Tables and Description

The blog post details all the tables in Order management:

Table Name

Description

OE_ACTIONS_IFACE_ALL

This is the open interface table for Order Management action requests. User can populate this table with data to perform a variety of actions such as booking, hold application and removal, automatic attachments, fulfillment set application and removal, match and reserve for Configured items, get ship method and freight rates (both individually and together), and the linking and delinking of Configured items.

View Definition - AP_WEB_PA_PROJECTS_V

 SELECT PROJECT_ID

, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, START_DATE
, COMPLETION_DATE

View Definition - AP_WEB_PEOPLE_LOV_V

 SELECT P.BUSINESS_GROUP_ID

, A.ORGANIZATION_ID
, P.PERSON_ID EMPLOYEE_ID
, A.ASSIGNMENT_ID
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY

View Definition - AP_WEB_SIGNING_LIMITS_V

 SELECT SL.ROWID ROW_ID

, HR.FULL_NAME EMPLOYEE_NAME
, SL.EMPLOYEE_ID
, AL.DISPLAYED_FIELD DISPLAYED_DOCUMENT_TYPE
, SL.DOCUMENT_TYPE
, SL.COST_CENTER
, SL.SIGNING_LIMIT
, SL.LAST_UPDATE_DATE

View Definition - AP_WFAPPROVAL_HISTORY_V

 ( SELECT DISTINCT HIS.INVOICE_ID

, HIS.LINE_NUMBER
, HIS.RESPONSE
, HIS.APPROVER_ID
, HIS.APPROVER_NAME
, HIS.AMOUNT_APPROVED

View Definition - AP_XML_BATCHLEVEL2_V

 SELECT HOU.NAME

, AISC.CHECKRUN_ID
, AISC.CHECKRUN_NAME
, AISC.CHECK_DATE
, HL.TOWN_OR_CITY
, HL.REGION_1
, HL.REGION_2
, HL.COUNTRY

View Definition - AP_XML_BATCHLEVEL_V

 SELECT AISC.CHECKRUN_ID BATCH_ID

, AISC.CHECKRUN_NAME BATCH_NAME
, AISC.ORG_ID
, AISC.CHECK_DATE
, AISC.CURRENCY_CODE
, HOU.NAME ORG_NAME
, HL.ADDRESS_LINE_1