When Is EFFECTIVE_T Populated in the JOURNAL_T Table? (Doc ID 2321890.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Goal

When is EFFECTIVE_T populated in the JOURNAL_T table in the following scenarios?

Once the feature is enabled, the following tests were performed, are these the expected results?
   a. A one-time event (purchase fee event) having END_T as 10-Oct was generated on 10-Oct, which would create a JOURNAL_T entry with EFFECTIVE_T = 1-Oct-2017.
   b. A one-time event (purchase fee event) having END_T as 1-Nov was generated on 1-Nov, which would create a new JOURNAL_T entry with EFFECTIVE_T = 1-Nov-2017.
   c. A one-time event (purchase fee event) having END_T as 31-Oct was generated on 1-Nov, which would update existing JOURNAL_T entry with EFFECTIVE_T = 1-Oct-2017.

Solution

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