PREV_STATUS Column in Table FM_STG_NFE Is Incorrectly Populated
Last updated on JULY 10, 2017
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 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'.
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