PO_AUTO_SRC Runs To No Success In Mp14 Environment (Doc ID 1998869.1)

Last updated on MARCH 01, 2017

Applies to:

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

Symptoms

On : 9.1 version, Requisitions

When attempting to run PO_AUTO_SRC,
the following error occurs.

ERROR
-----------------------
File: /vob/peopletools/src/psappeng/psaercur.cppSQL error. Stmt #: 795 Error Position: 1251 Return : 1438 - ORA-01438: value larger than specified precision allowed for this column Failed SQL stmt:INSERT INTO PS_PO_VNDR_CAT_T4 (PROCESS_INSTANCE, BUSINESS_UNIT, VENDOR_SETID, VENDOR _ID, VNDR_LOC, ITM_SETID, CATEGORY_ID, PRICE_SETID, PRICE_VENDOR, PRICE_LOC, ADDRESS_SEQ_NUM, BUYER_ ID, CURRENCY_CD, DECIMAL_POSITIONS, DISP_METHOD, ERS_ACTION, FREIGHT_TERMS, WTHD_CD, WTHD_SW, MATCH_ CNTRL_ID, MATCH_OPT, MATCH_SETID, MATCH_TYPE, PAY_TRM_BSE_DT_OPT, PYMNT_TERMS_CD, SHIP_TYPE_ID, VAT_ SVC_PERFRM_VND, VAT_SVC_PERFRM_FLG, ADDR_SEQ_NUM_SHFR, LIQUIDATE_METHOD, ULTIMATE_USE_CD, PHYSICAL_N ATURE, EXT_PRC_TOL, INSPECT_CD, LEAD_TIME, PCT_EXT_PRC_TOL, PCT_UNIT_PRC_TOL, QTY_RECV_TOL_PCT, RECV _REQ, REJECT_DAYS, RJCT_OVER_TOL_FLAG, ROUTING_ID, UNIT_PRC_TOL, UNIT_PRC_TOL_L, PCT_UNIT_PRC_TOL_L,

Process 3010787 ABENDED at Step PO_POCALC.VS2600.ISRTVNDR (SQL) -- RC = 1438




Changes

SQL

PO_POCALC   VS2600  ISRTVNDRS                                                

Appl Engine (Section)

PO_POCALC                 MAIN

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