EAP 9.2: On the Supplier > Payables Options and Procurement Options pages, Address fields default to 1 for Supplier > Location Details new Effective Dated row

(Doc ID 2008298.1)

Last updated on AUGUST 23, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When a new Effective Dated row is added to the Supplier > Location Details section, the Address fields on the Payables Options page and the Procurement Options page is automatically being defaulted to a value of 1, even if the Supplier has multiple Addresses setup, and the original row being copied from contains an Address value different than 1. The affected Record Fields are:

 + From the Vendor > Location > Payables Options page: (VENDOR_PAY_OPT_SEC)

        - PS_VENDOR_LOC.PRIM_ADDR_SEQ_NUM (Invoicing Address)
        - PS_VENDOR_LOC.REMIT_ADDR_SEQ_NUM (Remitting Address)

 + From the Vendor > Location > Procurement Options page: (VENDOR_PROC_OPT_SEC)

        - PS_VENDOR_LOC.ADDR_SEQ_NUM_ORDR (Ordering Address)
        - PS_VENDOR_LOC.RET_ADDR_SEQ_NUM (Return To Address)
        - PS_VENDOR_LOC.ADDR_SEQ_NUM_SHFR (Ship From Address)

A Supplier can have multiple Addresses being defined in their setup, and different Address values can be set for each of the Payables Options and Procurement Options as needed.  Whenever a new Effective Dated row is being cloned from an original one, the system should take the currently defined values, and establish it for Today's date, respecting the values selected so far, and not reset the Address related fields to a default value of 1. 

Since the default value is being set to 1 for the Address, this is causing Users to manually go into the Payables Options and Procurement Options pages, and one by one, re-selecting the proper Address Sequence Number values, which is very inefficient, and not user-friendly.

STEPS
  - Log into the FSCM Online Application as User ID = VP1
  - Navigate to Suppliers > Supplier Information > Add/Update > Supplier
  - Display Supplier ID = USA0000005 under SetID = SHARE
  - Go to the Address tab
  - Add a new Address ID = 2, with the required address related fields, and effective date of January 1, 1900, and Status = Active
  - Save the changes
  - Go to the Location tab
  - Click on Correction History mode button
  - Click on the 'Payables' hyperlink
  - Under the Invoicing section, set the Address field value from 1 to 2
  - Under the Remitting section, set the Address field value from 1 to 2
  - Click on OK
  - Save the changes
  - Click on the 'Procurement' hyperlink
  - Under the Ordering section, set the Address field value from 1 to 2
  - Under the Returning section, set the Address field value from 1 to 2
  - Under the Ship From section, set the Address field value from 1 to 2
  - Click on OK
  - Save the changes
  - At the Supplier > Location Details section, click on the + icon to add a new Effective Dated row
  - On the newly created row, click on the 'Payables' link
  - Confirm that the Address fields from Invoicing and Remitting sections have defaulted a value of 1, instead of the expected 2
  - On the newly created row, click on the 'Procurement' link
  - Confirm that the Address fields from Ordering, Returning, and Ship From sections have defaulted a value of 1, instead of the expected 2

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