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 […]
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
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 […]
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 […]
James Gosling, the creator of the original design of Java has resigned from Oracle a week ago. The news is anounced only now on his blog and confirmed by other sites (where you can find more details):
Context: – JBoss 5.1.0GA – Oracle9i Problem: During a long processing transaction, the ORA-02049 exception was thrown. Solution: According with metalink note 789517.1
Sorting characters is done differently from one language to another. For example, in English digits come before letters in an ascending sorting. But, in German, digits are ascendant sorted after letters. Sorting may or may not be case sensitive, diacritics may be considered or ignored, and phonetic rules could also be used (e.g.: in Spanish […]
In this article we will take a brief look at the Oracle SQL FIRST/LAST aggregate functions that allow you to select a value from the first or last row(s) of a sorted group, when the needed value is not the sort key. For example consider a table “PROJECT_COST” having the following structure and data:
By continuing to use the site, you agree to the use of cookies. More information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.