R12 APXINWKB APP-SQLAP-10006: The date you entered is not in an open accounting period. Open the period in the Control Payables Periods window. (Doc ID 1964513.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When creating invoices in AP which use deferred accounting feature
(Multiperiod accounting in SLA), the Deferred Start date column does not
allow use of any date which falls in a closed or never opened AP period.
However, there are many business cases where the invoices for such services
are received later, while the service itself starts from an earlier date.

The following error is encountered:

APP-SQLAP-10006: The date you entered is not in an open accounting period. Open the period in the Control Payables Periods window.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms