Home » Applications » Oracle Fusion Apps & E-Business Suite » Shipping Interface
Shipping Interface [message #317512] Thu, 01 May 2008 14:34 Go to next message
shree_z
Messages: 75
Registered: February 2008
Member
Hi all,

Our company deals with a third party which takes care of all the shipping, physically and ship confirms in their own custom application.
We just create the sales order, the third party picks the goods and stores in their warehouse and then ships to the customers according to the demand.The shipment information will be initially stored in the custom application of the third party and then they send that information to us as ASN.We flip that ASN in customer specific format and send to our customers. Mean while we will be loading the shipping info into Oracle ERP for future references.

My need is to develop an interface which can load all the data ,from the shipping info (ASN) sent by the third party , into our Oracle ERP.

How can this be made possible? Will this need a sql*loader script and creation of Custom staging tables?

Could anyone please explain the steps needed in the above scenario?

Thanks in advance

[Updated on: Thu, 01 May 2008 14:35]

Report message to a moderator

Re: Shipping Interface [message #318098 is a reply to message #317512] Mon, 05 May 2008 10:29 Go to previous message
shree_z
Messages: 75
Registered: February 2008
Member
Hi I am in the starting phase, to write a wrapper code for ship_confirm using API.
I have the following code for creating a trip.

CREATE OR REPLACE PACKAGE shipping_api
AS
PROCEDURE xx_create_trip (
      x_return_status   OUT   VARCHAR2,
      x_msg_count       OUT   NUMBER,
      x_msg_data        OUT   VARCHAR2,
      x_trip_id         OUT   NUMBER,
      x_trip_name       OUT   VARCHAR2
      );
END shipping_api;

CREATE OR REPLACE PACKAGE BODY shipping_api
AS
   PROCEDURE xx_create_trip (
      x_return_status   OUT   VARCHAR2,
      x_msg_count       OUT   NUMBER,
      x_msg_data        OUT   VARCHAR2,
      x_trip_id         OUT   NUMBER,
      x_trip_name       OUT   VARCHAR2
     )
     
   IS
    p_trip_info         wsh_trips_pub.trip_pub_rec_type ;
      
   BEGIN
      p_trip_info.trip_id := 123;
      p_trip_info.NAME := 'ABC';
      wsh_trips_pub.create_update_trip ('1.0',
                                        fnd_api.g_false,
                                        x_return_status,
                                        x_msg_count,
                                        x_msg_data,
                                        'CREATE',
                                        p_trip_info,
                                        'ABC',
                                        x_trip_id,
                                        x_trip_name
                                       );
--Harmonizing Project **heali
      DBMS_OUTPUT.put_line ('Return_Status' || ' ' || x_return_status);
      DBMS_OUTPUT.put_line ('Msg_Count' || ' ' || x_msg_count);
      DBMS_OUTPUT.put_line ('Msg_Data' || ' ' || x_msg_data);
      DBMS_OUTPUT.put_line ('trip_id' || ' ' || x_trip_id);
      DBMS_OUTPUT.put_line ('trip_name' || ' ' || x_trip_name);
   END xx_create_trip;
END shipping_api;


I ran this in TOAD and it successfully created the package and the body.

Then I registered this as concurrent program. When I run this, I can see that the procedure execution resulted in errors. This is the error in log file

Quote:
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XX_CREATE_TRIP'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



Can anyone help me to resolve this?

Thanks in advance.

[Updated on: Mon, 05 May 2008 10:32]

Report message to a moderator

Previous Topic: How to alter a parameter in a scheduled conc. program
Next Topic: E-BS R12 - User Management
Goto Forum:
  


Current Time: Sun Dec 04 00:40:26 CST 2016

Total time taken to generate the page: 0.25174 seconds