Customer Address is incorrectly Fetched in RMA NFE and Ref Doc Fiscal Incorrect in Form
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.
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.
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