Nota Fiscal TRAN_DATE Field Is Filled With SYSDATE Instead of Actual Transaction Date
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Fiscal Management - Version 13.2.5 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.
This article will be updated as official patch information becomes available.
In Oracle Retail Fiscal Management (RFM) 13.2.5, we find that NF (Nota Fiscal) are posted such that FM_TRAN_DATA.TRAN_DATE is populated with SYSDATE and not VDATE.
In FM_TRAN_DATA table, the column TRAN_DATE is filled with SYSDATE instead of the actual transaction date. This value is provided within FM_TRANDATA_POSTING_SQL.INSERT_TRAN_DATA. This results in FM_TRAN_DATA.TRAN_DATE being different from TRAN_DATA.TRAN_DATE.
Steps to Reproduce:
- Create a PO (Purchase Order).
- Register schedule and a Nota Fiscal.
- Receive in SIM. You can run the FM_TRAN_DATA batch on the next day.
- Note that TRAN_DATE field in FM_TRAN_DATA table is filled with SYSDATE and not VDATE.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms