GL Journal Upload

Description
Categories: Enginatics, Upload
Repository: Github
GL Journal Upload

Templates are provided for the following Journal Types
- Functional Actuals
- Foreign Actuals
- Budget Journals
- Encumbrance Journals

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
null action_,
null status_,
null message_,
null request_id_,
null row_id,
'Vision Operations (USA)' ledger_name,
'Operations' organization,
'CORPORATE 2000' budget,
'Spreadsheet' source,
'Adjustment' category,
'Dummy' journal_description,
'Dummy' journal_reference,
'GBP' currency,
sysdate accounting_date,
'Jan-99' period,
to_char(null) account_alias,
to_char(null) concatenated_segments,
to_char(null) gl_segment1,
to_char(null) gl_segment2,
to_char(null) gl_segment3,
to_char(null) gl_segment4,
to_char(null) gl_segment5,
to_char(null) gl_segment6,
to_char(null) gl_segment7,
to_char(null) gl_segment8,
to_char(null) gl_segment9,
to_char(null) gl_segment10,
to_char(null) gl_segment11,
to_char(null) gl_segment12,
to_char(null) gl_segment13,
to_char(null) gl_segment14,
to_char(null) gl_segment15,
0 debit,
0 credit,
'Yes'  reverse_journal,
'Jan-99' reversal_period,
'User' conversion_type,
sysdate conversion_date,
1 conversion_rate,
'Dummy' line_description,
'A' actual_flag,
'INV' encumbrance_type,
null attach_upload_file,
null status,
sysdate date_created,
to_number(null) created_by,
to_number(null) user_id,
null summary_flag,
null post_to_suspense_flag
from 
dual 
where
1=1 and
1=0 and
:p_actual_flag=:p_actual_flag and
nvl(:p_foreign_currency_flag,'No')=nvl(:p_foreign_currency_flag,'No') and
:p_create_summary_jnl=:p_create_summary_jnl and
:p_post_to_suspense_flag=:p_post_to_suspense_flag
&not_use_first_block
&report_table_select &report_table_name &report_table_where_clause &success_records
&processed_run
Parameter Name SQL text Validation
Journal Type
 
LOV
Allow Foreign Currency
 
LOV
Attach Upload file to Journal
:attach_upload_file_to_journal=:attach_upload_file_to_journal
LOV Oracle