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.