Skip to content

Load Aircraft Type ConfigurationΒΆ

Aircraft type or assembly type configuration data, required for activities such as creating aircraft and raising faults in the Forward/Line Maintenance solution, must be loaded to IFS Cloud Web for aircraft type configuration information to be available for the solution.

Loading the aircraft type configuration can include the creation or update of assemblies, systems, sub systems, Line Replaceable Unit (LRU) configuration slots, configuration slot positions, part groups and part numbers.

To create or update aircraft type configuration a comma separated (.csv) file with aircraft configuration with a comma as a separator must be uploaded to the 001_FLM_AC_DATA_LOAD migration job. It must contain columns and values as follows:

Column Header Description and Values Column Applicable for Record Type Mandatory for Record Type Data Type Max Length
Record Type The following are the record types that must be used to create or update the aircraft type configuration hierarchy as follows:
ASS to create or update an assembly
SYS to create or update a system
SUB to create or update a subsystem
CFG to create or update a Line Replaceable Unit (LRU) config slot
CFGPOS to create or update a configuration slot position
PG to create or update a part group
PN to create or update a part number
PGP to create or update a part group part		 All record types Yes Varchar 10
Assembly Type Code The code for the type of assembly. E.g. B131 All record types Yes for assembly and config slot
No for system, sub system, config slot position and part group		 Varchar 8
System Code The system code of the assembly system. E.g. 21-00 System No Varchar 50
Sub System Code The sub system code of the assembly sub system. E.g. 21-00-00 or 21-00-10. Sub system No Varchar 50
Config Slot Code The config slot code of the assembly sub system. E.g. 21-00-00 or 21-00-10. Configuration slot, config slot position and part group Yes Varchar 50
Config Slot Position Code The position code for the assembly config slot. E.g. FWD Left Cabin Configuration slot Yes Varchar 200
Part Group Code The code for part group associated with the config slot. E.g. 29-11-04 Part group Yes Varchar 50
Part Number The part number of the part assigned to the part group. E.g. 11483-000 Part Yes Varchar 40
Assembly Name/System Name/Sub System Name/Config Slot Name/Part Group Name/Part Name The name of the assembly, system, sub system, config slot, part group or part, based on the record type being created. All record types No Varchar Assembly Name-80
System Name- 100
Config Slot Name-100
Part Group Name - 100
Part Name - 80
Assembly Class Code The class code for the assembly. Valid values are ACFT for aircraft assemblies, ADMIN for administrative assemblies, APU for auxiliary power unit assemblies, LDGEAR for landing gear assemblies and ENG for engine assemblies. Configuration slot No Varchar 8
Inventory Class Code The class code for the inventory. Valid values are SER, TRK, BATCH. Configuration slot and part group No for configuration slot and part number
Yes for part group		 Varchar 16 for config slot
8 for part group and part number
Parent Aircraft Type Code The aircraft type code of the parent config slot. E.g. B131 Configuration slot No Varchar 16
Parent Config Slot Code The config slot code of the parent config slot. E.g. 21-00-00 Configuration slot No Varchar 40
Config Slot Status The status of the config slot. Valid values are ACTV for active configuration slots or OBSLT for obsolete configuration slots. Configuration slot No Varchar 8
Is Mandatory If the value is "TRUE" the configuration slot is a mandatory configuration slot for which when a component is removed, the hierarchy is considered incomplete until a replacement component is installed. Valid values are "TRUE" and "FALSE". Configuration slot Yes Varchar 20
Is Software If the value is "TRUE" the configuration slot it indicates that you want to install software components on the assembly. Valid values are "TRUE" and "FALSE". Configuration slot Yes Varchar 20
Number of Config Slot Positions The number of positions on the configuration slot on which parts can be installed. E.g. 2. Configuration slot Yes Number 20
Part Quantity This is the quantity to be installed on the configuration slot. E.g. 1. Part group Yes Number 20
Is Line Replaceable If the value is "1" this indicates if the part is a line replaceable unit. If the value is "0" this indicates that the part is not a line replaceable unit. Part group No Number 20
Applicability Range Values for the applicability range can consist of one or more applicability codes separated by commas and/or hyphens. E.g. 217, 219. Part group No Varchar 4000
Is Common Hardware If the value is "TRUE", this indicates that the part group is for common hardware. Valid values are "TRUE" and "FALSE". Part group Yes Varchar 20
Is Req Spec Part If the value is "TRUE" this indicates that a user must select a specific alternate part when requesting the part group. Valid values are "TRUE" and "FALSE". Part group Yes Varchar 5
Conditions Desc A description of the conditional part applicability or conditional information for the part group. Part group No Varchar 4000
Manufacturer The manufacturer code for the manufacturer of the part. E.g. GRIM. Part Yes Varchar 16
Part Use The category of part use. Valid values are AE for aeronautical equipment, TOOLS for tool part, and CONSUM for parts that are expensed when they are installed. Part No Varchar 20
Is Repairable If the value is "TRUE" this indicates that the part is repairable. Valid values are TRUE or FALSE. Part No Varchar 20
Part Status The status of the part. Valid values are ACTV for active parts, BUILD for bill of material parts and OBSLT for obsolete parts. Part No Varchar 20
Is Standard If the value is "TRUE", the part is a standard part for the part group. Valid values are "TRUE" or "FALSE". Part Group Part No Varchar 20
Interchangeability Order The interchangeability order of the part group. E.g. 1 or 2. Part Group Part No Number 20
Is Approved If the value is "TRUE", the part is an approved part. Valid values are "TRUE" and "FALSE". Part Group Part No Varchar 20
Is Conditions If the value is "TRUE", the alternate part has special conditions. Valid values are "TRUE" and "FALSE". Part Group Part No Varchar 20
Is Obsolete If the value is "TRUE", the alternate part is obsolete. Valid values are "TRUE" and "FALSE". All record types Yes Varchar 20
External ID An external identifier for the record type which identifies the row and if the new record type needs to be created or updated. E.g. 1000301:ASMB80:1. If a record is uploaded with an External ID that is new to the system, a new record is created. If not, the record with the existing External ID is updated. All record types Yes Varchar 80
System External ID An external identifier for the system under which the sub system is to be created or updated. The value for this field must be the same as the External ID for a system created previously. E.g. 1000302:SYS80:2 Sub system Yes Varchar 20
Part Group External ID An external identifier for the part group to which the part group part needs to be assigned. The value for this field must be the same as the External ID for a part group created previously. E.g. 1000303:PG80:3 Part Group Part Yes Varchar 80
Part Number External ID An external identifier for the part number with which the part group part can be assigned to the part group. The value for this field must be the same as the External ID for a part number created previously. E.g. 1000304:PN80:3 Part Group Part Yes Varchar 80

  1. In the IFS Cloud Web navigator, navigate to Solution Manager/Data Management/Data Migration and open the Execute Job page.

  2. Click Search in the top banner, then click Job ID and enter 001_FLM_AC_DATA_LOAD. Note: If you are unable to see this job, you need to log in as a user with access to the job. To do so navigate to Solution Manager/Data Management/Data Migration/Basic Data and on the Authorized Users page, search for your user, click Bulk Grant, search for and grant access to jobs with Group ID MIG_FLM_AC.

  3. On the Execute Job page Detail tab, click Load File.

  4. Drag and drop or browse for and select the .csv file to be uploaded.

  5. Click OK. If a file was successfully uploaded, a message is displayed indicating such.

  6. Click Search in the top banner, then click Job ID and enter 002_FLM_AC_RUN_ALL.

  7. On the Execute Job page, click Start Job and then click Online. After the execution of the job, a message summarizing the execution is displayed. It states how many rows the file contained, how many were committed and how many failed, if any.

  8. Based on the summary:

    1. If all the rows the file contained were committed, the aircraft configuration has been uploaded and you can navigate to the Aircraft Type Details page in the Aviation Maintenance navigator, search for and view the uploaded aircraft configuration hierarchy.

    2. If some or all rows failed, on the Execute Job page, search for the migration jobs with Group ID, MIG_FLM_AC. For the 001_FLM_AC_DATA_LOAD job click on the Detail tab. If the row failed data validation, the error message field displays why the row was not committed to the target tables.

      1. You can also navigate to the individual data migration jobs, 100_FLM_AC_ASSEMBLY, 200_FLM_AC_SYSTEM, 220_FLM_AC_SUB_SYSTEM, 300_FLM_AC_CFG_SLOT, 320_FLM_AC_CFG_SLT_POS, 400_FLM_AC_PART_GROUP, 420_FLM_AC_PART_NUMBER and 440_FLM_AC_PT_GRP_PART for aircraft type configuration, view the Detail tab and view the Error Message field.
      2. An example of an error that would be displayed on this tab, would be if the row for the configuration slot failed, on the Detail tab of the Execute Job page for Job ID 320_FLM_AC_CFG_SLT_POS, an error message would be displayed indicating that the configuration slot does not exist.

For more information on migration jobs, see Data Migration.