My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.