ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF9E3869E053B46B63588994Y 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 FROM fv_opa_exception_temp fvop WHERE fvop.ledger_id=:P_LEDGER_ID ORDER BY exception_category, AID,ATA,BPOA,EPOA,AV,MAIN,SUB, USSGL,REIMB,OCode,PCode FV FVOPAREXC US FV Object Class and Program Activity Exception Application: Federal Financials Source: Object Class and Program Activity Exception Report Short Name: FVOPAREXC 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