Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loading Supplier Details to Oracle SAAS through OIC

SreeparnaApr 9 2020

Hi,

We have developed an OIC integration which will load Supplier csv files(Supplier, Supplier Address, Supplier Sites, Supplier Site Assignment, Contacts) to Oracle SAAS. The integration will load all the csv files along with job.properties file to SAAS sequentially in the below order.

1.Supplier

2.Supplier Address

3.Supplier Sites

4.Supplier Site Assignment

5.Supplier Contacts

We have used Oracle ERP adapter(Import Bulk Data to ERP) to upload data. The files are loaded to interface table in the above mentioned sequence.

Issue- Whichever interface job is getting completed first for the any of the above mentioned supplier file will invoke the base table job before others.

e.g- If supplier Sites Interface table job gets completed first it will invoke the Base table job (Import Supplier Sites)before Import Supplier, Import Supplier Addresses which will result in failure as the Supplier won't exist in SAAS.

How can we ensure that all the base jobs get triggered in the above sequence ?

Thanks in advance.

Regards,

Deepak Rawat

Comments

user1175340

should be straight forward.

Click on 'select language mode' -> Configure file association for '.pks' -> choose language mode you want.

lng.jpg

595835

That's visual studio CODE. OP is asking about Visual STUDIO. Doesn't seem to be a way to do this… as ODT doesn't appear as an editor in the dropdown:

Christian.Shay -Oracle

Hi there,
In Visual Studio we don't yet have a full featured sql script editor like we do in VS Code.

We have a “Query Window” where you can type or cut and paste SQL and we have Tools→Run SQL Plus script menu item.

You can also open any file into Query Window like so:

  1. Open Query Window from a connection
  2. Open any file (eg .sql, or .pks) using File->Open File
  3. To Save, use File→Save or File→Save As

In a future release we hope to merge everything so that the behavior is much like the editor in VS Code, supporting scripts, opening files for edit, etc.

1 - 3

Post Details

Added on Apr 9 2020
#integration-adapters, #integration-general, #soa-process-management
1 comment
565 views
1 mention