My Oracle Support Banner

R12: HH:MI:SS Portion of Date Attributes Should Default to 00:00:00 (Doc ID 1080909.1)

Last updated on MARCH 18, 2019

Applies to:

Oracle Enterprise Performance Foundation - Version 12.0.4 and later
Information in this document applies to any platform.
FEM

Symptoms

On EPF 12.0.4 or 12.1.2, when creating a new Calendar Period dimension member using the Dimension Hierarchy Manager (DHM) User Interface  (UI) "Create" button, the Calendar tool automatically populates time stamps with the current time instead of 00:00.

This issue was already fixed in 11i as per Internal Bug: 4547847 fem.d - hh:mi:ss portion of date attributes should default to 00:00:00.

The above causes issues when doing an data loads using that calendar period.

EXPECTED BEHAVIOR
Expect the time stamp to default to 00:00:00.

STEPS

The issue can be reproduced at will with the following steps:
1. Enterprise Performance Foundation (EPF) Administrator -> Dimension -> Calendar Period -> Members
2. Create
3. Do not copy attributes
4. Choose a date for Calendar Period Start Date and Calendar Period End Date using the Calendar tool

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.