GL Other - Calendar Validation

➜ Back to Library
Description
Categories: BI Publisher
Application: General Ledger
Source: Other - Calendar Validation Report (XML)
Short Name: GLXCLVAL_XML
DB package: GL_GLXCLVAL_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT 
       m1.period_set_name period_set_dg,
       m1.period_type period_type_dg,
       m2.period_name before_per_dg,
       m3.period_name after_per_dg, 
       m1.accounting_date gap_start_date_dg,
       m3.accounting_date-1 gap_end_date_dg
FROM   gl_date_period_map m1,
       gl_date_period_map m2,
       gl_date_period_map m3
WHERE
      m1.accounting_date between :date_low 
                                                  and :date_high
AND   m1.period_name = 'NOT ASSIGNED'
AND   m2.period_set_name = :periodset
AND   m2.period_type = :periodtype
AND   m2.accounting_date+0 between :date_low 
                                                    and :date_high
AND   m2.accounting_date = m1.accounting_date-1
AND   m2.period_name != 'NOT ASSIGNED'
AND   m3.period_set_name = :periodset
AND   m3.period_type = :periodtype
AND   m3.accounting_date =
       ( SELECT min(m4.accounting_date)
         FROM gl_date_period_map m4 
         WHERE m4.period_set_name = :periodset
         AND   m4.period_type = :periodtype
         AND   m4.accounting_date between 
                  m1.accounting_date and :date_high
         AND   m4.period_name != 'NOT ASSIGNED' ) 
 and m1.period_set_name=:periodset 
 and m1.period_type=:periodtype
ORDER BY m1.accounting_date
Parameter Name SQL text Validation
Calendar 
 
 LOV Oracle
Period Type 
 
 LOV Oracle
Year From 
 
 Number
Year To 
 
 Number
Download
 
Related Blitz Reports
GCS Data Submission Impacted Balances Data Source GCS Data Submission Impacted Balances Base Data Source JG EMEA VAT: Allocation Rules Listing ECC Enterprise Asset Management, Work Order Assets (Maintenance) GL Chart of Accounts - Mapping Rules GMF Accounting Unit Mapping ECC Project Procurement, Approved Supplier List ECC Inventory Management, Inventory Trace Suppliers GML OPM Apps Receipt Number
Blitz Report™

Blitz Report™ provides multiple benefits: