My Oracle Support Banner

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

Last updated on JANUARY 22, 2021

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.

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

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.