EAP: Voucher Build abends at Step AP_VB_STGVCH.STGVCHR.STEP29, ORA-01407 (Doc ID 2000177.1)

Last updated on JANUARY 29, 2017

Applies to:

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

Symptoms

When trying to run Voucher Build to load a PO Voucher from an EDI file, if the PO does not exist in the system, Voucher Build will abend at Step AP_VB_STGVCH.STGVCHR.Step29 with an error.

This error occurred after applying Release 9.1 Bundle #32.

Prior to applying Bundle #32, Voucher Build would complete to Success but the Voucher would have the following Pre-edit Error -- Invalid Purchase Order.

ERROR
SQL Error: ORA-01407: cannot update ("EMDBO"."PS_VCHR_LINE_TMP4"."SHIP_TYPE_ID") to NULL.

STEPS
1.  Run Schedule Inbound EC Agent to load an EDI File that references a PO Voucher but the PO does not exist in the system
2.  Run Voucher Build
3.  Voucher Build will abend at Step AP_VB_STGVCH.STGVCHR.Step29 with the above error

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