Calendar Period Dimension Member Loader Receiving INVALID_DATE, INVALID_MEMBER Errors (Doc ID 343044.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
FEM

Symptoms

When trying to run the Calendar Period Dimension Member Loader in FEM D Rollup #2, the following error is found in the log file:

Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Request 256351 (Pre_Validation):
All sub-requests completed normally.

Request 256351 (New_Members):
All sub-requests completed normally.

Request 256351 (Base_Update):
All sub-requests completed normally.

Request 256351 (TL_Update):
All sub-requests completed normally.

Request 256351 (Pre_Validation_Attr):
All sub-requests completed normally.

Request 256351 (Attr_Assign_Update):
All sub-requests completed normally.

Request 256351 (Post_Cal_Periods):
All sub-requests completed normally.

0 rows loaded successfully.
187 rows failed to load successfully.

The execution produced errors. Correct the errors and rerun.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE

ERROR
0 rows loaded successfully.
187 rows failed to load successfully.


STEPS
1. Load Calendar period data into Interface tables.
2. Execute request
Enterprise Performance Foundation Administrator(1) > Process Management > Requests > Submit Request >
Program Name: Dimension Member Loader
Request Name: Load Calendar Period
Execution Mode: Snapshot
Dimension: Calendar Period
3. Start request and receive the error

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