Oracle Financials 9 - Newbie Question
Date: Thu, 28 Apr 94 00:41:48 GMT
Message-ID: <767493708.107snx_at_aleytys.pc.my>
Hi!
We are porting our inventory system from a COBOL (blech!) based system running on a IBM S/36 - flat files and all that - to Oracle Financials 9 / Oracle 7 RDBMS / Sun Sparcserver 1000 / Solaris 2.2.
Our current inventory item code has three (3) segments of 4/4/5 digits. We want to move the data intact over to our new system. In Oracle Inventory the item code is a "Key Flexfield" in Oraclespeak. Oracle Financials enforces the rule that the item code is unique (no problem there). It also enforces the unique rule for *each* segment. That means that all values entered in a particular segment must be unique. In each segment a value is entered as a code/description pair
The problem: Our current data is in the form of:
wwww-xxxx-00001 (e.g. steel bolt) yyyy-zzzz-00001 (e.g. 3 phase motor) wwww-xxxx-00002 yyyy-zzzz-00002 wwww-xxxx-00003 yyyy-zzzz-00003 wwww-xxxx-..etc yyyy-zzzz-..etc
The 00001 in wwww-xxxx is totally unrelated to the 00001 in yyyyzzzz. The restriction of one unique value (00001) and corresponding
description in each of segments TWO and THREE is a real pain. ^^^^^^^^^^^
Obviously when our people call up item yyyy-zzzz-00001 they don't want to see "steel bolt" when it is an electric motor!
The real solution, of course, is to take this "opportunity" to do a massive conversion exercise to a totally new set of item codes (currently about 12,000 and growing). Originally , however our engineers said that they did not have the manpower. We originally compromised by agreeing to move over all our item codes intact then the Store and Engineering departments would create new item codes and move the items from the old-->new codes piecemeal (the old and new codes occupying the same value space).
However none of us (including the Oracle Consultant) noticed this problem until I tried entering a few values to test the system. Conversion and testing of our 12,000 inventory and non-stock items is scheduled to take place next month.
Any reasonable suggestions are (more than) welcome. Of course I could always RTFM :(. But as I am also trying to get up to speed with this Solaris/Unix thingy and I have about 2 metres of shelf space currently occupied by the Solaris and Oracle manuals....
Yours in hope.
+---------------------------------+-------------------------------------------+Received on Thu Apr 28 1994 - 02:41:48 CEST
|Philip Chee: philip_at_aleytys.pc.my| This is a work of fiction.Any resemblance |
|Tasek Cement Berhad | to persons living or dead is completely |
|P.O.Box 254, 30908 Ipoh, MALAYSIA| coincidental. The creator of this article |
|Voice: +605-551-011 | has asserted its moral right to be |
| Fax: +605-566-142 | identified as the author. |
+-------------------Eigi-Eru-Enn-Allir-Jomsvikingar-Daudir!-------------------+