Supplier Conversion from Legacy System

Hi All,
I just completed converting suppliers/vendors from our old system to Oracle. All seems fine except if I go into Suppliers Inquiry in PO, and scroll (arrow down) thru the suppliers, if I hit one of the ones added during the conversion (some that were manually entered before the conversion was run already exist), and hit arrow-down to go to the next record, it prompts me to save or clear the record and wont let me continue. It is treating the record as if I just entered it. This isn't that big of a deal with the subset of 10 records that I am testing with, but I have to convert approx. 33,000 suppliers. Anyhelp is appreciated, greatly.

Juan

Is there a trigger associated with inserting new records to the suppliers table or a constraint that you turned off?

Run the trigger for each record you inserted (if it is feasible)- if it's now turned off - and check constraints. You may have created widows or orphans somehow.

After that I would guess there is some data in another table that is not there, part of the your data model, but not a constraint. If it is not obvious you will probably have to look at your Oracle Forms code.

Thanks Jim, but still have the problem after checking triggers and constraints....no triggers, and the only constraints are the required fields which wouldnt allow data to be written in the first place. Data model, and oracle forms code I dont know how to check.....I did check a view, ap_vendors_v, ran the select statement from sqlplus and it returned a row for each record added, so that was ok.....still looking for the solution unfortunately....Thanks again....

You have some sort of data problem in another table. IMO. You'll have to go into your form code, open the fmb file for the form that won't let you down arrow and start reading source.

Jim...Can you tell me how I get to the form code. Where it might be, the name of it.....Thanks

When you are in a form the name of the form is usually found in the upper left, in the title bar. Not always.

Source code for forms is <filename>.fmb .fmx is the executable version. If you have really old code, legacy, you probably have version 5 Oracle Forms. You will need to have Oracle Forms (v5 or v6) to be able to open the file.

Where the forms code directory is located, I don't know. There may not be one. -- Depending on the paranoia level or business model of your vendor. You can also check your distribution media from the legacy application. When the app was installed, there may have been an option to install forms source - or not.

If you have a legacy app that is no longer supported AND you do not have the source code, your company is up the creek. I can't imagine a company would predicate it's business on an unsupportable app, but it has happened before.