Integration Flows
The integration scope supports the following processes:
• OU WACS ERPFA Assets FTP Extract Process (Oracle Utilities Work and Asset Cloud Service initiated)
• OU WACS ERPFA Fixed Asset Addition Process (Oracle Utilities Work and Asset Cloud Service initiated)
OU WACS ERPFA Assets OS Extract Process (Oracle Utilities Work and Asset Cloud Service Initiated)
This scheduled integration process polls all the Asset Extract files from Oracle Utilities Work and Asset Cloud Service Object Storage (OS) and routes the asset records to the respective addition, adjustment, and retirement integration process based on the action. This process serves as the main/master flow that initiates the Oracle Utilities Work and Asset Cloud Service integration to Oracle Assets when Oracle Utilities Work and Asset Management/Oracle Utilities Work and Asset Cloud Service is on cloud.
The following diagram shows a graphical representation of the OU WACS ERPFA Assets OS Extract integration process.
Processing Details
This is an asynchronous scheduled integration process deployed on Oracle Integration Cloud and does the following activities:
1. This process is triggered by a schedule.
a. Define the integration schedule for this process and make sure the W1-ERPFA job schedule in Oracle Utilities Work and Asset Cloud Service is always run first, so that the file is available to be processed by the integration.
b. A couple of the default values used in this integration are defined in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS Oracle Integration Cloud lookup. Make sure to define the properties needed for this integration.
2. Invoke the Object Storage ListObjects REST API to get the list of files in a particular bucket where the Asset Extract files are stored. The bucket name is obtained from the os.bucketname property value. Only files that start with the string entered in the extract.filename.prefix property value are listed.
Note: The value extract.filename.prefix should match with the prefix of the fileName parameter value of the batch job W1-ERPFA in Oracle Utilities Work and Asset Cloud Service.
3. If no files are found, throw a fault and invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) integration flow.
4. Repeat the following steps for each file to process:
a. Invoke the Object Storage: Gets Object REST API to get the actual file to process.
b. Check if the file is zipped. If yes, unzip the file and extract the CSV file.
c. Read the CSV file and collect all file level records.
d. Once all records are added to the collection, invoke the RenameObject REST API Object Storage to rename the file.
• If any file processing errors out, then rename the file that was just processed in Object Storage by adding the prefix “Error” to the filename. The prefix can be configured at “extract.prefixtag.filenotuploaded” property in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS lookup.
• Else, rename the file by adding the prefix “Sent” or “Uploaded” to the filename. The prefix can be configured at “extract.prefixtag.fileuploaded” property in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS lookup.
5. Group all asset records by Asset Action.
6. For each Asset Action group, repeat the following process:
• If the Asset Action group is A, invoke the OU WACS ERPFA Asset Addition Process (Oracle Utilities Work and Asset Cloud Service Initiated) integration flow and pass addition records.
• If the Asset Action group is C, invoke the OU WACS ERPFA Asset Adjustment Process (Oracle Utilities Work and Asset Cloud Service initiated) integration flow and pass adjustment records.
• If the Asset Action group is R, invoke the OU WACS ERPFA Asset Retirement Process (Oracle Utilities Work and Asset Cloud Service initiated) integration flow and pass retirement records.
7. Each scope of the integration flow has fault handler to capture the errors if any and appends the error data to error record collection.
8. If the error record collection has any data, invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) integration flow to send an optional email notification.
Refer to the Error Handling section in Configuring Lookups, Error Handling, and Email Notifications for information on error scenarios and retry options.
Technical Details
The following table describes the integration processes and the respective artifacts used in this integration process.
Artifacts | Value |
|---|---|
Integration Process Name | OU WACS ERPFA Assets OS Extract |
Integration Package Name | outl.ba.wacs_erpfa.01_23_2000 |
REST Adapter | Oracle Utilities REST WACS Object Storage for WACS- ERPFA connection to retrieve asset extract file from WACS Object Storage for WACS-ERPFA |
REST Adapter | OU REST Trigger for WACS-ERPFA connection invoke the following integration flows: • OU WACS ERPFA Asset Addition integration endpoint • OU WACS ERPFA Asset Adjustment integration endpoint • OU WACS ERPFA Asset Retirement integration endpoint |
OU WACS ERPFA Assets FTP Extract Process (Oracle Utilities Work and Asset Cloud Service initiated)
This scheduled integration process polls all the Asset Extract files from the Oracle Utilities Work and Asset Cloud Service FTP server and routes the asset records to the respective addition, adjustment, and retirement integration process based on the action. This process serves as the main/master flow that initiates the integration.
The following diagram shows a graphical representation of the OU WACS ERPFA Assets FTP Extract integration process.
Processing Details
The integration process is a scheduled orchestrator deployed on Oracle Integration Cloud and performs the following activities:
1. This process is triggered by a schedule.
a. Define the integration schedule for this process and make sure the W1-ERPFA job schedule in Oracle Utilities Work and Asset Cloud Service is always run first, so that the file is available to be processed by the integration.
b. A couple of the default values used in this integration are defined in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS Oracle Integration Cloud lookup. Make sure to define the properties needed for this integration.
2. It invokes the List Files operation to get the list of files from FTP server where the Asset Extract files are stored. The FTP location is obtained from the extract.ftp.input.directory property value. Only files that start with the string entered in the property value extract.filename.prefix are selected.
Note: The value extract.filename.prefix should match the beginning of the parameter filename in the W1-ERPFA job in Oracle Utilities Work and Asset Cloud Service.
3. If no files are found, throw a fault, and invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) integration flow.
4. Repeat the following steps for each file to process:
a. Download the asset extract file.
b. Check if the file is zipped. If yes, unzip the file and extract the CSV file.
c. Read the CSV file and and collect all file level records.
d. Once all records are added to the collection, invoke the RenameObject REST API Object Storage to rename the file.
• If any file processing errors out, then rename the file that was just processed in Object Storage by adding the prefix “Error” to the filename. The prefix can be configured at “extract.prefixtag.filenotuploaded” property in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS lookup.
• Else, rename the file by adding the prefix "Sent" or "Uploaded" to the filename. The prefix can be configured at "extract.prefixtag.fileuploaded" property in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS lookup.
5. Group all asset records by Asset Action.
6. For each Asset Action group, repeat the following process:
a. Invoke the respective child integration process based on the asset action group.
• If the asset action group is A, invoke the OU WACS ERPFA Asset Addition integration flow and pass addition records.
• If the asset action group is C, invoke the OU WACS ERPFA Asset Adjustment integration flow and pass adjustment records.
• If the asset action group is R, invoke the OU WACS ERPFA Asset Retirement integration flow and pass retirement records.
7. Each scope of the integration flow has fault handler to capture the errors if any and appends the error data to error record collection.
8. If the error record collection has any data, invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) integration flow to send an optional email notification.
Refer to the Error Handling section in Configuring Lookups, Error Handling, and Email Notifications for information on error scenarios and retry options.
Technical Details
The following table describes the integration processes and the respective artifacts used in this integration process.
Artifacts | Value |
|---|---|
Integration Process Name | OU WACS ERPFA Assets FTP Extract |
Integration Package Name | outl.ba.wacs_erpfa.01_23_2000 |
FTP Adapter | OU FTP WACS FTP for WACS-ERPFA connection to retrieve asset extract file from WACS FTP server for WACS-ERPFA |
REST Adapter | OU REST Trigger for WACS-ERPFA connection invokes the following integration flows: • OU WACS ERPFA Asset Addition integration endpoint • OU WACS ERPFA Asset Adjustment integration endpoint • OU WACS ERPFA Asset Retirement integration endpoint |
OU WACS ERPFA Asset Addition Process (Oracle Utilities Work and Asset Cloud Service Initiated)
The integration process gets the asset addition records from the OU WACS ERPFA Assets OS Extract Process (Oracle Utilities Work and Asset Cloud Service Initiated) or OU WACS ERPFA Assets FTP Extract Process (Oracle Utilities Work and Asset Cloud Service initiated) integration flow.
The following diagram shows a graphical representation of the OU WACS ERPFA Asset Addition integration process. 
Processing Details
The integration process is an application driven orchestrator deployed on Oracle Integration Cloud. It performs the following activities:
1. The process is triggered when the Asset Extract master flow is triggered and if there are any addition records.
2. A group of Asset addition records will be passed to the OU WACS ERPFA Asset Addition Oracle Integration Cloud flow.
3. Repeat the step for each asset addition record.
a. If the badge number is not more than 15 characters length, then check:
a. If the Customer Contributed Flag is No and Parent ERP Reference Number or ERP Reference Number is present and the projects.implemented flag defined in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS lookup is Yes, append the asset record to the Project Asset record collection.
b. Else, append asset records to the Fixed Asset record collection.
b. Else, append asset record to the error collection.
4. If the project asset record count > 0, invoke the OU WACS ERPFA Asset Addition Process (Oracle Utilities Work and Asset Cloud Service Initiated) flow.
5. If the fixed asset record count > 0, invoke the OU WACS ERPFA Fixed Asset Addition Process (Oracle Utilities Work and Asset Cloud Service initiated) flow.
6. Each scope of the integration flow has fault handler to capture the errors if any and appends the error data to error record collection.
7. If the error record count is more than zero, invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) integration to send an optional email notification.
Refer to Configuring Lookups, Error Handling, and Email Notifications for error handling information on error scenarios and retry options.
Technical Details
The following table describes the integration process and the respective artifacts used in this integration process.
Artifacts | Value |
|---|---|
Integration Process Name | OU WACS ERPFA Asset Addition |
Integration Package Name | outl.ba.wacs_erpfa.01_23_2000 |
REST Adapter (trigger) | OU REST Trigger for WACS-ERPFA connection to initiate the flow |
REST Adapter | OU REST Trigger for WACS-ERPFA connection to invoke the following integrations: • OU WACS ERPFA Fixed Asset Addition integration endpoint • OU WACS ERPFA Project Asset Addition integration endpoint |
OU WACS ERPFA Fixed Asset Addition Process (Oracle Utilities Work and Asset Cloud Service initiated)
The integration process gets only the fixed asset addition records from the OU WACS ERPFA Asset Addition Process (Oracle Utilities Work and Asset Cloud Service Initiated) integration flow.
The following diagram shows a graphical representation of the OU WACS ERPFA Fixed Asset Addition integration process.
Processing Details
This integration is an application driven orchestrator deployed on Oracle Integration Cloud. It performs the following steps:
The process is invoked when asset extract file sent by Oracle Utilities Work and Asset Cloud Service has any fixed asset addition records:
1. The process receives a collection of fixed asset addition records.
2. Group the asset records based on the asset book (owning access group).
3. Repeat the process for each asset book:
a. Repeat the process for each asset:
a. If Asset Tax Jurisdiction is null, add the asset record to error record collection.
b. Generate the FA Mass Additions CSV file.
c. Generate the FA Mass Addition Distributions CSV file.
d. Generate the FA Mass Addition ZIP file.
e. Invoke Post Mass Additions FBDI with post status NEW and queue name NEW. This executes the following schedule processes in Oracle Fusion Cloud ERP:
a. Load the interface file for import.
b. Load the file to interface.
c. Transfer the file.
d. Prepare the Assets Transaction Data.
f. Wait for the Load Interface file to import job execution and retrieve the status
g. If the job status is success, invoke the Prepare Assets Transaction Data scheduled process with ERP cloud adapter query service option.
h. Else, display an error with the error response received from FBDI call with the list of jobs executed with the respective job status.
i. Wait for the Prepare Assets Transaction Data job execution and retrieve the status.
j. If the job status is success, invoke the PostMassAdditions scheduled process with ERP SOAP Service.
k. Else, display an error with the error response received from FBDI call with the list of jobs executed with the respective job status.
l. If the PostMassAdditions job status is successful, send email notification with the Job Id. Else, throw FBDI fault.
4. Each scope of the integration flow has fault handler to capture the errors if any and appends the error data to error record collection.
5. Check for the error record count. If there are any error records, invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) integration flow to send an optional email notification.
Refer to Configuring Lookups, Error Handling, and Email Notifications for error handling information on error scenarios and retry options.
Technical Details
The following table describes the integration processes and the respective artifacts used in this integration process.
Artifacts | Value |
|---|---|
Integration Process Name | OU WACS ERPFA Fixed Asset Addition |
Integration Package Name | outl.ba.wacs_erpfa.01_23_2000 |
REST Adapter | OU REST Trigger for WACS-ERPFA connection to initiate the integration flow |
ERP Adapter | OU ERP FA Cloud for WACS-ERPFA connection to invoke Post Mass Additions FBDI |
ERP REST Adapter | OU REST ERP FA for WACS-ERPFA connection to invoke ERP REST API to retrieve the job status |
SOAP Adapter | OU SOAP ERP FA for WACS-ERPFA to invoke post mass addition via ERP integration soap service |
OU WACS ERPFA Project Asset Addition Process (Oracle Utilities Work and Asset Cloud Service initiated)
This integration process receives additional records of project assets from the OU WACS ERPFA Asset Addition Process (Oracle Utilities Work and Asset Cloud Service Initiated) Oracle Integration Cloud flow.
The following diagram shows a graphical representation of the OU WACS ERPFA Project Asset Addition integration process.
Processing Details
This integration is an application driven orchestrator flow deployed on Oracle Integration Cloud. It performs the following activities.
The process is invoked when the asset extract file sent from Oracle Utilities Work and Asset Cloud Service has any addition records of project assets.
1. The process receives a collection of project asset addition records.
2. Repeat the process for each project asset addition record.
a. Generate the asset CSV file.
b. Generate the asset assignment CSV file.
3. Generate the import assets and assignments FBDI properties file.
4. Generate the import assets and assignments FBDI ZIP file.
5. Invoke the ERP Import Assets and Assignments Process FBDI file.
6. Send an email with the executed job details.
7. Each scope of the integration flow has fault handler to capture the errors if any and appends the error data to error record collection.
8. If there are any errors and the error record count is greater than zero, invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) flow to send an optional email notification with the error details.
Refer to Configuring Lookups, Error Handling, and Email Notifications for error handling information on error scenarios and retry options.
Technical Details
The following table describes the integration process and the respective artifacts used in this integration process.
Artifacts | Value |
|---|---|
Integration Process Name | OU WACS ERPFA Project Asset Addition |
Integration Package Name | outl.ba.wacs_erpfa.01_23_2000 |
ERP Adapter | OU ERP FA Cloud for WACS-ERPFA connection to invoke Import Asset and Assignment FBDI |
REST Adapter | OU REST Trigger for WACS-ERPFA connection to initiate the flow |
OU WACS ERPFA Asset Adjustment Process (Oracle Utilities Work and Asset Cloud Service initiated)
This application driven integration process gets a collection of asset adjustment records from the OU WACS ERPFA Assets OS Extract Process (Oracle Utilities Work and Asset Cloud Service Initiated) or OU WACS ERPFA Assets FTP Extract Process (Oracle Utilities Work and Asset Cloud Service initiated) flow.
The following diagram shows a graphical representation of the OU WACS ERPFA Asset Adjustment integration process.
Processing Details
This integration process is an application driven orchestrator deployed on Oracle Integration Cloud. It is initiated when the asset extract file sent by Oracle Utilities Work and Asset Cloud Service has asset adjustment records.
The process is executed as follows:
1. The process receives a collection of asset adjustment records.
2. Repeat the process for each asset adjustment record.
a. If the asset badge number is not more than 15 characters length, then check:
a. If the Customer Contributed Flag is No and Parent ERP Reference Number or ERP Reference Number is present and projects.implemented flag defined in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS lookup is Yes, append asset record to the Project Asset record collection.
b. Else, append asset records to the Fixed Asset record collection.
b. Else, append the asset record to the Fixed Asset record set.
3. If project asset record set has any data, repeat the process for each project asset record:
a. Check if the project asset exists in ERP. If it exists, add this record to fixed asset record set.
b. Else, add this to asset not available in ERP record set.
4. If the asset not available record set has any data, invoke the OU WACS ERPFA Project Asset Addition Process (Oracle Utilities Work and Asset Cloud Service initiated) integration flow to create the project asset in ERP.
5. If the fixed asset record set has any data:
a. Group the asset records by asset book/owning access group.
b. Repeat the process for each asset book.
a. Group the asset data by fixed asset number and repeat the process for each asset record in this group.
• If the quantity is not null and not zero, create the FA mass transfer CSV file.
• If cost is not null and not zero:
• Assign a cost flag to indicate that asset records have cost adjustment.
• Get the current ERP cost of the asset from BI Report.
• Generate the FA mass adjustment CSV file with calculated cost.
b. For each asset record in the asset book group, repeat the following process:
• If the quantity is not null and not zero:
• Get the fixed asset details from ERP.
• Extract the expense account value from BI Report.
• Using the expense account ID, retrieve the expense account segments from ERP.
• Generate the ERP FA mass transfer distribution CSV file.
• Assign a unit flag to indicate the asset records have unit adjustments.
c. If Asset record has cost and quantity as zero, collect the asset records and send an email notification with asset ID or fixed asset number.
d. If the cost flag is enabled:
• Generate the FA mass adjustment properties file.
• Generate the FA mass adjustment ZIP file with FA mass adjustment properties file and FA mass adjustment CSV file.
• Invoke the ERP FA mass adjustments import FBDI.
• Send the email notification with job details.
e. If the unit flag is enabled:
• Generate the FA mass transfer properties file.
• Generate the FA mass transfer ZIP file with FA mass transfer properties file, FA mass transfer CSV file, and FA mass transfer distribution CSV file.
• Invoke the ERP FA mass transfer import FBDI.
• Send the email notification with Job details.
6. Each scope of the integration flow has fault handler to capture the errors if any and appends the error data to error record collection.
7. If the error record collection has any data, invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) flow to send an optional email notification.
Refer to Configuring Lookups, Error Handling, and Email Notifications for error handling information on error scenarios and retry options.
Technical Details
The following table describes the integration process and the respective artifacts used in this integration process.
Artifacts | Value |
|---|---|
Integration Process Name | OU WACS ERPFA Asset Adjustment |
Integration Package Name | outl.ba.wacs_erpfa.01_23_2000 |
REST Adapter (trigger) | OU REST Trigger for WACS-ERPFA connection to initiate the flow |
ERP Adapter | OU ERP FA Cloud for WACS-ERPFA connection to invokes: • Fixed Assets Mass Adjustment Import FBDI • Fixed Assets Mass Transfer Import FBDI |
SOAP Adapter | OU BI ERP FA for WACS-ERPFA connection to invoke ERP BI report soap service |
OU WACS ERPFA Asset Retirement Process (Oracle Utilities Work and Asset Cloud Service initiated)
This application driven integration process gets a collection of asset retirement records from master extract flow.
The following diagram shows a graphical representation of the OU WACS ERPFA Asset Retirement integration process.
Processing Details
This is an application driven orchestration process deployed on Oracle Integration Cloud. The process is initiated when the asset extract file from Oracle Utilities Work and Asset Cloud Service has any asset retirement record.
The flow is executed as follows:
1. The process gets a collection of asset retirement records.
2. Group the asset data by asset book.
3. For each asset book group, repeat the following process:
a. For each asset record of this asset book group:
a. If the asset badge number is not more than 15 characters:
a. Invoke BI report to get the current cost of the asset from ERP.
b. Generate the retirement CSV file.
c. Else, display fault and add asset record it to the error collection. Skip this asset record.
b. If there are no errors:
a. Generate the FA mass retirement properties file.
b. Generate mass retirement ZIP file with mass retirement CSV and properties files.
c. Invoke ERP FA Mass Retirement FBDI.
d. Send the email notification with job details.
4. Each scope of the integration flow has fault handler to capture the errors if any and appends the error data to error record collection.
5. If the error record collection has any data, invoke the OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated) flow to send an optional email notification.
Refer to Configuring Lookups, Error Handling, and Email Notifications for error handling information on error scenarios and retry options.
Technical Details
The following table describes the integration process and the respective artifacts used in this integration process.
Artifacts | Value |
|---|---|
Integration Process Name | OU WACS ERPFA Asset Retirement |
Integration Package Name | outl.ba.wacs_erpfa.01_23_2000 |
ERP Adapter | OU ERP FA Cloud for WACS-ERPFA connection to invoke Fixed Assets Mass Retirements Import FBDI |
ERP REST Adapter | OU REST ERP FA for WACS-ERPFA connection to invoke ERP REST API to retrieve the Asset cost |
REST Adapter | OU REST Trigger for WACS-ERPFA connection to initiate the flow |
SOAP Adapter | OU BI ERP FA for WACS-ERPFA connection to invoke ERP BI report SOAP service |
OU WACS ERPFA Common Error Handler Process (Oracle Integration Cloud Initiated)
This application driven integration gets a collection of error records from the other integration processes the integration.
The following diagram shows a graphical representation of the OU WACS ERPFA Common Error Handler integration process.
Processing Details
This integration process is an application driven orchestrator deployed on Oracle Integration Cloud. It is initiated when the other integration process throws an error. It is executed as follows:
1. The process gets a collection of error records.
2. For each error record, repeat the following steps:
a. If the error record has any attachment, enable attachment flag.
3. If the notification.error.flag in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS Oracle Integration Cloud lookup is set to 'true'.
a. If the notification.type.email property in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS Oracle Integration Cloud lookup is set to 'email':
a. Invoke the 'GenerateTableData' library function to generate the error data in a tabular format.
b. If the attachment count is zero, send an email notification with the error data.
c. Else, send an email notification with the attachment.
Refer to Configuring Lookups, Error Handling, and Email Notifications for error handling information on error scenarios and retry options.
Technical Details
The following table describes the integration process and the respective artifacts used in this integration process.
Artifacts | Value |
|---|---|
Integration Process Name | OU WACS ERPFA Common Error Handler |
Integration Package Name | outl.ba.wacs_erpfa.01_23_2000 |
REST Adapter | OU REST Trigger for WACS-ERPFA connection to initiate the flow |