FV Object Class and Program Activity Exception

➜ Back to Library
Description
Categories: BI Publisher
Application: Federal Financials
Source: Object Class and Program Activity Exception Report
Short Name: FVOPAREXC
DB package:
Run FV Object Class and Program Activity 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
FROM fv_opa_exception_temp fvop
WHERE fvop.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
Download
Related Blitz Reports
FV Object Class and Program Activity FV Data Act File Creation Exception FV GTAS Activity Balance Exception FV Party Trading Partner TAS Not Found FV Party Trading Partner TAS FV Data Act File A FV Data Act File C Balances FV Data Act File B FV Data Act File C Activity
Blitz Report™

Blitz Report™ provides multiple benefits: