Oracle Fusion and EBS Knowledge Sharing

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)  {   ...

Oracle Apps  Java Concurrent Program We can build Java concurrent programs to use java capabilities.  Following are some steps  1. Create and compile java Class in jDeveloper. my suggestion is to create Java class package oracle.apps.fnd.cp.request Java class must implements   JavaConcurrentProgram Sample Java Class 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; ...