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 |