My Oracle Support Banner

FII_SNAPSHOT_TBL_C Load Snapshot Tables ORA-01403 (Doc ID 344874.1)

Last updated on SEPTEMBER 25, 2019

Applies to:

Oracle Financials Intelligence - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
FII_SNAPSHOT_TBL_C

Symptoms

+---------------------------------------------------------------------------+
Financial Intelligence: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FII_SNAPSHOT_TBL_C module: Load Snapshot Tables
+---------------------------------------------------------------------------+

Current system time is 13-DEC-2005 15:08:28

+---------------------------------------------------------------------------+

**Starts**13-DEC-2005 15:08:28
**Ends**13-DEC-2005 15:08:30
ORA-01403: no data found
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Entering Main
Calling Initialize
Debug On
Initialize: Now start processing...
Populating FII_GL_LOCAL_SNAP_F
> Entering REFRESH_GL_LOCAL_SNAP_F
>> l_this_date = 13-DEC-0x
>> l_year_id = xxxx
 
Please open the effected period and resubmit the request set.
Other error in Main
G_PHASE: Populate l_pp_this_date, l_pq_this_date, l_ly_this_date, l_this_date_gov
-->100:ORA-01403: no data found
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

 

Rows are present in:  

 FII_TIME_CAL_PERIOD
 FII_TIME_CAL_YEAR
   

but NOT in
    FII_TIME_ENT_PERIOD
    FII_TIME_ENT_YEAR
    FII_TIME_GL_PERIODS
    FII_TIME_MONTH
    FII_TIME_YEAR

And all periods are open

'Other - Calendar Validation Report' does not state unexpected issues or problems   

The value (date) of the Global Start Date parameter = 01/01/2005     3.

The first ever defined period in GL = JAN-2005

Changes

Upgrade of DBI to version 7.1

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
Changes
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.