Configuring Fixed Assets

Fixed asset integration ensures project and non-project related activities that are created, adjusted, or retired in Work and Asset Cloud Service (WACS) are able to be synchronized to Oracle Fusion ERP Cloud (project-based assets) and Oracle Fusion Fixed Assets Cloud (non-project assets).

About Fixed Asset Extract

In the Work and Asset Cloud application, Construction Work Activities (CWAs) are used to create project and non-project (customer contributed, gifted, or found) related assets. When assets are tracked using capital projects, the cost of the capital assets are tracked within the capital project before being transferred to Oracle Fusion Fixed Assets. The WACS process uses a single flat file (WACS Assets Extract) to perform the transfer to the external application.
  • For Project capital assets, once the asset is created and recorded in WACS the record is sent to ERP to create a project capital asset and corresponing asset assignment.
  • For Non-Project assets, once the asset is created and recorded in WACS the record is sent to ERP to create the fixed asset and distribution requirements.
  • When adding and retiring Project or Non-Project rolling fiscal assets such as conductors and poles, WACS creates an adjustment and the record is sent to ERP. In ERP, these types of assets are tracked as a single fixed asset however, cost and unit adjustments are created for the fixed asset.
  • For Capital Spare (Inventory) Assets, once installed in WACS, the record is sent to ERP as a cost adjustment record associated with an already present fixed asset in ERP. The cost adjustment adds the installation cost to the total cost of the fixed asset.
  • For Retired Assets, once an asset is retired in WACS, the retirement record is sent to ERP which directly retires the asset in the Fixed Assets table.
Oracle Fusion ERP holding project assets will have a corresponding WACS project. The WACS Project will have an External ID populated as ERP Project Number. The ERP Project Tasks will be mapped to the subproject in WACS and the WACS subproject will have an External ID populated as an ERP Task Number. WACS activities will be linked to their related subprojects.

Configuring the integration for fixed assets involve the following:

Master Configuration

This section describes how to configure the Work Management Master Configuration to synchronize fixed assets between the applications.

To access the Master Configuration portal, select Admin, select General, and select Master Configuration.

Select the Work Management master configuration and scroll to the Construction Work Management zone.

  • To enable synchronization of fixed assets, manually set the Oracle Asset Integration parameter to Yes. If Yes, then other rules are applied to individual business objects to accomplish the synchronization of the fixed assets.
    Note: Default setting is set to No. The system also considers the setting to be No if the parameter is left blank.
  • If Oracle Asset Integration parameter is set to Yes then also define the Fixed Asset Extract Batch Code to send the fixed assets to the external system. Batch control W1-ERPFA is already provided to assist in this process and completes the following:
    • Sends fixed assets to the external system
    • Adds retired fixed asset entries to the general process table
    • Adds an accept or return line entry to the general ledger for fixed assets
    • Adds a cancel line entry to the general ledger for a stock item that is a capital spare

Fixed Asset Rules

This section describes various rules that must be configured once the Oracle Asset Integration parameter is set to Yes.
  • Expense Code For Customer Contributed Fixed Asset is Required
  • Property Unit is required if Fixed Asset Number is specified.
  • Fixed Asset Number is not allowed if the Reconciliation Stock Item is a Capital Spare.
  • Owning Organization is required when the Property Unit is populated and Asset Type is not populated. Also, Owning Organization is requred when creating an asset from the Construction Location tab of the CWA. Owning Organization cannot be updated.
  • Compatible Units (CU) can be added to design elements, template construction work activities, and construction locations and MUST include a Usage Code and Cost Center. Also, if construction locations for the same activity have the same CU, the Cost Center for the CUs must also match. The same Fixed Asset Number on CUs cannot have a different Property Unit as they create a unique combination on the CU).
  • Set up a file integration type for a fixed asset. See the example below:
    • Description: Fixed Asset Extract
    • Class: Extract (existing lookup value)
    • Category: fixed asset, this is a new value to lookup
    • File Integration Records:
      • Sequence: 10
      • Record Type: W1-FixedAssetExtract
      • Description: Fixed Asset Extract
      • Data Area: Fixed Asset Extract Data Area
      • Extract Algorithms
        • Sequence: 10
        • Algorithm: the Fixed Asset Extract Algorithm
  • Ensure Fixed Asset Extract Data Area includes the following data to be extracted and used by the file integration type created in the previous step:
    • Actions: A for addition; R for retirement, and C for change or adjustment
    • Asset ID (WAM Asset ID)
    • Fixed Asset Number
    • Asset Description
    • Badge Number
    • Serial Number
    • Manufacturer
    • Model
    • Owning Organization
    • Property Unit
    • Customer Contributed Flag
    • Account Segment 1 though 10
    • Quantity
    • Cost
    • Project ID (WAM Project ID)
    • ERP Project Number
    • Parent Project ID
    • Parent ERP Project Number
    • Activity ID (CWA ID)
    • Work Order ID
    • Work Order Number
    • In Service Date
    • Retirement Date
    • Transaction Date
    • GEN_​PROC_​ID
    • MAINT_​OBJ_​CD
    • PK_​VALUE1
Additional rules to consider for applying Direct Overhead and Indirect Overhead cost to fixed assets:
  • Set the appropriate percentages to work with your ERP Project and Fixed Asset process on the Overhead portal (Click Admin, click O, and click Overhead). For example, if all such cost is applied in ERP, you can set the percentages to zero in WAM or elect not to reference any Overhead on the Construction Work Order or Activity.
  • Administrative and design cost related to construction work is tracked in WAM as a separate Overhead activity and is considered a Direct Cost. This activity is included in the same work order as the construction work activity and the cost is transferred from the Overhead activity to the construction work activity when the construction work activity is closed. For this type of activity, only charge appropriate cost, as part of your business process, or don't allow this type of activity at all.
  • Both Direct and Indirect overhead cost is applied to a construction work activity when it's closed. Cost is applied by an enter algorithm W1-APOVRHEAD (Apply Overhead Charges) defined on the CLOSED status of the construction work activity business object (W1-ConstructionWorkActivity). Disable or override the algorithm as needed.