RFGen Physical Inventory Error - New Count Quantity Differs from Inventory Quantity. Would you Like to Recount?

(Doc ID 1931842.1)

Last updated on OCTOBER 02, 2014

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.1.1 and later
Information in this document applies to any platform.

Symptoms

Error when using RFgen to perform Physical Inventory: "New Count Quantity differs from Inventory Quantity. Would you like to recount?" 

However, in WAM, the same count that was added in RFGen can be added via the application and the application takes it with no recount errors.

Steps to replicate:

SQL (run in SQL developer, Toad, etc.)
create user LiveBackup1 identified by x;
alter user LiveBackup1 quota unlimited on users;
create table LiveBackup1.sa_storeroom as select * from synergen.sa_storeroom;
Start RFgen Programmer's Assistant (3.2.1.28)
Click Data Sources, then "Connection 1 (Database: Oracle)"
Click Index Database
In SQL:
drop table LiveBackup1.sa_storeroom; (so that you will get error that it does not exist; alternatively, you can change a value in it and then you will see in RFGen that it is showing the value from the backup and not the live value)
In RFgen Programmer's Assistant:
Log in
choose storeroom
MAIN MENU
PHYSICAL INVENTORY
Enter Inventory No
Enter Stock Code
Enter Quantity
Get error "New Count Quantity differs from Inventory Quantity. Would you like to recount!"
Click on "Reports", then "View Error/Event Logs"
You will see this error:
Failed: select inventory_quantity,lot_ind,average_unit_price from LIVEBACKUP1.SA_STOREROOM where plant='01' and storeroom='ZSR' and stock_code='0000040828'
Reason: -2147217865 (942) [Oracle][ODBC][Ora]ORA-00942: table or view does not exist

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