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 188.8.131.52 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 (184.108.40.206)
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:
Enter Inventory No
Enter Stock Code
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