My Oracle Support Banner

Override Requisition Exceptions Causing FS_BP Abend (Doc ID 2428571.1)

Last updated on JULY 27, 2018

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


Budget check is failing on FS_BP_BKOT.iOvrHst1.S with a unique constraint error on KK_OVR_HST_TBL. This happens when there has been a budget override done at the line level and then a subsequent budget override is done at the transaction level. The error happens when the second override is being archived on to KK_OVR_HST_TBL and it is caused by the criteria within FS_BP_BKOT.gSeqNbr.S and gSeqNbr2.S.

ERROR
"805 - ORA-00001: unique constraint (SYSADM.PS_KK_OVR_HST_TBL) violated"


STEPS

Setup
1. Enable commitment control.
Navigation : Set Up Financials/Supply Chain > Install > Install Options > Products

2. Create a new rule (OVERRIDE) if it does not exist Select the attribute as “Super User”
Navigation : Commitment Control > Define Budget Security > Rule Definition

3. Assign Override event and select “All source transactions” in the Budget override source trans
4. Assign the Rule to the User VP1
Navigation : Commitment Control > Define Budget Security > Assign Rule to User ID

5. Run commit control security process in order to make the changes to the VP1 security to enable the override option
Navigation : Commitment Control > Define Budget Security > Assign Rule to User ID

6. Navigation : Commitment Control > Budget Journals > Enter Budget Journals.
  Create budget journal for ledger group EG_UNIV and check generate parent budgets.
  Save and Run the “Post Jounal” process

7. Create another budget journal for ledget group “EG_UNIV_PR”.
  Save and run post journal process

Steps:
8. Create a requisition. Save and run budget check.
9. Budget status went to error, Click the error hyperlink which will open the new page in the separate window
10. Select the override check boxes and save
11. Run the budget check for the requisition.
Navigation : Purchasing > Requisition > Budget Check

12. Open the requisition and ensure that the budget status is valid
13. Navigate to Commitment Control > Review Budget Activities > Budget Details
14. Enter PC BU and Project. Search. Pre-encumbrance : $20. Click Budget Exception
15. Open the requisition and increate the price of the item by $1 (20 -> 21).
16. Save and do budget check again. Went to error again, click error
17. Click override transaction at the header at this time. Save
18. Run budget check for the requisition. Navigation : Purchasing > Requisition > Budget Check
19. Navigate to Commitment Control > Review Budget Activities > Budget Details. Check the budget details and exceptions
21. Open the requisition and increase the price by $1 again ($21 –> $22). Save and do budget check
22. Go to process monitor and check the recent budget check process (FS_BP), the run status is “No success”.
  Got the error:
  "Process 158308 ABENDED at Step FS_BP_BKOT.BKOUT.iOvrHst1 (SQL) -- RC = 805"


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.