Create View Is Failing (Doc ID 2181218.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

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

Symptoms

create view is failing

Fin 9.2 upgrade with PT8.55
create view is failing for the attached errors.

ERROR
-----------------------
-- Log File --


FileName
------------
create_view_error.txt.


Creating View INV_ITM_UOM_CVW
 - SQL Error. Error Position: 32 Return: 1730 - ORA-01730: invalid number of column names specified
 
 CREATE VIEW PS_INV_ITM_UOM_CVW (SETID, INV_ITEM_ID, CONVERSION_RATE, QTY_PRECISION, ROUND_RULE, UNIT_OF_MEASURE, DFLT_UOM_STOCK, DFLT_UOM_REQ, LAST_DTTM_UPDATE, LAST_MAINT_OPRID, PACKING_WEIGHT, PACKING_VOLUME, SHIPPING_WEIGHT, SHIPPING_VOLUME, UNIT_MEASURE_WT, UNIT_MEASURE_VOL, PACKING_CD, PACKAGING_CD, CONTAINER_TYPE) AS SELECT A.SETID , A.INV_ITEM_ID , A.UNIT_OF_MEASURE , A.CONVERSION_RATE , A.QTY_PRECISION , A.ROUND_RULE , A.DFLT_UOM_STOCK , A.LAST_DTTM_UPDATE , A.LAST_MAINT_OPRID , A.PACKING_WEIGHT , A.PACKING_VOLUME , A.SHIPPING_WEIGHT , A.SHIPPING_VOLUME , A.UNIT_MEASURE_WT , A.UNIT_MEASURE_VOL , A.PACKING_CD , A.PACKAGING_CD , A.CONTAINER_TYPE FROM PS_INV_ITEM_UOM A
Error: Unable to process create statement for INV_ITM_UOM_CVW

------------------------------

Creating View PO_POD_HDR_EVW1
 - SQL Error. Error Position: 32 Return: 1730 - ORA-01730: invalid number of column names specified
 
 CREATE VIEW PS_PO_POD_HDR_EVW1 (BUSINESS_UNIT, PO_ID, VENDOR_SETID, VENDOR_ID, VNDR_LOC, PO_DT, DB_NUMBER_BU, DESCR_BU, ADDRESS1_BU, ADDRESS2_BU, ADDRESS3_BU, ADDRESS4_BU, CITY_BU, STATE_BU, POSTAL_BU, COUNTRY_BU, ADDRESS1_BILL, ADDRESS2_BILL, ADDRESS3_BILL, ADDRESS4_BILL, CITY_BILL, STATE_BILL, POSTAL_BILL, COUNTRY_BILL, CURRENCY_CD, TAX_EXEMPT_ID, STD_ID_NUM_VNDR, NAME1_VNDR, ADDRESS1_VNDR, ADDRESS2_VNDR, ADDRESS3_VNDR, ADDRESS4_VNDR, CITY_VNDR, STATE_VNDR, POSTAL_VNDR, COUNTRY_VNDR, PYMNT_TERMS_CD, DESCR50_PAY, BUYER_ID, PO_AMT_TTL, PROCESS_INSTANCE, AUDIT_ACTN, IN_PROCESS_FLG, TEXT254_CC1, TEXT254_CC2, VNDR_UPN_FLG, STD_ID_NUM_VNDRGLN, STD_ID_NUM_BILLTO, COMMENTS_2000, ATTN_TO) AS SELECT BUSINESS_UNIT , A.PO_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.PO_DT , A.DB_NUMBER_BU , A.DESCR_BU , A.ADDRESS1_BU , A.ADDRESS2_BU , A.ADDRESS3_BU , A.ADDRESS4_BU , A.CITY_BU , A.STATE_BU , A.POSTAL_BU , A.COUNTRY_BU , A.AD...
Error: Unable to process create statement for PO_POD_HDR_EVW1


------------------------------------
reating View PO_POD_HDR_EVW2
 - SQL Error. Error Position: 32 Return: 1730 - ORA-01730: invalid number of column names specified
 
 CREATE VIEW PS_PO_POD_HDR_EVW2 (VENDOR_SETID, VENDOR_ID, VNDR_LOC, BUSINESS_UNIT, PO_ID, PO_DT, DB_NUMBER_BU, DESCR_BU, ADDRESS1_BU, ADDRESS2_BU, ADDRESS3_BU, ADDRESS4_BU, CITY_BU, STATE_BU, POSTAL_BU, COUNTRY_BU, ADDRESS1_BILL, ADDRESS2_BILL, ADDRESS3_BILL, ADDRESS4_BILL, CITY_BILL, STATE_BILL, POSTAL_BILL, COUNTRY_BILL, CURRENCY_CD, TAX_EXEMPT_ID, STD_ID_NUM_VNDR, NAME1_VNDR, ADDRESS1_VNDR, ADDRESS2_VNDR, ADDRESS3_VNDR, ADDRESS4_VNDR, CITY_VNDR, STATE_VNDR, POSTAL_VNDR, COUNTRY_VNDR, PYMNT_TERMS_CD, DESCR50_PAY, BUYER_ID, PROCESS_INSTANCE, AUDIT_ACTN, IN_PROCESS_FLG, VNDR_UPN_FLG, STD_ID_NUM_VNDRGLN, STD_ID_NUM_BILLTO, TEXT254_CC1, COMMENTS_2000, ATTN_TO) AS SELECT VENDOR_SETID ,VENDOR_ID ,VNDR_LOC ,BUSINESS_UNIT ,PO_ID ,PO_DT ,DB_NUMBER_BU ,DESCR_BU ,ADDRESS1_BU ,ADDRESS2_BU ,ADDRESS3_BU ,ADDRESS4_BU ,CITY_BU ,STATE_BU ,POSTAL_BU ,COUNTRY_BU ,ADDRESS1_BILL ,ADDRESS2_BILL ,ADDRESS3_BILL ,ADDRESS4_BILL ,CITY_BILL ,STAT...
Error: Unable to process create statement for PO_POD_HDR_EVW2

-----------------------------------------
Creating View PO_POD_LN_EVW1
 - SQL Error. Error Position: 31 Return: 1730 - ORA-01730: invalid number of column names specified
 
 CREATE VIEW PS_PO_POD_LN_EVW1 (BUSINESS_UNIT, PO_ID, VENDOR_SETID, VENDOR_ID, VNDR_LOC, LINE_NBR, INV_ITEM_ID, DESCR254_MIXED, UNIT_OF_MEASURE, ITM_ID_VNDR, INV_ITEM_WEIGHT, INV_ITEM_HEIGHT, INV_ITEM_VOLUME, INV_ITEM_LENGTH, INV_ITEM_WIDTH, VNDR_CATALOG_ID, MFG_ID, MFG_ITM_ID, CNTRCT_ID, VERSION_NBR, CNTRCT_LINE_NBR, CAT_LINE_NBR, RELEASE_NBR, PROCESS_INSTANCE, AUDIT_ACTN, CANCEL_STATUS, IN_PROCESS_FLG, UPN_ID, COMMENTS_2000) AS SELECT B.BUSINESS_UNIT , B.PO_ID , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.LINE_NBR , B.INV_ITEM_ID , B.DESCR254_MIXED , B.UNIT_OF_MEASURE , B.ITM_ID_VNDR , B.INV_ITEM_WEIGHT , B.INV_ITEM_HEIGHT , B.INV_ITEM_VOLUME , B.INV_ITEM_LENGTH , B.INV_ITEM_WIDTH , B.VNDR_CATALOG_ID , B.MFG_ID , B.MFG_ITM_ID , B.CNTRCT_ID , B.VERSION_NBR , B.CNTRCT_LINE_NBR , B.CAT_LINE_NBR , B.RELEASE_NBR , B.PROCESS_INSTANCE , B.AUDIT_ACTN , B.CANCEL_STATUS , B.IN_PROCESS_FLG ,B.UPN_ID FROM PS_PO_LINE_OUT_EC B
Error: Unable to process create statement for PO_POD_LN_EVW1

------------------------------------------------
Creating View PO_POD_LN_EVW2
 - SQL Error. Error Position: 31 Return: 1730 - ORA-01730: invalid number of column names specified
 
 CREATE VIEW PS_PO_POD_LN_EVW2 (VENDOR_SETID, VENDOR_ID, VNDR_LOC, BUSINESS_UNIT, PO_ID, LINE_NBR, INV_ITEM_ID, DESCR254_MIXED, UNIT_OF_MEASURE, ITM_ID_VNDR, INV_ITEM_WEIGHT, INV_ITEM_HEIGHT, INV_ITEM_VOLUME, INV_ITEM_LENGTH, INV_ITEM_WIDTH, VNDR_CATALOG_ID, MFG_ID, MFG_ITM_ID, CNTRCT_ID, VERSION_NBR, CNTRCT_LINE_NBR, CAT_LINE_NBR, RELEASE_NBR, PROCESS_INSTANCE, AUDIT_ACTN, CANCEL_STATUS, IN_PROCESS_FLG, UPN_ID, COMMENTS_2000) AS SELECT B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.BUSINESS_UNIT , B.PO_ID , B.LINE_NBR , B.INV_ITEM_ID , B.DESCR254_MIXED , B.UNIT_OF_MEASURE , B.ITM_ID_VNDR , B.INV_ITEM_WEIGHT , B.INV_ITEM_HEIGHT , B.INV_ITEM_VOLUME , B.INV_ITEM_LENGTH , B.INV_ITEM_WIDTH , B.VNDR_CATALOG_ID , B.MFG_ID , B.MFG_ITM_ID , B.CNTRCT_ID , B.VERSION_NBR , B.CNTRCT_LINE_NBR , B.CAT_LINE_NBR , B.RELEASE_NBR , B.PROCESS_INSTANCE , B.AUDIT_ACTN , B.CANCEL_STATUS , B.IN_PROCESS_FLG ,B.UPN_ID FROM PS_PO_LINE_OUT_EC B
Error: Unable to process create statement for PO_POD_LN_EVW2
-------------------------------------------------------
Creating View PV_VOUCHER_VW4
 - SQL Error. Error Position: 31 Return: 1730 - ORA-01730: invalid number of column names specified
 
 CREATE VIEW PS_PV_VOUCHER_VW4 (BUSINESS_UNIT, REQ_ID, PO_ID, LINE_NBR, SCHED_NBR, BUSINESS_UNIT_AP, VOUCHER_ID, VOUCHER_LINE_NUM, ENTRY_STATUS, MATCH_STATUS_VCHR, MERCHANDISE_AMT, UOM_VCHR, QTY_VCHR, BUSINESS_UNIT_RECV, RECEIVER_ID, RECV_LN_NBR, URL) AS SELECT DISTINCT A.BUSINESS_UNIT_PO , C.REQ_ID , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , B.ENTRY_STATUS , B.MATCH_STATUS_VCHR , A.MERCHANDISE_AMT , A.UNIT_OF_MEASURE , A.QTY_VCHR , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR FROM PS_VOUCHER_LINE A , PS_VOUCHER B , PS_PV_REQ_PO_D_VW3 C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.BUSINESS_UNIT_PO = C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID
Error: Unable to process create statement for PV_VOUCHER_VW4

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