I’m trying to insert new Equipment Objects (View Name: Equipment_Object) which have three object levels — Operation, Area, and Local Area. All of these represent functional objects.
For linking purposes, I’m assigning the fields Sup_Contract and Sup_Mch_Code with the parent’s contract and machine code values. To display & link them correctly in the Equipment Object Navigator as a tree structure, I set the default value of Functional_Object_Seq as:
EQUIPMENT_OBJECT_API.GET_EQUIPMENT_OBJECT_SEQ(SUP_CONTRACT, SUP_MCH_CODE)
However, when I select and execute all three levels together (using Excel migration), they don’t seem to link up but all the objects are being created. After reloading data in excel, the fields Sup_Contract, Sup_Mch_Code, and Functional_Object_Seq appear as NULL.
Interestingly, when I execute each object level individually, the hierarchy and tree structure display correctly on the screen. The values for the fields Sup_Contract, Sup_Mch_Code, and Functional_Object_Seq are showing as expected.
So my question is:
👉 Does Excel migration insert and commit records row by row, or does it process all selected rows in parallel?
👉 Do I need to configure anything so that in single execution all three levels are inserted and the tree structure is built as expected for these functional objects?