Contracts are using the incorrect Setid when validating the Open Item Account (Doc ID 1636173.1)

Last updated on JUNE 09, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

 DESCRIPTION
===========
 Contracts are using the incorrect SetID when validating the Open Item Account field.  This is causing the following error to be thrown when using Open Item Accounts:

 

Error

-----------

Account (xxxxxx) on Line (1), Distribution (1) is not an open item account. (10400,538) The OpenItem field value on the distribution is going to be blanked out.

REPLICATION STEPS
=================
1. Create a new Table Set id

2. Create a new Table Set control

3. Be sure that the following are set to SHARE, AP_01, FS_18,FS_38

4. Lets check the Table Set Control for US001. Set FS_24 to HKS01

5. Create an Open Item Account as below in SHARE

6. Setup the Contract Options for the Setid: HKS01

7. Create a Recurring Voucher Contract in HKS01

8. Enter Vendor and Max Amount

9. Look Up AP Business Unit. Only US001 is valid due to setup. Select US001.

10. Enter Gross Amount and Line Info.  Click the Voucher Distribution icon:

11. Set the GL Unit to US005. Enter the Open Item Account

12. Enter any value in OpenItem field. Click OK. Save

13. An error message appears

Account (HKS01) on Line (1), Distribution (1) is not an open item account. (10400,538) The OpenItem field value on the distribution is going to be blanked out.

14. This is incorrect.  When doing the lookup on Account, the SetID used was SHARE.  Now, what the system is doing is validating the Open Item by attempting to look up the Item in SetID HKS01, the value of FS_24 for Set Control US001

15.  Lets check the Open item account again. Set ID is SHARE. Now, what the system is doing is validating the Open Item by attempting to look up the Item in SetID HKS01, the value of FS_24 for Set Control US001

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms