FV Data Act File Creation Exception

Description
Categories: BI Publisher
Columns: Exception Category, Aid, Ata, Av, Bpoa, Epoa, Sub, Main, Ussgl, Reimb ...
Application: Federal Financials
Source: Data Act File Creation Exception Report
Short Name: FVDATAEXC
DB package:
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
Parameter Name SQL text Validation
Ledger_id
 
LOV Oracle
Period
 
LOV Oracle
Report Type
 
LOV Oracle
Agency Id Low
 
LOV Oracle
Agency Id High
 
LOV Oracle
Main Account Low
 
LOV Oracle
Main Account High
 
LOV Oracle