Financial Statement Generator
Description
Categories: Enginatics
Repository: Github
Repository: Github
Blitz FSG offers the capability to generate reports on balances and delve into specific details. It allows for the linking of Excel cells to Oracle data through provided functions, enabling users to refresh the data as needed for the latest provided information. Furthermore, users can execute drilldown actions to access information at the balance, journal, and subledger levels.
Do not delet ... more
Do not delet ... more
Run
Financial Statement Generator and other Oracle EBS reports with Blitz Report™ on our demo environment
select :period_name period_name, :balance_type balance_type, :average_balance_type average_balance_type, :actual_flag actual_flag, :ledger ledger_name, :budget_name budget_name, :currency_code currency_code, :currency_type, :encumbrance_type encumbrance_type, :account_type account_type, :movement movement, :translated_flag translated_flag, :gl_segments gl_segments, :gl_segments_cb gl_segments_cb, :get_balance_function get_balance_function, :balance_drilldown_function balance_drilldown_function, :expand_segment_function expand_segment_function, :period_offset_function period_offset_function, :hierarchy_name, :gl_segment, :next_segment_value, :daily_rates, :gl_segment1 gl_segment1, :gl_segment2 gl_segment2, :gl_segment3 gl_segment3, :gl_segment4 gl_segment4, :gl_segment5 gl_segment5, :gl_segment6 gl_segment6, :gl_segment7 gl_segment7, :gl_segment8 gl_segment8, :gl_segment9 gl_segment9, :gl_segment10 gl_segment10, :create_lov create_lov, :responsibility_name responsibility_name, :responsibility_key, :gl_journal_drilldown, :gl_subledger_details, :gl_full_journal_drilldown, :gl_journal_attachment_dd from dual where 1=1 |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Ledger Name |
|
LOV | |
| Period Name |
|
LOV | |
| Currency Code |
|
LOV | |
| GL_SEGMENT1 |
|
LOV | |
| GL_SEGMENT2 |
|
LOV | |
| GL_SEGMENT3 |
|
LOV | |
| GL_SEGMENT4 |
|
LOV | |
| GL_SEGMENT5 |
|
LOV | |
| GL_SEGMENT6 |
|
LOV | |
| GL_SEGMENT7 |
|
LOV | |
| GL_SEGMENT8 |
|
LOV | |
| GL_SEGMENT9 |
|
LOV | |
| GL_SEGMENT10 |
|
LOV |
