Re: Oracle Financials

Philip Chee wrote
> You need to order the Technical Reference Manuals (TRMs)

Those are expensive because they only come in a printed form, as Oracle thinks of it as propietary material. Oracle might not even ship it to you if you do not own an Applications license yourself. However, if you only want to insert data into Applications maybe all you need is the Open Interfaces Manual, which can be found on the Applications CD-Rom online documentation as well. After populating the interface tables (and a control table in case of GL imports) you need to call some stored procedures to actually start the load (that is: schedule a job in the Concurrent Manager), as described in the Application Object Library -- also to be found on the CD-Rom. If you need help with this last step, let me know.

Only if you need to run queries you'll indeed need the TRMs -- which really are just table descriptions, including info on how the tables are linked.

> the Coding Standards manuals are probably going to be very useful too.

True indeed. Unlike the title suggests, this book also contains very usefull info on triggering the Concurrent Manager and retrieving the status of your jobs. I guess it is on the CD-Rom as well.

Arjan. Received on Sat Apr 17 1999 - 10:17:31 CDT