Reports2017-11-18T12:27:27+00:00

FV Object Class and Program Activity Exception

Description
Categories: BI Publisher, Financials
Application: Federal Financials
Source: Object Class and Program Activity Exception Report
Short Name: FVOPAREXC
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
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
Report Type
 
LOV Oracle
Period
 
LOV Oracle
Ledger ID
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept