My Oracle Support Banner

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:

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


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 (
Click Data Sources, then "Connection 1 (Database: Oracle)"
Click Index Database
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
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


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

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