FA Depreciation Projection
Description
Categories: Enginatics
Repository: Github
Repository: Github
Based on Oracle's 'Depreciation Projection Report' FASPRJ
Uses custom DB package call XXEN_FA_FAS_XMLP to launch Oracle standard Depreciation Projection concurrent FAPROJ. The data generation is explained in note:
How Does FA Depreciation Projections Handle Table FA_PROJ_INTERIM_XXX or FA_PROJ_INTERIM_REP ? (Doc ID 1607626.1)
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 ... more
Uses custom DB package call XXEN_FA_FAS_XMLP to launch Oracle standard Depreciation Projection concurrent FAPROJ. The data generation is explained in note:
How Does FA Depreciation Projections Handle Table FA_PROJ_INTERIM_XXX or FA_PROJ_INTERIM_REP ? (Doc ID 1607626.1)
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 ... more
Run
FA Depreciation Projection and other Oracle EBS reports with Blitz Report™ on our demo environment
select distinct gl.name ledger, fpiv.book_type_code book, &segment_columns &asset_number fpiv.period_name period, sum(fpiv.depreciation) over (partition by fpiv.request_id, fpiv.book_type_code, &segment_columns2 &asset_number fpiv.period_name, fpiv.fiscal_year) depreciation, fpiv.fiscal_year, fpiv.period_index, &segment_columns3 fpiv.request_id from gl_ledgers gl, fa_book_controls fbc, fa_proj_interim_v fpiv, fa_additions fa, gl_code_combinations gcc where 1=1 and gl.ledger_id=fbc.set_of_books_id and fbc.book_type_code=fpiv.book_type_code and fpiv.asset_id=fa.asset_id and fpiv.code_combination_id=gcc.code_combination_id order by fpiv.request_id, gl.name, fpiv.book_type_code, &segment_columns2 &asset_number fpiv.fiscal_year, fpiv.period_index |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Calendar |
|
LOV | |
Number of Periods |
|
Number | |
Starting Period |
|
LOV | |
Currency |
|
LOV | |
Book1 |
|
LOV | |
Book2 |
|
LOV | |
Book3 |
|
LOV | |
Book4 |
|
LOV | |
Show Asset Number |
|
LOV | |
Show Cost Center |
|
LOV | |
Run Depreciation Projection |
|
LOV | |
Previous Request Id |
|
LOV | |
Ledger |
|
LOV |