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.

Symptoms

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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