My Oracle Support Banner

Dealmain Form Does Not Populate Correct Next Invoice Date (Doc ID 2635719.1)

Last updated on FEBRUARY 11, 2020

Applies to:

Oracle Retail Merchandising System - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 14.1.3 version, Batches

ACTUAL BEHAVIOR
---------------
dealmain form does not populate correct dates (Est.Next Invoice date).

Calendar start_of_half_month is set up as 2 in system options. and calendar data was populated as below.


23-DEC-18 2019 1 5
27-JAN-19 2019 2 4
24-FEB-19 2019 3 4
24-MAR-192019 4 5
28-APR-19 2019 5 4
26-MAY-192019 6 4
23-JUN-19 2019 7 5
28-JUL-19 2019 8 4
25-AUG-19 2019 9 4
22-SEP-19 2019 10 5
27-OCT-19 2019 11 4
24-NOV-192019 12 4

22-DEC-19 2020 1 5
26-JAN-20 2020 2 4
23-FEB-20 2020 3 4
22-MAR-202020 4 5
26-APR-20 2020 5 4
24-MAY-202020 6 4
21-JUN-20 2020 7 5
26-JUL-20 2020 8 4
23-AUG-20 2020 9 4
20-SEP-20 2020 10 5
25-OCT-20 2020 11 4
22-NOV-202020 12 5

EXPECTED BEHAVIOR
-----------------------
since 26-JAN-20 is the first day of fiscal year, the Est.Next Invoice date should have been Jan 25th 2020

Steps to reproduce:


1. Create any bill back rebate type deal. Enter necessary data inputs on deal head tab.
2 .Choose bill back deal reporting level = Month on Bill Back Tab
3. Go to Financials Bill Back Period Tab. Choose Bill back period as Annual.
4. Notice that, Est.Next Invoice date =Dec 21st 2019. Where as it should have been Jan 25th 2020 as per 445 calendar set up.


Changes

 

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.