You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Primary Key: BICC FscmTopModelAM.DooTopAM.FulfillLine

13
Views
1
Comments
edited Apr 22, 2020 11:08PM in General Transactional Reporting (OTBI) 1 comment

Summary

Need Primary Key: BICC FscmTopModelAM.DooTopAM.FulfillLine

Content

We are relying on BICC to send data to the UCM, where it is picked up by another process and used for analytics.
Today we noticed that some of our extracts have multiple records for the same primary key.
Example:

Sales Orders Data Extract
File: FscmTopModelAM.DooTopAM.FulfillLine
Primary Key: Fulfilllineid is showing multiple records for the same Fulfilllineid.
We are expecting only one record for each Fulfilllineid. This field is marked as Primary Key in the configuration. Is should there be a different PK for FscmTopModelAM.DooTopAM.FulfillLine? We were advised by Support to try FulfillLineRootParentFulfillLineIdPk or FulfillLineParentFulfillLineIdPk, but both are returning values of "0" in all rows.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!