E1: 42: Sales Ledger Time (F42199.TDAY) is Updated With 61 Seconds (i.e. 100361) (Doc ID 2746166.1)

Last updated on JANUARY 31, 2023

Applies to:

Symptoms

When a Direct Ship Order has two partial receipts of quantity 1 each processed by EDI Shipping Notice Edit/Create (R47031), the program will split the sales order into three lines, one line for each of the two serial numbers received and one line for the unreceived quantity. If the transaction occurs as the time reaches 59 seconds, when writing last Sales Ledger record WriteSalesHistoryorLedger (B4200260) Business function will increment the seconds by '2' causing 61 seconds to be written in the Sales Ledger Time of Day field (F42199.TDAY). For example we can see the Time Of Day going from 10:03:59 to 10:03:61 on a Sales Ledger record for the one sales ledger line.

This issue was supposed to have been fixed by Bug 23760946 - F42199 TABLE TDAY FIELD UPDATED WITH INCORRECT SECONDS VALUE, but it was not fixed for the situation where multiple sales ledger lines were written due to a line split.

Changes

Cause

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