Customer Address is incorrectly Fetched in RMA NFE and Ref Doc Fiscal Incorrect in Form (Doc ID 2143490.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Retail Fiscal Management - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

Customer Address is incorrectly fetched in RMA NFE

In Package FM_T_EXT_TAXES_SQL.LOAD_NF_OBJECT C_GET_ENTITY_ATTRIBUTES the cursor accesses the View v_fiscal_attributes that calls the view v_br_customer_fiscal_attrib.
The view v_br_customer_fiscal_attrib uses a "max" in "ordcust" to get customer address data being ordcust that is not the same note is originated and the RMA with the different address.

Steps to Reproduce:
1. Create a sales NF for any address;
2. Create another NF sale with a different address from the first to the same customer;
3. Create an RMA for the first note.

 

The Ref field. Fiscal document is displaying the fiscal_doc_id_ref instead of displaying the fiscal_doc_no for the user.

Steps to Reproduce :
Check the Ref field. The tax document any RMA note.

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