ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF9C3869E053B46B63588994 select decode(record_category, 'GTAS_UNDEFINED', 'Account not defined on GTAS Attributes', 'USSGL_MULTIPLE_PARENTS', 'Multiple US SGL Account Parents Defined', 'NON_USSGL_ACCT', 'Not a Valid US SGL Account', 'USSGL_DISABLED', 'Disabled US SGL Account', 'EXCH_NON_EXCH_MULTIPLE', 'Only one Exchange or Non-exchange Code must be defined for GL Account', 'CUST_NON_CUST_INVALID', 'Custodial or Noncustodial Code not valid for GL Account', 'APPOR_CAT_INVALID', 'Apportionment Category Code not valid for GL Account', 'APPOR_CATB_MISSING', 'Apportionment Category B Code is Required', 'PRC_MISSING', 'Program Reporting Category Code is Required', 'BEA_CATEGORY BEA', 'Category Code not valid for GL Account', 'BORR_SOURCE_INVALID', 'Borrowing Source Code not valid for GL Account' , 'PYA_MULTIPLE', 'Only one Prior Year Adjustment Code must be defined for GL Account' , 'DIREC_REIMB_INVALID', 'Direct or Reimbursable Code not valid for GL Account', 'PCI_INVALID', 'Program Cost Indicator not valid for GL Account', 'CURR_SUB_INVALID', 'Only one Current or Subsequent Code must be defined for GL Account', 'INVALID_AUTH_TYPE_CODE', 'The derived Authority Type Code derived is not valid for the GL Account based on the GTAS Attribute valid values', 'INVALID_FED_NONFED_CODE', 'The Federal or Non-Federal Code derived based on the Customer Supplier is not valid for the GL Account base on the Federal or Non-Federal Code GTAS Attribute values', 'TP_AID_NOT_IN_RANGE', 'The Trading Partner Agency ID must between "001" and "999" if derived Federal or Non-Federal Code is "F" and the Trading Partner Checkbox is checked', 'TP_MAIN_ACCT_NOT_IN_RANGE', 'The Trading Partner Main Account must between "0000" and "9999" if derived Federal or Non-Federal Code is "F" and the Trading Partner Checkbox is checked', record_category) record_category, tas.dept_transfer, tas.department_id, tas.established_fiscal_yr, tas.end_year_avail, tas.availability_type_code, tas.fund_group_code, tas.TAFS_SUB_ACCT, tas.treasury_symbol, r.fund_value, r.amount, r.AUTHORITY_TYPE_CODE, r.DIRECT_OR_REIMB_CODE, r.APPOR_CAT_CODE, r.APPOR_CAT_B_CODE, r.PROGRAM_REPT_CODE, r.FED_NON_FED, r.TRADING_PARTNER_AGENCY_ID, r.TRADING_PARTNER_MAIN_ACCOUNT, r.NEW_BAL_CODE, r.CUR_SUBSEQUENT_CODE, r.BEA_CAT_CODE, r.BORR_SRC_CODE, r.EXCH_NON_EXCH, r.CUST_NON_CUST, r.BUDGET_IMPACT_IND, r.PYA_CODE, r.CREDIT_COHORT_YR, r.PROGRAM_COST_IND, r.REDUCTION_TYPE_CODE, r.USSGL_ACCOUNT FROM fv_gtas1_report_t2 r, fv_treasury_symbols tas WHERE r.set_of_books_id = :P_LEDGER AND r.reported_status = 'E' AND r.treasury_symbol_id = tas.treasury_symbol_id GROUP BY r.USSGL_ACCOUNT, r.record_category, tas.dept_transfer, tas.department_id, tas.established_fiscal_yr, tas.end_year_avail, tas.availability_type_code, tas.fund_group_code, tas.TAFS_SUB_ACCT, tas.treasury_symbol, r.fund_value,r.amount,r.AUTHORITY_TYPE_CODE, r.DIRECT_OR_REIMB_CODE,r.APPOR_CAT_CODE,r.APPOR_CAT_B_CODE, r.PROGRAM_REPT_CODE, r.FED_NON_FED,r.TRADING_PARTNER_AGENCY_ID, r.TRADING_PARTNER_MAIN_ACCOUNT, r.NEW_BAL_CODE,r.CUR_SUBSEQUENT_CODE,r.BEA_CAT_CODE,r.BORR_SRC_CODE, r.EXCH_NON_EXCH,r.CUST_NON_CUST,r.BUDGET_IMPACT_IND,r.PYA_CODE, r.CREDIT_COHORT_YR,r.PROGRAM_COST_IND,r.REDUCTION_TYPE_CODE ORDER BY r.USSGL_ACCOUNT, r.record_category, tas.dept_transfer, tas.department_id, tas.established_fiscal_yr, tas.end_year_avail, tas.availability_type_code, tas.fund_group_code, tas.TAFS_SUB_ACCT, tas.treasury_symbol, r.fund_value Y FV FVGTINTEXC Y US FV GTAS Interface Exception Application: Federal Financials Source: GTAS Interface Exception Report Short Name: FVGTINTEXC 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 3 30 :p_agency_id_low Char US Agency ID Low 4 40 :p_agency_id_high Char US Agency ID High 5 50 :p_main_account_low Char US Main Account Low 6 60 :p_main_account_high Char US Main Account High :$flex$.fv_srs_ledger_name Ledger To Period