Human Resources and ELM - PSFT (MOSC)

MOSC Banner

Department Budget inactive rows

edited Mar 30, 2022 1:09PM in Human Resources and ELM - PSFT (MOSC) 1 commentAnswered

Hi all,

I recently noticed that inactive rows are included in the DEPT_BUDGET and DEPT_BUDGET_ERN tables. I've included an example below. What is the purpose of this? It doesn't seem accurate that these rows are included.

POSITION_DATA - 00000060 has not been associated with department 30110 since prior to 2017-03-01

DEPT_BUDGET - However, a row for 30110 is still included for FY 2019 with EFF_STATUS=I

DEPT_BUDGET_ERN - And rows for 30110 are still included for FY 2019 here

Thanks for the help!

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