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.
Master Configuration
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.
ERP Integration Master Configuration
To create ERP Integration Master Configuration:
1. Navigate to Admin Menu > M > Master Configuration.
2. Click '+' against the ERP Integration Master Config value in the master configuration table.
3. In the Master Configuration Details section, select the ERP Integration Master Config (W1-ERPIntegrationMasterConfig) business object.
4. Navigate to Master Configuration > ERP Integration Master Config.
a. In the Main section, define the Oracle ERP External System.
b. In the Financial Configuration section, populate the account segments. One must be the Cost Center segment and another the Expense Code segment defined. The following table shows a sample reference.
c. In the Supply Chain Management Configuration section, configure the following:
• In the Storeroom Information section, the Storeroom Category flag sent by the integration should map to a valid Storeroom Type. This value is configured in the 'wacs.storeroom.category' property in the OUTL-BRT-WACS_ERPSCM_ConfigProps lookup in Oracle Integration Cloud.
Note: Currently only Standard Storeroom Category is supported in this release.
• In the Stock Item Detail Information section, the Stock Item Detail Class flags sent from the integration should map to Oracle Utilities Work and Asset Management Stock Item Detail business objects. This value is configured in the item.assign.stockitemdetail.class property in the OUTL-BRT-WACS_ERPSCM_ConfigProps lookup in Oracle Integration Cloud.
• In the Accounting Information section, populate the necessary fields.
d. In the Key Reference Mappings section, Stock Item Detail, Material Issue Line, and Node Mappings must be provided.
The following table shows a sample reference.
Seeder Sync Request Master Configuration
To create Seeder Sync Request Master Configuration:
1. Navigate to Admin Menu > M > Master Configuration.
2. Click '+' against the Seeder Sync Request Master Config value in the master configuration table.
3. In the Master Configuration Details section, select the Seeder Sync Request Master Config (W1-SeederSyncReqMasterConfig) business object.
4. Navigate to Master Configuration > Seeder Sync Request Master Configuration.
a. Create a row for the ERP External System, add the Cost Center and Resource Type Maintenance Object (MO) request mappings, and define the Ongoing Sync Request Business Objects and Key Reference Views.
The following table shows a sample reference.
ERP Admin Record
This section describes the Enterprise Resource Planning integration related configurations for the integration.
The Stock Item Detail, Stock Transaction, and Material Issue Line maintenance objects should be owned by Oracle Fusion ERP Cloud.
1. Navigate to Admin Menu > E > ERP Integration > Add.
2. Select “Stock Item Detail” as the Maintenance Object.
3. Select “Enterprise Resource Planning” as the Owner.
4. Repeat the steps 2 and 3 for the “Stock Transaction” and “Material Issue Line” maintenance objects.
Outbound Integration BO (W1-OutboundIntegration)
Make sure the following lifecycle algorithms are inactive:
• Awaiting Acknowledgment (AWAIT_ACKNLG) Status: Check for Response Timeout (W1-CHKRESP)
To inactivate the algorithm, add an option in the Status with an Inactive Algorithm Option Type and the name of the algorithm in the Value field.
Message Senders
Create a new message sender for each integration service initiated from Oracle Utilities Work and Asset Cloud Service.
To create a message sender:
1. Navigate to the Message Sender page from the Admin menu or from the Search menu.
2. Enter a unique message sender and its description.
3. Populate the following values:
• Invocation Type: Real-time
• Message Class: RTJSONSNDR
• Active: Select the checkbox.
• MSG Encoding: UTF-8 message encoding
4. Select the Context tab and set values for the following context types:
• HTTP Header: application/json
• HTTP Login User: User ID to access the Oracle Integration Cloud flow.
• HTTP Password: Password to access the Oracle Integration Cloud flow.
• HTTP Method (POST/GET): POST
• HTTP Timeout: 60
• HTTP Transport Method: SendReceive
• HTTP URL 1: Set the Activated Integration end point URL by removing the ?wsdl from the URL. If the URL value does not fit, use the additional HTTP URL types to set the complete URL.
Message sender configuration for integration services
Outbound Message Types
The following outbound message types are provided for each integration process.
On the Admin menu, navigate to the Outbound Message Type page. You can also navigate from the Search menu.
Add the following details to create an outbound message type:
External System
Create a new or update an existing external system to support the Oracle ERP Cloud.
To create an external system:
1. In the Admin menu, navigate to [M or Integration] > External System > Add.
2. Enter a unique External System and Description.
3. Associate the outbound message types and message senders created to the external system.
For each outbound message type, set the following: