My Oracle Support Banner

R12.1- APXRICAD- Error APP-SQLAP-10227 While creating Recurring Invoice Template (Doc ID 968016.1)

Last updated on MARCH 06, 2019

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
APXRICAD.fmb


Symptoms

Problem Statement:

On Applications <12.1.1> :

When attempting to Create Recurring Invoice Template and Enter the Number of Periods Associated with Special Calendar, the following error occurs.

Error:

APP-SQLAP-10227: THE NUMBER OF PERIODS THAT YOU ENTERED EXCEEDS THE NUMBER OF PERIODS DEFINED FOR THIS PERIOD TYPE.

Steps:

The issue can be reproduced at will with the following steps.

1. Create a Special Calender with 12 Periods. Starting Period is Jan-09.
   Ending Period is Dec-09.
2. Navigated to Recurring Invoice Template
3. Selected my Speical Calender Name from the Name LOV
4. Entered 12 in the Number of Periods LOV.


Business Impact:


The issue has the following business impact:
Due to this issue, users cannot create Recurring Invoice Templates.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.