Skip to main content
Question

Cannot be integrated in "PROD_STRUCTURE_HEAD" table.


Forum|alt.badge.img+13
  • Hero (Partner)
  • 150 replies

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

Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • 150 replies
  • March 1, 2024

Hello,
I'd like to reopen the subject.


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • March 1, 2024

@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.


Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • 150 replies
  • March 1, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings