FUSION: RCV: Transaction Date Time Is Changed Unintentionally on Review Receipts Interface ADFdi (Doc ID 2711743.1)

Last updated on OCTOBER 05, 2020

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When upload the record via Review Receipts Interface ADFDi, the TIME of transaction date will change unintentionally.

When importing receiving transaction in FBDI, if the time of RCV_TRANSACTIONS_INTERFACE.Transaction Date has been set "13:00", then this record that is downloaded by Review Receipts Interface ADFDi due to any errors etc is internally set the time of Transaction date to "9:00" on the spreadsheet in case of Japanese customers.

So if upload it as it is, the time of transaction date in created receiving transaction will be set 9:00 unintentionally.

The "9:00" would be set as based on Local customer locale settings, but "13:00" as DB date time is also ignored after all.


EXPECTED BEHAVIOR
-----------------------
On ADFdi, "TIME" of Transaction Date should be set based on DB date time. In this case, 13:00 should not be ignored.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Generate CSV file from Receiving Open Interface(ReceivingReceiptImportTemplate.xlsm) as RCV_TRANSACTIONS_INTERFACE. Transaction Date is "2020/7/27 13:00:00"
2. Upload the CSV file
3. Run Load Interface File for Import
4. Run Manage Receiving Transactions, then any error occurs. Note: In that time, user can confirm that Transaction date is set as "2020-07-27T13:00:00.000+00:00" in RCV_TRANSACTIONS_INTERFACE in DB via BI Publisher
5. Download Review Receipts Interface ADFDi
6. Search error records, Transaction Date field shows only date value like "2020/7/27". However, if click the Transaction Date field and check whole the value, we can see that it is "2020/7/27 9:00:00" automatically regardless of date time on DB.
7. Then update with the Transaction Date value as it is, so the Transaction Date of the created Receiving transaction will be changed to "2020/7/27 9:00:00".

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.