Oracle Applications

Saturday, July 17, 2021

Error Summary: ICS runtime execution error Error Reason: The IO operation failed.

The IO operation failed.

The "OPER[NOOP][UseNativeRename{S->R,T->R}]" IO operation

Check the virtual path of directory.

Friday, May 14, 2021

How to automate FBDI process in OIC

Use Case: Build a schedule orchestration to automate FBDI Process to load GL Daily rate to Oracle ERP Cloud.

First of all we will create the required FTP and ERP Cloud Connections

FTP Connection

Navigator --> Integration --> Connections --> Create

Search: FTP and click button Select

Fill the information as

Name: FBDI FTP Trig Invoke Connect

Identifier: FBDI_FTP_Connect

Role: Trigger and Invoke

Click button --> Create

New page Connection Properties will display and complete it as

FTP Server Host Address:129.148.208.34

FTP Server Port:5013

SFTP Connection OPTIONAL: Yes

Security

Username:********

Password:********

Press Button --> Test

Press Button --> Save

Oracle ERP Cloud Connection:

Navitator --> Integration --> Connections --> Create

Search: Oracle ERP Cloud and click button Select

Fill the information as

Name: FBDI Cloud ERP Trig Invoke Conn

Identifier: FBDI_Cloud_ERP_Conn

Role: Trigger and Invoke

Connection Properties:

ERP Cloud Host:https://***.**.**.oraclecloud.com

Security Policy:***

Username: fusion.technical

Password: *****

Press Button --> Test

Press Button --> Save

Now we will build our required integration

Navigator --> Integration -->Integration

Press Button --> Create

Choose integration style --> Schedule Orchestration and click button --> Select

New popup will display and fill the form as

Name: FBDI GL Daily Rates Main Service

Identifier: FBDI_GL_DAILY_RATES_MAIN_SERVI

Package: Practice

Click button --> Create

After pressing button Create the popup will closed and your integration will be created. Change layout to horizontal and press button --> Save.

Now Download the Template DailyRatesImportTemplate, add required data in the template and create zip file. Once zip file is created move it to FTP server using WinSCP

In our integration, our first step is to read the file from directory and to do so we need add the FBDI FTP Trig Invoke Connect to integration.

New popup will appear and fill the information as

Now we need add the FBDI Cloud ERP Trig Invoke Conn to integration.

New popup will appear and fill the information as

We need to map the file from SFTP and pass input to Bulk import.

Press button validate and close to return back to integration. There is an error on the right side of the integration page. It need to fix.

Action --> Tracking

Press Button --> Save to return to integration page.

Press Button Save again and press button Close to return to integrations listing.

Activate the integration

Run the integration

That is It!

Thursday, May 6, 2021

Enable File Server in Oracle Integration Cloud - OIC

Login to OCI account

https://cloud.oracle.com/?region=me-dubai-1&region=me-dubai-1

2.     Open Oracle Integration Cloud Instance

Navigator à Developer Services à Application Integration à Integration

New page will display and click on Display name devoic

Click on component Dropdown and select your component. It will display the list of Integration Instances. Click on your Integration Instance.

3.     Enable File Server and save the changes

To enable the File Server you need to click on status

4.     Login to OIC Instance after few minutes and verify if File Server is enabled.

https://devoic-axi9xnppgnv7-dx.integration.ocp.oraclecloud.com/ic/home/

Navigator à Settings à File Server

5.     Use WinSCP and connect to file server entering IP and port number using Username and Password.

That is it!

Monday, April 12, 2021

Import Customers using FBDI Process

In this post we are going to learn how to import customers using FBDI process.
1.       Download the template
Open the below link to download the Template
https://docs.oracle.com/en/cloud/saas/financials/20b/oefbf/customer-data-model.html#customer-data-model
2.       Fill the customer details in below listed template tabs
Remove the existing data already added in excel sheet and fill the required data in below listed excel template tabs
·         HZ_IMP_PARTIES_T

·         HZ_IMP_PARTYSITES_T

·         HZ_IMP_PARTYSITEUSES_T

·         HZ_IMP_ACCOUNTS_T

·         HZ_IMP_ACCTSITES_T

·         HZ_IMP_ACCTSITEUSES_T

·         HZ_IMP_LOCATIONS_T

3.       Generate rate Zip file
Click on button Generate CSV file and zip file should be as below image.

Now zip file should be there in the folder and contains the files as

4.       Run process to load Zip file
Tools à Schedule process à Schedule New Process
New window will appear

Click on dropdown and click on search hyper link and type à Load Interface file for import
Press Button Search

Press Button OK and again press button OK
Click on dropdown à Import Process to search import process and click on search hyperlink. New screen will appear

Import Process : Import Trading Community Data in Bulk
Click button Search and select the record and click button OK
Click on dropdown Data File to upload the zip file and click hyper link Upload a new file


Click button Submit to close the window.
Press icon refresh to make sure that status changed to Success or Error. If it displays the status error then download the file and check for the error.
It is import to note that after fixing the error/s in template data change column Insert Update Indicator data to “U “.
5.       Run the process to import customer data in bulk
Tools à Schedule process à Schedule New Process
Click on dropdown and click on search hyper link and type à Import Bulk Customer Data
Press Button Search

Select a row and press button OK and again press button OK.
New page process Details will open, enter the batch id and press button Submit.

Once process completed successfully then verify the imported data
6.       Verify Imported Data
Navigator à Receivables à Billing à Tasks à Manage Customers
Enter Organization Name which you entered in template and Press Button Search.

Happy Learning!