Oracle

Accrual Basis Accounting

July 23, 2010

Accrual Basis Accounting is the most commonly used accounting method which recognized revenue and expenses as follows: Revenue Recognition Revenue is recognized when the following conditions are met Income is earned when cash is received when products are delivered or services are provided Income is realized when it is reasonable to expect that cash will [...]

Read the full article →

Accounting Encumbrance

July 23, 2010

In accounting, an encumbrance is an action of predefining future expenditures for a certain planned project, company expenses, etc. This will later on become actual expenditures when goods and services are received. The primary purpose of tracking encumbrances is to avoid overspending a budget. Encumbrances can also be used to predict cash outflow and as [...]

Read the full article →

Get Employee Details in Oracle E-Business Suite

July 20, 2010

select distinct p.person_id, p.full_name, p.employee_number, p.email_address, p1.full_name supervisor, p1.employee_number supervisor_emp_num, p1.email_address supervisor_email from per_all_people_f p, per_all_assignments_f a, per_all_people_f p1 where p.employee_number = a.assignment_number and a.SUPERVISOR_ID = p1.person_id and p.EFFECTIVE_END_DATE >= sysdate and p1.EFFECTIVE_END_DATE >= sysdate and p.employee_number = ‘&EMP_NUMBER’;

Read the full article →

Check the Oracle Database Version

July 17, 2010

Run this query to check the version of the Oracle Database: select MAX(version) from v$instance;

Read the full article →

New Oracle SOA Book

June 25, 2009

Are you new to SOA and would like to learn how Oracle SOA Suite fits into the SOA world ? Or are you a SOA professional and looking for an all in one book on Oracle SOA Suite? Then wait no more, after a few months of waiting, Matt Wright and Antony Reynolds finished the [...]

Read the full article →

Oracle Enterprise 2.0 Bootcamp

July 9, 2008

Companies are using Web 2.0 technologies such as blogs, wiki and social networking. However, there are top issues that need to be considered before implementing such technologies. They are cultural change, privacy, best practices and internal collaboration. Assessment of the impact of implementation to the organization is needed. Oracle organized Oracle Enterprise 2.0 Bootcamp on [...]

Read the full article →

Oracle Architecture Centers

July 9, 2008

To support Oracle’s investment to Service Oriented Architecture and acquisition of various SOA related products, Oracle created Architect Centers for SOA, Virtualization, Enterprise 2.0 and Extreme Transaction Processing in OTN website. OTN is adding an “Architect” focus to the community, with new centers covering expanded SOA (including governance), Extreme Transaction Processing, Virtualization (Oracle VM + [...]

Read the full article →

Wehmeyer Choosed Oracle Retail Optimization

July 9, 2008

Wehmeyer, a German fashion house, selected Oracle Retail Optimization to avail the efficiency in improving the inventory management. Oracle Retail Application introduced Wehmeyer an advanced approach in managing in-season inventory, assortment and pricing strategies across its 40 stores across Germany. Wehmeyer is expected to enjoy the following benefits of Oracle Retail Optimization. Oracle Retail Price [...]

Read the full article →

Validating Numeric and Non-Numeric Values

June 2, 2008

To check if numeric and non-numeric values, the following syntax can be use. Syntax PLAIN TEXT CODE: select DECODE( TRANSLATE(<value here>,'0123456789',' '), NULL, 'Numeric','Character')  from dual; Example PLAIN TEXT CODE: select DECODE( TRANSLATE('12345Z','0123456789',' '), NULL, 'Numeric','Character')  from dual; The example above will return 'Character' because the value has non-numeric characters.

Read the full article →

Loading CSV in Oracle Forms

February 21, 2008

Yesterday, I and my team mates conducted a brownbag session about a functionality that allows loading of CSV files to a database table. The general overview of this functionality is to call a Unix shell script that invokes SQL Loader to load the CSV to the table. The first stage is uploading the CSV file [...]

Read the full article →