Item FBDI - transaction type import sequence
Summary:
We are trying to update GTIN relationship for a specific item using Item FBDI. One is DELETE and the other is CREATE using the same Batch and same import ESS.
For the same item and same GTIN UOM - first the existing GTIN should be DELETED and then new GTIN should be CREATED.
However, we get the error message - "A GTIN relationship already exists with this UOM for this item. (EGP-2775737)" . The error message appeared because the CREATE is processed before the DELETE.
Does oracle follow a sequence to process the transactions - like first DELETE and then CREATE records ? Or will it be processed in the same sequence as it is kept in the FBDI sheet ? Or, it randomly picks up any records without maintaining any specific sequence ?