Fixed Assets - EBS (MOSC)

MOSC Banner

Problem in Getting the EOFY_RESERVE

edited Jan 14, 2017 4:00AM in Fixed Assets - EBS (MOSC) 1 commentAnswered

Hi,

I have a requirement to build a report which will show all the movement in the current financial year. So for that I need to show the cost of the asset in the beginning of the year(1st Jan), any change in the cost, depreciation, retirements and net book value as on date.

I am struggling to get the cost on the 1st Jan. Ideally business is saying that it should remain the same throughout the year. So I tried to subtract the EOFY_RESERVE in FA_BOOKS from the the cost to get that value. But the problem is if I change the cost in the current year, Oracle distributes the depreciation for the increased amount throughout the life and a new row with the updated EOFY_RESERVE is populated. So if I consider that row then the cost as on 1st Jan gets changed. But business wants that change in the depreciation value due

Tagged:

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

EBS Fixed Assets Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center