RFGen Physical Inventory Error - New Count Quantity Differs from Inventory Quantity. Would you Like to Recount? (Doc ID 1931842.1)

Last updated on JANUARY 24, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.