Creating Index PSBPO_SPEND_PVG on Table PS_PO_SPEND_PVG Fails when Applying PUM 17 with error 'PS_PO_SPEND_PVG' has 23 columns

(Doc ID 2122159.1)

Last updated on JUNE 22, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Creating index PSBPO_SPEND_PVG on table PS_PO_SPEND_PVG fails when applying PUM 17.

Error message for the table which failed to create in MSS:

1. Creating Table PO_SPEND_PVG
2. Import PO_SPEND_PVG 1377
3. Building required indexes for PO_SPEND_PVG
4. Error: - SQL Error. Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 11
for SQL Server][SQL Server]The index 'PSBPO_SPEND_PVG' on table 'PS_PO_SPEND_PVG' has 23 columns in the key list. The maximum limit for index.
key column list is 16.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statemen

CREATE NONCLUSTERED INDEX PSBPO_SPEND_PVG ON PS_PO_SPEND_PVG (BUSINESS_UNIT, BUYER_ID, PO_DT, REPORT_ENTITY, VENDOR_SETID, VENDOR_ID, VNDR_LOC, PO_ID, LINE_NBR, SCHED_NBR, FISCAL_YEAR,
.
ACCOUNTING_PERIOD, CURRENCY_CD, MERCHANDISE_AMT, BUYER_DESCR, NAME1, INV_ITEM_ID, DESCR254_MIXED, CATEGORY_CD, DUE_DT, SHIPTO_ID, SRM_DB_S_ACCT_PER, ASOF_DTTM)
Error: Unable to process create statement for PO_SPEND_PVG.

The configuration where this error was noticed has PeopleTools 8.55 Patch 02 FSCM 9.2 Image 7 and RDBMS platform & version MSS 2014.

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