Cloud Readiness / Oracle Inventory Management Cloud
What's New
Expand All


  1. Update 20C
  1. Revision History
  2. Overview
  3. Optional Uptake of New Features (Opt In)
  4. Feature Summary
    1. Project-Driven Supply Chain
        1. Cost Account Direct Material Procurement on Project for Manufacturing
        2. Cost Account Direct Material Procurement on Project for Maintenance
    2. Inventory Management
        1. Add Requester to Inventory Transactions Real Time Subject Area
        2. Migrate Integrations with Oracle WMS Cloud from SOAP to REST Services
        3. Purge Cycle Count Sequence Options
        4. Relax Restrictions for Item Serial Generation Attribute Changes
        5. Validate Inventory Transaction Dates
    3. Shipping
        1. Add Packing Unit to Shipping Real Time Subject Area
        2. Enhance ATO and PTO Behavior for Brazil
      1. Other Shipping Changes in This Update
    4. Receiving
        1. Supplier Returns Without Receipt Reference
    5. Cost Management
        1. Match Cost of Goods Sold to Revenue Recorded in Oracle Revenue Management Cloud
        2. Use Additional Subledger Accounting Sources in Cost Management
        3. Cost Account Supplier Returns Without Reference to an Original Purchase Order
    6. Fiscal Document Capture
        1. Process Brazilian Fiscal Documents for Bookkeeping Purposes
    7. Supply Chain Financial Orchestration
        1. Use Transaction Organization as Item Validation Organization in Supply Chain Financial Orchestration
  5. IMPORTANT Actions and Considerations

Update 20C

Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Date Product Feature Notes
30 OCT 2020 Shipping Other Shipping Changes in This Update Updated document. Added section.
19 JUN 2020     Created initial document.

Overview

This guide outlines the information you need to know about new or improved functionality in this update, and describes any tasks you might need to perform for the update. Each section includes a brief description of the feature, the steps you need to take to enable or begin using the feature, any tips or considerations that you should keep in mind, and the resources available to help you.

Security and New Features

The Role section of each feature identifies the security privilege and job role required to use the feature. If feature setup is required, then the Application Implementation Consultant job role is required to perform the setup, unless otherwise indicated. (If a feature doesn't include a Role section, then no security changes are required to use the feature.)

If you have created job roles, then you can use this information to add new privileges to those roles as needed. For details about how to compare your configured job roles to predefined job roles and add security artifacts to your configured job roles, see the Security Console and Roles and Role Assignments chapters in the Oracle SCM Cloud: Securing SCM guide on the Oracle Help Center.

Give Us Feedback

We welcome your comments and suggestions to improve the content. Please send us your feedback at oracle_fusion_applications_help_ww_grp@oracle.com.

Optional Uptake of New Features (Opt In)

Oracle Cloud Applications delivers new updates every quarter. This means every three months you'll receive new functionality to help you efficiently and effectively manage your business. Some features are delivered Enabled meaning they are immediately available to end users. Other features are delivered Disabled meaning you have to take action to make available. Features delivered Disabled can be activated for end users by stepping through the following instructions using the following privileges:

  • Review Applications Offering (ASM_REVIEW_APPLICATIONS_OFFERINGS_PRIV)
  • Configure Oracle Fusion Applications Offering (ASM_CONFIGURE_OFFERING_PRIV)

Here’s how you opt in to new features:

  1. Click Navigator > My Enterprise > New Features.
  2. On the Features Overview page, select your offering to review new features specific to it. Or, you can leave the default selection All Enabled Offerings to review new features for all offerings.
  3. On the New Features tab, review the new features and check the opt-in status of the feature in the Enabled column. If a feature has already been enabled, you will see a check mark. Otherwise, you will see an icon to enable the feature.
  4. Click the icon in the Enabled column and complete the steps to enable the feature.

In some cases, you might want to opt in to a feature that's not listed in the New Features work area. Here's how to opt in:

  1. Click Navigator > My Enterprise > Offerings.
  2. On the Offerings page, select your offering, and then click Opt In Features.
  3. On the Opt In page, click the Edit Features (pencil) icon for the offering, or for the functional area that includes your feature.
  4. On the Edit Features page, complete the steps to enable the feature.

For more information and detailed instructions on opting in to new features for your offering, see Offering Configuration.

Opt In Expiration

Occasionally, features delivered Disabled via Opt In may be enabled automatically in a future update. This is known as an Opt In Expiration. If your cloud service has any Opt In Expirations you will see a related tab in this document. Click on that tab to see when the feature was originally delivered Disabled, and when the Opt In will expire, potentially automatically enabling the feature. You can also click here to see features with Opt In Expirations across all Oracle Cloud Applications.

Feature Summary

Column Definitions:

Features Delivered Enabled

Report = New or modified, Oracle-delivered, ready to run reports.

UI or Process-Based: Small Scale = These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.

UI or Process-Based: Larger Scale* = These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.

Features Delivered Disabled = Action is needed BEFORE these features can be used by END USERS. These features are delivered disabled and you choose if and when to enable them. For example, a) new or expanded BI subject areas need to first be incorporated into reports, b) Integration is required to utilize new web services, or c) features must be assigned to user roles before they can be accessed.

Ready for Use by End Users
(Features Delivered Enabled)

Reports plus Small Scale UI or Process-Based new features will have minimal user impact after an update. Therefore, customer acceptance testing should focus on the Larger Scale UI or Process-Based* new features.

Action is Needed BEFORE Use by End Users
(Features Delivered Disabled)

Not disruptive as action is required to make these features ready to use. As you selectively choose to leverage, you set your test and roll out timing.

Feature

Report

UI or
Process-Based:
Small Scale

UI or
Process-Based:
Larger Scale*

Project-Driven Supply Chain

Cost Account Direct Material Procurement on Project for Manufacturing

Cost Account Direct Material Procurement on Project for Maintenance

Inventory Management

Add Requester to Inventory Transactions Real Time Subject Area

Migrate Integrations with Oracle WMS Cloud from SOAP to REST Services

Purge Cycle Count Sequence Options

Relax Restrictions for Item Serial Generation Attribute Changes

Validate Inventory Transaction Dates

Shipping

Add Packing Unit to Shipping Real Time Subject Area

Enhance ATO and PTO Behavior for Brazil

Other Shipping Changes in This Update

Receiving

Supplier Returns Without Receipt Reference

Cost Management

Match Cost of Goods Sold to Revenue Recorded in Oracle Revenue Management Cloud

Use Additional Subledger Accounting Sources in Cost Management

Cost Account Supplier Returns Without Reference to an Original Purchase Order

Fiscal Document Capture

Process Brazilian Fiscal Documents for Bookkeeping Purposes

Supply Chain Financial Orchestration

Use Transaction Organization as Item Validation Organization in Supply Chain Financial Orchestration

IMPORTANT Actions and Considerations

Project-Driven Supply Chain

Project-Driven Supply Chain is an end-to-end, integrated solution across the Oracle Supply Chain Management and Project Management Cloud applications.  This solution is designed to support various business processes of manufacturing and asset-intensive companies.

You can use the Project-Driven Supply Chain solution to manage your supply chain processes in the context of projects without creating separate organizations for each project. You can also capture supply chain costs as project expenditures.

In this update, the Project-Driven Supply Chain solution includes these features:

  • Plan Project-Specific Supply
  • Purchase Unplanned Material for Project-Specific Manufacturing Work Order
  • Purchase Unplanned Material for Project-Specific Maintenance Work Order
  • Purchase Goods and Services for Project-Specific Manufacturing and Maintenance Work Orders
  • Cost Account Direct Material Procurement on Project for Manufacturing
  • Cost Account Direct Material Procurement on Project for Maintenance

The Project-Driven Supply Chain features in Oracle Inventory Management Cloud are described in this document.

Cost Account Direct Material Procurement on Project for Manufacturing

Shop and create requisitions for unplanned items required for a project-based manufacturing work order. Navigate to Self Service Procurement to make purchases, by referencing the work order from the requisition.

Seamless process automation between the Manufacturing and Self-Service Procurement applications ensures cost-efficient and timely procurement of unplanned items that may not be held in stock or if the item is intended to be a one-off purchase.

When you associate a manufacturing work order on the requisition, the work order project and the task automatically display in the purchase requisition’s distribution. A purchase order is created referencing the work order and the project details from the requisition. The purchase order is delivered to the work order destination, consumed, and costed in the work order. The expenditure incurred is transferred to Oracle Project Portfolio Management. Using the feature, you can expedite the procurement of unplanned materials for work orders and also capture material costs for the specific project and task.

These screenshots illustrate the feature.

Work Order with Project Attributes

Purchase Requisition with Work Order and Project Details

Review Cost Accounting Distributions Shows Project Attributes for the Purchase Order Receipt Into Work Order Transaction

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials Management

Feature: Project-Driven Supply Chain

After you opt in, you must perform additional steps to enable project-driven supply chain. For instructions, refer to the Steps to Enable section in the Segregate and Manage Project-Specific Inventory feature, available in Oracle Inventory Management Cloud What's New, update 20A.

If you previously opted in to the Project-Driven Supply Chain feature, you're not required to opt in and perform initial setup again.

Tips And Considerations

When you create requisitions for work order destination type with project-based work orders, the project and task in the requisition line distribution must match the project and task of the work order.

Key Resources

Role Information

  • Job Role Name and Code: 
    • Cost Accountant (ORA_CST_COST_ACCOUNTANT)

Cost Account Direct Material Procurement on Project for Maintenance

Shop and create requisitions for unplanned items or services required for a project-based manufacturing work order. Use the integrated flow to navigate from the work order to the shopping home page, or navigate directly to Self-Service Procurement to make purchases, by referencing the work order from the requisition.

Seamless process automation between the Maintenance and Self-Service Procurement applications ensures cost-efficient and timely procurement of maintenance parts and services.

When you associate a maintenance work order on the requisition, the work order project and the task automatically display in the purchase requisition’s distribution. A purchase order is created referencing the work order and the project details from the requisition. The purchase order is delivered to the work order destination, consumed, and costed in the work order. The expenditure incurred is transferred to Oracle Project Portfolio Management. Using the feature, you can expedite the procurement of unplanned materials or services for work orders and also capture associated cost of the purchase for the specific project and task.

These screenshots illustrate the feature.

Edit Work Order

Edit Requisition

Review Cost Accounting Distributions - Project-Based Maintenance Work Order Costs

Review Cost Accounting Distributions - Project-Based Maintenance Work Order Costs: Cost Distributions interfaced to projects

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials Management

Feature: Project-Driven Supply Chain

After you opt in, you must perform additional steps to enable project-driven supply chain. For instructions, refer to the Steps to Enable section in the Segregate and Manage Project-Specific Inventory feature, available in Oracle Inventory Management Cloud What's New, update 20A.

If you previously opted in to the Project-Driven Supply Chain feature, you're not required to opt in and perform initial setup again.

Tips And Considerations

When you create requisitions for work order destination type with project-based work orders, the project and task in the requisition line distribution must match the project and task of the work order.

Key Resources

For more details about:

Role Information

  • Job Role Name and Code:
    • Cost Accountant (ORA_CST_COST_ACCOUNTANT)

Inventory Management

Add Requester to Inventory Transactions Real Time Subject Area

Oracle Transactional Business Intelligence lets you create ad hoc reports using real-time transactional data from Oracle Inventory Management Cloud to monitor your materials management processes. In this update, the Requester dimension is now available under the Inventory Transaction Details dimension of the Inventory Transactions Real Time subject area. The Requester dimension includes these attributes:

  • Display Name
  • First Name
  • Full Name
  • Honors
  • Last Name
  • Middle Name
  • Previous Last Name
  • Email Address
  • Supervisor Name
  • Title

The addition of these fields within the Inventory Transactions Real Time subject area provides you with additional reporting capability for your inventory transactions.

Inventory Transactions Real Time Subject Area - Requester

The Requester dimension allows you to augment your inventory transactional reports with a number of requester-related attributes, providing visibility into the performer or owner of the transaction.

Steps to Enable

Leverage new subject area(s) by adding to existing reports or using in new reports. For details about creating and editing reports, see the Creating and Administering Analytics and Reports book (available from the Oracle Help Center > your apps service area of interest > Books > Administration).

Tips And Considerations

You can add the new Requester fields to your existing reports, or create new reports that use this new field. For details about creating and editing reports, see the Oracle SCM Cloud: Creating and Administering Analytics and Reports guide, available on the Oracle Help Center.

Key Resources

  • Oracle Supply Chain Management Cloud: Implementing Manufacturing and Supply Chain Management guide, available on the Oracle Help Center.

Migrate Integrations with Oracle WMS Cloud from SOAP to REST Services

To take advantage of new features in Oracle Inventory Management Cloud, you can now migrate your standard integrations with Oracle Warehouse Management System Cloud from SOAP services to REST services for receipt advices, changed receipt advices, and shipment requests. While SOAP service integrations are not going away, new feature support is added only to REST services.

To facilitate this migration, Inventory Management will publish two new events, Outbound Receipt Advice and Outbound Shipment Request, instead of the existing events, Receipt Advice Event Notification and Shipment Request Generate Event. You can configure Inventory Management to publish these new events by configuring business events using the new Inventory Business Event Configurations REST service. When the new events are published, they're made available in Oracle Integration Cloud Service and the Oracle SOA Cloud Service using the Oracle ERP Cloud Adapter.

You can use these new events and invoke the REST services from the integration layer to retrieve the receipt advices and shipment requests. For retrieving receipt advice, use the Receipt Advice Lines REST service. Use the Shipment Line Change Requests and Shipment Lines REST services for shipment requests. If you don't create any business event configurations using the new REST service, the system will publish the old events by default.

Using this feature lets you take advantage of the upcoming new features along with the additional benefit of increasing the performance and efficiency of the integration itself.

Steps to Enable

Review the REST service definition in the REST API guides, available from the Oracle Help Center > your apps service area of interest > REST API. If you're new to Oracle's REST services you may want to begin with the Quick Start section.

  1. Using the Inventory Business Event Configurations REST service, create event configuration records to choose the new event to be published for receipt advice and shipment request.
  2. Change your integrations within Oracle Integration Cloud to listen to the new events and invoke the corresponding REST services to gather and forward the receipt advices and shipment requests.

Key Resources

Role Information

You have a couple options for giving people access to this feature, depending on whether you're assigning them predefined job roles or your own configured job roles.

Users who are assigned any of these predefined job roles are automatically able to access this feature:

  • Warehouse Manager (ORA_INV_WAREHOUSE_MANAGER)
  • Inventory Manager (ORA_INV_INVENTORY_MANAGER)
  • Supply Chain Application Administrator (ORA_RCS_SUPPLY_CHAIN_APPLICATION_ADMINISTRATOR)

Purge Cycle Count Sequence Options

When you need to purge a cycle count sequence, you might not be aware of some cycle count sequences that another person uploaded but didn’t process yet. If you don’t process those pending transactions and later upload the same transactions again prior to processing, you end up with error transactions stuck as pending transactions.

Now, when purging a cycle count, an error is raised if you have pending transactions for the cycle count. This assures that you’re aware of any pending transactions in the system against the cycle count and forces you to process the pending transactions. Additionally, the Purge Cycle Count process contains a new parameter that lets you purge only the count sequences with errors or you can purge all count sequences. The Purge Cycle Count process is accessed from the action menu on the Manage Cycle Counts page or it can be run as a scheduled process.

The new Purge Count Sequences parameter includes these options: Purge all count sequences and Purge only count sequences with errors. Select nothing for backward compatibility. 

Action / Purge Cycle Count

Purge Cycle Count Scheduled Process

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

If you select Purge only count sequences with errors and choose Purge Count Setup > No, then only the count sequences that have error records in pending transactions are deleted. In this case, the Purge Count Details Before date is not required. 

If you select Purge all count sequences and choose Purge Count Setup > Yes, then all count sequences and pending transactions with errors before the specified date are deleted.

Key Resources

  • Oracle Supply Chain Management Cloud: Using Inventory Management guide, available on the Oracle Help Center.

Role Information

You have a couple options for giving people access to this feature, depending on whether you're assigning them predefined job roles or your own configured job roles.

Users who are assigned any of these predefined job roles are automatically able to access this feature:

  • Warehouse Manager (ORA_INV_WAREHOUSE_MANAGER)
  • Inventory Manager (ORA_INV_INVENTORY_MANAGER)

Users who are assigned configured job roles that contain these privileges are able to access this feature:

  • Manage Cycle Count (INV_MANAGE_CYCLE_COUNT)

Relax Restrictions for Item Serial Generation Attribute Changes

When configuring new items within the Product Information Management work area, your business requirements dictate that you set up item attributes in a specific way. The decisions that you make when configuring these item attributes significantly impact downstream processing of transactions in areas like inventory, receiving, and shipping. Later, your business requirements may change and you might find that you need to adjust some of the item attributes accordingly.

For example, let’s say you set the serial generation method for an item to Predefined serial number based upon the value of the item. As time passes, the value of the item is no longer significant so you need to change the serial generation method to No serial number control. You verify that there's no on-hand quantity for the item and only some open purchase orders for your suppliers to fulfill. Now you can update the serial generation for the item even though you have pending receiving transactions.

Relaxing restrictions for item serial generation attribute changes improves product usability and provides you greater flexibility when business requirements change or item attributes are configured incorrectly.

Item Serial Generation Control

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Serial number generation control changes are not allowed for an item in the source and destination inventory organizations for in-transit shipments and transfer orders. In this particular use case, you have an in-transit shipment between a source and destination inventory organization. You cannot change the item serial generation control for such scenarios in both the source and destination inventory organizations.

If you have enabled the Defer sending inventory updates to integrated applications shipping parameter, you cannot change the item serial generation control when outbound shipments are pending inventory interface.

Key Resources

Role Information

You have a couple options for giving people access to this feature, depending on whether you're assigning them predefined job roles or your own configured job roles.

Users who are assigned any of these predefined job roles are automatically able to access this feature:

  • Warehouse Manager (ORA_INV_WAREHOUSE_MANAGER)
  • Inventory Manager (ORA_INV_INVENTORY_MANAGER)
  • Warehouse Operator (ORA_INV_WAREHOUSE_OPERATOR)
  • Product Manager (ORA_EGP_PRODUCT_MANAGER)

Users who are assigned configured job roles that contain these privileges are able to access this feature:

  • Manage Item Lot and Item Serial Number (INV_MANAGE_ITEM_LOT_AND_ITEM_SERIAL_NUMBER)
  • Manage Item (EGP_MANAGE_ITEM)

Validate Inventory Transaction Dates

Even when every effort to ensure that the data you enter for an inventory transaction is correct, mistakes happen. These data mistakes can be particularly problematic when dates are accidentally transposed during bulk data loads. For example, let’s say you accidentally enter a transaction date with the year 2002 instead of 2020 and then copy that date for 500 records. A short time later, your cost accountant works on closing the cost accounting period for your organization and submits the Close Cost Period scheduled process. The process eventually ends in error because transactions submitted for 2002 don’t map to a specific cost accounting period. Ultimately, this results in stuck transactions that you must manually correct within Oracle Cost Management Cloud. In other words, a data fix is required to update both the transaction date and the cost date.

Now, you have the ability to specify the maximum number of days prior to the current date in which your users can create a transaction. This can help you ensure that dates entered for inventory transactions are within your open cost accounting period and reduce the amount of data entry errors you encounter.

Validate Inventory Transaction Date

Steps to Enable

To use the Validate Inventory Transaction Dates feature, you'll need to enable the profile option Maximum Number of Days Prior to Current Date in Which a Transaction Can Be Created. The Profile Value is supported only at the Profile Level of Site.

Here's how to configure the profile option:

  1. In the Setup and Maintenance work area, go to the Manage Inventory Profile Options task:
  • Offering: Manufacturing and Supply Chain Materials Management
  • Functional Area: Inventory Management
  • Task: Manage Inventory Profile Options
  1. On the Manage Inventory Profile Options page, enter Maximum Number of Days Prior to Current Date in Which a Transaction Can Be Created in the Profile Display Name field and click Search
  2. Enter the maximum number of days in the Profile Value field for the Profile Level of Site and click Save

Manage Inventory Profile Options

Tips And Considerations

The profile option Maximum Number of Days Prior to Current Date in Which a Transaction Can Be Created is used in conjunction with the existing profile option Transaction Date Validation Enabled. The new profile option is only invoked when the profile option Transaction Date Validation Enabled has a Profile Value of No validation. The default value for the Profile Value is 5 days. However, you can change the Profile Value based on your business needs.

The Validate Inventory Transaction Dates feature validates transactions created by the Inventory Transaction file-based data import (FBDI) process and REST/SOAP services. The error message, "You can't create the transaction because the transaction date is prior to 2019-01-07," is displayed on the Manage Pending Transactions page when the transaction date is entered incorrectly in the Inventory Transaction FBDI. When entered incorrectly using REST/SOAP services, the error message is displayed in the service response. In both cases, you can correct the inventory transaction date and reprocess the transaction.

Key Resources

Role Information

You have a couple options for giving people access to this feature, depending on whether you're assigning them predefined job roles or your own configured job roles.

Users who are assigned any of these predefined job roles are automatically able to access this feature:

  • Warehouse Manager (ORA_INV_WAREHOUSE_MANAGER)
  • Inventory Manager (ORA_INV_INVENTORY_MANAGER)
  • Warehouse Operator (ORA_INV_WAREHOUSE_OPERATOR)

Users who are assigned configured job roles that contain these privileges are able to access this feature:

  • Create Miscellaneous Transaction (INV_CREATE_INVENTORY_TRANSACTION_MISCELLANEOUS_TRANSACTION)
  • Create Subinventory Transfer (INV_CREATE_INVENTORY_TRANSACTION_SUBINVENTORY_TRANSFER)
  • Create Interorganization Transfer (INV_CREATE_INVENTORY_TRANSACTION_INTERORGANIZATION_TRANSFER)

Shipping

Add Packing Unit to Shipping Real Time Subject Area

Oracle Transactional Business Intelligence lets you create ad hoc reports using real-time transactional data from Oracle Inventory Management Cloud to monitor your materials management processes. In this update, the Packing Unit dimension is now available under the Shipment Line dimension of the Shipments Real Time subject area. The Packing Unit dimension includes these attributes:

  • Packing Unit
  • Weight UOM
  • Maximum Load Weight
  • Gross Weight
  • Tare Weight
  • Net Weight
  • Maximum Volume
  • Volume
  • Volume UOM
  • Percentage Filled
  • Minimum Fill Percent
  • Master Serial Number
  • Seal Number

The addition of these fields within the Packing Unit dimension provides you with additional reporting capability for your Shipment Lines.

Shipping Real Time Subject Area - Packing Unit

The Packing Unit dimension allows you to augment your shipping reports with Packing Unit and a number of associated attributes, including the ability to report on up to 10 levels of nested packing units.

Steps to Enable

Leverage new subject area(s) by adding to existing reports or using in new reports. For details about creating and editing reports, see the Creating and Administering Analytics and Reports book (available from the Oracle Help Center > your apps service area of interest > Books > Administration).

Tips And Considerations

You can add the new Packing Unit fields to your existing reports, or create new reports that use this new field. For details about creating and editing reports, see the Oracle SCM Cloud: Creating and Administering Analytics and Reports guide, available on the Oracle Help Center.

Key Resources

  • Oracle Supply Chain Management Cloud: Implementing Manufacturing and Supply Chain Management guide, available on the Oracle Help Center.

Enhance ATO and PTO Behavior for Brazil

The Brazil outbound shipment flow streamlines the process for fiscal document generation and approval for shipments originating from your inventory organizations based in Brazil. Oracle Shipping Cloud inherently integrates with fiscal document generation to process and monitor your fiscal document submission and approval process.

The Brazil outbound shipment flow now allows you to process ATO and PTO model structures for sales order and transfer order shipments. For example, you can create a sales order for a complex item structure, such as a hybrid model containing both a PTO model and ATO model. Accordingly, Shipping communicates the appropriate information to fiscal document generation to ensure compliance with Brazilian fiscal document processing requirements.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

  • Oracle Supply Chain Management Cloud: Implementing Manufacturing and Supply Chain Materials Management Guide, available on the Oracle Help Center.

Role Information

You have a couple options for giving people access to this feature, depending on whether you're assigning them predefined job roles or your own configured job roles.

Users who are assigned any of these predefined job roles are automatically able to access this feature:

  • Warehouse Manager (ORA_INV_WAREHOUSE_MANAGER)
  • Shipping Manager (ORA_WSH_SHIPPING_MANAGER)

Users who are assigned configured job roles that contain these privileges are able to access this feature:

  • Manage Fiscal Document Generation (JG_MANAGE_FISCAL_DOCUMENT_GENERATION)

Other Shipping Changes in This Update

This section includes details about additional changes in this update that can change the way Oracle Shipping Cloud works.

Ensure Shipment's Actual Ship Date is Later than the Picking Transaction Date

If the November monthly maintenance pack is applied, then the application will ensure that the shipment’s actual ship date is later than the picking transaction date of all lines in the shipment. This helps to account for the ownership transfer transactions and issue transactions, and ensures success in costing.

Here are the changes that were implemented to restrict the shipment’s actual ship date:

  • Actual ship date field is no longer defaulted
  • Actual ship date field accepts only future date and times
  • Actual ship date field accepts only values later than the pick transaction date of all lines in the shipment
  • If the actual ship date selected is not today, the time component defaults to 11:59:59 PM
  • If the actual ship date selected is today, the time component defaults to current time at the time of processing

Bug reference: 31434334

Receiving

Supplier Returns Without Receipt Reference

In certain situations, it might be impractical for you to return goods to your supplier using the original receipt. For example, let’s say your supplier issues a mass recall for a particular good, and because you regularly order this good you have thousands of on-hand quantity that you received at various times. It would be nearly impossible to determine which goods came in on which receipt. Furthermore, it would take far too many hours to search for each receipt and then return the individual quantity indicated on each receipt.

Now you can return goods to your supplier without referencing the original receipt. Specifically, you can return the shipment to the supplier when they require a physical return of the goods. Also, you can scrap the material when your supplier requests that you dispose of the goods. This lets you return goods to your suppliers in bulk when referencing individual receipts isn't practical, or when you can't remember exactly when the goods were received.

Now you have the ability to manage and create a supplier return without receipt reference for a supplier and supplier site and process both the scrap and shipping transactions seamlessly in inventory and shipping through to cost accounting. You can also view these transactions on the Review Inventory Transactions page.

Manage Supplier Returns Without Receipt Reference

Create Supplier Returns Without Receipt Reference

Review Completed Transactions

Watch a Demo

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials Management

Tips And Considerations

You can return material to a supplier using this feature from a non-reservable subinventory only. Only stockable and transactable items are eligible for supplier returns without a receipt. Intercompany transactions and consigned inventory transactions are not supported for supplier returns without a receipt. You should manually create a debit memo for supplier returns without a receipt. You can use the Supplier Returns REST service to query, create, edit, cancel, delete, or submit the supplier return transactions. Supplier return transactions are costed at the current item cost.

Key Resources

Role Information

You have a couple options for giving people access to this feature, depending on whether you're assigning them predefined job roles or your own configured job roles.

Users who are assigned any of these predefined job roles are automatically able to access this feature:

  • Warehouse Manager (ORA_INV_WAREHOUSE_MANAGER)

Users who are assigned configured job roles that contain these privileges are able to access this feature:

  • Manage Supplier Returns Without Receipt (RCV_MANAGE_SUPPLIER_RETURNS)

Cost Management

Match Cost of Goods Sold to Revenue Recorded in Oracle Revenue Management Cloud

Automate revenue recognition in compliance with IFRS 15 and ASC 606 for sales orders from Order Management Cloud that represent contacts with customers. Recognize associated cost of goods sold in Cost Management Cloud in proportion to the revenue recognized in Oracle Revenue Management Cloud Service.

The integration with Oracle Revenue Management Cloud enables you to identify revenue contracts as sales order documents are submitted. Revenue Management automatically identifies accounting contracts, performance obligations, and their valuations at inception, which provides you with insight into the expected consideration from the sale of goods and services to customers as soon as the orders are booked. This integration also enables Revenue Management to process fulfillment data from Order Management, and consequently to recognize the revenue accordingly, over time or at a point in time, as and when the performance obligations have been satisfied.

When a revenue satisfaction event has been accounted in Revenue Management, the integration with Cost Management enables the associated cost of goods sold to be accurately recognized in the same period and the same proportion to the revenue recognized in Revenue Management. The revenue and the cost of goods sold information is available for you to perform detailed gross margin analysis.

The new revenue standard requires accounting for revenue notwithstanding the individual selling prices for different line items within a contract. Rather, the contract revenue is allocated on the basis of standalone selling prices.

When you set up integration with Revenue Management (see Steps to Enable section), Oracle Accounts Receivable is not used as the revenue source and consequently running the Import Revenue Lines is not necessary. Note that the revenue recognition process would also apply for ship only orders and returns.

The following example illustrates the method of revenue recognition in Oracle Revenue Management Cloud and its corresponding impact to cost of goods sold. For comparison, the information per legacy generally accepted accounting principles (GAAP) is also provided.

Sales Order # 520917

Item UOM Quantity Unit Selling Price Selling Amount
Network Gateway Switch Each 2 105.00 210.00
      Total 210.00

Sales Order # 520919

Item UOM Quantity Unit Selling Price Selling Amount

Oracle Database Enterprise Edition

Each

10

165.00

1650.00

Extended Warrany 2 years Each 10 45.00 450.00
      Total 2100.00

Legacy GAAP - Recognize Revenue in Accounts Receivables

Receivables Invoice # 127017

Item UOM Quantity Unit Selling Price Bill Amount Revenue
Network Gateway Switch Each 2 105.00 210.00 210.00
        Total 210.00

Receivables Invoice # 127018

Item UOM Quantity Unit Selling Price Selling Amount

Oracle Database Enterprise Edition

Each

10

165.00

1650.00

Extended Warranry 2 years Each 10 45.00 450.00
      Total 2100.00

New Guidance - Recognize Revenue in Revenue Management Cloud

Revenue Contract # 14011

Item UOM Quantity Unit Selling Price Selling Amount Unit Standalone Selling Price Extended Standalone Selling Price New Revenue
Network Gateway Swtich Each 2 105.00 210.00 98.00 196.00 134.51

Oracle Database Enterprise Edition

Each

10

165.00

1650.00

123.00 1230.00 844.12
Extended Warranty 2 years Each 10 45.00 450.00 97.00 970.00 1331.37
            Total 2310.00

Cost Management - COGS and Gross Margin (Revenue as per Legacy GAAP)

Order # Invoice # Item Unit Cost Quantity Total Cost Revenue Gross Margin Gross Margin %

520917

127017

Network Gateway Switch

50

2

100.00

500.00

400.00

80.00%

520919

127018

Oracle Database Enterprise Edition

75

10

750.00

500.00

-250.00

-50.00%

        Total 850.00 1000.00 150.00  

Cost Management - COGS and Gross Margin (Revenue as per New Guidance)

Order # Contract # Item Unit Cost Quantity Total Cost Revenue Gross Margin Gross Margin %

520917

14011

Network Gateway Switch

50.00

2

100.00

134.51

34.51

25.66%

520919 14011 Oracle Database Enterprise Edition 75.00 10 750.00 844.12 94.12 11.15%
        Total 850.00 978.63 128.63  

The data flow diagram below illustrates the end to end flow of information.

End to End Data Flow Diagram

Steps to Enable

To enable the Revenue Management Cloud integration with Order Management Cloud, ensure that the extraction date and the adoption date are set up in Manage Systems Options for Revenue Management for each ledger. The extraction date indicates the date from which the orders should be interfaced to Revenue Management, while the adoption date indicates the period from which the revenue is recognized as per the new standard.

Tips And Considerations

  • The source for revenue information is determined by the adoption date in the Manage System Options setup in Revenue Management. Revenue information is transferred to costing once the revenue lines are finally accounted.
  • The adoption date is the start date of the period that you choose in the Manage Systems Options for Revenue Management page and is for a future period.
  • Ensure that the document type "DOO Sales Order" is used for the integration with Order Management Cloud and Revenue Management Cloud.
  • Only order lines that have shipment task enabled or marked as Bill Only is interfaced from Revenue Management Cloud to Cost Management Cloud.
  • Extraction date cannot be more than 90 days prior to the adoption date. 
  • Receivables Cloud continues to be the source for transferring revenue information for intercompany invoices. Note that intercompany invoices are interfaced for purposes of gross margin calculation and not cost of goods sold recognition.

Key Resources

Role Information

  • Job Role Name and Code: 
    • Cost Accountant (ORA_CST_COST_ACCOUNTANT)

Use Additional Subledger Accounting Sources in Cost Management

The following sources are available when you create account rules, mapping sets, and description rules for sales order issue event class for COGS recognition and RMA recognition event types. These sources will allow you to use the same set of values used by Receivables Cloud to determine the revenue account for a transaction.

  • Invoice Line Flexfield Attribute - represents the Receivables lines descriptive flexfield attributes
  • Receivables Sales Credit Sales Person - refers to the sales person associated at the invoice line level.
  • Receivables Sales Credit Sales Person Number - refers the sales person number associated at the invoice line level.
  • Receivables Transaction Line Revenue Account - refers to the revenue account stamped by Receivables Cloud on the invoice line distribution.
  • Receivables Sales Credit Revenue Account - refers to the revenue account associated with the sales person that is used on the invoice line level.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

  • To determine if the sources are mapped to the event class that you want to use, refer to the Manage Subledger transaction Objects in the Setup and Maintenance work area.
  • To use values captured in Order Management extensible flexfields (EFF), map these attributes to revenue line or header descriptive Flexfields segment using the mapping feature provided in Oracle Order Management Cloud.

Key Resources

  • Oracle Supply Chain Management Cloud: Implementing Manufacturing and Supply Chain Materials Management Guide, available on the Oracle Help Center.

Role Information

  • Job Role Name and Code: 
    • Cost Accountant (ORA_CST_COST_ACCOUNTANT)

Cost Account Supplier Returns Without Reference to an Original Purchase Order

In certain situations it may be impractical for you to return goods to your supplier using the original receipt. For example, your supplier issues a mass recall for a particular item, and because you regularly order this item you have a sizable quantity on-hand that you received at various times. It would be impractical and time-consuming to determine the quantity that were delivered on a specific purchase order receipt. With this feature, you can return goods to your supplier without referencing the original receipt. This lets you return goods to your suppliers in bulk when referencing individual receipts isn't practical. The following screenshots illustrate this feature.

Manage Supplier Returns Without Receipt Task Option

Create Supplier Return Without Receipt Transaction

Review Cost Accounting Distributions for Supplier Returns

When you interface the unreferenced vendor return transaction to Cost Management, the transaction is processed using the current cost of the item within Cost Accounting similar to a miscellaneous issue transaction. Cost Accounting will create the following accounting distributions.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials Management

Tips And Considerations

Unreferenced return to vendor transactions are not available in accrual reconciliation. Use the appropriate accounting configuration to match the Inventory Return to Vendor Clearing account with the debit memo created in Payables.

Key Resources

  • Oracle Supply Chain Management Cloud: Implementing Manufacturing and Supply Chain Materials Management Guide, available on the Oracle Help Center

Role Information

  • Job Role Name and Code: 
    • Cost Accountant (ORA_CST_COST_ACCOUNTANT)

Fiscal Document Capture

Process Brazilian Fiscal Documents for Bookkeeping Purposes

When you import goods into Brazil from a supplier or an internal source, or if you transfer goods within Brazil and you want to use an external application for recording the purchasing and receiving transactions, you can still use Fiscal Document Capture to capture the fiscal document for reporting purposes. You can use No Source as the source document type when creating the fiscal document via either the user interface or XML. Using a No Source document type will exclude the fiscal document from creating a receipt transaction and Payables Invoice.

This screen illustrates the feature.

Process Brazilian Fiscal Documents for Bookkeeping - Edit Fiscal Document User Interface

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Fiscal Document Capture uses the CFOPs to determine the fiscal flow to use. Since the CFOPs are common between Purchased Material Import and Import Material by Internal Transfer, you should process No Source internal transfers using the Purchased Material Import fiscal flow. Disable the Import Material by Internal Transfer fiscal flow by inactivating it in the Manage Fiscal Flows user interface.

Key Resources

  • For more information about this feature, see the Using Fiscal Document Capture Guide, available on the Oracle Help Center.

Role Information

  • Privilege Name and Code:
    • Capture Fiscal Document (CMF_ENTER_FISCAL_DOCUMENT)
  • Job Role Name and Code:
    • Fiscal Document Specialist (ORA_CMF_FISCAL_DOCUMENT_SPECIALIST)

Supply Chain Financial Orchestration

Use Transaction Organization as Item Validation Organization in Supply Chain Financial Orchestration

When you operate multiple businesses in a single instance, you may keep your items separate and not share the same item validation organization across these businesses. You may even choose to have different master organizations in the same instance. Prior to this update, Oracle Supply Chain Financial Orchestration required you to specify an item validation organization in the System Options page. However, with this update, specifying the item validation organization is optional. When you do not specify an item validation organization, the transaction organization is used to fetch and validate all item related attributes.

Oracle Supply Chain Financial Orchestration uses the organization information to:

  • Fetch item information such as the item class, item type, item number, and inventory asset flag to validate financial orchestration qualifiers.
  • Fetch the item description to interface to intercompany invoices. For description-based items, the description entered on the purchase order is used for intercompany invoices.
  • Fetch the applicable attributes for configured items to interface to Oracle Pricing or a third-party transfer pricing service.
  • Validate invoice enabled attribute for the item before creating an intercompany AR invoice.

The table lists the organizations that are used as the transaction organizations if you do not specify the item validation organization.

Transaction Type Transaction Organization
PO Receipt/Return to Vendor Receiving trade organization
Shipment Shipping inventory organization
RMA Delivery Receiving trade organization
Transfer order/Internal transfer Shipping inventory organization
Customer drop ship Logical receiving inventory organization
Non-shippable sales Shipping organization, when available. Else, the item validation organization for the order business unit is used.
Transfer to owned Organization where the consigned item is consumed
Transfer to consigned Organization where the item is transferred to consigned

Oracle Supply Chain Financial Orchestration System Options Page

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

  • Oracle Supply Chain Management Cloud: Using Supply Chain Financial Orchestration Guide, available on the Oracle Help Center.

Role Information

  • Job Role Name and Code:
    • Supply Chain Application Administrator (ORA_RCS_SUPPLY_CHAIN_APPLICATION_ADMINISTRATOR_JOB)
  • Privilege Name and Code:
    • Maintain Supply Chain Financial Orchestration Flow (FOS_MAINTAIN_SUPPLY_CHAIN_FINANCIAL_TRADE_AGREEMENT_PRIV)

IMPORTANT Actions and Considerations

This section includes details about additional changes in this update that might change the way your products work.

BUGS FIXED

Reuse Serial Numbers on ASNs or ASBNs Across Organizations After Issue from Inventory

After updating to 20C, you'll be able to reuse serial numbers on advance shipment notices (ASNs) or advance shipment billing notices (ASBNs) across organizations provided that the corresponding goods have been issued out of inventory.  The goods can be issued out of inventory by a miscellaneous issue or a return to supplier. This also applies if you receive in one organization and transfer to a different organization prior to issuing the goods out of inventory. Prior to 20C, you couldn't reuse serial numbers on ASNs or ASBNs  in different organizations, even after issue from inventory.

Bug reference: 31069829