Physical Inventory Comparison Program Overwrites Differing Tag Number

(Doc ID 2310988.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

When in the process of running the Physical Inventory Comparison Program and entering a tag number for an existing asset that differs from the tag number that is in the application for the asset, why does the fapicmp.sql script cause the tag number in the fa_inv_interface table to be overwritten with the tag number already in the system in the fa_additions_b table?
 

Solution

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