ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF973869E053B46B63588994Y select decode(exception_category, 'PRG_ACT_REQUIRED', 'Program Activity is required but is not configured on the Reporting Codes form ', 'OBJ_CLASS_REQUIRED', 'An Object Class Code is required but is not configured on the Reporting Codes form', 'MULTIPLE_PRG_ACT', 'More than one Program Activity is derived based on the configuration on the Reporting Codes form ', 'MULTIPLE_OBJ_CLASS', 'More than one Object Class Code is derived based on the configuration on the Reporting Codes form', exception_category) exception_category, AGENCY_IDENTIFIER AID ,ALLOC_XFER_AGENCY ATA ,AVAIL_INDICATOR AV ,begin_period_avail BPOA ,End_period_avail EPOA ,Sub_Account_Code SUB ,main_account_code MAIN ,ussgl_account USSGL ,Reimb_Indicator REIMB ,Object_Class_Code OCODE ,Prog_Reporting_Code PCODE ,Prog_Reporting_desc PROGDESC ,(SELECT concatenated_segments from gl_code_combinations_kfv where code_combination_id = ccid) CCID ,Attribute_value ATTV FROM fv_dact_exception_temp fvdp WHERE fvdp.ledger_id=:P_LEDGER_ID ORDER BY exception_category, AID,ATA,BPOA,EPOA,AV,MAIN,SUB, USSGL,REIMB,OCode,PCode FV FVDATAEXC US FV Data Act File Creation Exception Application: Federal Financials Source: Data Act File Creation Exception Report Short Name: FVDATAEXC DB package: BI Publisher :p_ledger_id 1 10 :p_ledger_id 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_id 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 Period 3 30 :p_report_type LOV Oracle FV_OPA_REPORT_TYPE Y select lookup_code id, description value, null description from fv_lookup_codes where lookup_type='FV_OPA_REPORT_TYPE' and enabled_flag='Y' and sysdate between start_date_active and nvl(end_date_active,sysdate+1) order by value,description US Report Type 4 40 :p_agency_id_low LOV Oracle FV_GTAS_AID_LOW Y select laid id, aid value, null description from (select distinct(treasury_dept_code) aid,treasury_dept_code laid,set_of_books_id from fv_facts_federal_accounts) where set_of_books_id=:$flex$.fv_srs_ledger_name order by aid US Agency Id Low 5 50 :p_agency_id_high LOV Oracle FV_GTAS_AID_HIGH Y select laid id, aid value, null description from (select distinct(treasury_dept_code) aid,treasury_dept_code laid,set_of_books_id from fv_facts_federal_accounts) where set_of_books_id=:$flex$.fv_srs_ledger_name and aid>=:$flex$.fv_gtas_aid_low order by aid US Agency Id High 6 60 :p_main_low LOV Oracle FV_GTAS_MAIN_ACCT_LOW Y select lmain id, main value, null description from (select distinct(treasury_acct_code) main,treasury_acct_code lmain,set_of_books_id from fv_facts_federal_accounts) where set_of_books_id=:$flex$.fv_srs_ledger_name order by main US Main Account Low 7 70 :p_main_high LOV Oracle FV_GTAS_MAIN_ACCT_HIGH Y select lmain id, main value, null description from (select distinct(treasury_acct_code) main,treasury_acct_code lmain,set_of_books_id from fv_facts_federal_accounts) where set_of_books_id=:$flex$.fv_srs_ledger_name and main>=:$flex$.fv_gtas_main_acct_low order by main US Main Account High