[pmalin]

Describe my steps. I choose file and click UPLOAD and data uploaded then BUT i dont have second step when i need to choose TRANSACTION CODE and smth else.

I guess i need to enable this option but dont know how and where. Any ideas?

[cunninghamg]

What you are describing is what happens when you upload a csv file.

When you upload an xml, the transaction codes are specified with the xml - so the file just gets processed.

Regards
Gary

[chrisplough]

In addition - if you package your CSV files up into a zip file, you can put the transaction code in the control file -- giving you the same flexibility.

--Chris

[Nadeem Naqvi]

Hi all,

I have created the given below python script in Linux and now trying to incorporate the same in my PL/SQL Procedure.

What is the best way to call this script in Oracle Procedure??

python ClientUtil.py -command csvImport -hostname abc -username GLOG.ADMIN -password ABC -localDir /csv_file -localFileName abc.csv -csvUtilCommand i -xvalidate=None

[Sachin]

Originally Posted by cunninghamg

What you are describing is what happens when you upload a csv file.

When you upload an xml, the transaction codes are specified with the xml - so the file just gets processed.

Regards
Gary

Hi,

I'm trying to upload a location XML. I have entered the username & password in the xml, also the transaction code as IU.

But i'm unable to upload this xml through integration manager. I'm getting an exception error(attached). I've also attached the location xml which i tried uploading.

Could any body help me in identifying what's wrong in the xml?

Regards,
Rajiv

[Sachin]

Unable to upload in xml format. Hence attached in notepad.

[josephliang]

Your XML is not valid against to OTM schema (GLogXML.xsd)
Use any XML editor to correct the XML before uploading to OTM.
In addition, whenever you try to create an object, e.g. Location, Order, etc., do NOT include Status elements.

[LourensGlog]

To learn a bit more about uploading data, read the Integration Guide, as mentioned here (Transportation Orders for Buy Shipments).

Unfortunately for you, Oracle doesn't tell you how your message should look like other than to follow the schema, and there are dozens of do's and dont's like the ones that Joseph shared, that are not documented.

[Sachin]

Originally Posted by josephliang

Your XML is not valid against to OTM schema (GLogXML.xsd)
Use any XML editor to correct the XML before uploading to OTM.
In addition, whenever you try to create an object, e.g. Location, Order, etc., do NOT include Status elements.

Hi Joseph & Lourens,

Thanks for your replies.

We extracted the xml from GlogXML.xsd and used it to create new locations in OTM. Here we face an issue like when we try to insert a new location with an existing corporation (parent location gid) in OTM, xml gets processed with out any error.
But when we insert a new location with a new corporation id (parent location gid) the transmission errors out.

Is it not possible to create a new corporation (parent location gid) along with a new location in a single xml transmission?

Regards,
Rajiv

[Sachin]

Hi all,

We are developing an interface to create locations in OTM through integration. As I mentioned earlier post, the problem is whenever we try to pass a location with new corporation ID the transmission errors out.

The log file says "Cannot Update the LOCATION_CORPORATION record".

We are passing Corporation GID/XID as parent location GID/XID in xml. What we understand is when we pass parent location GID/XID OTM is trying to update LOCATION_CORPORATION table only and since this is not available in CORPORATION table, it errors.

It will be of great help to us if any one can tell how to create a new corporations through xml transmission?

Thanks,
Rajiv