Archive for the ‘Oracle E Business Suite’ Category

Creating scheduled jobs in ORACLE

Share

When you need to run an ORACLE DB task every day the best choice is to use the Scheduler. Scheduled Jobs can be used to run PL/SQL Blocks, Stored Procedures or even scripts. To setup the job, we need to fill in some mandatory fields:

Share


SQL : Updating Oracle table with data using subquery

Share

In Oracle Database 11g , when you need to update values of certain records from one table,  and the value and the records to update are determined by a second table, you can use a subquery in the update statement to achieve the update. Using “EMPLOYEE”  and “EMPLOYEE_STAGING”  tables as an example , we want […]

Share


SQL : Concatenating multiple rows into a single string

Share

In some occasions it is necessary to concatenate data from a number of rows into a single row. Using HR.DEMO table as an example , we want to retrieve a list of employees for each department. Base Data :   Desired Output :  

Share


Oracle OpenWorld 2011

Share

October 2-6, Moscone Center, San Francisco. “Oracle OpenWorld is the most cost-effective and efficient way to stay ahead of the technology curve.” Why not believe it? When tens of thousands of people attend,  you have thousands of sessions to choose from, you can enjoy membership in a global community of Oracle technologists, customers and partners […]

Share
Tags:   

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Installation

Share

You can start your  OBIEE 11g installation after completing the prerequisites list. In the unzipped install files go to Disk 1 and run the setup.exe file (for Windows). This launches the Oracle Universal Installer. There are 12 steps in the installation process. And we’ll go through the most important ones

Share
Tags:  

Installing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g prerequisites

Share

There are a few steps to complete before you can start with OBIEE 11g installation. This demo describes the steps required on a Windows system and requires

Share
Tags:    

Bank statements import and reconciliation in EBS Oracle

Share

As you may know, bank statements manual input and reconciliation is a demanding task. You won’t have to bother anymore after setting up bank statements import and reconciliation. This example uses EBS Oracle 12.0.6. and the file format imported is SWIFT MT940. Here are a few steps to setup and submit the actual request for

Share
Tags:       

SLA for OPM – (Subledger Accounting for Oracle Process Manufacturing) – a straight forward approach to get Journal Entries for Accounting Events

Share

In EBS R12 (Oracle Enterprise Business Suite Release 12), seeded AAD (Application Accounting Definition) does not work for OPM (Oracle Process Manufacturing) transactions. Anyway this standard functionality is not quite far away. With common effort we can get to accounting entries. The most straight forward solution is to copy seeded setup in a user owned […]

Share
Tags:   

Oracle BI Publisher step by step report

Share

Oracle BI Publisher (formerly XML Publisher)  is an enterprise-level reporting tool that separates the data from the presentation. This means that the IT department can define the data sources, and power users can specify the report layout using tools like Microsoft Word. The same data source can be used by multiple report templates. Here are […]

Share
Tags:    

Porting applications from Oracle to PostgreSQL

Share

If you are planning to migrate a database application from Oracle to PostgreSQL, this article can help you to understand and solve some of the issues occurring in such a process. PostgreSQL has recently become feature-complete in many areas and therefore porting projects from Oracle might be a feasible option in much more cases. Oracle […]

Share
Tags: