Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Is it possible to edit the "retirements" formula in Fixed Asset Balances Real Time?
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
Answers
-
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,
1 -
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.
1
