Oracle Apps

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

noreply@blogger.com (Unknown) — Wed, 12 Jul 2023 04:11:00 +0000

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.

4. Select the Data Source: Choose the appropriate data source for your TBC report. This could be an existing data set or a custom data set created specifically for this report.

5. Define the Report Structure: Determine the layout and structure of your TBC report. This involves selecting the relevant fields, arranging them in the desired order, and specifying any grouping or summarization requirements.

6. Apply Filters and Parameters: Add filters and parameters to narrow down the data included in the report. This helps you focus on specific transactional data relevant to your analysis.

7. Customize Report Formatting: Adjust the formatting options to suit your preferences and requirements. This includes choosing fonts, colors, column widths, and other visual elements to enhance the report's appearance.

8. Configure Calculations and Formulas: If needed, set up calculations or formulas within the report to perform calculations or derive additional insights from the data.

9. Preview and Validate the Report: Preview the report to ensure it looks as expected. Validate the data and calculations to verify accuracy and correctness.

10. Save the Report: Save the report in the desired location within Oracle Fusion's reporting environment. Provide an appropriate name and description for easy identification.

11. Schedule or Share the Report: If required, schedule the report to run automatically at specific intervals. Alternatively, you can share the report with other users or distribute it in various formats such as PDF, Excel, or HTML.

12. Test and Refine: Test the report thoroughly to ensure it meets your requirements. Make any necessary adjustments or refinements based on feedback and user validation.

It's important to note that the specific steps and terminology might vary slightly depending on the version of Oracle Fusion you are using.

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

noreply@blogger.com (Unknown) — Tue, 11 Jul 2023 18:18:00 +0000

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.

4. Define Query or Retrieve Data: Once connected, you can define a query or retrieve data from the selected data source. This may involve selecting specific dimensions, members, or measures to include in your report.

5. Apply Filters and Prompts: If needed, you can apply filters or prompts to refine your data selection. This allows you to focus on specific subsets of data or customize the report based on user input.

6. Format the Report: Use Excel's formatting features to enhance the appearance of your report. You can apply styles, adjust cell formatting, and create visualizations such as charts or graphs.

7. Add Calculations and Formulas: Utilize Excel's formulas and Smart View's calculation capabilities to perform calculations or create derived measures within your report. This allows you to derive insights or perform complex analyses on the retrieved data.

8. Save and Share: Once you have completed your report, save it as an Excel file. You can share the file with others who have Smart View installed, or you can publish the report to an Oracle Enterprise Performance Management (EPM) system for wider distribution.

These steps provide a general outline for creating an Oracle Smart View for Office report. The specific details and options available may vary depending on the version of Smart View and the data sources you are using. It's recommended to consult the Oracle Smart View documentation or user guides for more detailed instructions and guidance.

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

noreply@blogger.com (Unknown) — Tue, 11 Jul 2023 18:14:00 +0000

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.

4. Define Report Parameters: If your report requires user input or customization, you can define report parameters. These parameters allow users to filter data or provide input during report generation. Parameters can be defined in the data model and referenced in the report layout.

5. Add Report Logic: If your report requires any calculations, conditional formatting, or other custom logic, you can add it using the available functions and expressions provided by BI Publisher. These can be added to the data model or the report layout, depending on the requirements.

6. Preview and Test: Before finalizing the report, it's essential to preview and test it. Use the preview feature in BI Publisher to generate sample output and verify that the data, layout, and logic are as expected. Make any necessary adjustments or corrections based on the preview results.

7. Save and Publish: Once you are satisfied with the report design and functionality, save it in BI Publisher. You can also choose to publish the report to make it available for end-users. Publishing the report typically involves specifying the appropriate delivery options (e.g., email, file server, printer) and scheduling options (e.g., one-time, recurring).

8. Distribute and Access the Report: After the report is published, users can access it through the designated channels or interfaces provided by Oracle Fusion. Depending on the permissions and access controls, users can run the report, provide input to parameters, and view or download the generated output.

These steps provide a general overview of the process involved in creating a BI Publisher report in Oracle Fusion. The actual steps and options may vary depending on the specific version and configuration of your Oracle Fusion application. It's recommended to refer to the official documentation or consult with your organization's Oracle Fusion administrators for detailed instructions and guidance.

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

noreply@blogger.com (Unknown) — Tue, 11 Jul 2023 17:58:00 +0000

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.

4. Define criteria: After selecting the subject area, you can define criteria to filter the data in your report. This step allows you to narrow down the information to be displayed. For example, you can specify a date range, specific product categories, or regions.

5. Add columns: Once you have defined the criteria, you can add columns to your report. Columns represent the fields or attributes you want to include in your report's result set. Select the desired columns from the subject area and arrange them in the desired order.

6. Apply sorting and formatting: You can apply sorting to the columns to control the order in which the data appears. Additionally, you can apply formatting options to enhance the visual presentation of your report, such as font styles, colors, and conditional formatting.

7. Create filters and prompts (optional): If you want to allow report users to dynamically filter or select data when running the report, you can add filters and prompts. Filters restrict the data based on specific conditions, while prompts allow users to input values or select from a predefined list.

8. Save and run the report: Once you have finished building your report, save it and give it a meaningful name. You can then run the report to see the results based on the defined criteria and columns.

9. Customize layout and views (optional): If you want to further customize the report's layout or create different views with different visualizations, you can explore the available options in the OTBI application. You can modify column properties, create charts, pivot tables, and more.

10. Share and distribute the report: After creating and finalizing your report, you can share it with others in your organization. OTBI provides options to schedule report deliveries via email or publish reports to specific users or groups.

These steps should provide a general framework for creating a sample OTBI report in Oracle Fusion. Keep in mind that the specific interface and options may vary slightly depending on the version and configuration of your Oracle Fusion environment.

What are the different reporting tools available in Oracle Fusion

noreply@blogger.com (Unknown) — Tue, 11 Jul 2023 17:55:00 +0000

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.

4. Oracle Transactional Reporting (OTR): OTR is a built-in reporting tool in Oracle Fusion Applications that allows users to create and customize reports based on transactional data. It offers a range of standard report templates and the flexibility to define custom reports.

5. Oracle Fusion Analytics Warehouse (FAW): FAW is a data warehousing and reporting solution that provides a comprehensive set of prebuilt reports and dashboards for Oracle Fusion Applications. It offers deep insights into various aspects of business performance and allows users to perform advanced analytics.

6. Oracle Business Activity Monitoring (BAM): BAM is a real-time monitoring and reporting tool that tracks and analyzes key business metrics and events in Oracle Fusion. It provides interactive dashboards, alerts, and notifications to help users monitor and respond to critical business events.

7. Oracle Transactional Business Control (TBC): TBC is a reporting and control tool that enables users to define and enforce business policies, rules, and controls in Oracle Fusion Applications. It provides real-time visibility into compliance and control-related data.

These are some of the prominent reporting tools available in Oracle Fusion, each offering different functionalities and capabilities to meet diverse reporting requirements.

Different subscription methods in Oracle Fusion

noreply@blogger.com (Unknown) — Tue, 11 Jul 2023 17:49:00 +0000

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.

2. On-Premises Subscription:

While Oracle Fusion Applications are primarily offered as a cloud-based SaaS solution, Oracle also provides an option for on-premises deployment. In this case, customers can install and host the Fusion Applications within their own data centers. They acquire a perpetual license for the software, paying an upfront fee for the license and subsequent annual maintenance fees. This model is suitable for organizations with specific requirements for maintaining applications on their own infrastructure or complying with certain regulations.

It's worth noting that Oracle primarily focuses on delivering Fusion Applications through the cloud subscription model, encouraging customers to migrate from traditional on-premises deployments to the cloud. Therefore, the availability and features of the on-premises subscription option may vary depending on the specific Oracle Fusion product and version. It's advisable to consult with Oracle or an authorized Oracle partner for the most up-to-date information on subscription options and licensing models.

Overview of Oracle Fusion Cloud Application

noreply@blogger.com (Unknown) — Tue, 11 Jul 2023 17:48:00 +0000

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.

3. Oracle Fusion CX: This module supports customer relationship management (CRM) activities, including sales, marketing, service, and commerce. It enables businesses to deliver personalized customer experiences, automate sales processes, track customer interactions, and drive customer loyalty.

4. Oracle Fusion SCM: This module covers supply chain planning, logistics, order management, inventory management, and manufacturing operations. It helps organizations optimize their supply chain processes, enhance collaboration with suppliers and partners, and improve overall operational efficiency.

5. Oracle Fusion EPM: This module focuses on financial planning, budgeting, forecasting, and performance reporting. It provides businesses with tools to align their financial goals with operational plans, monitor performance, and make data-driven decisions.

Key features and benefits of Oracle Fusion Cloud Applications include:

- Integrated suite: Oracle Fusion Cloud Applications offer seamless integration between various modules, providing a holistic view of business operations and enabling cross-functional collaboration.

- Scalability and flexibility: The applications are built on a scalable cloud infrastructure, allowing organizations to adapt and grow as their business needs evolve. They can easily add or remove modules as required.

- Intelligent automation: Oracle Fusion Cloud Applications leverage artificial intelligence (AI) and machine learning (ML) capabilities to automate repetitive tasks, optimize processes, and provide actionable insights.

- Enhanced security and compliance: Oracle incorporates robust security measures to protect sensitive data and ensure compliance with industry regulations.

- Mobile and collaborative: The applications are designed to be accessible from anywhere, on any device, enabling employees to collaborate, make decisions, and take action on the go.

- Continuous innovation: Oracle provides regular updates and new features to its Fusion Cloud Applications, ensuring organizations benefit from the latest advancements in technology and best practices.

Overall, Oracle Fusion Cloud Applications provide a comprehensive suite of cloud-based solutions that empower organizations to streamline their operations, enhance customer experiences, optimize their workforce, and drive business growth.

Oracle eTRM details of PO ASL tables

noreply@blogger.com (Unknown) — Fri, 07 May 2021 19:14:00 +0000

Table: PO_APPROVED_SUPPLIER_LIST

Description:	Approved supplier list

Primary Key: PO_APPROVED_SUPPLIER_LIST_PK

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

Comments

PO_APPROVED_SUPPLIER_LIST stores the relationship between an item or
commodity; a supplier, distributor, or manufacturer; ship-to
organizations; and approval/certification status.

Indexes

Index	Type	Tablespace	Column
PO_APPROVED_SUPPLIER_LIST_U1	UNIQUE	APPS_TS_TX_IDX	ASL_ID
PO_APPROVED_SUPPLIER_LIST_N1	NONUNIQUE	APPS_TS_TX_IDX	ITEM_ID VENDOR_ID
PO_APPROVED_SUPPLIER_LIST_N2	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_ID VENDOR_ID
PO_APPROVED_SUPPLIER_LIST_N3	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID PRIMARY_VENDOR_ITEM

Columns

Name	Datatype	Length	Mandatory	Comments
ASL_ID	NUMBER		Y	ASL unique identifier
USING_ORGANIZATION_ID	NUMBER		Y	Ship-to organization using this record
OWNING_ORGANIZATION_ID	NUMBER		Y	Organization that created the record initially
VENDOR_BUSINESS_TYPE	VARCHAR2	(25)	Y	Business type of Distributor, Direct, or Manufacturer
ASL_STATUS_ID	NUMBER		Y	Approval/certification status
LAST_UPDATE_DATE	DATE		Y	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Y	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Y	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
MANUFACTURER_ID	NUMBER			Manufacturer
VENDOR_ID	NUMBER			Supplier
ITEM_ID	NUMBER			Item
CATEGORY_ID	NUMBER			Category
VENDOR_SITE_ID	NUMBER			Supplier site
PRIMARY_VENDOR_ITEM	VARCHAR2	(25)		Supplier, Manufacturer, or Distributor item number
MANUFACTURER_ASL_ID	NUMBER			Manufacturer associated with distributor
REVIEW_BY_DATE	DATE			Review by date
COMMENTS	VARCHAR2	(240)		Comments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
DISABLE_FLAG	VARCHAR2	(1)		Indicator of whether the ASL entry has been disabled

Name	Datatype	Length
SESSION_KEY	NUMBER
USER_KEY	NUMBER
PROCESS_ACTION	VARCHAR2	(30)
PROCESS_STATUS	VARCHAR2	(30)
ASL_ID	NUMBER
USING_ORGANIZATION_ID	NUMBER
USING_ORGANIZATION_DSP	VARCHAR2	(240)
OWNING_ORGANIZATION_ID	NUMBER
OWNING_ORGANIZATION_DSP	VARCHAR2	(240)
VENDOR_BUSINESS_TYPE	VARCHAR2	(25)
ASL_STATUS_ID	NUMBER
ASL_STATUS_DSP	VARCHAR2	(25)
MANUFACTURER_ID	NUMBER
MANUFACTURER_DSP	VARCHAR2	(100)
VENDOR_ID	NUMBER
VENDOR_DSP	VARCHAR2	(240)
ITEM_ID	NUMBER
ITEM_DSP	VARCHAR2	(50)
CATEGORY_ID	NUMBER
CATEGORY_DSP	VARCHAR2	(240)
VENDOR_SITE_ID	NUMBER
VENDOR_SITE_DSP	VARCHAR2	(240)
PRIMARY_VENDOR_ITEM	VARCHAR2	(25)
MANUFACTURER_ASL_ID	NUMBER
MANUFACTURER_ASL_DSP	VARCHAR2	(50)
REVIEW_BY_DATE	DATE
COMMENTS	VARCHAR2	(240)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
DISABLE_FLAG	VARCHAR2	(1)

Index	Type	Tablespace	Column
PO_ASL_ATTRIBUTES_U1	UNIQUE	APPS_TS_TX_IDX	ASL_ID USING_ORGANIZATION_ID
PO_ASL_ATTRIBUTES_N1	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID ITEM_ID
PO_ASL_ATTRIBUTES_N2	NONUNIQUE	APPS_TS_TX_IDX	USING_ORGANIZATION_ID
PO_ASL_ATTRIBUTES_N3	NONUNIQUE	APPS_TS_TX_IDX	ENABLE_VMI_FLAG
PO_ASL_ATTRIBUTES_N4	NONUNIQUE	APPS_TS_TX_IDX	CONSIGNED_FROM_SUPPLIER_FLAG

Name	Datatype	Length	Mandatory	Comments
STATUS_ID	NUMBER		Y	Status unique identifier
STATUS	VARCHAR2	(25)	Y	Status name
STATUS_DESCRIPTION	VARCHAR2	(240)	Y	Status description
ASL_DEFAULT_FLAG	VARCHAR2	(1)	Y	Default status for new approved supplier list records
LAST_UPDATE_DATE	DATE		Y	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Y	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Y	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
INACTIVE_DATE	DATE			Inactive date
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ZD_EDITION_NAME	VARCHAR2	(30)	Y

Foreign Key Column	Foreign Table
PO_ACCRUAL_WRITE_OFFS_ALL.ACCRUAL_ACCOUNT_ID	GL_CODE_COMBINATIONS
PO_ACCRUAL_WRITE_OFFS_ALL.PO_TRANSACTION_ID	RCV_TRANSACTIONS
PO_ACCRUAL_WRITE_OFFS_ALL.INV_TRANSACTION_ID	MTL_MATERIAL_TRANSACTIONS
PO_ACCRUAL_WRITE_OFFS_ALL.WIP_TRANSACTION_ID	WIP_TRANSACTIONS
PO_ACCRUAL_WRITE_OFFS_ALL.PO_HEADER_ID	PO_HEADERS_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.PO_LINE_ID	PO_LINES_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.VENDOR_ID	PO_VENDORS
PO_ACCRUAL_WRITE_OFFS_ALL.INVOICE_ID	AP_INVOICES_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.REASON_ID	MTL_TRANSACTION_REASONS

Index	Type	Tablespace	Column
PO_ACCRUAL_WRITE_OFFS_U1	UNIQUE	APPS_TS_TX_IDX	WRITE_OFF_ID
PO_ACCRUAL_WRITE_OFFS_N1	NONUNIQUE	APPS_TS_TX_IDX	PO_DISTRIBUTION_ID PO_TRANSACTION_ID
PO_ACCRUAL_WRITE_OFFS_N2	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_LINE_NUM
PO_ACCRUAL_WRITE_OFFS_N3	NONUNIQUE	APPS_TS_TX_IDX	INV_TRANSACTION_ID
PO_ACCRUAL_WRITE_OFFS_N4	NONUNIQUE	APPS_TS_TX_IDX	WIP_TRANSACTION_ID

Name	Datatype	Length	Mandatory	Comments
WRITE_OFF_ID	NUMBER		Y	Write-off unique identifier
LAST_UPDATE_DATE	DATE		Y	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Y	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Y	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		Y	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PERIOD_NAME	VARCHAR2	(15)		Accounting period name
WRITE_OFF_GL_DATE	DATE		Y	The General Ledger date for the manual journal entry
TRANSACTION_ORGANIZATION_ID	NUMBER		Y	Organization where transaction took place
ITEM_MASTER_ORGANIZATION_ID	NUMBER		Y	Item Master/Purchasing reference organization
ACCRUAL_ACCOUNT_ID	NUMBER	(25)	Y	Accrual account unique identifier
ACCRUAL_CODE	VARCHAR2	(80)	Y	Type of transaction or A/P match condition
PO_TRANSACTION_TYPE	VARCHAR2	(25)		Purchasing transaction code
TRANSACTION_DATE	DATE		Y	Original transaction date
INVOICE_NUM	VARCHAR2	(50)		Invoice number
RECEIPT_NUM	VARCHAR2	(30)		Receipt number
PO_TRANSACTION_ID	NUMBER			Receiving transaction unique identifier
INV_TRANSACTION_ID	NUMBER			Inventory transaction unique identifier
INV_TRANSACTION_TYPE_ID	NUMBER			Inventory transaction type unique identifier
WIP_TRANSACTION_ID	NUMBER			WIP transaction unique identifier
WIP_TRANSACTION_TYPE_ID	NUMBER			WIP transaction type unique identifier
INVENTORY_ITEM_ID	NUMBER			Item unique identifier
PO_UNIT_OF_MEASURE	VARCHAR2	(25)		Purchasing unit of measure
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)		Primary unit of measure for the item
TRANSACTION_QUANTITY	NUMBER			Quantity for the transaction
NET_PO_LINE_QUANTITY	NUMBER			PO line invoice quantity less the receipt quantity
PO_HEADER_ID	NUMBER			Document header unique identifier
PO_NUM	VARCHAR2	(20)		PO number
PO_LINE_NUM	NUMBER			Purchase order line number
PO_LINE_ID	NUMBER			Document line unique identifier
PO_DISTRIBUTION_ID	NUMBER			Document distribution unique identifier
VENDOR_ID	NUMBER			Supplier unique identifier
VENDOR_NAME	VARCHAR2	(240)		Supplier name
TRANSACTION_UNIT_PRICE	NUMBER			Unit price for transaction
INVOICE_ID	NUMBER			Invoice unique identifier
INVOICE_LINE_NUM	NUMBER			Invoice distribution number
AVG_RECEIPT_PRICE	NUMBER			Average receipt price for the purchase order line
TRANSACTION_AMOUNT	NUMBER			Transaction debit or credit
LINE_MATCH_ORDER	NUMBER			Line sequence number for printing the Accrual Reconciliation Report
TRANSACTION_SOURCE_CODE	VARCHAR2	(25)	Y	Transaction source or subledger
REASON_ID	NUMBER			Transaction reason unique identifier
COMMENTS	VARCHAR2	(240)		Comments for the accrual write-off
WRITE_OFF_CODE	VARCHAR2	(25)		Write-off status for the write-off transaction
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination type for the transaction
INVOICE_PRICE_VARIANCE	NUMBER			For pre-release 10 transactions, the reported IPV
ORG_ID	NUMBER			Organization identifier
ADJUSTMENT_TRANSACTION	NUMBER			Specifies if the transaction is a retroactive price adjustment
ENTERED_TRANSACTION_AMOUNT	NUMBER			Transaction amount in the entered currency
CURRENCY_CODE	VARCHAR2	(15)		Currency code of the entered currency
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type used
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate used
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date

Name	Datatype	Mandatory	Comments
TRANSACTION_AMOUNT	NUMBER		transaction amount
WRITE_OFF_ID	NUMBER	Y	write off identifier
AVG_RECEIPT_PRICE	NUMBER		average receipt price
TRANSACTION_UNIT_PRICE	NUMBER		transaction unit price
INVOICE_PRICE_VARIANCE	NUMBER		invoice price variance
SET_OF_BOOKS_ID	NUMBER		set of books identifier
SECURITY_GROUP_ID	NUMBER		Security group identifier

Name	Datatype	Length	Mandatory	Comments
EXTENSION_ID	NUMBER		Y	Stores Extension id.
ATTR_GROUP_ID	VARCHAR2	(30)	Y	Stores Attribute Group Id
BID_NUMBER	NUMBER		Y	Stores the BID Number, Unique Identifier.
DATA_LEVEL_ID	NUMBER			Stores Data Level ID.
PK1_VALUE	NUMBER			PK1_VALUE
PK2_VALUE	NUMBER			PK2_VALUE
PK3_VALUE	NUMBER			PK3_VALUE
PK4_VALUE	NUMBER			PK4_VALUE
PK5_VALUE	NUMBER			PK5_VALUE
LAST_UPDATE_DATE	DATE		Y	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Y	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Y	Standard who column - date when this row was created.
C_EXT_ATTR1	VARCHAR2	(4000)		C_EXT_ATTR1
C_EXT_ATTR2	VARCHAR2	(4000)		C_EXT_ATTR2
C_EXT_ATTR3	VARCHAR2	(4000)		C_EXT_ATTR3
C_EXT_ATTR4	VARCHAR2	(4000)		C_EXT_ATTR4
C_EXT_ATTR5	VARCHAR2	(4000)		C_EXT_ATTR5
C_EXT_ATTR6	VARCHAR2	(4000)		C_EXT_ATTR6
C_EXT_ATTR7	VARCHAR2	(4000)		C_EXT_ATTR7
C_EXT_ATTR8	VARCHAR2	(4000)		C_EXT_ATTR8
C_EXT_ATTR9	VARCHAR2	(4000)		C_EXT_ATTR9
C_EXT_ATTR10	VARCHAR2	(4000)		C_EXT_ATTR10
C_EXT_ATTR11	VARCHAR2	(4000)		C_EXT_ATTR11
C_EXT_ATTR12	VARCHAR2	(4000)		C_EXT_ATTR12
C_EXT_ATTR13	VARCHAR2	(4000)		C_EXT_ATTR13
C_EXT_ATTR14	VARCHAR2	(4000)		C_EXT_ATTR14
C_EXT_ATTR15	VARCHAR2	(4000)		C_EXT_ATTR15
C_EXT_ATTR16	VARCHAR2	(4000)		C_EXT_ATTR16
C_EXT_ATTR17	VARCHAR2	(4000)		C_EXT_ATTR17
C_EXT_ATTR18	VARCHAR2	(4000)		C_EXT_ATTR18
C_EXT_ATTR19	VARCHAR2	(4000)		C_EXT_ATTR19
C_EXT_ATTR20	VARCHAR2	(4000)		C_EXT_ATTR20
C_EXT_ATTR21	VARCHAR2	(4000)		C_EXT_ATTR21
C_EXT_ATTR22	VARCHAR2	(4000)		C_EXT_ATTR22
C_EXT_ATTR23	VARCHAR2	(4000)		C_EXT_ATTR23
C_EXT_ATTR24	VARCHAR2	(4000)		C_EXT_ATTR24
C_EXT_ATTR25	VARCHAR2	(4000)		C_EXT_ATTR25
C_EXT_ATTR26	VARCHAR2	(4000)		C_EXT_ATTR26
C_EXT_ATTR27	VARCHAR2	(4000)		C_EXT_ATTR27
C_EXT_ATTR28	VARCHAR2	(4000)		C_EXT_ATTR28
C_EXT_ATTR29	VARCHAR2	(4000)		C_EXT_ATTR29
C_EXT_ATTR30	VARCHAR2	(4000)		C_EXT_ATTR30
C_EXT_ATTR31	VARCHAR2	(4000)		C_EXT_ATTR31
C_EXT_ATTR32	VARCHAR2	(4000)		C_EXT_ATTR32
C_EXT_ATTR33	VARCHAR2	(4000)		C_EXT_ATTR33
C_EXT_ATTR34	VARCHAR2	(4000)		C_EXT_ATTR34
C_EXT_ATTR35	VARCHAR2	(4000)		C_EXT_ATTR35
C_EXT_ATTR36	VARCHAR2	(4000)		C_EXT_ATTR36
C_EXT_ATTR37	VARCHAR2	(4000)		C_EXT_ATTR37
C_EXT_ATTR38	VARCHAR2	(4000)		C_EXT_ATTR38
C_EXT_ATTR39	VARCHAR2	(4000)		C_EXT_ATTR39
C_EXT_ATTR40	VARCHAR2	(4000)		C_EXT_ATTR40
N_EXT_ATTR1	NUMBER			N_EXT_ATTR1
N_EXT_ATTR2	NUMBER			N_EXT_ATTR2
N_EXT_ATTR3	NUMBER			N_EXT_ATTR3
N_EXT_ATTR4	NUMBER			N_EXT_ATTR4
N_EXT_ATTR5	NUMBER			N_EXT_ATTR5
N_EXT_ATTR6	NUMBER			N_EXT_ATTR6
N_EXT_ATTR7	NUMBER			N_EXT_ATTR7
N_EXT_ATTR8	NUMBER			N_EXT_ATTR8
N_EXT_ATTR9	NUMBER			N_EXT_ATTR9
N_EXT_ATTR10	NUMBER			N_EXT_ATTR10
N_EXT_ATTR11	NUMBER			N_EXT_ATTR11
N_EXT_ATTR12	NUMBER			N_EXT_ATTR12
N_EXT_ATTR13	NUMBER			N_EXT_ATTR13
N_EXT_ATTR14	NUMBER			N_EXT_ATTR14
N_EXT_ATTR15	NUMBER			N_EXT_ATTR15
N_EXT_ATTR16	NUMBER			N_EXT_ATTR16
N_EXT_ATTR17	NUMBER			N_EXT_ATTR17
N_EXT_ATTR18	NUMBER			N_EXT_ATTR18
N_EXT_ATTR19	NUMBER			N_EXT_ATTR19
N_EXT_ATTR20	NUMBER			N_EXT_ATTR20
UOM_EXT_ATTR1	VARCHAR2	(3)		UOM_EXT_ATTR1
UOM_EXT_ATTR2	VARCHAR2	(3)		UOM_EXT_ATTR2
UOM_EXT_ATTR3	VARCHAR2	(3)		UOM_EXT_ATTR3
UOM_EXT_ATTR4	VARCHAR2	(3)		UOM_EXT_ATTR4
UOM_EXT_ATTR5	VARCHAR2	(3)		UOM_EXT_ATTR5
UOM_EXT_ATTR6	VARCHAR2	(3)		UOM_EXT_ATTR6
UOM_EXT_ATTR7	VARCHAR2	(3)		UOM_EXT_ATTR7
UOM_EXT_ATTR8	VARCHAR2	(3)		UOM_EXT_ATTR8
UOM_EXT_ATTR9	VARCHAR2	(3)		UOM_EXT_ATTR9
UOM_EXT_ATTR10	VARCHAR2	(3)		UOM_EXT_ATTR10
UOM_EXT_ATTR11	VARCHAR2	(3)		UOM_EXT_ATTR11
UOM_EXT_ATTR12	VARCHAR2	(3)		UOM_EXT_ATTR12
UOM_EXT_ATTR13	VARCHAR2	(3)		UOM_EXT_ATTR13
UOM_EXT_ATTR14	VARCHAR2	(3)		UOM_EXT_ATTR14
UOM_EXT_ATTR15	VARCHAR2	(3)		UOM_EXT_ATTR15
UOM_EXT_ATTR16	VARCHAR2	(3)		UOM_EXT_ATTR16
UOM_EXT_ATTR17	VARCHAR2	(3)		UOM_EXT_ATTR17
UOM_EXT_ATTR18	VARCHAR2	(3)		UOM_EXT_ATTR18
UOM_EXT_ATTR19	VARCHAR2	(3)		UOM_EXT_ATTR19
UOM_EXT_ATTR20	VARCHAR2	(3)		UOM_EXT_ATTR20
D_EXT_ATTR1	DATE			D_EXT_ATTR1
D_EXT_ATTR2	DATE			D_EXT_ATTR2
D_EXT_ATTR3	DATE			D_EXT_ATTR3
D_EXT_ATTR4	DATE			D_EXT_ATTR4
D_EXT_ATTR5	DATE			D_EXT_ATTR5
D_EXT_ATTR6	DATE			D_EXT_ATTR6
D_EXT_ATTR7	DATE			D_EXT_ATTR7
D_EXT_ATTR8	DATE			D_EXT_ATTR8
D_EXT_ATTR9	DATE			D_EXT_ATTR9
D_EXT_ATTR10	DATE			D_EXT_ATTR10
UDA_TEMPLATE_ID	NUMBER			UDA_TEMPLATE_ID

Name	Datatype	Length	Mandatory	Comments
EXTENSION_ID	NUMBER		Y	Stores the EXTENSION_ID
ATTR_GROUP_ID	VARCHAR2	(30)	Y	Stores the Stores the ATTR_GROUP_ID of the attribute group of the attribute group
AUCTION_HEADER_ID	NUMBER		Y	Stores Auction Header ID, Unique Identifier
DATA_LEVEL_ID	NUMBER			Stores Data Level ID.
PK1_VALUE	NUMBER			PK1_VALUE
PK2_VALUE	NUMBER			PK2_VALUE
PK3_VALUE	NUMBER			PK3_VALUE
PK4_VALUE	NUMBER			PK4_VALUE
PK5_VALUE	NUMBER			PK5_VALUE
LAST_UPDATE_DATE	DATE		Y	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Y	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Y	Standard who column - date when this row was created.
C_EXT_ATTR1	VARCHAR2	(4000)		C_EXT_ATTR1
C_EXT_ATTR2	VARCHAR2	(4000)		C_EXT_ATTR2
C_EXT_ATTR3	VARCHAR2	(4000)		C_EXT_ATTR3
C_EXT_ATTR4	VARCHAR2	(4000)		C_EXT_ATTR4
C_EXT_ATTR5	VARCHAR2	(4000)		C_EXT_ATTR5
C_EXT_ATTR6	VARCHAR2	(4000)		C_EXT_ATTR6
C_EXT_ATTR7	VARCHAR2	(4000)		C_EXT_ATTR7
C_EXT_ATTR8	VARCHAR2	(4000)		C_EXT_ATTR8
C_EXT_ATTR9	VARCHAR2	(4000)		C_EXT_ATTR9
C_EXT_ATTR10	VARCHAR2	(4000)		C_EXT_ATTR10
C_EXT_ATTR11	VARCHAR2	(4000)		C_EXT_ATTR11
C_EXT_ATTR12	VARCHAR2	(4000)		C_EXT_ATTR12
C_EXT_ATTR13	VARCHAR2	(4000)		C_EXT_ATTR13
C_EXT_ATTR14	VARCHAR2	(4000)		C_EXT_ATTR14
C_EXT_ATTR15	VARCHAR2	(4000)		C_EXT_ATTR15
C_EXT_ATTR16	VARCHAR2	(4000)		C_EXT_ATTR16
C_EXT_ATTR17	VARCHAR2	(4000)		C_EXT_ATTR17
C_EXT_ATTR18	VARCHAR2	(4000)		C_EXT_ATTR18
C_EXT_ATTR19	VARCHAR2	(4000)		C_EXT_ATTR19
C_EXT_ATTR20	VARCHAR2	(4000)		C_EXT_ATTR20
C_EXT_ATTR21	VARCHAR2	(4000)		C_EXT_ATTR21
C_EXT_ATTR22	VARCHAR2	(4000)		C_EXT_ATTR22
C_EXT_ATTR23	VARCHAR2	(4000)		C_EXT_ATTR23
C_EXT_ATTR24	VARCHAR2	(4000)		C_EXT_ATTR24
C_EXT_ATTR25	VARCHAR2	(4000)		C_EXT_ATTR25
C_EXT_ATTR26	VARCHAR2	(4000)		C_EXT_ATTR26
C_EXT_ATTR27	VARCHAR2	(4000)		C_EXT_ATTR27
C_EXT_ATTR28	VARCHAR2	(4000)		C_EXT_ATTR28
C_EXT_ATTR29	VARCHAR2	(4000)		C_EXT_ATTR29
C_EXT_ATTR30	VARCHAR2	(4000)		C_EXT_ATTR30
C_EXT_ATTR31	VARCHAR2	(4000)		C_EXT_ATTR31
C_EXT_ATTR32	VARCHAR2	(4000)		C_EXT_ATTR32
C_EXT_ATTR33	VARCHAR2	(4000)		C_EXT_ATTR33
C_EXT_ATTR34	VARCHAR2	(4000)		C_EXT_ATTR34
C_EXT_ATTR35	VARCHAR2	(4000)		C_EXT_ATTR35
C_EXT_ATTR36	VARCHAR2	(4000)		C_EXT_ATTR36
C_EXT_ATTR37	VARCHAR2	(4000)		C_EXT_ATTR37
C_EXT_ATTR38	VARCHAR2	(4000)		C_EXT_ATTR38
C_EXT_ATTR39	VARCHAR2	(4000)		C_EXT_ATTR39
C_EXT_ATTR40	VARCHAR2	(4000)		C_EXT_ATTR40
N_EXT_ATTR1	NUMBER			N_EXT_ATTR1
N_EXT_ATTR2	NUMBER			N_EXT_ATTR2
N_EXT_ATTR3	NUMBER			N_EXT_ATTR3
N_EXT_ATTR4	NUMBER			N_EXT_ATTR4
N_EXT_ATTR5	NUMBER			N_EXT_ATTR5
N_EXT_ATTR6	NUMBER			N_EXT_ATTR6
N_EXT_ATTR7	NUMBER			N_EXT_ATTR7
N_EXT_ATTR8	NUMBER			N_EXT_ATTR8
N_EXT_ATTR9	NUMBER			N_EXT_ATTR9
N_EXT_ATTR10	NUMBER			N_EXT_ATTR10
N_EXT_ATTR11	NUMBER			N_EXT_ATTR11
N_EXT_ATTR12	NUMBER			N_EXT_ATTR12
N_EXT_ATTR13	NUMBER			N_EXT_ATTR13
N_EXT_ATTR14	NUMBER			N_EXT_ATTR14
N_EXT_ATTR15	NUMBER			N_EXT_ATTR15
N_EXT_ATTR16	NUMBER			N_EXT_ATTR16
N_EXT_ATTR17	NUMBER			N_EXT_ATTR17
N_EXT_ATTR18	NUMBER			N_EXT_ATTR18
N_EXT_ATTR19	NUMBER			N_EXT_ATTR19
N_EXT_ATTR20	NUMBER			N_EXT_ATTR20
UOM_EXT_ATTR1	VARCHAR2	(3)		UOM_EXT_ATTR1
UOM_EXT_ATTR2	VARCHAR2	(3)		UOM_EXT_ATTR2
UOM_EXT_ATTR3	VARCHAR2	(3)		UOM_EXT_ATTR3
UOM_EXT_ATTR4	VARCHAR2	(3)		UOM_EXT_ATTR4
UOM_EXT_ATTR5	VARCHAR2	(3)		UOM_EXT_ATTR5
UOM_EXT_ATTR6	VARCHAR2	(3)		UOM_EXT_ATTR6
UOM_EXT_ATTR7	VARCHAR2	(3)		UOM_EXT_ATTR7
UOM_EXT_ATTR8	VARCHAR2	(3)		UOM_EXT_ATTR8
UOM_EXT_ATTR9	VARCHAR2	(3)		UOM_EXT_ATTR9
UOM_EXT_ATTR10	VARCHAR2	(3)		UOM_EXT_ATTR10
UOM_EXT_ATTR11	VARCHAR2	(3)		UOM_EXT_ATTR11
UOM_EXT_ATTR12	VARCHAR2	(3)		UOM_EXT_ATTR12
UOM_EXT_ATTR13	VARCHAR2	(3)		UOM_EXT_ATTR13
UOM_EXT_ATTR14	VARCHAR2	(3)		UOM_EXT_ATTR14
UOM_EXT_ATTR15	VARCHAR2	(3)		UOM_EXT_ATTR15
UOM_EXT_ATTR16	VARCHAR2	(3)		UOM_EXT_ATTR16
UOM_EXT_ATTR17	VARCHAR2	(3)		UOM_EXT_ATTR17
UOM_EXT_ATTR18	VARCHAR2	(3)		UOM_EXT_ATTR18
UOM_EXT_ATTR19	VARCHAR2	(3)		UOM_EXT_ATTR19
UOM_EXT_ATTR20	VARCHAR2	(3)		UOM_EXT_ATTR20
D_EXT_ATTR1	DATE			D_EXT_ATTR1
D_EXT_ATTR2	DATE			D_EXT_ATTR2
D_EXT_ATTR3	DATE			D_EXT_ATTR3
D_EXT_ATTR4	DATE			D_EXT_ATTR4
D_EXT_ATTR5	DATE			D_EXT_ATTR5
D_EXT_ATTR6	DATE			D_EXT_ATTR6
D_EXT_ATTR7	DATE			D_EXT_ATTR7
D_EXT_ATTR8	DATE			D_EXT_ATTR8
D_EXT_ATTR9	DATE			D_EXT_ATTR9
D_EXT_ATTR10	DATE			D_EXT_ATTR10
UDA_TEMPLATE_ID	NUMBER			UDA_TEMPLATE_ID

Name	Datatype	Length	Mandatory	Comments
EXTENSION_ID	NUMBER		Y	Stores extension_id
ATTR_GROUP_ID	VARCHAR2	(30)	Y	Stores the Attribute Group ID.
AUCTION_HEADER_ID	NUMBER			Stores Auction_header_id , Unique Identifier.
DATA_LEVEL_ID	NUMBER			Stores Data level ID.
PK1_VALUE	NUMBER			PK1_VALUE
PK2_VALUE	NUMBER			PK2_VALUE
PK3_VALUE	NUMBER			PK3_VALUE
PK4_VALUE	NUMBER			PK4_VALUE
PK5_VALUE	NUMBER			PK5_VALUE
SOURCE_LANG	VARCHAR2	(30)	Y	Stores the identifier of the Source language
LANGUAGE	VARCHAR2	(30)	Y	Stores the language
LAST_UPDATE_DATE	DATE		Y	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Y	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Y	Standard who column - date when this row was created.
TL_EXT_ATTR1	VARCHAR2	(4000)		TL_EXT_ATTR1
TL_EXT_ATTR2	VARCHAR2	(4000)		TL_EXT_ATTR2
TL_EXT_ATTR3	VARCHAR2	(4000)		TL_EXT_ATTR3
TL_EXT_ATTR4	VARCHAR2	(4000)		TL_EXT_ATTR4
TL_EXT_ATTR5	VARCHAR2	(4000)		TL_EXT_ATTR5
TL_EXT_ATTR6	VARCHAR2	(4000)		TL_EXT_ATTR6
TL_EXT_ATTR7	VARCHAR2	(4000)		TL_EXT_ATTR7
TL_EXT_ATTR8	VARCHAR2	(4000)		TL_EXT_ATTR8
TL_EXT_ATTR9	VARCHAR2	(4000)		TL_EXT_ATTR9
TL_EXT_ATTR10	VARCHAR2	(4000)		TL_EXT_ATTR10
TL_EXT_ATTR11	VARCHAR2	(4000)		TL_EXT_ATTR11
TL_EXT_ATTR12	VARCHAR2	(4000)		TL_EXT_ATTR12
TL_EXT_ATTR13	VARCHAR2	(4000)		TL_EXT_ATTR13
TL_EXT_ATTR14	VARCHAR2	(4000)		TL_EXT_ATTR14
TL_EXT_ATTR15	VARCHAR2	(4000)		TL_EXT_ATTR15
TL_EXT_ATTR16	VARCHAR2	(4000)		TL_EXT_ATTR16
TL_EXT_ATTR17	VARCHAR2	(4000)		TL_EXT_ATTR17
TL_EXT_ATTR18	VARCHAR2	(4000)		TL_EXT_ATTR18
TL_EXT_ATTR19	VARCHAR2	(4000)		TL_EXT_ATTR19
TL_EXT_ATTR20	VARCHAR2	(4000)		TL_EXT_ATTR20
TL_EXT_ATTR21	VARCHAR2	(4000)		TL_EXT_ATTR21
TL_EXT_ATTR22	VARCHAR2	(4000)		TL_EXT_ATTR22
TL_EXT_ATTR23	VARCHAR2	(4000)		TL_EXT_ATTR23
TL_EXT_ATTR24	VARCHAR2	(4000)		TL_EXT_ATTR24
TL_EXT_ATTR25	VARCHAR2	(4000)		TL_EXT_ATTR25
TL_EXT_ATTR26	VARCHAR2	(4000)		TL_EXT_ATTR26
TL_EXT_ATTR27	VARCHAR2	(4000)		TL_EXT_ATTR27
TL_EXT_ATTR28	VARCHAR2	(4000)		TL_EXT_ATTR28
TL_EXT_ATTR29	VARCHAR2	(4000)		TL_EXT_ATTR29
TL_EXT_ATTR30	VARCHAR2	(4000)		TL_EXT_ATTR30
TL_EXT_ATTR31	VARCHAR2	(4000)		TL_EXT_ATTR31
TL_EXT_ATTR32	VARCHAR2	(4000)		TL_EXT_ATTR32
TL_EXT_ATTR33	VARCHAR2	(4000)		TL_EXT_ATTR33
TL_EXT_ATTR34	VARCHAR2	(4000)		TL_EXT_ATTR34
TL_EXT_ATTR35	VARCHAR2	(4000)		TL_EXT_ATTR35
TL_EXT_ATTR36	VARCHAR2	(4000)		TL_EXT_ATTR36
TL_EXT_ATTR37	VARCHAR2	(4000)		TL_EXT_ATTR37
TL_EXT_ATTR38	VARCHAR2	(4000)		TL_EXT_ATTR38
TL_EXT_ATTR39	VARCHAR2	(4000)		TL_EXT_ATTR39
TL_EXT_ATTR40	VARCHAR2	(4000)		TL_EXT_ATTR40
UDA_TEMPLATE_ID	NUMBER			UDA_TEMPLATE_ID

Foreign Key Column	Foreign Table
PO_ACCEPTANCES.PO_HEADER_ID	PO_HEADERS_ALL
PO_ACCEPTANCES.PO_RELEASE_ID	PO_RELEASES_ALL
PO_ACCEPTANCES.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL

Index	Type	Tablespace	Column
PO_ACCEPTANCES_U1	UNIQUE	APPS_TS_TX_IDX	ACCEPTANCE_ID
SYS_IL0000044861C00036$$	UNIQUE	APPS_TS_TX_DATA
PO_ACCEPTANCES_N1	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID
PO_ACCEPTANCES_N2	NONUNIQUE	APPS_TS_TX_IDX	PO_RELEASE_ID
PO_ACCEPTANCES_N3	NONUNIQUE	APPS_TS_TX_IDX	EMPLOYEE_ID
PO_ACCEPTANCES_N4	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_LOCATION_ID REVISION_NUM

Name	Datatype	Length	Mandatory	Comments
ACCEPTANCE_ID	NUMBER		Y	Acceptance unique identifier
LAST_UPDATE_DATE	DATE		Y	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PO_HEADER_ID	NUMBER			Document header unique identifier
PO_RELEASE_ID	NUMBER			Release unique identifier
ACTION	VARCHAR2	(240)		Description of the follow-up action performed with the supplier
ACTION_DATE	DATE			Date of follow-up action
EMPLOYEE_ID	NUMBER	(9)		Employee unique identifier
REVISION_NUM	NUMBER			Document revision number
ACCEPTED_FLAG	VARCHAR2	(1)		Indicates whether the customer accepted the purchase order
ACCEPTANCE_LOOKUP_CODE	VARCHAR2	(25)		Type of acceptance
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PO_LINE_LOCATION_ID	NUMBER			Line Location unique identifier
NOTE	CLOB	(4000)		Long description of the result of the follow-up action
ACCEPTING_PARTY	VARCHAR2	(1)		Indicates if the purchasing document is signed by the Buyer or Supplier. For the manual signatures Accepting party will always be Buyer.
ROLE	VARCHAR2	(240)		Role of the person who is signing the document.
ERECORD_ID	NUMBER			Stores the Id of the eRecord if the signature is done electronically.This field references DOCUMENT_ID column of the EDR_PSIG_DOCUMENTS table.
SIGNATURE_FLAG	VARCHAR2	(1)		Indicates if the acceptance is Signature or Not.
DRAFT_ID	NUMBER			Draft Id
VENDOR_CONTACT_ID	NUMBER			Vendor contact id
VENDOR_CONTACT_NAME	VARCHAR2	(240)		Name of the Vendor contact accepted and signed the document
VENDOR_CONTACT_TITLE	VARCHAR2	(240)		Title of the Vendor contact accepted and signed the document
VENDOR_SIGNED_DATE	DATE			Date of signature by the vendor contact

Foreign Key Column	Foreign Table
AHL_OSP_ORDERS_B.PO_AGENT_ID	PO_AGENTS
MRP_SYSTEM_ITEMS.BUYER_ID	PO_AGENTS
PO_HEADERS_ARCHIVE_ALL.AGENT_ID	PO_AGENTS
PO_HEADERS_DRAFT_ALL.AGENT_ID	PO_AGENTS
PO_HEADERS_ALL.AGENT_ID	PO_AGENTS
PO_RELEASES_ALL.HOLD_BY	PO_AGENTS
PO_RELEASES_ALL.AGENT_ID	PO_AGENTS
PO_REQEXPRESS_LINES_ALL.SUGGESTED_BUYER_ID	PO_AGENTS
PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_BUYER_ID	PO_AGENTS
PO_REQUISITION_LINES_ALL.SUGGESTED_BUYER_ID	PO_AGENTS
PO_VENDORS.HOLD_BY	PO_AGENTS

Name	Datatype	Length	Mandatory	Comments
AGENT_ID	NUMBER	(9)	Y	Buyer unique identifier
LAST_UPDATE_DATE	DATE		Y	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Y	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LOCATION_ID	NUMBER			Location unique identifier
CATEGORY_ID	NUMBER			Item category unique identifier
AUTHORIZATION_LIMIT	NUMBER			Maximum purchase order authorization limit for the buyer
START_DATE_ACTIVE	DATE			Key Flexfield start date
END_DATE_ACTIVE	DATE			Key Flexfield end date
ATTRIBUTE_CATEGORY	VARCHAR2	(240)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
IS_CONTRACT_OFFICER	VARCHAR2	(1)		This user is a contracting officer or not (Y/N)
WARRANT_ID	NUMBER			Id of the Warrant issued to the contracting officer user.

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.
OE_ACTION_PRE_REQS	A temporary table used during the WF upgrade into R11i.
OE_ADJ_ATTRIB_EBS_LOG	Log table for the Euro conversion of OE_PRICE_ADJ_ATTRIBS. Only the Euro Customer Conversion concurrent program uses this table.
OE_AK_GEN_OBJECTS_CFG	No longer used
OE_AK_OBJECTS_EXT	Extension tables to AK_OBJECTS. Used to store additional data (ex. can the object be defaulted or constrained) for the defaulting/constraints framework.
OE_AK_OBJ_ATTR_EXT	Extension table to AK Object Attributes. Used to store additional data, (eg. can the attribute be defaulted /constrained, security / clear dependent APIs) for the defaulting or constraints framework.
OE_AK_OBJ_WF_ITEMS	Extension table to AK Object Attributes that is used to store additional data
OE_APPROVER_LISTS	This table will be used with the OM Approvers List setup form to setup the approvers list
OE_APPROVER_LIST_MEMBERS	This table will be used to manage all the approvers in the approvers list
OE_APPROVER_TRANSACTIONS	This table will be used to manage the runtime transaction level approvals and its statuses.
OE_ATTACHMENT_OBJECT_REFS	No longer used
OE_ATTACHMENT_OBJECT_REFS_TL	No longer used
OE_ATTACHMENT_RULES	OE_ATTACHMENT_RULES stores the entity to which an attachment rule should be applied.
OE_ATTACHMENT_RULE_ELEMENTS	OE_ATTACHMENT_RULE_ELEMENTS stores the attributes and attribute values that make up the attachment rule.
OE_AUDIT_ATTR_HISTORY	Audit Trail History Table
OE_BLANKET_HEADERS_ALL	Table to capture sales agreement header details..
OE_BLANKET_HEADERS_EXT	Table to capture sales agreement header details, specific to sales agreement functionality.
OE_BLANKET_HEADERS_HIST	Table to capture sales agreement header history. Primary for storing revisions.
OE_BLANKET_LINES_ALL	Table to capture sales agreement Line details.(Attributes common between Sales Order and Sales Agreements).
OE_BLANKET_LINES_EXT	Table to capture sales agreement line details specific to sales agreement functionality.
OE_BLANKET_LINES_HIST	Table to capture sales agreement lines history.
OE_BLANKET_ORG_ASSIGN	Not in use
OE_CC_TEMP	ONT.OE_CC_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
OE_CONC_REQUEST_IFACE	Interface table for the retrobilling concurrent program
OE_CONFIG_DETAILS_TMP	ONT.OE_CONFIG_DETAILS_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
OE_CREDITS_IFACE_ALL	This is a multi-org table for sales order/line credits open interface.
OE_CREDIT_BALANCES_ALL	Stores the current credit exposure data for each individual customer and site with credit limits. Each customer(or site)'s credit limit (including default limits) will have one row for each valid credit rule in the system.
OE_CREDIT_CHECK_RULES	This table stores information about the credit check rules.
OE_CREDIT_SUMMARIES	This summary table is used to implement Pre-Calculated Credit Exposure
OE_CUSTOMER_INFO_IFACE_ALL	Interface table to add new customer, its address and contact info.
OE_CUSTOM_ACTIONS	This table stores the information about all the actions that are assigned to a folder.
OE_CUST_ITEM_SETTINGS	OE_CUST_ITEM_SETTINGS stores the shipment and return tolerances for customer-item, item-site and item combinations
OE_CUST_MERGES_GTT	ONT.OE_CUST_MERGES_GTT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
OE_CUST_TOTAL_AMTS_ALL	Stores the accumulated order value for a customer over three periods.
OE_DEFAULT_ACTIONS	This table stores the information about all the actions that are applicable to the Sales Order.
OE_DEF_ATTR_CONDNS	Associates the defaulting condtion, defined at the entity level , to a specific attribute.
OE_DEF_ATTR_DEF_RULES	Defaulting rules for an attribute for a defaulting condition.
OE_DEF_CONDITIONS	This table stores defaulting conditions for an entity. The defaulting rules for attributes on this entity can be associated with these conditions.
OE_DEF_CONDITIONS_TL	OE_DEF_CONDITIONS_TL stores the translated columns for defaulting conditions.
OE_DEF_CONDN_ELEMS	This table stores elements (columns and column values) that makeup the defaulting condition identified by condition_id.
OE_DOC_SEQUENCE_AUDIT	OE_DOC_SEQUENCE_AUDIT is the table used by the FND module for audit purposes when the sequences used to generate the order numbers are created.
OE_DROP_SHIP_SOURCES	This table stores relationship between order lines in oe_order_lines_all table and associated oracle purchasing requisitions in PO_REQUISITIONS_ALL and Oracle purchasing purchase orders in PO_LINES_ALL.
OE_EM_INFORMATION_ALL	This table maintains tracking information for Order Import and Electronic Messaging (EDI & XML).
OE_EVENT_ATTRIBUTES	This table stores order header and line attributes that trigger repricing, when modified, at various pricing events.
OE_EXPOSURE_INTERFACE	This table contains Credit Exposure Data to be imported into Oracle Order Management.
OE_EXP_INTERFACE_ERRORS	This table contains error messages for each row of exposure data in the OE_EXPOSURE_INTERFACE table that failed validation.
OE_FLOW_STATUS_AIA_SYNC	Stores the information about which flow status code raises an O2C business event.
OE_FOLDER_EXTENSIONS	This table stores the information about Folder Extensions. Each row includes the name of the objects in the folders, user identifier, folder identifier, information about the tabs and line detail regions that are displayed for the folder.
OE_HEADERS_EBS_LOG	Log table for the Euro conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent program.
OE_HEADERS_EXT_IFACE_ALL
OE_HEADERS_IFACE_ALL	This is a multi-org table for sales order headers open interface.
OE_HEADER_ACKS	This is the acknowledgment table for Order Management sales order headers. This table contains sales order header information and is populated by both EDI and XML transactions when acknowledgments are required.
OE_HOLD_AUTHORIZATIONS	Stores information about who has the authority to apply and release holds.
OE_HOLD_DEFINITIONS	This table stores information about hold name and its validity period.
OE_HOLD_RELEASES	This tables stores information about all the holds that has been released.
OE_HOLD_SOURCES_ALL	This table stores information of the hold source criteria.
OE_INIT_CREDIT_SUMM_GTT	ONT.OE_INIT_CREDIT_SUMM_GTT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
OE_INIT_SUMM_TMP	ONT.OE_INIT_SUMM_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
OE_INVOICE_NUMBERS	This table is used for generating invoice numbers based on the delivery name.
OE_ITEMS_MV	This table stores accumulated order quantity and value for an item of a customer over three periods.
OE_ITEM_CUST_VOLS_ALL
OE_ITEM_ORDERABILITY	This tables stores information about the general Availability of the items.
OE_ITEM_ORDERABILITY_RULES	This tables stores information about the Availability Rules Set for the items.
OE_LINES_EBS_LOG	Log table for the Euro conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent program.
OE_LINES_EXT_IFACE_ALL
OE_LINES_IFACE_ALL	This is a multi-org table for sales order lines open interface. This table stores order lines information that is imported from a feeder system into Oracle Order Management using Order Import.
OE_LINE_ACKS	This table stores information about the acknowledgements for Order Lines.
OE_LINE_SETS	This table stores information about Sets.
OE_LINE_SPLIT_DETAILS	This table stores information about all the lines getting split.
OE_LOTSERIALS_IFACE_ALL	This is a multi-org table for return line lot serials open interface.
OE_LOTSERIAL_ACKS	This table stores information about the acknowledgements for lot and serial numbers for return lines.
OE_LOT_SERIAL_NUMBERS	This table stores customer reported lot serial numbers for lot and / or serial number controlled return lines.
OE_NOTES_OBJECT_REFS	No longer used
OE_NOTES_OBJECT_REFS_TL	No longer used
OE_NOTES_RULES	ONT.OE_ORDERORG_GTT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
OE_NOTES_RULE_ELEMENTS	OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
OE_ORDERORG_GTT
OE_ORDER_HEADERS_ALL
OE_ORDER_HEADERS_ALL_EFC	OE_ORDER_HEADERS_ALL_EFC holds data in the original set of books currency prior to the switch to a set of books in euro.
OE_ORDER_HEADERS_ALL_EXT_B	Base table to store user defined attributes of oe_order_headers_all
OE_ORDER_HEADERS_ALL_EXT_TL	TL table to store user defined attributes of oe_order_headers_all
OE_ORDER_HEADER_HISTORY	Stores history of attribute change for Order Headers
OE_ORDER_HOLDS_ALL	This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
OE_ORDER_LINES_ALL_EXT_B	Base table to store user defined attributes of oe_order_lines_all
OE_ORDER_LINES_ALL_EXT_TL	TL table to store user defined attributes of oe_order_lines_all
OE_ORDER_LINES_HISTORY	Stores history of attribute change for Order Lines.
OE_ORDER_NUMBER_SOURCES	No longer used
OE_ORDER_PRICE_ATTRIBS	This table stores pricing attributes and asked for promotions, deals, and coupon number entered by the user.
OE_ORDER_SOURCES	Feeder System Names that create orders in Order Management tables.
OE_PAYMENTS	It holds the commitment payment information.
OE_PAYMENTS_HISTORY	Table to store payment audit trail.
OE_PAYMENTS_IFACE_ALL	This table is used to store Payments data to be imported into OE_PAYMENTS table. This table will be used by Order Import Program.
OE_PAYMENT_TYPES_ALL	Multiorg table to store different payment types for each Operating Unit
OE_PAYMENT_TYPES_TL	This table stores the name and description for each payment type in different languages
OE_PC_ASSIGNMENTS	This table stores the responsibilities that are constrained by the constraint identified by constraint_id.
OE_PC_CONDITIONS	This table stores the conditions associated with the constraints identified by constraint_id.
OE_PC_CONDITIONS_TL	This table stores the translated conditions associated with the constraints identified by constraint_id.
OE_PC_CONSTRAINTS	This table stores the constraints that prevent create/update/delete of order entities.
OE_PC_EXCLUSIONS	This table stores the responsibilities that are not constrained by a particular constraint.
OE_PC_RSETS	This table store the constraint record sets and the constraint conditions can be built to validate against any or all the records in this record set.
OE_PC_RSETS_TL	OE_PC_RSETS_TL stores the translated columns for record sets for constraints.
OE_PC_RSET_SEL_COLS	This table stores columns to be matched for a constraint record set.
OE_PC_VALIDATION_PKGS	This table stores the names of the dynamically generated constraints validation packages.
OE_PC_VTMPLTS	This table stores the constraint validation templates that are used in constraint conditions.
OE_PC_VTMPLTS_TL	OE_PC_VTMPLTS_TL stores the translated columns for validation templates for constraints.
OE_PC_VTMPLT_COLS	This table stores the attribute validation pairs for validation templates that are based on column values.
OE_PRICE_ADJS_HISTORY	Stores history of attribute changes of Entity Price
OE_PRICE_ADJS_IFACE_ALL	This is a multi-org open interface table for sales order/line price adjustments.
OE_PRICE_ADJUSTMENTS	This table is used to store price adjustments that have been applied to an order or a line. The column automatic flag indicates if the adjustment was applied automatically or manually. Manual discouts are created with applied_Flag = Y.
OE_PRICE_ADJ_ASSOCS	This table stores the association between order lines and price adjustments and also between price adjustments
OE_PRICE_ADJ_ATTRIBS	This table stores information on qualifiers and pricing attributes, which to that corresponding price adjustment line qualified for.
OE_PRICE_ADJ_EBS_LOG	Log table for the Euro conversion of OE_PRICE_ADJUSTMENTS. This table is used only by the Euro Customer Conversion concurrent program.
OE_PRICE_ATTRIB_EBS_LOG	Log table for the Euro conversion of OE_ORDER_PRICE_ATTRIBS. This table is used only by the Euro Customer Conversion concurrent program.
OE_PRICE_ATTS_IFACE_ALL	This is a multi-org Interface table to populate OE_ORDER_PRICE_ATTRIBS.
OE_PROCESSING_MSGS	This table stores the context information of the processing messages that will be generated during Order Entry concurrent program execution or UI process.
OE_PROCESSING_MSGS_TL	This table stores the processing messages which will be generated during Order Entry concurrent program execution or UI process. This is a multi-lingual table.
OE_PURGE_ORDERS	OE_PURGE_ORDERS stores the order details for orders included in a purge set.
OE_PURGE_SETS	OE_PURGE_SETS stores purge set information.
OE_REASONS	Table to store change reasons for entities inserted into history tables.
OE_RESERVATION_SETS	This table is to store header information of reservation sets.
OE_RESERVTNS_IFACE_ALL	This is a multi-org table for inventory reservations open interface. This table stores reservation details that is imported from a feeder system into Oracle Order Management using Order Import.
OE_RETROBILL_REQUESTS	This table identifies a retrobill request and information used to initiate the retrobilling request.
OE_RSV_SET_DETAILS	This table is to store line information of reservation sets.
OE_SALES_CREDITS	This table stores information about sales credits.
OE_SALES_CREDIT_HISTORY	Stores history of attribute changes of Entity Sales Credits.
OE_SALES_CREDIT_TYPES	This table stores information about sales credit types.
OE_SCHEDULE_LINES_TEMP	ONT.OE_SCHEDULE_LINES_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
OE_SCH_ID_LIST_TMP	ONT.OE_SCH_ID_LIST_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
OE_SELECTED_ITEMS	Stores the inventory items selected by users in the Advance Item Search Window.
OE_SETS	OE_SETS stores information on line sets.
OE_SETS_HISTORY	Stores history of Set information
OE_SYSTEM_PARAMETERS_ALL	This table is used for storing all system parameter information.
OE_SYSTEM_PARAMS_UPG	OE_SYSTEM_PARAMS_UPG is an intermediate table used during upgrade to 11
OE_SYS_PARAMETERS_ALL	This is a multi-org table for OM parameter setup information. This table stores parameter values for the parameters defined in parameter definition table.
OE_SYS_PARAMETER_DEF_B	This table stores OM parameter name and description. This is a multi-lingual table.
OE_SYS_PARAMETER_DEF_TL	This table stores information about the order and line transaction types. This is a multi-org table.
OE_TRANSACTION_TYPES_ALL	This table stores information about the order and line transaction types
OE_TRANSACTION_TYPES_TL	This is a mult-lingual table for OE_TRANSACTION_TYPES_ALL table.
OE_TRXN_TEMP	ONT.OE_TRXN_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
OE_UI_QUERIES_TL	This table stores the user defined queries that can be administered in the Sales Order UI.
OE_UI_QUERY_COLUMNS	This table stores the column values for the user defined queries that are stored in OE_UI_QUERIES_TL table.
OE_UPGRADE_DISTRIBUTION	Stores the Slabs or from and to header ids for parallel upgrade processing.
OE_UPGRADE_ERRORS	Stores Errors trapped while Upgrading
OE_UPGRADE_LOG	Upgrade Control Information.
OE_UPGRADE_PC_ATTR_MAP	Processing constraints upgrade mapping table.
OE_UPGRADE_PC_CONDNS	Stores the Conditions to be upgraded to 11i.
OE_UPGRADE_PC_SCOPE	Processing constraints upgrade table.
OE_UPGRADE_PC_TEMP	Processing constraints upgrade table.
OE_UPGRADE_WF_ACT_MAP	Wofkflow upgrade mapping table.
OE_UPGRADE_WF_HIST_TEMP	This table is used during OM upgrade for cycles to workflow conversion
OE_UPGRADE_WF_OBS_CODES	This table stores the Action names and Result names which are obsoleted in R11i.
OE_UPGRADE_WF_VLD_CYC	Temporary table used by OM upgrade for cycles to workflow upgrade.
OE_UPGRADE_WSH_IFACE	Sales Order upgrade table - Shipping integration.
OE_WORKFLOW_ASSIGNMENTS	This table associates assignments to order types and line types.
ONT_DBI_CHANGE_LOG	Event notification for DBI
ONT_PRT_MARGIN_ANALYSIS	ONT_PRT_MARGIN_ANALYSIS contains margin analysis information grouped by customer, item, territory, and sales person for three different time periods, last week, last 30 days, and last 90 days
ONT_PRT_MARGIN_ANA_ERR	ONT_PRT_MARGIN_ANA_ERR contains primary key values of the failing record while building the ONT_PRT_MARGIN_ANALYSIS table.
ONT_WF_SKIP_LOG	OM WorkFlow Activity Skip Log.

Oracle Apps

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

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

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

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

What are the different reporting tools available in Oracle Fusion

Different subscription methods in Oracle Fusion

Overview of Oracle Fusion Cloud Application

Oracle eTRM details of PO ASL tables

Primary Key: PO_APPROVED_SUPPLIER_LIST_PK

Foreign Keys from this table:

Comments

Indexes

Columns

Table: PO_APPROVED_SUPPLIER_LIST_GT

Comments

Columns

Table: PO_ASL_API_ERRORS

Comments

Columns

Table: PO_ASL_ATTRIBUTES

Comments

Indexes

Columns

Table: PO_ASL_ATTRIBUTES_GT

Comments

Columns

Table: PO_ASL_DOCUMENTS

Comments

Indexes

Columns

Table: PO_ASL_DOCUMENTS_GT

Comments

Columns

Table: PO_ASL_STATUSES

Primary Key: PO_ASL_STATUSES_PK

Comments

Indexes

Columns

Table: PO_ASL_STATUS_RULES

Primary Key: PO_ASL_STATUS_RULES_PK

Comments

Indexes

Columns

Oracle eTRM details of PO Accrual Tables

Comments

Indexes

Columns

Table: PO_ACCRUAL_WRITE_OFFS_ALL

Foreign Keys from this table:

Comments

Indexes

Columns

Table: PO_ACCRUAL_WRITE_OFFS_ALL_EFC

Comments

Columns

Oracle eTRM details of PO Bid tables

Primary Key: PON_BID_HEADERS_EXT_B_PK

Comments

Columns

Table: PON_BID_HEADERS_EXT_TL

Comments

Columns

Table: PON_BID_ITEM_PRICES_EXT_B

Comments

Columns

Table: PON_BID_ITEM_PRICES_EXT_TL

Comments

Columns

Oracle eTRM details of the PO Auction Tables

Comments

Primary Key: PON_AUC_HEADERS_EXT_B_PK

Indexes

Columns

Table: PON_AUCTION_HEADERS_EXT_TL

Comments

Columns

Table: PON_AUCTION_ITEM_PRICES_EXT_B

Comments

Columns