Modification of Constraints in TERMS_DETAIL to Include 0 In DISC_DOM & DUE_DOM
(Doc ID 2919947.1)
Last updated on MAY 11, 2023
Applies to:Oracle Retail Merchandising System - Version 19.0.1 and later
Information in this document applies to any platform.
TERMS_DETAIL table has a check constraint to allow DUE_DOM and DISC_DOM value in 1 to 31 limit. However customer finance system and legacy RMS system have 0 values for these two fields for few payment terms.
Steps to reproduce:
- Create new payment terms with zero value for DUE_DOM and DISC_DOM.
- Notice that it results in a "terms_detail check constraint violate".
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