My Oracle Support Banner

FASLSCAL: Calendar Listing Cannot Show the Last Period of Fiscal Year (Doc ID 2542903.1)

Last updated on AUGUST 19, 2020

Applies to:

Oracle Assets - Version 12.1 and later
Information in this document applies to any platform.


Calendar Listing (FASLSCAL) cannot show the last period when the start date of the last period is the same as the last day of fiscal year.

Steps to Reproduce
1.  Create a Fiscal Year

    Go to (N)Setup > Asset System > Fiscal Years

    From Date    To Date      Mid Year  Start Date  Fiscal Year
    -----------  -----------  --------------------  -----------
    01-JAN-2019  31-DEC-2019                               2019

    * The last day of fiscal year is "31-DEC-2019"

2.  Create a Calendar

    Go to (N)Setup > Asset System > Calendars

    Number  Name    From Date    To Date      
    ------  ------  -----------  -----------  
         1  P1-19   01-JAN-2019  31-JAN-2019  
         2  P2-19   01-FEB-2019  28-FEB-2019  
         3  P3-19   01-MAR-2019  31-MAR-2019  
         4  P4-19   01-APR-2019  30-APR-2019  
         5  P5-19   01-MAY-2019  31-MAY-2019  
         6  P6-19   01-JUN-2019  30-JUN-2019  
         7  P7-19   01-JUL-2019  31-JUL-2019  
         8  P8-19   01-AUG-2019  31-AUG-2019  
         9  P9-19   01-SEP-2019  30-SEP-2019  
        10  P10-19  01-OCT-2019  31-OCT-2019  
        11  P11-19  01-NOV-2019  30-DEC-2019  
        12  P12-19  31-DEC-2019  31-DEC-2019  <--- *** Point ***

    * The start date of the last period is "31-DEC-2019"

3.  Run Calendar Listing

    Calendar Listing

    Period Number Period Name     From Date   To Date
    ------------- --------------- ----------- -----------
    1             P1-19           01-JAN-2019 31-JAN-2019
    2             P2-19           01-FEB-2019 28-FEB-2019
    3             P3-19           01-MAR-2019 31-MAR-2019
    4             P4-19           01-APR-2019 30-APR-2019
    5             P5-19           01-MAY-2019 31-MAY-2019
    6             P6-19           01-JUN-2019 30-JUN-2019
    7             P7-19           01-JUL-2019 31-JUL-2019
    8             P8-19           01-AUG-2019 31-AUG-2019
    9             P9-19           01-SEP-2019 30-SEP-2019
    10            P10-19          01-OCT-2019 31-OCT-2019
    11            P11-19          01-NOV-2019 30-DEC-2019

Result : The period "P12-19" is NOT showing.  It should be shown.




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

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