Oracle Integration Cloud Service (OIC/ICS) - AP Invoice Using ERP Cloud Adapter

[@Rockie_Vzg]

I always appreciate your efforts, Thanks a lot sir..

[@tampin7027]

Hello Sir, thank you very much for teaching this. I have a question from a user angle. IN old EBS, we used to give FTP access to a 'Payables User' to transfer an excel file to DBSREVER and then he submit a loader program to load invoice. Now with OIC , who will transfer the file to be loaded and kick off the integration OR how is this achieved? How do you control the access to 'Payables User' to the integrations page ? The reason I am asking is because, we may have a bunch of integrations going to AP,AR and HR. In EBS, we control this thru responsibility, how do we do that in OIC world ? Any insight will be helpful.

[@venkattalenthub8847]

Good Presentation. I will get the demo instance and will try the same.

[@VibeTribe786]

When we use download and when use read file while importing the file to ERP. In some videos they using read in some they using download file to temp.

[@prasoonsneha6081]

Hello Sir, You mentioned the ftp functionality can also be achieved using OIC agent and we can read csv file from local system. Can you please elaborate??

[@TheFoxyVlogs]

Yes

[@oratrainings]

For Source Please check my Udemy course : www.udemy.com/course/oracle-cloud-erp-technical

[@rajashriwatve3533]

Can you share videos for - AR Invoice as well Using ERP Cloud Adapter in OIC

[@meghakrishna5480]

Hi Sir, very good explanation. I want to know the navigation in oracle Fusion application that where we can check the zip file uploaded into ERP. Please send me the navigation path in fusion instance

[@oratrainings]

N: Tools --> File Import & Export

[@ainsalleh]

If we don't have an FTP server and use Agent for the localhost as said at @2:30 . What kind of connection need to be created then?

[@ainsalleh]

is it File adapter?

[@TheFoxyVlogs]

File Adapter connection.

[@IsmetCakr-mh9jy]

hi, how can I delete the old data My entegration send the new exchange rates to erp but I can not delete the old rates.

[@adilasif01]

Hello Sir! I need to update AP invoice(invoice header and lines) in oracle fusion through OIC.. can you please help here. (Possibly show a demo how to do that)? Thank you

[@TheFoxyVlogs]

Yes, You can use REST api to update the invoice details.

[@adilasif01]

Thank you Aeron! Yes I have identified the the Rest API to update invoice details. It asks the invoce ID but I wonder how can I pass the invoice payload in the RET API? for Example If I want to update Inovice Number of existing invoice how will I pass invoice number along with invoice_id ? Can you please show me (any video or document if you can provide?) Thank you !

[@TheFoxyVlogs]

Give me some time, I will create integration for same and i will share with you.

[@adilasif01]

Thank you so much I will be waiting for it !

[@adilasif01]

Hi Aeron, did you get a chance to create the integration ?

[@jeffersongatty8428]

Hi, really good presentation, so, I would like to know if is possible integrate with webservices? where I find some documentation about this integration with payaple?

[@SOUMIKGHOSHsoghosh4]

Hello, How can we get access to Oracle ERP url to perform the end to end hands-on which you showed. Like salesforce, is there any way we can signup for Oracle ERP account. Please suggest

[@oratrainings]

We can't sign it up freely, only way is through any partner channels or training institutes who can provide demo instance for practice

[@agarwalhimansh1]

hello sir, i am getting the error after submitting the integration during process Import Payables Invoices Error: The zip file contains data with invalid extension: properties any help with this issue is appreciated!

[@oratrainings]

it seems the zip file is missing the manifest/Properties file. To invoke the FBDI job, you need a ZIP file consisting of a data file in CSV format and a manifest/properties file that has job details such as job name and its parameters- cloudcustomerconnect.oracle.com/posts/4de059f07b

[@agarwalhimansh1]

The properties file is there but still it's giving error...can you please share the zip file which you have used in the video email: [e-mail]