System Allows Saving Multiple Contracts for Same Supplier With Allow Open Item Reference Checked and having Same Begin Date (Doc ID 1623883.1)

Last updated on AUGUST 29, 2023

Applies to:

Symptoms

The system allows Multiple contracts per supplier for a given begin date to be defined for open item reference. A contract that allows Open Item referencing has already been defined on a different contract for this vendor with the same beginning date. The system does not validate the contract begin date and supplier if a contract already exists for the same supplier when contract is directly approved on selecting approved status. However the system validates for existing contract for a supplier having same begin date when a contract is in Open status and then changed to approved.


Error /Warning Message :
------------------
Allow Open Item reference has been defined on contract XXX, with the same begin date, for this vendor (10400,77)

REPLICATION STEPS
=================

The issue can be reproduced at will with the following steps:


1. Navigation: Supplier Contracts > Create Contracts and Documents > Contract Entry

2. Create a contract with entering Vendor, Begin Date, checking "Allow Open Item Reference" and specifying Status "Approved", and save it

3. Create a contract with entering the same Vendor as #2, the same Begin Date as #2, checking "Allow Open Item Reference" and specifying Status "Open", and save it

4. Changing Status from "Open" to "Approved" for a contract entered in #3.

5. The error message "Allow Open Item reference has been defined on contract XXXX, with the same begin date, for this vendor (10400,77) " was shown and could not save this contract

6. Again, create a contract with entering the same Vendor as #2, the same Begin Date as #2, checking "Allow Open Item Reference" and specifying Status "Approved", and save it.  Save is allowed when it should not be allowed.  Should get same error as in step 5 above.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.