Delivered Dac Task Failed Loading Purchase Order & Purchase Schedule Line Fact Due To Unique Key Vi
(Doc ID 1372351.1)
Last updated on OCTOBER 01, 2019
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168 [AA 1830] to 22.214.171.124 [AA 1830] [Release V7]
Information in this document applies to any platform.
Violation has occurred due to multiple versions of Purchase Contract existing in source (Peoplesoft SCM 9.1) and this is correct. A purchase order can have multiple versions of contract. Please advice what is the solution for this issue.
SIL_PurchaseOrderFact >> This DAC task failed due to unique constraint violation.
[Create Index INDEX W_PURCH_ORDER_F_U1]
SIL_PurchaseScheduleLinesFact >> This DAC task failed due to unique constraint violation [Create Index INDEX W_PRCH_SC_LN_F_U1]
SIL_PurchaseCostFact >> This DAC task failed due to unique constraint violation.
[Create Index INDEX W_PURCH_COST_F_U1]
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document