IGC Contract Commitment Open Interface Exception Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Contract Commitment Open Interface Exception Report
Application: Contract Commitment
Source: Contract Commitment Open Interface Exception Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGCCLDER_XML
DB package: IGC_IGCCLDER_XMLP_PKG
Run IGC Contract Commitment Open Interface Exception Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
select  ige.interface_header_id "Interface Header ID"
          , ige.interface_acct_line_id "Interface Account Line ID"
          , ige.interface_det_pf_line_id "Payment Forecast ID"
          , igh.cc_num "Contract Number"
          , iga.cc_acct_line_num "Account Line Number"
          , igf.cc_det_pf_line_num "Forecast Line Number"
          , ige.error_message "Error Message"
from igc_cc_interface_errors ige
      , igc_cc_headers_interface igh
      , igc_cc_acct_lines_interface iga
      , igc_cc_det_pf_interface igf
where ige.batch_id = :P_batch_id
and ige.interface_header_id = igh.interface_header_id(+)
and ige.interface_header_id = iga.interface_header_id(+)
and ige.interface_acct_line_id = iga.interface_acct_line_id(+)
and ige.interface_acct_line_id= igf.interface_acct_line_id(+)
and ige.interface_det_pf_line_id = igf.interface_det_pf_line_id(+)
order by ige.interface_header_id
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
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 Fix Exception - draft IGC Contract Commitment Revaluation Exception Report- Not Supported: Reserved For Future Use IGC Contract Commitment Archive Purge Report- Not Supported: Reserved For Future Use ECC Projects, Projects Costing: Transactions, SQL1 INV Print Cycle Count Entries Open Interface data AR Transactions and Lines XX AR Transactions and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: