FV GTAS Interface Exception

Description
Categories: BI Publisher, Financials
Application: Federal Financials
Source: GTAS Interface Exception Report
Short Name: FVGTINTEXC
DB package:
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
Parameter Name SQL text Validation
Main Account High
 
Main Account Low
 
Agency ID High
 
Agency ID Low
 
To Period
 
LOV Oracle
Ledger
 
LOV Oracle