PREV_STATUS Column in Table FM_STG_NFE Is Incorrectly Populated
(Doc ID 1631770.1)
Last updated on MARCH 10, 2019
Applies to:Oracle Retail Fiscal Management - Version 13.2.5 and later
Information in this document applies to any platform.
In Oracle Retail Fiscal Management (RFM) 13.2.x, while bringing the Nota Fiscal(NF) back to Worksheet status and re-approving, the PREV_STATUS column in table FM_STG_NFE is incorrectly populated.
Steps to Reproduce:
1. Find a Nota Fiscal (NF) in 'NFE_P' status.
2. Error out the NF.
3. Check the FM_STG_NFE table. The PREV_STATUS column shows value as 'NFE_P' and status as 'E'. This is correct.
4. Now bring the NF back to Worksheet status and re-approve.
5. Note that the NF goes to 'NFE_P' status. However, observe the PREV_STATUS and STATUS columns in the table FM_STG_NFE. Both are now populated as 'NFE_X'. This is incorrect; the PREV_STATUS column should have value as 'E', and the current status should be 'NFE_X'.
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