PO_POCREATE Abends With the Following Message, ABENDED at Step PO_POCREATE.PB8500.BLDHDRS (SQL) -- RC = 805 (Doc ID 2061397.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

When a User creates a new PO and manually assigns a PO ID that is within the auto number sequence, when a req is sourced and the new PO ID is the one the User created the following error is thrown:

PO Create abends at Step PO_POCREATE.PB8500.BLDHDRS (Action SQL) -- RC = 805

SQL Error: ORA-00001: unique constraint (EMDBO.PS_PO_HDR) violated


STEPS
1. Create a PO and assign a PO ID that is within the auto number sequence
2. Close that PO
3. Create a new Requisition
4. Pick the req on Requisition Selection
5. Run PO Calc
6. Run PO Create
(Detailed replication steps)

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