ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 4D7541E4C44D23BFE0630100007FEA98Y select null action_, null status_, null message_, null modified_columns_, gl.name ledger_name, iddt.dossier_name dossier_type, iddt.amount_type, idth.trx_number transaction_number, idth.dossier_transaction_name, idth.description, idth.trx_status status, idth.parent_trx_number parent_transaction_number, idts.budget_name source_budget, idts.period_name source_period, gcck_s.concatenated_segments source_account, idts.budget_amount source_budget_amount, idts.funds_available source_funds_available, idts.new_balance source_new_balance, idtd.budget_name dest_budget, idtd.period_name dest_period, gcck_d.concatenated_segments dest_account, idtd.budget_amount dest_budget_amount, idtd.funds_available dest_funds_available, idtd.new_balance dest_new_balance from igi_dos_trx_headers idth, igi_dos_doc_types iddt, gl_ledgers gl, igi_dos_trx_sources idts, igi_dos_trx_dest idtd, gl_code_combinations_kfv gcck_s, gl_code_combinations_kfv gcck_d where 1=1 and idth.dossier_id=iddt.dossier_id and idth.sob_id=gl.ledger_id and idth.trx_id=idts.trx_id and idts.source_trx_id=idtd.source_trx_id and idth.trx_id=idtd.trx_id and idts.code_combination_id=gcck_s.code_combination_id(+) and idtd.code_combination_id=gcck_d.code_combination_id(+) U A xxen_igi_upload.upload_dossier xxen_igi_upload.validate_row( p_ledger_name=>:$column$.Ledger_Name, p_dossier_name=>:$column$.Dossier_Type, p_source_budget=>:$column$.Source_Budget, p_source_period=>:$column$.Source_Period, p_source_account=>:$column$.Source_Account, p_dest_budget=>:$column$.Dest_Budget, p_dest_period=>:$column$.Dest_Period, p_dest_account=>:$column$.Dest_Account, p_dest_budget_amount=>:$column$.Dest_Budget_Amount ) US IGI Dossier Maintenance Upload Upload to create and maintain dossier transactions (budget transfers) for Oracle Public Sector Financials International (IGI). Supports header creation with source and destination budget lines using the seeded IGI Dossier Maintenance APIs. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual Y US Upload Mode 2 20 1=1 gl.name=:ledger LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name xxen_util.default_ledger Y US Ledger 3 30 1=1 idth.trx_number=:transaction_number LOV custom Y select idth.trx_number value, iddt.dossier_name||': '||idth.dossier_transaction_name||' ('||idth.trx_status||')' description from igi_dos_trx_headers idth, igi_dos_doc_types iddt where idth.dossier_id=iddt.dossier_id and :$flex$.upload_mode='C,U' order by idth.trx_number desc US Transaction Number 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 LEDGER_NAME LOV custom varchar2 30 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name select gl.ledger_id id, gl.name value from gl_ledgers gl Y Y 6 DOSSIER_TYPE LOV custom varchar2 60 select iddt.dossier_name value, iddt.dossier_description description from igi_dos_doc_types iddt order by iddt.dossier_name Y 7 AMOUNT_TYPE Char varchar2 5 select iddt.amount_type from igi_dos_doc_types iddt where iddt.dossier_name=:$column$.Dossier_Type Y 8 TRANSACTION_NUMBER Char varchar2 40 Y 9 DOSSIER_TRANSACTION_NAME Char varchar2 80 Y 10 DESCRIPTION Char varchar2 80 Y 11 STATUS Char varchar2 30 coalesce((select idth.trx_status from igi_dos_trx_headers idth where idth.trx_number=:$column$.Transaction_Number),'In Process') Y 12 PARENT_TRANSACTION_NUMBER Char varchar2 40 13 SOURCE_BUDGET LOV custom varchar2 25 Y select gbv.budget_name value, gbv.description from gl_budgets_v gbv where gbv.status in ('C','O') and (:$column$.Ledger_Name is null or gbv.ledger_name=:$column$.Ledger_Name) order by gbv.budget_name Y 14 SOURCE_PERIOD LOV custom varchar2 30 Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_ledgers gl, gl_period_statuses gps where gl.name=:$column$.Ledger_Name and gps.ledger_id=gl.ledger_id and gps.application_id=101 and gps.closing_status in ('O','F') order by gps.start_date desc Y 15 SOURCE_ACCOUNT LOV custom varchar2 311 Y select gcck.concatenated_segments value, gcck.description from gl_code_combinations_kfv gcck, igi_dos_doc_types iddt where iddt.dossier_name=:$column$.Dossier_Type and gcck.chart_of_accounts_id=iddt.coa_id and gcck.enabled_flag='Y' and gcck.summary_flag='N' order by gcck.concatenated_segments Y 16 SOURCE_BUDGET_AMOUNT Number number Y 17 SOURCE_FUNDS_AVAILABLE Number number xxen_igi_upload.source_funds_available(:$column$.Ledger_Name,:$column$.Dossier_Type,:$column$.Source_Budget,:$column$.Source_Period,:$column$.Source_Account) Y 18 SOURCE_NEW_BALANCE Number number xxen_igi_upload.source_funds_available(:$column$.Ledger_Name,:$column$.Dossier_Type,:$column$.Source_Budget,:$column$.Source_Period,:$column$.Source_Account)-:$column$.Source_Budget_Amount Y 19 DEST_BUDGET LOV custom varchar2 80 Y select gbv.budget_name value, gbv.description from gl_budgets_v gbv where gbv.status in ('C','O') and (:$column$.Ledger_Name is null or gbv.ledger_name=:$column$.Ledger_Name) order by gbv.budget_name Y 20 DEST_PERIOD LOV custom varchar2 30 Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_ledgers gl, gl_period_statuses gps where gl.name=:$column$.Ledger_Name and gps.ledger_id=gl.ledger_id and gps.application_id=101 and gps.closing_status in ('O','F') order by gps.start_date desc Y 21 DEST_ACCOUNT LOV custom varchar2 311 Y select gcck.concatenated_segments value, gcck.description from gl_code_combinations_kfv gcck, igi_dos_doc_types iddt where iddt.dossier_name=:$column$.Dossier_Type and gcck.chart_of_accounts_id=iddt.coa_id and gcck.enabled_flag='Y' and gcck.summary_flag='N' order by gcck.concatenated_segments Y 22 DEST_BUDGET_AMOUNT Number number Y 23 DEST_FUNDS_AVAILABLE Number number xxen_igi_upload.dest_funds_available(:$column$.Ledger_Name,:$column$.Dossier_Type,:$column$.Dest_Budget,:$column$.Dest_Period,:$column$.Dest_Account) Y 24 DEST_NEW_BALANCE Number number xxen_igi_upload.dest_funds_available(:$column$.Ledger_Name,:$column$.Dossier_Type,:$column$.Dest_Budget,:$column$.Dest_Period,:$column$.Dest_Account)-:$column$.Dest_Budget_Amount Y U 1 p_ledger_name in Char LEDGER_NAME U 2 p_dossier_name in Char DOSSIER_TYPE U 3 p_transaction_number in Char TRANSACTION_NUMBER U 4 p_transaction_name in Char DOSSIER_TRANSACTION_NAME U 5 p_description in Char DESCRIPTION U 6 p_parent_transaction_number in Char PARENT_TRANSACTION_NUMBER U 7 p_source_budget in Char SOURCE_BUDGET U 8 p_source_period in Char SOURCE_PERIOD U 9 p_source_account in Char SOURCE_ACCOUNT U 10 p_dest_budget in Char DEST_BUDGET U 11 p_dest_period in Char DEST_PERIOD U 12 p_dest_account in Char DEST_ACCOUNT U 13 p_dest_budget_amount in Number DEST_BUDGET_AMOUNT U 14 p_query_transaction_number in Char Y U 15 status_ out Char STATUS_CODE_ U 16 message_ out Char MESSAGE_ Error SQL Order By ledger_name, dossier_type, transaction_number, source_account, dest_account Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.ledger_name, xu.dossier_type, xu.amount_type, xu.transaction_number, xu.dossier_transaction_name, xu.description, xu.status, xu.parent_transaction_number, xu.source_budget, xu.source_period, gcck_s.concatenated_segments source_account, xu.source_budget_amount, xu.source_funds_available, xu.source_new_balance, xu.dest_budget, xu.dest_period, gcck_d.concatenated_segments dest_account, xu.dest_budget_amount, xu.dest_funds_available, xu.dest_new_balance from ( select xu.action_, xu.status_, xu.message_, xu.modified_columns_, gl.name ledger_name, iddt.dossier_name dossier_type, iddt.amount_type, idth.trx_number transaction_number, idth.dossier_transaction_name, idth.description, idth.trx_status status, idth.parent_trx_number parent_transaction_number, idts.budget_name source_budget, idts.period_name source_period, idts.budget_amount source_budget_amount, idts.funds_available source_funds_available, idts.new_balance source_new_balance, idtd.budget_name dest_budget, idtd.period_name dest_period, idtd.budget_amount dest_budget_amount, idtd.funds_available dest_funds_available, idtd.new_balance dest_new_balance, xu.source_account, xu.dest_account, idts.code_combination_id source_code_combination_id, idtd.code_combination_id dest_code_combination_id from xxen_igi_dossier_mainte_8049_u xu, igi_dos_trx_headers idth, igi_dos_doc_types iddt, gl_ledgers gl, igi_dos_trx_sources idts, igi_dos_trx_dest idtd where xu.status_code_=xxen_upload.status_success and xu.ledger_name=gl.name and xu.dossier_type=iddt.dossier_name and xu.transaction_number=idth.trx_number and idth.dossier_id=iddt.dossier_id and idth.sob_id=gl.ledger_id and idth.trx_id=idts.trx_id and idts.source_trx_id=idtd.source_trx_id and idth.trx_id=idtd.trx_id ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped gl_code_combinations_kfv gcck_s, gl_code_combinations_kfv gcck_d where xu.source_account=gcck_s.concatenated_segments(+) and xu.source_code_combination_id=gcck_s.code_combination_id(+) and xu.dest_account=gcck_d.concatenated_segments(+) and xu.dest_code_combination_id=gcck_d.code_combination_id(+)