AP Period Close Exceptions

Description

Categories
Enginatics, R12 only
Source
Period Close Exceptions Report (XML)
Short Name
APXPCER
DB package
ap_period_close_pkg
Repository
GitHub
Based on Oracle standard Period Close Exceptions Report

SQL 421 lines

Parameters 7

ParameterTypeList of values SQL
LedgerLOV
x.ledger=:p_ledger
Operating UnitLOV
x.operating_unit=:p_operating_unit
Exception TypeLOV
x.exception_type=:p_exception_type
Period NameLOV
From Accounting DateDate
aid.accounting_date>=:p_period_start_date
To Accounting DateDate
aid.accounting_date<:p_period_end_date+1
SupplierLOV
x.supplier_name=:p_supplier_name