Oracle Fusion and EBS Knowledge Sharing

  OIC Agent diagram Introduction OIC  agents  are the  agent  that help  Oracle Integration Cloud ( OIC )  to connect and integrate on-premise application.  The  agent  is required on install and configure at on-premise network. It can be installed at any machine/node within the network where it must have access to target system. Implementation To implement OCI Agent, we need to create agent group in OIC and then download installation files. let's create agent group in integration cloud Navigate  to Agents from the Integration homepage Select Create Agent Group  button OIC Agent 1 Give any meaningful Name Identifier  will be auto filled We need this identifier  to specify in the configuration file after the download Edit OIC Agent Click Save Select Download and then Connectivity Agent OIC Agents Download and unzip at any local on-premise location OIC Agent  Go the the oic_conn_agent_installer directory Edit...

  Step1 The below diagram shows FBD modal upload process.  for more detail,  Visit  https://docs.oracle.com/en/cloud/saas/procurement/20d/oefbp/supplier-model.html#supplier-model Select Import Suppliers and   Download below xlsm file  We can can create new suppliers or update existing suppliers by setting Import Action column value After reviewing the data, we need to create zip file that we will upload to Fusion Apps Select Schedule Processes under Tools from Fusion Apps Menu/homepage Select Schedule New Processes and search for  Load Interface File for Import  Select  Import Suppliers   and upload the zip file and submit the job And Submit note down the request id After successfully completion of above job,  Schedule new process and search for  Import Suppliers  and provide the details as below After successfully completion of the Import Supplier job, you can view the log and Supplier search

Before you start You must have appropriate Ledger assigned, specific period must open Visit  https://docs.oracle.com/en/cloud/saas/financials/20b/oefbf/index.html Download below xlsm file  Enter Journal lines with correct information i.e Debit and Credit must balance After reviewing the data, we need to create zip file that we will upload to Fusion Apps Select Schedule Processes under Tools from Fusion Apps Menu/homepage Select Schedule New Processes and search for  Load Interface File for Import  Select  Import Journals   and upload the zip file and submit the job Note down request id, this will help in search our submitted  request Now submit Import Journals job

Introduction Oracle EBS provide the functionality to leverage Java into action. When you love java and to feel in your EBS environment. I am sharing here a sample java class code that will will be used for  Oracle EBS  Concurrent program executable and perform the tasks of fetching data from database with power of JDBC and will create a csv file on application server file system. I have used a string variable to hold string content you as payload to create file Java Code package oracle.apps.fnd.cp.request;     import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.FileWriter; import java.io.IOException; import java.io.PrintWriter; import java.io.StringWriter;   import java.security.NoSuchProviderException;   import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;   import java.text.SimpleDateFormat; ...

Sample java REST API client class for Oracle EBS Concurrent program package oracle.apps.fnd.cp.request;     import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.FileWriter; import java.io.IOException; import java.io.PrintWriter; import java.io.StringWriter;   import java.security.NoSuchProviderException;   import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;   import java.text.SimpleDateFormat;   import java.util.Date;   import oracle.apps.fnd.util.ParameterList;   import oracle.jdbc.OracleCallableStatement;   public class JavaConcRestAPIClient implements JavaConcurrentProgram {     String pDate;       public JavaConcRestAPIClient() {     }       public void runProgram(CpContext pCpContext)  {   ...