Product Definition Module for Oracle Cloud

Key Functional Areas

Items

Item Relationships

Structures

Trading Partners

Item Transaction Defaults

Sales Orders

Item Associations

Price Lists

Inventory Transactions

Items

Generate and maintain item definitions with fully flexible and customizable spreadsheets, leveraging the features of Excel to manage your Item master data quickly and easily. Lay out all layers of your item details in one sheet, including attachments, categories, revisions and all your EFF and DFF values.

Item Relationships

Apply and sustain item relationships from a spreadsheet where relationship types like cross-references, trading partner items, global trade item numbers (GTINs), related items, and spoke system items, are supported. Adaptable layouts allow you to simplify single or multiple relationship types or maintain them all from the same spreadsheet.

The More4apps Product Definition Module for managing related items.

Structures

Produce and handle convoluted data structure/assembly definitions in one spreadsheet.

These complex data configurations are easy to manage with flexible built-in download features, calculation, and replication features included with Excel. The entire data hierarchy supports components, substitutes, and reference designators.

The More4apps Product Definition Module supports components.

Trading Partners

Manage trading partners, their items, and inventory relationships in a single flexible worksheet. Built-in downloads let you work with items using internal or external IDs, with easy relationship management and attachment support included.

Item Transaction Defaults

Create and Update Item Transaction Defaults for all your Orgs simultaneously in the same comprehensive spreadsheet with full download functionality built in. Pre-upload validation helps ensure an error-free upload with the minimum of rework.

Sales Orders

Create, update, and submit Sales Orders from one flexible, easy-to-use worksheet. Download existing orders for quick maintenance or replication, and manage EFFs and attachments seamlessly ” all in one streamlined process.

Item Associations

Manage Subinventory and Locator Item Associations for all your Orgs simultaneously in a comprehensive spreadsheet with full download functionality built in. Pre-upload validation helps ensure an error-free upload with the minimum of rework.

Price Lists

Create and update price lists in a single user-oriented worksheet. Manage items, charges, access sets and approvals in one place. Download existing price lists for maintenance or replication and filter by item number for pricing changes to particular products or services.

Inventory Transactions

Create Store Issues and Store Receipts with lot numbers, serial numbers, project details and attachments all visible in the same worksheet. Download existing transactions, interface records, or on-hand quantities to make issues easier. Upload instantly to Oracle, or via the interface.

Product Definition Module for Oracle Fusion Cloud Applications Covers all of your Business Needs

A Simple User-Oriented Upload Process

Create item and structure definitions and item relationships in one spreadsheet tab without the linking of worksheets. There are no extra interface steps or background jobs to monitor. Upload results are returned in the worksheet next to your data rows. Clear and concise messages flag errors, so you can correct the data and reload it easily.

Item Creation and Updates

Produce items quickly with all other related information, like attachments, in your working spreadsheet. Download existing items to use as a basis for new items or use the 'copy-from-existing-item' option to remove hours of manual data entry.

Item Relationship Management

Create and revise item relationships, related items, item cross-references, trading partner items, GTIN relationships, spoke system item references, and relevant DFFs in the same spreadsheet. With adaptable layouts, you can concurrently manage as few or as many relationship types as you like.

Item Structures (formally Bills of Materials/BOMs)

Supports creating and updating item structure definitions. Oversee the whole data hierarchy, including structure header, components, substitutes, reference designators, and relevant DFFs, in one sheet.

Flexible Item Structure Downloading

Download structure assembly details into the worksheet for subsequent updates and choose what you want to see. 'Explode' structures to show the whole hierarchy of sub-component details. Download components 'Where used' to view which structure includes them, or go further and 'Implode' them to view the entire structure hierarchy of the structures they're assigned to.

Trading Partners

Managing external trading partners, their items, and the relationships to your inventory items doesn't have to be a headache. Simplify the process by managing trading partners, partner items, and item relationships in one central worksheet"with built-in attachment support. Download items using either internal or external designations to easily review, update, and maintain relationships.

Sales Orders

Managing Sales Orders in Oracle doesn't have to be time-consuming. Simplify high-volume order creation and maintenance with spreadsheet-based loading. Upload directly with full support for EFFs and attachments, and download existing orders for updates, replication, or deletion " all within adaptable worksheet layouts designed to match your business processes.

Item Transaction Defaults

Manage Item Transaction Defaults together for all Orgs in the same spreadsheet workbook where you manage your Item master data. Create and Update in the same worksheet. Maintenance is easy with the built-in Download functionality, and pre-upload validation helps reduce errors and rework.

Item Associations

Manage Subinventory and Locator Item Associations for all your Orgs in the same spreadsheet workbook where you manage your Item master data. Pre-upload validation helps reduce errors and rework, and the built-in Download functionality makes maintaining associations easy.

Price Lists

Manage price lists, their items and associated charges in one simple easy to navigate spreadsheet with all information visible simultaneously. Alter access sets and trigger approvals at the same time. Download existing price lists for maintenance or replication and filter by item number for pricing changes to particular products or services.

Inventory Transactions

Create Store Issues and Store Receipts in a flexible spreadsheet that adapts to your work processes. Lay out lot numbers, serial numbers, project details and attachments in the same worksheet and upload instantly to Oracle, or via the interface if you prefer. Update and delete interface records prior to executing any imports. Download existing transactions, interface records, or on-hand quantities to make managing issues easier.

The Smarter Excel Interface for Your Oracle Fusion Cloud Data

Organizing and preparing item details and complicated structure component hierarchies is difficult in the Oracle forms. The navigation is complex, so it’s hard to see what is in the system versus what is missing.

With the More4apps Product Definition Module, you see the whole picture in pre-integrated Excel spreadsheets that follow the existing Oracle security and dynamically adapt to your system setup and business rules.

See for yourself how the More4apps ERP Cloud Toolbox stacks up against Oracle’s tools!>

Oracle User Forms

Oracle ADFdi

Oracle FBDI