Asset Lifecycle Management Telecom

Integrating Asset Lifecycle Management with Enterprise Applications

An Asset Lifecycle Management Suite is a powerful and flexible solution for tracking and managing your infrastructure assets and inventory throughout their lifecycle. Fulcrum’s CATS provides a wide range of features, modules and functionality to meet many different asset management scenarios. At the same time, CATS is flexible and scalable to allow a wide range of implementation and integration options that will fit within almost any enterprise ecosystem.

While CATS can function as a stand-along asset management system, some of the greatest value that it brings is the ability to integrate with any number of enterprise systems that could benefit from the data that CATS Mobility collects and stores.

The CATS system is designed around field users collecting information about assets as they are physically encountered and acted upon. As such, CATS integration with existing systems provides accurate and up to date physical inventory status using the CATS interfaces services. External systems including financial, planning, ordering, purchasing, warehouse, spares management, etc. have specific sets of needs that we can tailor our interface records to meet. 

For example, there are several areas in the asset lifecycle that are considered financially triggering events, including initial PO receipt, installation and project go-live, repair and warranty execution, inter-business transfers, excess availability and re-use, retirement and disposition.

A thorough analysis with each customer determines what is considered a financially triggering event based on their business needs and their ERP system’s needs.  Once established those rules are applied to CATS data entry validation and Interface configurations.

CATS integration includes a multi-step approach:

  1. Configure CATS to include external systems business logic and validations rules at the point of data entry.
  2. Evaluate each transaction as it occurs to determine external system notification needs.
  3. Capture an event record of the transaction and any transient data needed for external systems for later processing.
  4. Establish processing rules applying any additional integration rules required by each external system (i.e. rolling up of transactions, pending of transactions, processing order of transactions, automatic reprocessing of erred integration records, etc.)
  5. Schedule CATS integration services and configure the services to create interface files in required formats and delivery methods.
  6. Establish error handling and management methods.

Fulcrum’s implementation teams have a wide array of previous CATS integrations to draw on and reference providing support and guidance for our clients when determining business requirements for each integration.  Some examples:

> Transfer integrations might exclude transactions for inventory that is inactive, at a repair location, in a disposed or retired status, non-trackable part type, in a pending status in external system, have not been assigned a financial asset id in external system, etc.

Transfer integrations might include transactions on inventory that is moving from one location to another, have a change of business unit or owner, have a change of asset label, serial number or part number, etc.

Transfer data entry validations might include preventing transfers to inactive locations, to unapproved projects, across business units, to invalid locations and business unit combinations, etc.

Transfer integration records may be “rolled up” to bypass consecutive intermediate transfer transactions to generate a single transaction showing movement from the external system assets current location to CATS current location, reducing external system processing time.

CATS can communicate in a multitude of ways to meet a wide range of needs and requirements.

With any integration between two systems, there are often numerous considerations to consider, including:

  1. Whether CATS is deployed as a Hosted or On-Premise installation.
  2. Needs for synchronous or asynchronous transmission.
  3. Batch, real-time or On-demand frequencies.
  4. Data exchange methods – HTTP or FTP/SFTP, Direct database access, JMS messaging, Web Services, etc.

The answers to any of these considerations could affect the simplicity or complexity of the implementation of the integration.

For those looking to deploy quickly, a file transfer methodology provides the most lightweight and simple integration option. CATS provides a number of options to provide data files that can be available for external systems. The following lists some options in increasing complexity.

  1. Data Forms that provide data lookups and can be used to manually export data into .csv file format. These forms are provided in the CATS Web UI and can be made available to different user groups through configuration.
  2. Query Builder results, which can be modified by users through the CATS Web UI. Query Builder results are in .csv file format, and are based upon accessing existing CATS database views. Query Builder results can be scheduled to be run and emailed to users at a desired frequency.
  3. Services can be configured that extract data into several types of file formats (.csv, .txt, .xml) and placed into a directory or JMS messaging queue accessible by users or external systems.
  4. Services can be scheduled to run on a desired frequency, and can also include additional validation and error handling options.
  5. Services can be configured to monitor directories and message queues for the existence of data files or messages in different file formats (.csv, .txt, .xml, .jms) that CATS can select and load into the CATS database. Error handling and validation options can be instituted.
  6. CATS REST API is available for external systems to post transactional data to the CATS system.

One of the primary considerations when implementing the CATS application is how to populate the system with inventory and asset data. There are a various options available, depending upon the client’s needs and maturity level with asset management in general. This can range from performing an initial inventory in conjunction with the CATS system implementation, all the way to a comprehensive data conversion with one or more enterprise systems.

An initial inventory may be an option for clients who are implementing an asset tracking or asset management system for the first time. In this scenario, there is often no legacy data for assets and inventory, or if data is available, it is highly suspect for data integrity. Either a client’s internal team or a contracted team would travel between locations where trackable equipment resides, and perform the initial identification of asset and non-serialized inventory into the CATS application. This option may present a higher cost either materially in contractor hours, or in changing focus of internal teams that are not typically tasked with this type of work. However, this option does present a time-boxed option for getting the asset and inventory data quickly into CATS.

Another option for those clients with little to no, or suspect, legacy data is to perform the initial load of the asset and non-serialized inventory data into CATS in conjunction with performing the business processes that involve handling the trackable equipment. This is typically done by focusing on distribution centers first, where equipment moves through prior to being shipped to field locations, and at locations where excess equipment is consolidated from the field. This is often augmented with an Audit schedule of field locations, to allow for capture of those locations’ trackable equipment over a reasonable time period.

Over time the CATS system is populated with data as the system is exercised. Initial costs should be lower than dedicating an inventory team to perform the initial identification, as described in the first option. However, this option isn’t time-boxed, so there may be more ambiguity as to when the majority of trackable equipment has been identified, and the ability to realize full benefits from the asset and inventory data may take longer to manifest.

For a client that has legacy asset and inventory data available, and there is a level of confidence in that data, a data conversion plan is an attractive option. Within this approach, there are several different methods available to load the data into the CATS application. Options can include having users load Excel data files directly into CATS via web forms, setting up one time jobs within CATS that systematically ingest data, to implementing incremental loads of initial and delta data extracts through a dedicated interface.

Costs associated with performing data conversions will range commensurately with the level of systematic process needed. High degrees of system based integration will cost more to setup and run than simple import processes used. However, a direct data conversion will preclude the need for hiring dedicated inventory teams and can provide a sooner benefit return of implementing CATS.

Fulcrum’s implementation teams are well versed in the different options available to load the CATS system with asset and inventory data and work with our clients to identify the best options for them. Often this is a combination of different options available. As an example, a data conversion and then an audit of field level locations within an initial time frame to true up discrepancies that would inevitably occur with snapshot data. The goal of the Fulcrum implementation team is to get the CATS system providing benefits for the client, with the least amount of disruption to the user base, as soon as possible. 

XO and Fulcrum Technologies Featured as ISE Magazine Cover Story:

XO’s supply chain Journey; with lessons learned from an amazing cross-country bike journey that spanned over 4,000 miles. Yvonne encountered an incredible number of variables, twists, and turns thrown at her by the environment for both journeys. Fortunately, she was prepared for anything, understood how long these voyages take, and tackled everything one mile at a time. A fantastic story:

You can read the full article here: http://www.isemag.com/2017/03/xos-supply-chain-journey/ or visit the digital edition here: http://digital.isemag.com/#&pageSet=0&contentItem=0

Secure Mobile Phone Scanning Software

When choosing a mobile solution front end to track and manage your critical assets, infrastructure, and equipment, you need to consider a few “must-have” features.  

First, you should have a mobility solution that can be configured to let any worker in any environment scan 1D, 2D, or Micro PDF barcodes.  You also want that mobile software to work on any major scanner or smartphone scanning platform, so you have flexibility, choices, and known interfaces.  Whether your people are in the field, the warehouse, or back office, they will need a reliable, consistent method of capturing ALL transactional data to feed your fixed asset database.  From an ergonomic perspective, you want that worker to perform asset scans with the least amount of attempts required, capturing asset data as it flows organically throughout its lifecycle.

And every role throughout the supply chain workflow is unique, with a unique set of needed functionality.  Because of this, you want a solution that has multiple-step processes which can be configured for different types of users. 

When tracking assets to the tops of snowy mountains and into rattlesnake infested cell sites in the desert, we have learned a valuable lesson; you also never know when you’re going to be connected, so your solution needs to work perfectly online, and can perfectly collect data in a ‘batch mode’ when offline. 

Lastly, in this era where intellectual property as a competitive advantage in the enterprise, having enterprise-grade security from end-to-end for your mobile solution is invaluable.   This level of security ensures your collected proprietary data remains uncompromised.  It requires having a secure log-on, user limited permissions, and encrypted password protection.  It should also allow you to connect in real-time and through a secure transport layer behind your own firewall.

These are all best practices that we’ve implemented in major Communication Service Providers in North America and abroad.  If you want to talk with one of our consultants on how to perfect your enterprise mobile scanning, email INFO@Fulcrum.net.  We would love to help.

Asset Lifecycle Management Telecom

To have accurate visibility, insight and control of your assets from end to end, Telecom organizations have to have Asset Lifecycle Management (ALM) in the center of all back-end, mobile, and e-Polling systems. This greatly improves the accuracy of the data by means of data reconciliation as well as data collection. A great ALM solution can reconcile and verify any and all asset data regardless of the source, to provide every connected system with the most accurate and consistent data possible, at either a high or low level. This ensures the integrity of CSP asset information, reduces or removes the need for physical audits and serves as the database of record for all assets.

Because critical asset and infrastructure costs are so enormous ($350 billion globally), network & engineering executives, finance managers and supply chain executives are all starting to demand better ALM to solve a plethora of their Supply Chain pains:

·    It reduces the requirement to purchase duplicate equipment.

·    It allows for efficient reuse of extra assets, inventory and spare equipment (spares).

·    It gives visibility and insight into invoiced equipment to provide an understanding of what has truly been received and if it matches the purchase orders (POs).

·    It gives visibility and insight into the status of equipment going through the return and repair process.

·    It reduces theft, fraud and employee stockpiling / hoarding.

Asset Lifecycle Management Benefits for Telecom:

·    It gives Telecom companies an accurate picture of what is actually in use & where the inventory and assets reside - to allow for accurate tax payments.

·    It supports internal controls to allow for compliance, which reduces organizational and regulatory risks immensely.

·    It removes excessive repair and replacement expense through granular-level accurate warranty tracking.

·    It also allows field techs to find spares quickly, with insight into network information, revision numbers and more.

The ability to use ALM to reduce and optimize capex becomes a telecom’s biggest strategic advantage in a fiercely competitive global marketplace.   This is because ALM is the complete end-to-end management of network equipment through each of the many lifecycle stages from acquire to retire.

To learn how Asset Lifecycle Management can help you, please email info@fulcrum.net, or visit www.Fulcrum.net.