My Oracle Support Banner

FM_EDI_VALIDATION_SQL should also Process Items with Origin_Country other than 'BR' (Doc ID 2621668.1)

Last updated on DECEMBER 23, 2019

Applies to:

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

Symptoms

Item/Supp/Country validation in FM_EDI_VALIDATION

EDI NFs for imported scenarios can't be processed unless the relation item/supp/country of 'BR' is created.

Currently there is a validation in FM_EDI_VALIDATION_SQL that is processing only items that have a item/supp/country relation with 'origin_country_id = 'BR', and this is not correct because in imported scenarios that can be items with origin_country different than 'BR'.

A similar issue is corrected by <Patch 24308434> (GET UNIT_COST OF ITEM IMPORTED).

Workaround is same as <Patch 24308434>, but this need a solution


Steps required to reproduce this issue.
1) Import NF from partner in EDI tables with items with no item/supp/country = 'BR' relations.
2) Run fmedinf

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