EGL9.2: Budget Checking Process is not Updating PS_KK_ACTIVITY_LOG and PS_LEDGER_KK Correctly After Changing Accounting Date and Budget Date. (Doc ID 2044655.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

On : 9.2 version, KK-Budget Checking

ACTUAL BEHAVIOR
---------------
Budget checking process is not updating PS_KK_ACTIVITY_LOG and PS_LEDGER_KK correctly when changing accounting date + budget date and re-budget check voucher or purchase order.

EXPECTED BEHAVIOR
-----------------------
Budget checking process should be updating PS_KK_ACTIVITY_LOG and PS_LEDGER_KK correctly when changing accounting date + budget date and re-budget check voucher or purchase order.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Make sure Budget Definition is linked to a yearly calendar.
  2. Create a new voucher with invoice date 01-JUN-2015. Accounting date for voucher is 01-JUN-2015 and Budget date for voucher line is 01-JUN-2015.
  3. Budget check voucher.
  4. Budget status is Valid.
  5. PS_KK_ACTIVITY_LOG and PS_LEDGER_KK is updated for June 2015, this is correct.
  6. Change voucher accounting date and voucher line budget date to 01-JUL-2015 and save voucher.
  7. Budget status is Not Chk’d.
  8. Budget check voucher.
  9. Budget status is Valid.
  10. PS_KK_ACTIVITY_LOG is updated incorrectly (two rows are added for period 7).
  11. PS_LEDGER_KK is updated incorrectly.
  12. 2015 period 6 remains unchanged. 2015 period 7 is updated and reversed (so total for period 7 remains 0)
  13. Same is happening for Purchase Orders.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, wrong budget is updated.

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