Re: Oracle Application Financials

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Sat, 27 Feb 1999 11:01:48 +0100
Message-ID: <36d7c28d$0$11114@newton>

saidmiry wrote
>Do you have informations of open interfaces using GLand AR ?

Well, I do hope you have some documentation, or don't you have any CD or book at all?

>We're looking for information about launching GL and AR
>interfaces from SQL language (With SQLPlus for example).

Launching would imply filling the tables and then trigger the actual import. To trigger the import you need to submit a request to the concurrent manager, using fnd_request.submit_request. Something like

    vCrid number(10); -- Concurrent Request ID     begin

        vCrid = fnd_request.submit_request
            ( 'RA' -- application short name
            , 'RACUST' -- program short name
            , 'Triggered from SQL*Plus' -- description
            , null  -- start time: now
            , false  -- sub request: no
            );
        if nvl( vCrid, 0 ) = 0
        then
            -- some error handling here.
        else
            commit; -- actually submit the request
        end if

    end;

>We have a problem when we try to import customers from
>RA_CUSTOMERS_INTERFACE_ALL
You should avoid using the _ALL tables directly. If you do not use multi-org, then simply use the VIEW ra_customer_interface. When running multi-org, first set up the the organization for which you want to import data and then also use the VIEW ra_customers_interface in your scripts:

    dbms_application_info.set_client_info( your_orgid );     insert into ra_customers_interface ...

If you must use SQL*Loader when running multi-org, then indeed you will need to fill a _ALL table, and also specify the org_id column in that _ALL table. Applications won't recognize your data if column org_id is null!

>The open interface doesn't import any records in
>ORACLE APPLICATIONS without setting any errors.

Like *what* errors?

>The name of the table has changed ?

Since when? Did you already use the import in 10.4? If so, then just setting the org_id should enable you to keep using your old scripts.

> Is this a bug in OA? ...

Get real... Applications 10.7 has been there a long time, and now you are the one to find a bug in the import tables during your first try? Mwahhh.

>Thank you for any help.

Give us more details next time please.

Arjan. Received on Sat Feb 27 1999 - 04:01:48 CST