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.
Sequence
Element Name
Account Segment Type
Include in Cost Center
1
cmAccountSegments/ company
 
No
2
cmAccountSegments/lob
 
No
3
cmAccountSegments/costCenter
 
Yes
4
cmAccountSegments/expenseCode
 
No
5
cmAccountSegments/product
 
No
6
cmAccountSegments/intercompany
 
No
7
cmAccountSegments/segment7
 
No
8
cmAccountSegments/segment8
 
No
9
cmAccountSegments/segment9
 
No
10
cmAccountSegments/segment10
 
No
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.
Maintenance Object
Ongoing Sync Key Reference View
Identifier Type
Material Issue Line
Integration Key Material Issue View
W1-EXTID
Node
Ongoing Sync Key Location View
W1SE
Stock Item Detail
Ongoing Sync Key Stock Item Detail View
W1EX
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.
Maintenance Object
Ongoing Sync request BO
Ongoing Sync Key Reference View
Identifier Type
W1-COSTCTR
(Cost Center)
W1-OngoingSync RequestCostCtr (Cost Center Ongoing Sync Request)
W1_ON_COST_CE NTER_VW
(Ongoing Sync Key Cost Center View)
W1EI
W1-RESRCTYPE
(Resource Type)
W1-OngoingSyncRequestStockItem
(Stock Item Ongoing Sync Request)
W1_ON_STOCK_ITEM_VW
(Ongoing Sync Key Stock Item View)
W1EI
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
Message Sender
Description
HTTP URL
INT_ARR
Message Sender for ARR/Reservation ERP Integration
https://OIC_HOST/ic/api/integration/v2/flows/oracleutilities/project/OUTL-BA-WACS_ERPSCM/OU_WACS_ERPSCM_RESERVATION_PROC/1.0/arReq
INT_MR
Message Sender for Material Request ERP Integration
https:// OIC_HOST/ic/api/integration/v2/flows/oracleutilities/project/OUTL-BA-WACS_ERPSCM/OUTL-BA-WACS_ERPSCM_MRREQ_PROCES/1.0/receiveMR
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:
Outbound Message Type
Description
Outbound Message BO
Priority
W1-AMROUTMS
Activity Mat Resource Outbound Message Type
W1-ActMatResrcOutboundMessage
50
W1-MROUTMS
Material Request Outbound Message Type
W1-MatlReqIntegOutMsg
50
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:
Outbound Message Type
Processing Method
Message Sender
Date/Time Format
JSON Conversion Method
W1-AMROUTMS
Real-time
INT_ARR
XSD
Base JSON Conversion
W1-MROUTMS
Real-time
INT_MR
XSD
Base JSON Conversion