Configuring Admin Data
This section describes the admin data setup in Oracle Utilities Work and Asset Cloud Service related to the integration. The Admin menus can be configured to be grouped alphabetically or by functional groups. The descriptions that follow will include both groupings.
External System
Create a new or update an existing external system to support the Enterprise Resource Planning Cloud.
To create a new External System:
1. In the Admin menu, navigate to [M or Integration] > External System > Add.
2. Enter a unique External System and its Description.
3. Set the Our Name in Their System field to Oracle Utilities Work and Asset Cloud Service.
4. Associate the outbound message types created to the external system.
For each outbound message type, set the following:
• Outbound Message Type: Outbound message type for the respective integration service
• Processing Method: Real-time
Note: To create a new external system, outbound message type and processing method are required. For this integration, Oracle Utilities Work and Asset Cloud Service does not send any outbound message to the Oracle ERP Product Hub Cloud application. Thus, it does not have any outbound message types to setup. To be able to save the record, just add any outbound message type.
Inbound Web Service (IWS)
The following REST inbound web service is applicable for this integration:
• W1-StockItemSynchronization
The full URI component for the REST inbound web service is configurable.
The Oracle Utilities Work and Asset Cloud Service documentation provides instructions about the one-time setup. Refer to the Documentation and Resources section in Preface for information about documentation resources.
Master Configuration Setup
This section describes the master configuration details for the integration. The following Master Configurations can be found from the Admin menu [M or General] > Master Configuration.
Seeder Sync Request Master Configuration
The Seeder Sync master configuration identifies the ongoing sync request business object and key reference view for the maintenance object specified in the synchronization request.
To create a Seeder Sync Request master configuration:
1. Create a row for the Oracle Enterprise Resource Planning External System and Resource Type Maintenance Object (MO): W1- RESRCTYPE for Stock Item Sync Integration.
2. Define the Ongoing Sync Request Business Object that will process the integration record and the Ongoing Sync Key Reference View and Identifier Type to find existing integration records.
The table below shows a sample reference Business Object, Ongoing Sync Key Reference View and Identifier Type for the Maintenance Object.
Master Data Synchronization Master Configuration
This Master Configuration is used to update External IDs with IDs used within Oracle Utilities Work and Asset Cloud Service.
To create a Master Data Synchronization master configuration, create a row for the Stock Item (Resource Type) FK Ref and Oracle Enterprise Resource Planning External System that references the Stock Item Ongoing Sync Key Reference View.
The table below shows a sample reference for FK Reference, Ongoing Sync Key Reference View, External System and Identifier Type.
Business Object
Stock Item Ongoing Sync Request Business Object
This section includes the following:
Acknowledgment
No positive/negative acknowledgment messages need to be returned to the ERP system. Make the following lifecycle algorithms inactive to not send any acknowledgment:
• Synchronized (SYNCHRONIZED) Status - Create Positive Acknowledgment for ERP (W1-CPOSAERP)
• Negative Acknowledgment Sent (NEG-ACK-SENT) Status - Create Negative Acknowledgment (W1-CRENEGACK)
To make the algorithms inactive, add an option within the Status with an Inactive Algorithm Option Type and the name of the algorithm within the Value field.
Target Business Object
The Oracle Utilities Work and Asset Cloud Service business object created from the Sync Request is defined on the Data Transformed state's Determine Stock Item Target business object algorithm parameters.
Lifecycle States
The following deferred monitors are set on the following lifecycle states. These deferred monitors are executed using the corresponding batch control submission. They can be removed from each lifecycle state for immediate execution of the state algorithms.
• Ongoing Sync Request - Pending (W1-SIOPE)
• Pending
• Ongoing Sync Request - Error (W1-SIOER). This Deferred Monitor allows to retry the state algorithms after an error is found.
• Pre-Add Error
• FK Resolution Error
• Update Error
• Additional Processing Error
Expense Code and Vendor Location Setup
The Stock Item must reference an existing Expense Code and Cost Category. These can be added using the application Admin menus. The Stock Item can also reference one or more Vendor Locations. These Vendor Locations can either be added via the W1- SyncRequestInbound requests or an existing Vendor Location can be updated to include the External ID that will be referenced by the Stock Item sync.