Scenario 1: CC&B – MWM

Scenario 1: CC&B – MWM - WAM v1.9.1.x

In this scenario, the integration product coordinates processing between three Oracle Utilities application products based on the configuration settings described. All two or three application products and the integration product must be configured to enable this business scenario. This section of the document describes the configuration required for one of the application products.

To configure the integration layer for Scenario 1:

• Setting AIA Configuration Properties

• Settings for System Properties

• Domain Value Maps

• Cross-References

• Updating MDS with AIA Meta Data

• Update Configuration Properties

• Deploying Individual Composites/Undeploying Composites and Updating MDS

• Error Notification Setup

• SOA Infrastructure Common Properties

Setting AIA Configuration Properties

Various configurations that apply to the entire Oracle AIA system, Core Infrastructure Components, and specific process integration services are stored in the AIAConfigurationProperties.xml file which is stored in MDS.

This section lists the configurations in this file that are used by the integration layer. These configurations hold several configurable values that are picked up by the integration at runtime to:

• Default some business entity value sent to the target edge applications when the data is moved from one system to another. These configuration values may need to be updated to your implementation specific values for the integration to work correctly. These properties are described in this section in detail.

• Activate custom implemented extension points available inside the ABCS. By default these properties are set not to invoke any of the extension points as the extension points need to be implemented using the AIA ABCS Extension guidelines before being activated. These properties need to be changed only if you decide to extend the core functionality provided by this Process integration Pack, using the predefined ABCS extension points. These properties are not listed in this section but can be identified in the AIAConfigurationProperties.xml file as the name of these Service Configuration properties start with ABCSExtension and are available in the file under each ABCS Name.

For more information on extending the ABCS using extension points, refer to Chapter 19: General Extensibility Options.

• Get the endpoint URLs for Provider ABCS. These properties are set to appropriate values during the installation of Process Integration Pack, based on the information specified during the installation. You should not have to modify the values.

Settings for System Properties

Two sets of configuration properties are described in this section:

• Module Configurations are the properties that are shared by multiple integration processes within the integration layer.

• Service Configurations are the properties that are used by a specific ABCS.

Module Configurations

Module Name	Property Name	Default / Shipped Value	Integration Point	Description
OUFieldWorkPIP WorkOrderAction Codes	WorkOrder.ActionCode. CREATE	CREATE	Work Order	This is internally used by the integration to identify the messages sent for Work order creation. Do not change the value of this property.
OUFieldWorkPIP WorkOrderAction Codes	WorkOrder.ActionCode. UPDATE	UPDATE	Work Order	This is internally used by the integration to identify the messages sent for Work order updates. Do not change the value of this property.
OUFieldWorkPIP WorkOrderAction Codes	WorkOrder.ActionCode. COMPLETE	COMPLETE	Work Order	This is internally used by the integration to identify the messages sent for Work order completion. Do not change the value of this property.
OUFieldWorkPIP WorkOrderAction Codes	WorkOrder.ActionCode. CANCEL	CANCEL	Work Order	This is internally used by the integration to identify the messages sent for Work order cancellation. Do not change the value of this property.
OUFieldWorkPIPWorkOrderActionCodes	WorkOrder.ActionCode. INCOMPLETE	IN-COMPLETE	Work Order	This is internally used by the integration to identify the messages sent for Work order incomplete transactions. Do not change the value of this property.
OUFieldWorkPIPWorkOrderActionCodes	WorkOrder.ActionCode. STATUSUPDATE	STATUSUPDATE	Work Order	This is internally used by the integration to identify the messages sent for Work order status updates. Do not change the value of this property.
OUWAM	WAM.WorkOrder.Default.MessageID	0000000000	Work Order	This is a default message ID used for Work Order messages sent from WAM. Do not change the value of this property.
OUWAM	WAM.Default.PLANT	FWI	Work Order	This specifies the WAM plant that it is integrated with.
OUMWM	OUMWM.Transaction Code.CREATE	M2UP	Work Order	The MWM transaction code set on the Work Order Create messages inbound to MWM. Do not change.
OUMWM	OUMWM.Transaction Code.UPDATE	M2UP	Work Order	The MWM transaction code set on the Work Order Update messages inbound to MWM. Do not change.
OUMWM	OUMWM.Transaction Code.CANCEL	M2CA	Work Order	The MWM transaction code set on the Work Order Cancel messages inbound to MWM. Do not change.
OUMWM	OUMWM.Transaction Code.COMPLETE	M2CO	Work Order	The MWM transaction code set on the Work Order Cancel messages inbound to MWM. Do not change.
OUMWM	OUMWM.timeUsage Window	M1EF	Work Order	This specifies the timeUsageWindow in MWM. Do not change.
OUMWM	OUMWM.Plant	FWI	ALL IPs	This specifies the WAM plant that MWW is integrated with.
OUMWM	OUMWM.External System	FWI-PIP	ALL IPs	This is the external system configured in the MWM.
OUWAM	OUWAM.Transaction Code.CREATE	W1AD	WorkOrder	The WAM Transaction code set on the Work Order Create messages inbound/outbound for WAM v2.1.x. Do not change.
OUWAM	OUWAM.Transaction Code.UPDATE	W1UP	WorkOrder	The WAM transaction code set on the Work Order Update messages coming from WAM v2.1.x. Do not change the value of this property for WAM v2.1.x.
OUWAM	OUWAM.Transaction Code.CANCEL	W1CA	WorkOrder	The WAM Transaction code set on the Work Order Cancel messages coming from/to WAM v2.1.x. Do not change the value of this property for WAM v2.1.x.
OUWAM	OUWAM.IdentifierType. PIPActivity	W1FA	WorkOrder	The Identifier Type is used by WAM v2.1.x to determine the types of identifiers being passed in. This identifier type is used to identify the PIP Id. Do not change the value of this property for WAM v2.1.x.
OUWAM	OUWAM.IdentifierType.CCBActivity	W1CF	WorkOrder	The Identifier Type is used by WAM v2.1.x to determine the types of identifiers being passed in. This identifier type is used to identify the CCB Id. Do not change the value of this property for WAM v2.1.x.
OUWAM	OUWAM.IdentifierType. MWMActivity	W1MT	WorkOrder	The Identifier Type is used by WAM v2.1.x to determine the types of identifiers being passed in. This identifier type is used to identify the MWM Activity ID. Do not change the value of this property for WAM v2.1.x.
OUWAM	OUWAM.ExternalSystem	MWM	WorkOrder	This identifier is used by WAM 2.1.x to determine the types of identifiers passed in to identify the MWM external system. Do not change the value of this property for WAMv2.1.x.
OUWAM	OUWAM.IdentifierType.CCBSP	W2EI	WorkOrder	This identifier is used by WAM 2.1.x to determine the types of identifiers passed in to identify the Servicepoint information. Do not change the value of this property for WAMv2.1.x.
OUWAM	OUWAM.CCB.ExternalSystem	CCB	WorkOrder	This identifier is used by WAM 2.1.x to determine the types of identifiers passed in to identify the CCB external system. Do not change the value of this property for WAMv2.1.x.
OUWAM	OUWAM.IdentifierType. RelatedActivity	W1RA	WorkOrder	The Identifier Type is used by WAM v2.1.x to determine the types of identifiers being passed in. This identifier type is used to identify the parent WAM Activity ID. Do not change the value of this property for WAM v2.1.x.

ABCS Configurations

ABCS Name	Property Name	Default / Shipped Value	Description
CreateCustomerInteractionOUWAMUtilitiesReqABCSImpl	ContactClass	SVC	Used by the customer interaction process to specify an CC&B Contact Class to be used when a customer contact is created in CC&B by this process. Specify the contact class created above for this property. Refer to Customer Contact Class and Type for configuration details.
CreateCustomerInteractionOUWAMUtilitiesReqABCSImpl	ContactType	MISC	Used by the customer interaction process to specify an CC&B Contact Type to be used when a customer contact is created in CC&B by this process. Specify the contact type created above for this property. Refer to Customer Contact Class and Type for configuration details.
CreateCustomerInteractionOUWAMUtilitiesReqABCSImpl	Description	Added with WAM Requester ABCS to create Customer Contact in CC&B	This is the Description that is specified on the Customer Contact when it is created in CC&B by the customer interaction. You can change this to the text that you wish to have on these customer contacts.
CreateCustomerInteractionOUWAMUtilitiesReqABCSImpl	ToDoRole	SUPPORT	Used by the customer interaction process to specify a CC&B ToDORole to be used when a ToDo is created in CC&B by this process. Set this property to the created/identified To Do Role for this purpose. Refer to To Do Type/ To Do Role for configuration details.
CreateCustomerInteractionOUWAMUtilitiesReqABCSImpl	TriggerDay	20	This property is for future use. Do not modify.
CreateCustomerInteractionOUWAMUtilitiesReqABCSImpl	TriggerToDo	YES	This property is for future use. Do not modify.
CreateInvoiceOUCCBUtilitiesProvABCSImpl	CCB.BillableChargeSATypeCode	MI-SUBCH	This is the CC&B SA Type used by Billable Charge Integration process for finding or creating a Billable Charge SA. Set this to the appropriate CC&B SA Type that you use for this purpose.
CreateInvoiceOUCCBUtilitiesProvABCSImpl	CCB.CisDivisionCode	OH	This is the default CIS Division to use for finding or creating a Billable Charge SA in CC&B. This is only used when CC&B cannot find the CIS Division for the input Account or SP. Set this to the appropriate CC&B CIS Division that you use for this purpose.
CreateInvoiceOUCCBUtilitiesProvABCSImpl	CCB.OrderIDCharacteristicTypeCode	CI_SOLID	This is the Characteristic Type to use for storing the common Work Order ID in the Billable Charge Upload Line Characteristics.
CreateInvoiceOUCCBUtilitiesProvABCSImpl	CCB.SAStartOption	<blank>	This is the SA Start Option used for finding or creating a Billable Charge SA. This is an optional field. You can specify a valid CC&B SA Start Option to be used for this purpose.
CreateInvoiceOUCCBUtilitiesProvABCSImpl	CCB.ToDoMessage Category	90000	Set this to a valid CC&B Message Category that you want to be used for To Do entries created by the Billable Charge process. Set this property to the created/identified To Do Message Category for this purpose. Refer to To Do Type/ To Do Role for configuration details.
CreateInvoiceOUCCBUtilitiesProvABCSImpl	CCB.ToDOMessage Number	5010	Set this to a valid CC&B Message Number that you want to be used for To Do entries created by the Billable Charge process. Set this property to the created/identified To Do Message Number for this purpose. Refer to To Do Type/ To Do Role for configuration details.
CreateInvoiceOUCCBUtilitiesProvABCSImpl	CCB.ToDoRole	<blank>	CC&B To Do Role to be used by Billable Charge process, for the creation of a To Do Entry when multiple accounts are linked to an SP. This is an optional field. Set this property to the created/identified To Do Role for this purpose if needed. Refer to To Do Type/ To Do Role for configuration details.
CreateInvoiceOUCCB UtilitiesProvABCSImpl	CCB.ToDOTypeCode	CI_WRNMU	CC&B To Do Type to use by Billable Charge process, for the creation of a To Do Entry when multiple accounts are linked to an SP. Set this property to the created/identified To Do Type for this purpose.
CreateInvoiceOUCCB Utilit iesProvABCSImpl	CCB.BillableChargeDescriptionOnBill	Field Work Charges	This property is used to default the Billable Charge Description on Bill.
GetWOLineApptWinAvailOUCCBUtilitiesReqABCSImpl	CCB.ResponseCodeFor ErrorAppointment	100	This is the response code used by Appointments when there is an error retrieving the appointment slots. For internal use only. Do not modify.
GetWOLineApptWinAvailOUCCBUtilitiesReqABCSImpl	CCB.ResponseCodeForSuccessWithoutAvailable Appointment	101	This is the response code used by Appointments when no appointment slots were found for the search criteria specified. For internal use only. Do not modify.
GetWOLineApptWinAvailOUCCBUtilitiesReqABCSImpl	GeoCodeLatitude GeoCodeLongitude	LAT LONG	Specify the value for the CC&B Geo Types used on service point to indicate geographic coordinates. Refer to Geographic Type for configuration details.
GetWOLineApptWinAvailOUMWMUtilitiesProvABCSImpl	24hours.Default.Value	2400	This value is for internal use by this integration. Do not modify.
GetWOLineApptWinAvailOUMWMUtilitiesProvABCSImpl	destination.Default.Value	RTS	This value is for scheduler system use for routing appointment request to end MWM application. This value is for internal use. Do not modify.
GetWOLineApptWinAvailOUMWMUtilitiesProv ABCSImpl	FONumber.Default.Value	00000	This is the default Field Order Number used by the Appointments when the order number is missing in the Request for appointment slots sent from CC&B. For internal use only. Do not modify.
GetWOLineApptWinAvailOUMWMUtilitiesProv ABCSImplV2	MaxApptWinCount. Default.Value	1000	Default value of Max Appointment Window Count
GetWOLineApptWinAvailOUMWMUtilitiesProv ABCSImplV2	MaxCostUnits.Default. Value	1e99	Default value of Max Cost Units.
GetWOLineApptWinAvail OUMWMUtilitiesProv ABC SImplV2	SlotGroup.Default. Value	<blank>	Default value of SlotGroup. It is empty by default.
ProcessWorkOrderCompleteOUMWMUtilitiesReq ABCSImplV2	Default.Cancel.Reason	Canceled/ Completed in WAM	This is the cancellation reason text sent to WAM when MWM cancels a Work Order. You can change this to the text that you wish to use for this purpose.
ProcessWorkOrderCompleteOUMWMUtilitiesReq ABCSImplV2	Default.Plant	FWI	This is the default Plant Information sent from MWM to WAM
ProcessWorkOrderComplet eOUMWMUtilitiesReq ABC SImplV2	Default.MeterReadSource	FWI	This is the default meter read source.
ProcessWorkOrderCompleteOUMWMUtilitiesReq ABCSImpl	MWM.Pass.Representative. Information	true	This is used to indicate whether or not the representative ID is to be passed to CC&B. If the property is false indicating that the representative ID should not be passed to CC&B, then the CC&B Provider uses the generic representative configured in the AIA Configuration. If the property is true indicating that the representative ID should be passed, the MWM requester passes the representative ID to the Integration layer. The integration layer looks up the new DVM and passes the value configured in the DVM. If the Crew Data is synchronized between CC&B and MWM, this DVM can be left empty. When DVM is left empty, integration layer passes the CrewID coming from MWM directly to CC&B without any transformation.
ProcessWorkOrderCompleteOUMWMUtilitiesReq ABCSImplV2	MWM.Pass.Representative. Information	false	This is used to indicate whether or not the representative ID is to be passed to CC&B. If the property is false indicating that the representative ID should not be passed to CC&B, then the CC&B Provider uses the generic representative configured in the AIA Configuration. If the property is true indicating that the representative ID should be passed, the MWM requester passes the representative ID to the Integration layer. The integration layer looks up the new DVM and passes the value configured in the DVM. If the Crew Data is synchronized between CC&B and MWM, this DVM can be left empty. When DVM is left empty, integration layer passes the CrewID coming from MWM directly to CC&B without any transformation.
ProcessWorkOrder CompleteOUWAM UtilitiesReqABCSImpl	WAM.Pass.Representative. Information	true	This is the WAM Pass Representative Information.
ProcessWorkOrderCreateO UMWMUtilitiesReq ABCSI mplV2	MWM.SPValidation.MessageCategory	11503	Message Category populated for SP Validation
ProcessWorkOrderCreateO UMWMUtilitiesReq ABCSI mplV2	MWM.SPValidation.MessageNumber	11214	Message Number populated for SP Validation
ProcessWorkOrderOUCCBUtilitiesReqABCSImpl	OUCCB.PhoneType.Value	HOME	Default Phone Type value passed from C&CB
ProcessWorkOrderCreate OUMWMUtilitiesReq ABCSImplV2	CreateCustomerContact. Flag	false	Set to either True or False to indicate whether a customer contact is to be created in CC&B along with field activities that are created by the integration. This property is used by Work Order process, when an Order Create request is sent from MWM to CC&B.
ProcessWorkOrderOUCCBUtilitiesReqABCSImpl	OUCCB.GeoCode Latitude OUCCB.GeoCode Longitude	GRID_X GRID_Y	Specify the value for the CC&B Geo Types used on service point to indicate geographic coordinates. Refer to Geographic Type for configuration details.
ProcessWorkOrderCreate OUWAMUtilitiesReq ABCSImpl	Default.Dispatch.Group	FWIUSER	This is the dispatch group used by Work Order process for all Order Creates sent from WAM to CC&B. Set this value to match with one of the values in the DVM FS_Order_DispatchGroup under column OU_WAM_01.
ProcessWorkOrderCreate OUWAMUtilitiesReq ABCSImpl	Default.Enrichment.For. Meter.SystemID	OU_CCB_01	This is used by the Work Order process to identify the application used for retrieving meter and register information for Order Create messages sent from WAM. Do not modify.
ProcessWorkOrderOUCCBUtilitiesProvABCSImpl	CCB.CustomerContact. Class	CC	This is the CC&B Customer Contact Class that is used by Work Order process when this process creates a new field activity in CC&B as a result of Order Create Request from WAM or MWM. Set this property to the created/identified Customer Contact Class for this purpose. Refer to Customer Contact Class and Type for configuration details.
ProcessWorkOrderOUCCBUtilitiesProvABCSImpl	CCB.CustomerContact. Desc	New SR created from Field Work Integration.	This is the Description that is specified on the Customer Contact when it is created in CC&B by the Work Order process when this process creates a new field activity in CC&B as a result of Order Create Request from WAM or MWM. You can change this to the text that you wish to have on customer contacts.
ProcessWorkOrderOUCCBUtilitiesProvABCSImpl	CCB.CustomerContact. Type	INQUIRE	This is the CC&B Customer Contact Type that is used by Work Order process when this process creates a new field activity in CC&B as a result of Order Create Request from WAM or MWM. Set this property to the created/identified Customer Contact Type for this purpose. Refer to Customer Contact Class and Type for configuration details.
ProcessWorkOrderOUCCBUtilitiesProvABCSImpl	CCB.Representative. FACompletion	MWMCR1	The representative to be used when MWM or WAM sends an order completion message to CC&B. Must be valid in CC&B for the CC&B Dispatch Group(s) used for sending orders.
ProcessWorkOrderOUCCBUtilitiesProvABCSImpl	CCB.ToDoRole	CIACTIV	Specify the value for the CC&B user role that the To DoEntry created by the Work Order process should be assigned to. Set this property to the created/identified To Do Role for this purpose. Refer to To Do Type/ To Do Role for configuration details.
ProcessWorkOrder OUWAMUtilitiesProv ABCSImpl	Default.Employee.For. InventoryLog	MWM, INTEGRATION	This is the default WAM checkout employee used by the Work Order process for the inventory log transactions sent from MWM to WAM with the Order Completion message. All the inventory log transactions are created for this WAM employee. Set this to a valid WAM employee name to be used for this purpose. The name is to be specified in the format <Employee Last Name>, <Space><Employee First Name>. Refer to Employee for Checkout Transactions.
ProcessWorkOrderResponseOUCCBUtilitiesProvABCSImpl	Default.Create.FA.Log	true	Values are true and false. This is used by Work Order Integration process while sending positive or negative acknowledgments back into CC&B and determines if a FA Log entry is to be created in CC&B on the receipt of the acknowledgment.
ProcessWorkOrderResponseOUCCBUtilitiesProvABCSImpl	Default.Notification. External.ID	AIA-FS	This is the CC&B Notification External ID used by the Work Order integration process while sending positive or negative acknowledgments back into CC&B for Order messages sent out by CC&B. Set this to a valid External System. Refer to Setting Up CC&B > Configure Notification Download Staging section for more information.
ProcessWorkOrderResponseOUCCBUtilitiesProvABCSImpl	Default.Reply.To. Message.Source	AIA-FS	This is the CC&B Reply To Message Source used by the Work Order integration process while sending positive or negative acknowledgments back into CC&B for Order messages sent out by CC&B. Set this to a valid External System. Refer to Setting Up CC&B > Configure Notification Download Staging section for more information.
ProcessWorkOrderUpdateOUWAMUtilitiesReqABCSImpl	Default.Dispatch. Group	FWIUSER	This is the dispatch group used by Work Order flow for all Order Creates sent from WAM to CC&B. This value must match the value of the Default.Dispatch.Group, which was set for Create messages in a previous step.
ProcessWorkOrderUpdateOUWAMUtilitiesReqABCSImpl	IntermediateStatus	CREX	This is used to identify the intermediate status code sent by WAM for Work Order Update messages. Do not modify.
ProcessWorkOrder CompleteOUWAMUtilities ReqABCSImpl	WAM.Pass.Representative. Information	true	This is used to indicate whether or not the representative ID is to be passed to CC&B. If the property is false indicating that the representative ID should not be passed to CC&B, then the CC&B Provider uses the generic representative configured in the AIA Configuration. If the property is true indicating that the representative ID should be passed, the WAM requester passes the representative ID to the Integration layer. The integration layer looks up the new DVM and passes the value configured in the DVM. If the Crew Data is synchronized between CC&B and WAM, this DVM can be left empty. When DVM is left empty, integration layer passes the CrewID coming from WAM directly to CC&B without any transformation.
ProcessWorkOrder CompleteOUWAMUtilities ReqABC SImpl	Default.Cancel.Reason	Canceled in WAM	This is the cancellation reason text sent to CC&B/MWM with the cancellation request, when WAM cancels a Work Order. You can change this to the text that you wish to use for this purpose.
ValidateInstalledProduct OUMWMUtilitiesReq ABCSImplV2	Transaction.Code	Read	Default value of Transaction Code. Do not change this property value

Domain Value Maps

Domain value maps (DVMs) are a standard feature of the Oracle SOA Suite which maps codes and other static values across applications. The DVMs are stored in MDS. For example, For example, country code in one application can be US in one application and USA in another application.

DVMs are static in nature, though administrators can add additional maps as needed. Transactional business processes never update DVMs—they only read from them. They are stored in XML files and cached in memory at runtime.

Maintain the Information within Domain Value Maps

1. Open a browser and access the SOA Composer (http://soa-server:soa-port/soa/composer) for your installation.

2. On the SOA Composer application open DVM.

3. Search and select the relevant DVM you wish to maintain.

4. Set up the required values for each integrated application.

The Oracle Process Integration Pack for Oracle Utilities Field Work work includes the following DVMs:

DVM	Integration Points	Description
FS_Invoice_ChargeLineTypeCode	BillableCharge	DVM mapping for charge line type code
FS_Order_DisconnnectLocationCode	WorkOrder	DVM mapping for disconnect location code
FS_Order_DispatchGroup	WorkOrder, AvailableAppointment	DVM mapping for dispatch group
FS_Order_Division	WorkOrder, AvailableAppointment	DVM mapping for division
FS_Order_ExpenseTypeCode	WorkOrder	DVM mapping for expense type code.
FS_Order_ItemStatusCode	WorkOrder	DVM mapping for item status code
FS_Order_ItemStockLocationCode	WorkOrder	DVM mapping for item stock location code
FS_Order_ItemTypeCode	WorkOrder	DVM mapping for item type code
FS_Order_MeterConfigurationType	WorkOrder, InstalledProduct	DVM mapping for meter configuration type
FS_Order_MeterStatusCode	WorkOrder	DVM mapping for meter status code
FS_Order_MeterStockLocationCode	WorkOrder	DVM mapping for meter stock location code
FS_Order_MeterTypeCode	WorkOrder	DVM mapping for meter type code
FS_Order_OperationsArea	WorkOrder, AvailableAppointment	DVM mapping for operations area. For WAM, this is set up as Dept**Area
FS_Order_ReadTypeCode	WorkOrder	DVM mapping for meter read type code
FS_Order_RegisterReadUnitCode	WorkOrder, InstalledProduct	DVM mapping for register read unit code
FS_Order_RegisterTimeOfUseCode	WorkOrder, InstalledProduct	DVM mapping for register read time of use code
FS_Order_ServicePointTypeCode	WorkOrder, AvailableAppointment	DVM mapping for service point type code
FS_Order_Status	WorkOrder	DVM mapping for order status
FS_Order_SubStatus	WorkOrder	DVM mapping for order sub status
FS_Order_TypeCode	WorkOrder, AvailableAppointment	DVM mapping for order type code. For WAM, this is set up as Service Request Type**Problem Code
FS_Order_Worker	WorkOrder	DVM mapping for Representative ID values
FS_Order_RemarksCode	WorkOrder	DVM mapping for Remarks Code values
FS_Order_StepType	WorkOrder	DVM mapping for Step Type values
FS_Order _SlotGroup	AvailableAppointment	DVM mapping for Slot group for an Appointment values
FS_Order_MeterLocationCode	WorkOrder	DVM mapping for Meter Location Code values
FS_Order_PriorityCode	WorkOrder	DVM mapping for Priority Code values
FS_Order_TimeZone	WorkOrder	DVM mapping for passing Time Zone Code values
FS_Country_Code	WorkOrder	DVM mapping to pass Country Codes
FS_Language_Code	InstalledProduct	DVM mapping to pass Language Codes
FS_Order_TypeCode_Use ReadingOnBill	WorkOrder	DVM mapping to map UseOnBill Indicator based on Order Type Code
FS_Order_ManufacturerCode	WorkOrder	DVM mapping to map Manufacturer code of Meter/Item.
FS_Order_ServiceWarnings	WorkOrder	DVM mapping to map service warnings
FS_Order_ServiceInstructions	WorkOrder	DVM mapping to map service instructions
FS_Order_PremiseTypeCode	WorkOrder	DVM mapping to map Premise Type
FS_Order_ServiceTypeCode	WorkOrder	DVM mapping to map Service Type
FS_BO	ServicePoint	DVM mapping to business object
FS_MO	ServicePoint	DVM mapping to maintenance object
FS_ErrorCodes	ServicePoint	DVM mapping to error information
FS_SPNodeType	ServicePoint	DVM mapping to SP Type information
FS_NodeDisposition	ServicePoint	DVM mapping to disposition information
FS_Order_RegisterSeqCode	WorkOrder	DVM mapping to register sequence information
FS_LifeSupportSensitiveLoad	ServicePoint	DVM mapping to Lifesupport Sensitive information
FS_OkToEnterCode	ServicePoint	DVM mapping to pass true or false

For more information about DVMs, refer to the Working with Domain Value Maps section in the Oracle Fusion Middleware Developing SOA Applications with Oracle SOA Suite.

For information on matching values for each DVM, refer to the applicable section in Setting up Oracle Utilities Customer Care and Billing for OU_CCB_01, Setting up Oracle Utilities Work and Asset Management v1.9.1.x for OU_WAM_01, Setting up Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management v2.1.x for OU_WAM_01 and to Setting up Oracle Utilities Mobile Workforce Management for OU_MWM_01.

FS_Invoice_ChargeLineTypeCode

Bill charge line types simplify the creation of billable charges in Oracle Utilities Customer Care and Billing. Each line type contains values that are defaulted onto the line details associated with the uploaded billable charges.

When billing information is sent from Oracle Utilities Work and Asset Management v1.9.1.x to Oracle Utilities Customer Care and Billing, using the Invoice integration point, this DVM is used to populate the appropriate value for the bill charge line type. This bill charge line type is then used within Oracle Utilities Customer Care and Billing to control the behavior of the billable charge.

Common	OU_CCB_01	OU_WAM_01	OU_CCB_SHOW_ON_ BILL
AIA common value: Describes the type of charge line. Must be unique for each DVM row.	Must match values for Bill Charge Line Type.	Must match values for Category in the EXPENSE CODE Business Rule.	This information is used to populate the Description on Bill information for the Billable Charge Upload Staging Line. This is the description of the charge line that appears on the customer’s bill in CC&B.
Note that since MWM is not involved in the Invoice integration point that uses this DVM, the OU_MWM_01 column is not used and should be left blank.

FS_Order_DisconnnectLocationCode

When a service point is disconnected from the supply source, a disconnect location must be specified. This location defines where service was severed.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the disconnect location. Must be unique for each DVM row.	Must match values for Disconnect Location	Must match values for Disconnect Location in Code Table 246.	Must match values for Disconnect Location Code. MWM uses the Disconnect Location Extendable Lookup

FS_Order_DispatchGroup

A dispatch group is a logical group of representatives located at an operations area. When a field activity is created, the system assigns it to a dispatch group based on the type of activity, the type of service point, and the operations area that manages the service point.

Each of the edge applications in use may refer to a dispatch group differently. To account for these differences, create the mapping between the dispatch groups in each application using this DVM.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the dispatch group. Must be unique for each DVM row.	Must match values for Dispatch Group	WAM does not store a Dispatch Group. This column can be blank except for one row where the value is set to the default WAM Dispatch Group as specified in the AIA Configuration Properties. The property is Default.Dispatch.Group for WAM create and update requester.	Must match values for Service Area.

FS_Order_ItemStatusCode

Maps Item Status code from Oracle Utilities Mobile Workforce Management to Oracle Utilities Customer Care and Billing when Oracle Utilities Mobile Workforce Management sends Order Completion to Oracle Utilities Customer Care and Billing with Item information.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the Status. Must be unique for each DVM row.	Must match with valid On-Off Status in CC&B related to Items. The values in CC&B are 0 for OFF and 1 for ON.	Leave blank.	MWM uses the M2_DEVICE_STATUS_FLG Lookup.

FS_Order_ItemStockLocationCode

A stock location is a physical or logical location at which items are stored while they are not installed at a service point. When an item is removed from a service point the stock location must be entered. Each edge application involve may have different codes for the various stock locations.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the item stock location. Must be unique for each DVM row.	Must match values for ‘Stock Location’.	Leave blank.	MWM uses the Stock Location Extendable Lookup

FS_Order_ItemTypeCode

Items are any type of equipment, other than meters. Every item has an item type that defines characteristics common to all items with this type. Each edge application involve may have different codes for the item types.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the item type. Must be unique for each DVM row.	Must match values for Item Type.	Leave blank.	Leave blank.

FS_Order_MeterConfigurationType

Every meter configuration must reference a meter configuration type. Each edge application involve may have different codes for the meter configuration types.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the meter configuration type. Must be unique for each DVM row.	Must match values for Meter Configuration Type.	Must match the CC&B value on the corresponding rows.	MWM uses the Meter Configuration Type Extendable Lookup

FS_Order_MeterStatusCode

Maps the Meter Status code between Oracle Utilities Mobile Workforce Management, Oracle Utilities Work and Asset Management v1.9.1.x and Oracle Utilities Customer Care and Billing when Oracle Utilities Mobile Workforce Management or Oracle Utilities Work and Asset Management v1.9.1.x sends Order Completion to Oracle Utilities Customer Care and Billing with Meter information.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the Status. Must be unique for each DVM row.	Must match valid Meter On-Off Status in CC&B. The values in CC&B are 0 for OFF and 1 for ON.	Must match valid Meter Status in WAM. The values in WAM are 0 for OFF and 1 for ON.	MWM uses the M2_DEVICE_STATUS_FLG Lookup.

FS_Order_MeterStockLocationCode

A stock location is a physical or logical location at which meters are stored while they are not installed at a service point. When a meter is removed from a service point its stock location must be input. Each edge application involve may have different codes for the various stock locations.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the meter stock location. Must be unique for each DVM row.	Must match values for Stock Location	Must match the MWM value on the corresponding rows.	MWM uses the Stock Location Extendable Lookup

FS_Order_MeterTypeCode

Every meter references a meter type. The meter type defines the type of service and common characteristics shared by its meters. Each edge application involved may have different codes for the various meter types.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the meter type. Must be unique for each DVM row.	Must match values for Meter Type	Must match the CC&B value on the corresponding rows.	Must match the CC&B value on the corresponding rows.

FS_Order_OperationsArea

When a service point is set up, the operation areas that manage its fieldwork are defined. Each edge application involved may have different codes for the various operation areas. v1.9.1.x.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01	OU_WAM_05
AIA common value: Describes the operation area. Must be unique for each DVM row.	Must match values for Operation Area	Set to a combination of valid WAM department code and area code. Use the format: <department_code>**<area_code>.	Must match values in the MWM configuration table DHTDIST, column DISTRICT.	Specify a valid WAM account code to be used as the default account for each combination of WAM department and area, to be used on the SR.

FS_Order_ReadTypeCode

Read type indicates who read a meter and how it was read. This information accompanies meter register reading data. Each edge application involved may have different codes for read types.

This DVM is shipped with required values populated. You should not need to change these values.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the read type code. Must be unique for each DVM row.	CC&B values for this column are 60 and 70.	CC&B values for this column are 60 and 70.	CC&B values for this column are 60 and 70.

FS_Order_RegisterReadUnitCode

Register read unit code indicates the units of measure of the register reading. This information accompanies meter register reading data. Each edge application involved may have different codes for units of measure.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the register read unit code. Must be unique for each DVM row.	Specify a list of Unit of measure valid in CC&B.	Must match the CC&B value on the corresponding rows.	MWM uses the Unit Of Measure Extendable Lookup

FS_Order_RegisterTimeOfUseCode

Maps register time of use (TOU) codes between Oracle Utilities Customer Care and Billing, Oracle Utilities Work and Asset Management v1.9.1.x and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the register TOU. Must be unique for each DVM row.	Specify a list Time Of Use Codes valid in CC&B.	Must match the CC&B value on the corresponding rows.	MWM uses the Time Of Use Extendable Lookup

FS_Order_ServicePointTypeCode

Every service point must reference a service point (SP) type. The SP type controls almost all aspects of the service point behavior (for example, the type of field activity that may be dispatched to it, the type of service agreement that may be linked to it, the type of meter that may be installed at it). Each edge application involved may have different codes for SP Type.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the service point type. Must be unique for each DVM row.	Specify a list of Service Point Types valid in CC&B.	Must match values for Asset Type Codes Code Table. The Asset Type codes in this code table that correspond to the CC&B Service Point type codes need to be listed in this DVM.	n/a

FS_Order_Status

Order status indicates the current state or status of the order such as Active, Held, or Finished. Each edge application involved may have different codes for Status.

This DVM is shipped with required values predefined. You should not need to change these values.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01	OU_WAM_01_CANCELED
AIA common value: Describes the order status. Must be unique for each DVM row.	A list of valid CC&B FA Statuses has been specified in this column.	A list of valid WAM SR Statuses has been specified in this column.	A list of valid MWM FO Statuses has been specified in this column.	A list of valid WAM statuses for canceled messages in WAM.

FS_Order_SubStatus

For status updates from Oracle Utilities Work and Asset Management v1.9.1.x to Oracle Utilities Customer Care and Billing, this maps Oracle Utilities Work and Asset Management v1.9.1.x status codes to Oracle Utilities Customer Care and Billing Intermediate Status Codes. For status updates from Oracle Utilities Mobile Workforce Management to Oracle Utilities Customer Care and Billing, this maps Oracle Utilities Mobile Workforce Management Transaction codes to Oracle Utilities Customer Care and Billing Intermediate Statuses.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the intermediate status. Must be unique for each DVM row.	Specify a list of valid CC&B intermediate statuses.	Must match values for WAM service request status and must contain a row with the value CREX in this column with the corresponding CC&B value also specified as CREX.	Specify MWM transaction IDs corresponding to the intermediate status in CC&B. A list of values is shipped for this DVM.

FS_Order_TypeCode

The order type code is used for two important functions:

• Mapping field activity type values, Service Request Type and Problem Code values, and Field Order Type values between the edge applications involved in the integration.

• Determining which applications an order is routed to when it is created.

Column	Description
COMMON	AIA common value: Describes the order type. Must be unique for each DVM row.
OU_CCB_01	Must match values for field activity types
OU_WAM_01	This holds a concatenation of two values: Service Request Type (WAM Code table 240) Problem Code (WAM Code table 241) These are separated by “” for example in the format: <WAM SR Type><WAM Problem Code>.
OU_MWM_01	Must match values for activity types in MWM.
ROUTE_TO_CCB	When this value is set to Y orders of this type are routed to CC&B when they are created by either WAM or MWM. When set to N orders are not routed.
ROUTE_TO_WAM	When this value is set to Y orders of this type are routed to WAM when they are created by either CC&B or MWM.
ROUTE_TO_MWM	When this value is set to Y orders of this type are routed to MWM when they are created by either WAM or CC&B. When set to N orders are not routed.

FS_Order_Worker

This indicates the Representative ID of the person who worked on the Order. This information is used for identifying the exact Crew who worked on any particular Order. This is an optional setup and required only if the crews are not synchronized between the edge applications.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the representative ID. Must be unique for each DVM row.	CC&B Representative ID value	Must match Crew ID	Must match WorkedBy Field

FS_Order_RemarksCode

This indicates the Remarks Codes associated with an Order. Remarks codes are mapped from Oracle Utilities Mobile Workforce Management and/or Oracle Utilities Work and Asset Management v1.9.1.x into Oracle Utilities Customer Care and Billing.

Oracle Utilities Mobile Workforce Management and Oracle Utilities Work and Asset Management v1.9.1.x send a list of codes to Oracle Utilities Customer Care and Billing.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the remarks code. Must be unique for each DVM row.	CC&B Remarks Code value	WAM Remarks code value	MWM Remarks Code value

FS_Order_StepType

This indicates the Step Types associated with an Order sent from Oracle Utilities Customer Care and Billing. Step Types are mapped between Oracle Utilities Customer Care and Billing, Oracle Utilities Mobile Workforce Management and Oracle Utilities Work and Asset Management v1.9.1.x.

This DVM only maps Oracle Utilities Customer Care and Billing Step type to Common Step type. Oracle Utilities Mobile Workforce Management or Oracle Utilities Work and Asset Management v1.9.1.x step types are not mapped. The implementation can customize and use this DVM to map to Oracle Utilities Work and Asset Management v1.9.1.x or Oracle Utilities Mobile Workforce Management step types if needed.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the step type. Must be unique for each DVM row.	CC&B Step Type value	WAM Step Type value	MWM Step Type value

FS_Order _SlotGroup

This indicates the Slot Group associated with an Appointment.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the slot group. Must be unique for each DVM row.	CC&B Slot Group value		MWM Slot Group value

FS_Order_MeterLocationCode

This indicates the Location of a Meter. This DVM is applicable only to Oracle Utilities Customer Care and Billing and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the meter location. Must be unique for each DVM row.	CC&B Meter Location Code value		MWM Meter Location Code value

FS_Order_PriorityCode

This indicates the Priority Code of Orders. This DVM is used to map Priority Codes between Oracle Utilities Customer Care and Billing, Oracle Utilities Work and Asset Management v1.9.1.x and Oracle Utilities Mobile Workforce Management.

Note: In Oracle Utilities Mobile Workforce Management the Priority Code is mapped to the Queue.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the Priority Code. Must be unique for each DVM row.	CC&B Priority Code value	WAM Priority Code value	MWM PriorityCode value

FS_Order_TimeZone

This DVM is used to map Time Zones between Oracle Utilities Customer Care and Billing, Oracle Utilities Work and Asset Management v1.9.1.x and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the Priority Code. Must be unique for each DVM row.	CC&B Time Zone value	WAM Time Zone value	MWM Time Zone value

FS_Country_Code

This DVM is used to map Country Codes between Oracle Utilities Customer Care and Billing, Oracle Utilities Work and Asset Management v1.9.1.x and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the Country Code. Must be unique for each DVM row.	CC&B Country Code value	WAM Country Code value	MWM Country Code value

FS_Language_Code

This DVM is used to map Language Codes between Oracle Utilities Customer Care and Billing, Oracle Utilities Work and Asset Management v1.9.1.x and Oracle Utilities Mobile Workforce Management. Currently the language code is only passed from Oracle Utilities Mobile Workforce Management to Oracle Utilities Customer Care and Billing for Installed Product.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the Language Code. Must be unique for each DVM row.	CC&B Language Code value	WAM Language Code value	MWM Language Code value

FS_Order_TypeCode_UseReadingOnBill

This DVM is used to map the Use on Bill Indicator on a Reading depending on the Order Type. The Use on Bill Indicator can be either true or false.

OU_CCB_ORDER_TYPE_CODE	USE_READING_ON_BILL
CC&B Order Type Code value	Use On Bill Indicator.

FS_Order_ManufacturerCode

This indicates the Manufacturer of a Meter or Item. This DVM is applicable only to Oracle Utilities Customer Care and Billing and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the meter/item manufacturer. Must be unique for each DVM row.	CC&B Meter/Item Manufacturer Code value		MWM uses the Meter/Item Manufacturer Code value stored as extendable lookup

FS_Order_ServiceWarningsCode

This indicates the Service Warnings associated with a Service Point. This DVM is applicable only to Oracle Utilities Customer Care and Billing and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the service warnings code associated with a service point. Must be unique for each DVM row.	CC&B Service Warnings Code value		MWM uses the Service Warnings Code value stored as an extendable lookup

FS_Order_ServiceInstructionsCode

This indicates the Service Instructions associated with a Service Point. This DVM is applicable only to Oracle Utilities Customer Care and Billing and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the service instructions code associated with a service point. Must be unique for each DVM row.	CC&B Service Instructions Code value		MWM uses the Service Instructions Code value stored as an extendable lookup

FS_Order_PremiseTypeCode

This indicates the Premise Type. This DVM is applicable only to Oracle Utilities Customer Care and Billing and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the premise type code.	CC&B Premise Type Code value		MWM uses the Premise Type Code value stored as the M2-PremiseType extendable lookup

FS_Order_ServiceTypeCode

This indicates the Service Type. This DVM is applicable only to Oracle Utilities Customer Care and Billing and Oracle Utilities Mobile Workforce Management.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the Service Type code.	CC&B Service Type Code value		MWM Service Point Type Code value stored as extendable lookup M2-ServicePointType

FS_BO

This indicates the business object mapping information. This DVM is applicable only between Oracle Utilities Customer Care and Billing, Oracle Utilities Mobile Workforce Management and Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management v2.1.x.

MWM_BO	CCB_BO	WAM_BO
MWM business object names	CCB business object names	WAM/ODM business object names

FS_MO

This indicates the maintenance object mapping information. This DVM is applicable only between Oracle Utilities Customer Care and Billing, and Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management v2.1.x.

CCB_MO	ODM_MO
CCB maintenance object names	WAM/ODM maintenance object names

Note: FS_MO and FS_BO are used to map attachment business objects and maintenance objects between Oracle Utilities Customer Care and Billing, Oracle Utilities Mobile Workforce Management and/or Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management.

FS_ErrorCodes

This indicates the error codes mapping information. This DVM is applicable only between Oracle Utilities Customer Care and Billing and Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management v2.1.x.

WAM_ErrorCode	CCB_ErrorCode
WAM message category and message number combination codes	CCB message category and message number combination codes

FS_SPNodeType

This indicates the service point mapping information. This DVM is applicable only between Oracle Utilities Customer Care and Billing and Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management v2.1.x.

CCB_NodeType	ODM_SPType
CCB SP type information	WAM/ODM SP type information

FS_NodeDisposition

This indicates the service point disposition mapping information. This DVM is applicable only between Oracle Utilities Customer Care and Billing and Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management v2.1.x.

CCB_NodeDisposition	ODM_NodeDisposition
CCB node disposition information	WAM/ODM SP node disposition information

FS_Order_ RegisterSeqCode

This indicates the register sequence mapping information across applications.

Common	OU_CCB_01	OU_WAM_01	OU_MWM_01
AIA common value: Describes the Register sequence	CC&B Register sequence values	WAM Register sequence values	MWM Register sequence values

FS_OkToEnterCode

This indicates the service point ok to enter or not ok mapping information. This DVM is applicable only between Oracle Utilities Customer Care and Billing and Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management v2.1.x.

CCB_OkToEnterCode	ODM_OkToEnterCode
true	W2YS
false	W2NO

FS_LifeSupportSensitiveLoad

This indicates the service point life support mapping information. This DVM is applicable only between Oracle Utilities Customer Care and Billing and Oracle Utilities Work and Asset Management/Oracle Utilities Operational Device Management v2.1.x.

CCB_LifeSupportSensitiveLoad	ODM_LifeSupportSensitiveLoad
Y	W2LS
N	W2NO

Cross-References

Cross-references map and connect the records within the application network, and enable these applications to communicate in the same language. The integration server stores the relationship in a persistent way so that others can refer to it.

These are the cross-references for the integration layer:

Note: During implementation you do not need to do anything with this table. This table is populated by the integration processes as orders are created.

XREFTABLENAME	COLUMN NAME	DESCR	USAGE
FS_ORDER_ID	OU_CCB_01	CC&B FA ID	Populated by work order create business flow for orders that involve CC&B
	COMMON		Populated by work order create business flow
	OU_MWM_01	MWM FO ID	Populated by work order create business flow for orders that involve MWM
	OU_WAM_01	WAM SR ID	Populated by work order create business flow for orders that involve WAM
	ROUTED_TO_CCB		Populated by work order create business flow for orders that are routed to CC&B
	ROUTED_TO_WAM		Populated by work order create business flow for orders that are routed to WAM
	ROUTED_TO_MWM		Populated by work order create business flow for orders that are routed to MWM

For more information about cross-references, refer to the Oracle Fusion Middleware Developer's Guide for Oracle SOA Core Extension under "Understanding Message Transformation, Enrichment, and Configuration" and “Creating Cross-References."

Updating MDS with AIA Meta Data

You must upload artifacts to MDS if any of the following occurs:

• New artifacts are created

• Extensions or customizations are made on artifacts

• DVM changes are made in AIAMetaData

• AIAConfigurationProperties.xml is changed

Oracle MDS repository contains all metadata. The contents under <AIA_HOME>/AIAMetaData are uploaded to SOA-MDS > apps/AIAMetaData. This includes specific schemas, WSDLS, DVMs, Cross Reference metada, default faultPolicies, AIAConfigurationProperties.xml and AIAEHNotification.xml

For more information about updating MDS, see Oracle Application Integration Architecture – Foundation Pack: Integration Developers Guide, “Updating MDS.”

You may need to bounce the SOA managed server to activate the changes uploaded to the MDS.

Update Configuration Properties

There are two steps to update the configuration:

• Download the configuration properties file from MDS using GetFieldWorkConfigFileDP.xml

Linux:

ant -f $SOA_HOME/aiafp/Install/AID/AIAInstallDriver.xml - DDeploymentPlan=$AIA_HOME/pips/FieldWork/DeploymentPlans/ GetFieldWorkConfigFileDP.xml -DPropertiesFile=$DOMAIN_LOCATION/soa/aia/bin/ AIAInstallProperties.xml

Windows:

ant -f %SOA_HOME%\aiafp\Install\AID\AIAInstallDriver.xml - DDeploymentPlan=%AIA_HOME%\pips\FieldWork\DeploymentPlans\GetFieldWo rkConfigFileDP.xml -DPropertiesFile=%DOMAIN_LOCATION%\soa\aia\bin\AIAInstallProperties.xml

It will prompt for user name and password. Pass the details.

• Edit the downloaded file in $AIA_HOME/config folder and make the changes that needs to updated and run the UpdateFieldWorkConfigFileDP.xml utility provided.

Linux:

ant -f $SOA_HOME/aiafp/Install/AID/AIAInstallDriver.xml - DDeploymentPlan=$AIA_HOME/pips/FieldWork/DeploymentPlans/ UpdateFieldWorkConfigFileDP.xml -DPropertiesFile=$DOMAIN_LOCATION/soa/aia/bin/ AIAInstallProperties.xml

Windows:

ant -f %SOA_HOME%\aiafp\Install\AID\AIAInstallDriver.xml - DDeploymentPlan=%AIA_HOME%\pips\FieldWork\DeploymentPlans\UpdateField WorkConfigFileDP.xml -DPropertiesFile=%DOMAIN_LOCATION%\soa\aia\bin\AIAInstallProperties.xml

Deploying Individual Composites/Undeploying Composites and Updating MDS

FieldWorkCustomDP.xml utility is provided for this purpose. Edit the file. Add as per the comments in the file and run the command accordingly.

Linux:

ant -f $SOA_HOME/aiafp/Install/AID/AIAInstallDriver.xml - DDeploymentPlan=$AIA_HOME/pips/FieldWork/DeploymentPlans/ FieldWorkCustomDP.xml -DPropertiesFile=$DOMAIN_LOCATION/soa/aia/bin/ AIAInstallProperties.xml

Windows:

ant -f %SOA_HOME%\aiafp\Install\AID\AIAInstallDriver.xml - DDeploymentPlan=%AIA_HOME%\pips\FieldWork\DeploymentPlans\FieldWorkC ustomDP.xml -DPropertiesFile=%DOMAIN_LOCATION%\soa\aia\bin\AIAInstallProperties.xml

It will prompt for user name and password. Provide these details.

Update MDS with AIAMetaData

Update the appropriate WSDL/DVM files in AIAMetData under $AIA_HOME. SOA Core Extensions for 12.2.1 provides UpdateMetaDataDP.xml utility for updating MDS.

• Source the file aiaenv.sh (located at Middleware Home/user_projects/domains/soa_domain/soa/aia/bin) by executing the following command:

source aiaenv.sh

• Browse to the folder at $DOMAIN_LOCATION/soa/aia/MDSUtils/UpdateMetaDataDP.xml and open the deployment plan file, UpdateMetaDataDP.xml.

• Update the file UpdateMetaDataDP.xml by inserting include tags for each resource group that you want to add to the MDS:

Example to update DVM:

</fileset>

Example to update wsdl file:

• Run the update utility.

Linux:

ant -f $SOA_HOME/aiafp/Install/AID/AIAInstallDriver.xml - DDeploymentPlan=$DOMAIN_LOCATION/soa/aia/MDSUtils/ UpdateMetaDataDP.xml -DPropertiesFile=$DOMAIN_LOCATION/soa/aia/bin/ AIAInstallProperties.xml

Windows:

ant -f %SOA_HOME%\aiafp\Install\AID\AIAInstallDriver.xml - DDeploymentPlan=

%DOMAIN_LOCATION%\soa\aia\MDSUtils\UpdateMetaDataDP.xml -DPropertiesFile=%DOMAIN_LOCATION%\soa\aia\bin\AIAInstallProperties.xml

It will prompt for user name and password. Provide these details.

Error Notification Setup

Based on the roles defined for the services, email notifications are sent if a service errors out.

For more information about error handling and error notifications, refer to the Configuring Oracle AIA Processes for Error Handling and Trace Logging section in the Oracle Fusion Middleware Developer's Guide for Oracle SOA Core Extension.

SOA Infrastructure Common Properties

Payload Validation property defined in SOA Infrastructure should be turned off.

This property is defined on SOA level under Common Properties and can be overridden for each process.

Make sure your implementation always has Payload Validation disabled.