ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF983869E053B46B63588994Y SELECT je_source, je_category, account_number ,sgl_acct_num ,amount ,doc_num ,trading_partner_name ,trading_partner_agency_id ,trading_partner_main_account ,bud_trx_type, DECODE(exception_category, 'NO_SINGLE_AUTH_TYPE_CODE','A single Authority Type Code cannot be derived from the GL Account' ,'INVALID_AUTH_TYPE_CODE','Invalid Authority Type Code' ,'INVALID_AUTH_TYPE_CODE_SUB','Budget Transaction Sub Type Authority Type Code Does not Match GTAS Authority Type Code GL Attribute' ,'INVALID_AUTH_TYPE_CODE_TRX','Budget Transaction Type Authority Type Code Does not Match GTAS Authority Type Code GL Attribute' ,'FED_TP_MUST_HAVE_AGENCY_ID','Federal Trading Partner must have an Agency ID between 000-999' ,'INVALID_FED_NONFED_CODE','Trading Partner not Compatible with the GTAS Federal or Non-Federal Code GL Attribute' ,'INVALID_FED_NONFED_CODE_TAS','Trading Partner not Compatible with the GTAS Federal or Non-Federal Code GL Attribute and/or TAS' ,'INVALID_BUD_IMPACT_IND','Derived Budget Impact Indicator not valid for GL Account' ,'INVALID_GL_REFERENCE_INFOMATION','Invalid General Ledger reference information' ,'FED_ACCT_SYM_NOT_FOUND','Trading Partner Treasury Account Symbol not found' ,'PARTY_INFO_NOT_FOUND','Party information not found' ,'NO_REDUCTION_TYPE_CODE','Reduction Type code cannnot be derived' ,exception_category) exception_category1 FROM fv_gtas_exceptions WHERE set_of_books_id = :P_LEDGER ORDER BY je_source, je_category, exception_category FV FVGTACTBALEXC US FV GTAS Activity Balance Exception Application: Federal Financials Source: GTAS Activity Balance Exception Report Short Name: FVGTACTBALEXC DB package: BI Publisher :p_ledger 1 10 :p_ledger LOV Oracle FV_SRS_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers_public_v l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id and l.ledger_category_code='PRIMARY' order by name US Ledger 2 20 :p_period_name LOV Oracle FV_GTAS_ACT_TO_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses where set_of_books_id=:$flex$.fv_srs_ledger_name and application_id=101 and closing_status in ('O','C') and period_year in (select distinct fiscal_year from fv_gtas_run where set_of_books_id=:$flex$.fv_srs_ledger_name) order by value,description US To Period