My Oracle Support Banner

EPC 9.2: When Changing a Budget Item That Was Previously Even Spread on a Budget Detail Page, It Leaves Orphan Rows in the PC_BUD_DETAIL Table. (Doc ID 3028573.1)

Last updated on JUNE 19, 2024

Applies to:

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

Symptoms

When changing a budget item that was previously even spread on a budget detail page, it leaves orphan rows in the PC_BUD_DETAIL table.

Replication step

  1. Added a new project and activity. Project Costing -> Project Definitions - > Define Project General Info.
  2. Added Cost Budget by clicking Project Budgeting under More.
  3. Add a new Budget Plan.
  4. Go To the Budget Detail page, Add a new budget item, and then do the Adjust by Amount. Populate an amount, click OK, and then Save the page.
  5. Do an Even Spread so that the budget amount gets distributed to budget periods. Review the PC_BUD_DETAIL table and the rows are populated correctly.
  6. Go Back to the Budget Adjustments by clicking on the icon next to Budget Item.
  7. Change the Budget Item and Save.
  8. Notice that this leaves an orphan row in the PC_BUDGET_ITEM table.

Replication screenshots



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
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.