Question

Cannot be integrated in "PROD_STRUCTURE_HEAD" table.

  • 27 February 2024
  • 3 replies
  • 17 views

Userlevel 5
Badge +11

Hello,
We would like to integrate data into the "PROD_STRUCTURE_HEAD" table using Data Migration Manager.
However, we can't deploy the values because we get this error message during deployment:

While checking some things, I noticed in the deployment container that some values were empty except for the "ALTERNATIVE_NO" field:


We think this is a bug and that the problem comes from the "Extract_Key_Values" procedure located in the "DAT_DEPLOY_DETAIL_API" package.

What do you think?
Thanks in advance. 


3 replies

Userlevel 5
Badge +11

Hello,
I'd like to reopen the subject.

Userlevel 6
Badge +15

@TheoB normally once you insert data into INVENTORY_PART_TAB using inventory_part_api.New, the system will automatically create a record in PRODUCT_STRUCTURE_HEAD with BOM Type Purchased or Manufactured depending on the inventory part type.

Userlevel 5
Badge +11

Hi @Marcel.Ausan ,

Thank you for your reply.
Yes, exactly.
However, the bug/problem also affects the "PROD_STRUCTURE" view. 
These lines must be integrated using a file during data transfer.

Reply