Projects - EBS (MOSC)

MOSC Banner

PA_BUDGET_PUB.UPDATE_BUDGET: budget lines are not updated

edited Oct 16, 2017 5:03AM in Projects - EBS (MOSC) 3 commentsAnswered

hi!

I was asked to investigate an issue when existing budget lines are not updated, for instance a revenue is not updated.

I've checked the code in PA_BUDGET_PUB.UPDATE_BUDGET procedure and it looks like budget lines are updated based on resource assignment ID, currency code and budget line start date:

UPDATE PA_BUDGET_LINES

SET  REVENUE = :xRevenue,

LAST_UPDATE_DATE = :xLastUpdateDate,

LAST_UPDATED_BY = 28032,

LAST_UPDATE_LOGIN = -1

WHERE RESOURCE_ASSIGNMENT_ID  = 4814795

AND START_DATE = :xStartDate

AND TXN_CURRENCY_CODE = 'NOK'

but Start Date was not changed, only the revenue value was changed. I started to dig more in the code and found some strange piece of code and now I'm confused what is purpose of this code. Here it is the listing:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center