profile image
Gaurav Kulkarni
Technical Specialist at HCL Software
Experience in Java technologies like Hibernate, Spring boot, Web Services and REST APIs, UI technologies like native JavaScript, jQuery, ReactJS, python flask, Databases like Postgres, Oracle. Enthusiast about full stack software development and other similar technologies.
Posts by Gaurav Kulkarni
Automation | May 10, 2021
Enhance your Oracle E-Business Suite Scheduling Capabilities with Workload Automation
Oracle E-Business Suite as the name suggests is a suite of several application software mainly consisting of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) with the Oracle relational database management system (RDBMS) at its very core. Oracle E-Business Suite is one of the most popular solutions out there. Globally organizations use it to streamline their business processes and manage their day-to-day transactions and ultimately reduce costs and bring more efficiency.
Automation | August 28, 2020
Simplify The Data Loading Using Oracle UCM and HCM Data Loader plugins with Workload Automation
Customers using Oracle Human Resources Cloud face the challenge of continuous bulk loading of large amounts of data at regular intervals. Oracle Human Resources Cloud provides the tools like HCM Data Loader which address this business use case. Now you can automate data loading into Oracle Human Resources cloud using the Oracle UCM and Oracle HCM Data Loader plugins which leverage the HCM Data Loader for the Workload automation users. Business Process automated:       Source: The above diagram shows the business process automated through these plugins: This process is divided into 2 steps and hence the 2 plugins: A .zip file containing .dat files is placed on the Oracle WebCenter Content server. Here the Oracle WebCenter Content server acts as a staging infrastructure for files that are loaded and processed by the HCM Data Loader. HCM Data Loader imports the data first into its stage tables and then into application tables. Any errors that occur during either the import phase or load phase are reported in the job status and details in job log.   Technical description and workflow Oracle UCM plugin The Oracle UCM enables you to stage data files for processing to HCM Data Loader. It provides easier integration with other business processes by using the Oracle Universal Content Management (UCM) integration. The Oracle UCM Data Loader automates the process of bulk-loading of data. You can load the data files and monitor them from a single point of control. The data is uploaded as zip files to Oracle UCM, which is processed by the HCM Data Loader. This integration helps you save time, resources, and speed up data loading in a secure manner. Prerequisite for the plugins to work: - Oracle Human Resources Cloud service account with correct permissions to access File Import and Export task...
Automation | July 31, 2020
Agents and Reports: Oracle Business Intelligence, A step ahead with Workload Automation
Are you familiar with Automation Hub! It is the time.  Data! We have enough data to process.  Analyze! We have multiple software and algorithms to analyze and process the data.  Question is how to represent or publish the processed data together as a report. There are few which do this favor.  But, will the generated reports be flexible for reuse? Will the report maintenance be easy? Will they have an optimized data extraction and data generation process?  Answering is tough. Because it is not easy to maintain and produce efficient reports from huge data consistently with an ease.  Big fishes like Oracle, IBM will have the trick to satisfy the customer with the required features.  There comes our plugin OBI Run Report to answer all the queries with minimal effort which is associated with Oracle BI publisher.  This can be combined with the workload automation tool by the users.  Yes, reports are generated and published with the requirements. How to reach them to the customers.  Simple answer is by using agents. Agents can deliver the reports to the customers based on the trigger events and the targets. Targets can be different, in other way, the delivery routes can be varying by multiple conditions and requirements.  Agents are triggered by schedules or conditions that in turn generates a request to perform analytics on data based upon defined criteria, which can be used for reports scheduling as well as alerts sent to the required recipients on different web accessible / communication devices.  Agents also provide proactive delivery of real-time, personalized, and actionable intelligence throughout the business network.  As a next block of feature, we introduce OBI agent which help to satisfy the requirement. This plugin shares the features with Oracle iBot/agent in all aspects and they are part of session-based web services...