PREV_STATUS Column in Table FM_STG_NFE Is Incorrectly Populated (Doc ID 1631770.1)

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.

Symptoms

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'.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms