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:
Run FV Data Act File Creation Exception and other Oracle EBS reports with Blitz Report™ on our demo environment
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
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 ECC Projects, Projects Costing: Transactions, SQL1 COPY OF: INV Inventory Item Upload INV Inventory Item Upload
Blitz Report™

Blitz Report™ provides multiple benefits: