Upgrade Preparation Queries for Supplier Sites and Contacts in Release 11.5.10 (Doc ID 844307.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version: 11.5.10.0 to 11.5.10.0 - Release: 11.5.10 to 11.5.10
Oracle Payables - Version: 11.5.10.0 to 11.5.10.0   [Release: 11.5.10 to 11.5.10]
Information in this document applies to any platform.
POSVCSND.sql
POSVSDDN.sql
POSVSNDD.sql

Goal

The Goal of this document is to simply declare the patches required to prepare Suppliers, Sites and Contacts for migration from Release 11.5.10 to Release 12.

Prior customers performs the upgrade from Release 11i to Release 12, it is critically important to review and cleanup the Supplier Site details across all of the operating units in order to prevent the creation of redundant Supplier Address records. The purpose of the review will be to eliminate the differences between all Supplier Sites that are similar and in fact represent the same Supplier location. To assist with this effort Oracle is providing Supplier Site Upgrade Preparation queries for Releases 11i.9 and 11i.10 to enable customers to identify Supplier Sites that appear to be similar. These queries will be available as 11i.9 and 11i .10 patches and can be download through Metalink.

For more information please see Oracle´┐Ż Financials and Oracle Procurement Functional Upgrade Guide: Release 11i to Release 12 Part No. B31543-01.

Solution

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