Last updated on OCTOBER 02, 2014
Applies to:Oracle Utilities Work and Asset Management - Version 126.96.36.199 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 (188.8.131.52)
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms