IGC Contract Commitment Revaluation Fix Exception - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Contract Commitment
Source: Contract Commitment Revaluation Fix Exception Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGCCRVFR_XML
DB package: IGC_IGCCYRPR_XMLP_PKG
Run IGC Contract Commitment Revaluation Fix Exception - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
select  ige.cc_header_id "Contract Header ID"
          , igh.cc_type "Contract Type"
          , igh.cc_num "Contract Number"
          , iga.cc_acct_line_num "Account Line Number"
          , igf.cc_det_pf_line_num "Forecast Line Number"
          , ige.exception_reason  "Error Message"
from igc_cc_process_exceptions ige
      , igc_cc_headers igh
      , igc_cc_acct_lines iga
      , igc_cc_det_pf igf
where ige.set_of_books_id = :P_SET_OF_BOOKS_ID 
and ige.org_id = :P_ORG_ID
and ige.process_type = :P_PROCESS_TYPE
and ige.process_phase = :P_PROCESS_PHASE
and ige.request_id = :P_REQUEST_ID
and ige.cc_header_id = igh.cc_header_id(+)
and ige.cc_header_id = iga.cc_header_id(+)
and ige.cc_acct_line_id = iga.cc_acct_line_id(+)
and ige.cc_acct_line_id= igf.cc_acct_line_id(+)
and ige.cc_det_pf_line_id = igf.cc_det_pf_line_id(+)
Parameter Name SQL text Validation
Ledger Id 
 
 Number
Organization Id 
 
 Number
Process Phase 
 
 LOV Oracle
Process Type 
 
 Char
Request Id 
 
 Number
Download
Related Blitz Reports
IGC Contract Commitment Mass Payment Forecast Shift Exception Report- Not Supported: Reserved For Future Use IGC Contract Commitment Complete Cover Commitment Exception Report- Not Supported: Reserved For Future Use IGC Contract Commitment Revaluation Exception Report- Not Supported: Reserved For Future Use IGC Contract Commitment Open Interface Exception Report- Not Supported: Reserved For Future Use IGC Contract Commitment Archive Purge Report- Not Supported: Reserved For Future Use IGC Contract Commitment Display Results - draft ECC Projects, Projects Costing: Transactions, SQL1 PA Project Subledger: Detail by Project GL Journals - Entered Currency (132 Char)
Blitz Report™

Blitz Report™ provides multiple benefits: