FV Data Act File Creation Exception

Description
Categories: BI Publisher, Financials
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
Main Account High
 
LOV Oracle
Main Account Low
 
LOV Oracle
Agency Id High
 
LOV Oracle
Agency Id Low
 
LOV Oracle
Report Type
 
LOV Oracle
Period
 
LOV Oracle
Ledger_id
 
LOV Oracle