Oracle WebADI Error – java.lang.ArrayIndexOutOfBoundsException: 1

When user tried to download an Excel document using WebADI, they got this error java.lang.ArrayIndexOutOfBoundsException: 1 which gives no information whatsoever on the exact issue Check the value of the profile option BNE Server Log Path, which will give full

Tagged with: , , , , , ,
Posted in Java, Oracle, WebADI

Oracle Fusion SPMLWebService – Java concurrent Program – 3

Call the webservice client from java concurrent program executable Create java class to call the webservice client Configure Java concurrent program pre-Reqs: All the required Java class files should be copied over to their respective folders under $JAVA_TOP, otherwise, expect

Tagged with: , , , , , , ,
Posted in Concurrent Programs, Fusion, Java, Oracle

Oracle Fusion SPMLWebService – Java concurrent Program – 2

Oracle Fusion SPMLWebService-1 Build Webservice client to consume the SPML WebService Extract java stubs from WSDL Identify values required for spmlconfig.properties Create CustomSOAP handler class to handle webservice port Create a new java class to build call to the webservice

Tagged with: , , , , , , ,
Posted in Fusion, Java, Oracle

Oracle Fusion SPMLWebService – Java concurrent Program – 1

In this post, I will discuss about the consuming Oracle Fusion SPMLWebService and calling webservice from Java concurrent program. Requirement: To update currency preference of all managers in Oracle Fusion environment based on the salary basis currency in Oracle R12.

Tagged with: , , , , , , ,
Posted in Fusion, Java, Oracle

BIPublisher – Output file was found but is zero sized – Deleted

Issue Created RTF template for the report using BI Publisher Desktop 10.1.3.2 Had to download  BI Publisher Desktop 11g to work on Oracle Fusion Reports Now, when I change the EBS RTF using  BI Publisher Desktop 11g, the program has Completed

Posted in BI Publisher, Oracle

OA Frawework – External LOV

In this post, we will discuss about implementing an External LOV in OAF. To understand the implementation better, please have a look at the diagram below.   As shown in the diagram, we create a LOV Region in the project

Tagged with: , , , , , ,
Posted in OAF, Oracle

Oracle HR – Person Details Tables.

The indicative details of all persons are stored in table PER_ALL_PEOPLE_F. This table stores the historic and current information of the employee based on the Date track mode used during the record updates. Tables below present the same data, but

Tagged with: , , , ,
Posted in HRMS and Payroll, Oracle

Oracle HR – Date Tracking

Date tracking in Oracle E-business is a mechanism to store data based on dates. This helps storage of historical data along with current data in the system. The date tracked tables in Oracle end with ‘_F’ and have columns EFFECTIVE_START_DATE

Tagged with: , , , ,
Posted in HRMS and Payroll, Oracle

Execution Plans

Posted in Uncategorized

Oracle HR – Script for Adding phone details for Employees

The requirement was to add phone details ( Work phone number, work mobile number) a list of employees. We have implemented this using hr_phone_api Process Steps: 1. Create a temp table CREATE TABLE load_phone_temp AS SELECT parent_id,phone_number work_phone,phone_number mobile_phone FROM

Tagged with: , , , , , , ,
Posted in HRMS and Payroll, Oracle
Follow

Get every new post delivered to your Inbox.