Is it possible to edit the "retirements" formula in Fixed Asset Balances Real Time?

Question

I put the "retirements" field in my report, but they are considering SOURCE_TYPE_CODE = RETIREMENT and ACCOUNT_TYPE = COST, DEPRECIATION_RESERVE e TRUE_DEPRECIATION_RESERVE amounts, but I need Only the COST.

select book_type_code,ledger_id,period_counter,period_name,source_table,source_distribution_type,transaction_type_code,source_type_code,account_type,beginning_balance,amount, creation_date,last_update_login

This way, my asset has a cost of 5.004,24 and the retirement amount is 11.717,96

The correct is consider the retirement amout = 5004,24

Tks

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/24311/is-it-possible-to-edit-the-retirements-formula-in-fixed-asset-balances-real-time

You will not be able to update/edit the seeded values/logic coming from a subject area. Either you can create your custom BIP or check if there is any other column in the subject area that can give you the value you are looking for.

Thanks.

Bhaskar Konar · Answer

Hi @Riane,

Users can't change the formula of an existing OTBI column as users don't have access to the underlying metadata which holds the definition of columns, formula etc.

You might want to use the existing fields and write the report in a different way to achieve your requirement. If it is not at all possible using OTBI SAs then we have to go for custom SQL and use BI Publisher.

Also you can raise an idea in the idea lab with your business requirement and if it gets enough votes, Oracle might consider it for future releases.

Hope this help.

Cheers,