GPFRA: DSN - Store GPFR_DSN_LASTW_DAY And GPFR_DSN_NEXTW_DAY In GPFR_DSN_AB_TMP (Doc ID 2880367.1)

Last updated on JULY 06, 2022

Applies to:

Goal

Enhancement request:

1. In the DSN, the initial step selects and stores absences in GPFR_DSN_AB_TMP
2. After the DSN step which populates GPFR_AF_EXTRACT the DSN, calculates GPFR_DSN_LASTW_DAY and GPFR_DSN_NEXTW_DAY.

There is a requirement that the GPFR_DSN_LASTW_DAY and GPFR_DSN_NEXTW_DAY are stored in the table GPFR_DSN_AB_TMP in the initial step.
In this way, the DSN process will be simplified.
 

Solution

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