FV Data Act File Creation Exception

➜ Back to Library
Description
Categories: BI Publisher
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 NameSQL textValidation
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
Download
Related Blitz Reports
FV Data Act File C Activity FV Data Act File C Balances FV Data Act File B FV Data Act File A FV Object Class and Program Activity Exception AP Supplier Upload ZX US Sales Tax INV Item Upload COPY OF: AP Supplier Upload
Blitz Report™