EPC9.1+: PC_BUD_SUM Not Updating Field PC_BUDGET_ITEM For Revenue Budget Plan (Doc ID 2005916.1)

Last updated on MAY 16, 2019

Applies to:

Symptoms

Create a revenue budget plan for 10,000 USD. Select budget item CONSLT and finalize the budget plan. This will create a RBD row in PS_PROJ_RESOURCE.
Open the Budget vs. Actual page. A row with budget item CONSLT has been created for 10,000 USD as the Budget Amount.

Now create a BLD row for 100 USD and run the engine PC_INTFEDIT. Notice that the field PC_BUDGET_ITEM is blank for the BLD row in the table
PS_PC_BUD_SUMMARY. It should have been updated to CONSLT. Open the Budget vs. Actual page. A separate row has been created for the BLD row (100 USD).

This is wrong, as the application should have updated the field Actual Amount of the row with budget item CONSLT instead of creating a new row. When you
create a budget plan with budget type 'Cost', then the issue doesn't happen. No separate row is created and the actual amount is updated on the budget
item row.

Cause

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