Understanding the Load Process

Once all the requested data (Message GET_DISCOVERYDATA_ACK) has been received, the View Request Status page displays "Success". All of the data from the XML has been received and written to application staging tables during subscription. An Application Engine process (IT_LOAD_PROC) is automatically submitted and uses the staging tables as input to produce translated data in the cache and error tables.

This cache data is then used by the compare process.

Note: You can view the results of the data integration via PeopleSoft Integration Broker Message Details. Check the status of the following Messages: GET_DISCOVERYDATA, GET_DISCOVERYDATA_STATUS_ACK, GET_DISCOVERYDATA_ACK.

The Load Process validates and translates the third-party data, consisting of. Serial Number, Manufacturer, Computer Type (IT Resource), Model, Primary User, Primary User Domain, Machine Name, IP Address, Date of Last Inventory, Software Titles, and Total Run Time. The Load Process translates the data from the third-party into data that is familiar to the asset repository (for example, Primary User + Domain = Employee ID). When this translation is successful, data is inserted into the cache table. Errors occurring during these translation edits will prohibit the IT device or software title from being inserted into the cache tables. Instead errors encountered will be inserted into the error tables with the applicable error code as well as a table that preserves the original third-party values. This is done to allow later processing of the data either by the comparison process or again by Load once a valid translation for the data has been created.

You can view the errors produced by the load process for the latest discovery request from a high level pagelet and drill down to the details on the View Integration Data Load Errors page.

This table lists the order of processing the translation edits:

Application Engine: IT_LOAD_PROC




Checks for Duplicate Serial Numbers


Duplicate Serial ID Error


Checks for the existence of a mapping of the primary user and domain to an employee ID


Unmapped Primary User/Domain - Empl ID


Retrieves Department and HR business unit for an Empl ID from the PS_JOB table for Employees "Primary Job".

HCM Integrated data


Retrieves the mapped GL Business Unit value for the HR Business Unit

HCM to GL Business Unit


Checks for unmapped/blank GL Business Unit value for the HR Business Unit


No GL BU Mapped to HR BU


Check for no HR Business Unit value in PS_JOB table


No GL BU Mapped to HR BU


Retrieves the max AM Business Unit value in the BU_BOOK_TBL table for the GL Business Unit


Retrieves the SetIDs for Asset Subtype (AM_SUBTYPE), Manufacturer (MANUFACTURER), Location (LOCATION_TBL) where there is a MFG_ID


Retrieves the SetIDs for Asset Subtype (AM_SUBTYPE), Manufacturer (MANUFACTURER), Location (LOCATION_TBL) where MFG_ID is blank.


Retrieves the Manufacturer when provided. Error if provided value is not in mappings.


Unmapped Manufacturer Error


Retrieves the IT_SUBTYPE and AM_SUBTYPE from the 3rd party value. Error if no mapping.


Unmapped Asset Subtype


Retrieves the Location for IP Addresses that are not VPN. Error if not in mapping.


Unmapped IP Address Error


When no MFG_ID is returned from the third-party application , PeopleSoft IT Asset Management stores a blank MFG_ID to the IT_HRDWR_CACHE table.

Once completed, the system sets the "Last Request Date" to the current date for the IT Subtypes and reprocesses errors from prior requests unless more current data comes from the third-party application.