Re: Oracle Financials/Concurrent Manager Question

Lee Carney wrote:
>
> We are in the middle of a major application migration project and have run
> into a problem. I hope that someone here with Oracle Financials/Concurrent
> Manager experience can offer some assistance.
>
> We are running version 7.4 of Oracle Financials. We want to upgrade to 10.7
> Oracle Financials Smart Client. On the 7.4 version of Oracle Financials, it
> executes a number of PRO*C programs through the Concurrent Manager. These
> PRO*C programs execute on the server and produce a lot of output. We are
> upgrading all the older versions of the forms to Forms 4.5 and want to be
> able to run both character and GUI versions of the forms. With Smart
> Client, we want all PRO*C programs to be executed on the server, even when
> the client is running in GUI mode.
>
> My question is: Will the new version of Smart Client/Concurrent Manager be
> able to run in GUI mode on a PC and execute the PRO*C submitted through
> Concurrent Manager to the server? Is there a way to execute the PRO*C
> without using user exits in version 10.7 of Oracle Financials?
>
> In general, what are the Concurrent Manager differences between 7.X and
> 10.7?
>
> The software versions are:
> AOL - 5.0.8 version Release 9.4.0
> SQL Forms 2.3.31.1.7
> Oracle RDBMS 7.1.6.2.0
>
> I would greatly appreciate any ideas that this newsgroup's readers have.
>
> Thank you,
>
> Lee Carney

Lee,

I am a little confused by your explanation. I'm not sure where your pro*c programs reside today, on the server or the client? I can't impagine why they would be on the client but I guess you could have a situation where a pro*c program is accessing the remote db from a pc via sql*net. Messy! I think the most conventional setup is a client request for server execution of a pro*c program resident on the server. I guess I can't fugure out either whether you are talking about upgrading custom (your) forms to 10.7 or installing the AOL 10.7 forms provided with the software.

Anyway... The cpmgr will run your concurrent programs, event pro*c current programs. You execute (start) these programs via the std concurrent program request form (new since V9) after declaring them in the concurrent executables and concurrent program AOL forms. This will work in SC and good old char mode. If you need a custom form to kick off a concurrent process, you can do that too using the FND_REQUEST package.

Try SQL>desc fnd_request.submit_request

Keep in mind that all your pro*c programs are server based. You have to compile them, link them and run them all on the server.

I've never worked on V7, so I'm at a loss to give you a run down on the differences between its cpmgr and the current flavor.

Have fun, I do!

Rian MONNAHAN Received on Tue Dec 09 1997 - 00:00:00 CET