We currently have a VB/SQL 2000 program that populates the Paymix tables in Oracle with timecard records. However, we need to convert this program to populate the BEE tables in 11i. I planned on changing the data to the proper format then append it directly to the BEE tables but I am running into problems. I have changed the SQL stored procedures to create records for the PAY_BATCH_HEADERS & PAY_BATCH_LINES tables but I am unable to figure out how to create the batch and batch line IDs. I tried to used the max value in the table and then increment it for the new records but run into duplicate index problems when users manually enter batches within Oracle.
I have heard of the Oracle APIs but I am not sure how I can use them since we do not use Oracle Developer.
If anyone knows how Oracle generates the new Batch Ids or how to use the Oracle API within VB your help would be greatly appreciated. Thanks.
Jeff
I have heard of the Oracle APIs but I am not sure how I can use them since we do not use Oracle Developer.
If anyone knows how Oracle generates the new Batch Ids or how to use the Oracle API within VB your help would be greatly appreciated. Thanks.
Jeff