My Oracle Support Banner

Adding New Line(s) to An Already Budget Checked Purchase Order Then Budget Checking, Getting Unique Constraint at Step FS_BP_PEOD.VSRCLN.ISRCLN or at Step FS_BP_PEOD.ActLogC.iActLog (Doc ID 2714635.1)

Last updated on DECEMBER 12, 2024

Applies to:

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

Symptoms

After adding one or more lines to an already budget checked PO then budget checking, the FS_BP budget checking process is abending on a unique constraint error.


ERROR [A] - Unique constraint error at Step FS_BP_PEOD.VSRCLN.ISRCLN

ERROR [B] - Unique constraint error at Step FS_BP_PEOD.ActLogC.iActLog while inserting in to PS_KK_ACTIVITY_LOG


Replication Steps #1 for Error [A]

1) Create a change order to an approved PO (originally created by copying from a budget-checked requisition)
2) Add a new line to the PO (not copying from a requisition) then try to budget check

Replication Steps #2 for Error [A]

1) PO has been rolled over six times
2) Add a new line to the PO (not copying from a requisition) then try to budget check

 

Replication Steps for Error [B]

1) enter and budget check a PO with original lines 1-16 (created by copying from a budget-checked requisition)
2) later add lines 17-77 to the PO (not copying from a requisition) then budget check
3) later add lines 78-84 (copying from a budget checked requisition) then try to budget check

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.