An Oracle database directory is a logical object mapping of a physical folder on the database server file system. We often need to ...
Post
Oraask Latest Articles
Post
API to Update Extra Information Types EIT in Oracle APPS R12
API to Update Extra Information Types EIT in Oracle APPS R12
5 mins read
Introduction When we work with extra information types EIT DFF in HRMS, we often need to update an EIT entry ...
Post
API to Create Organization Manager in Oracle APPS R12
API to Create Organization Manager in Oracle APPS R12
5 mins read
Introduction When we define our work structure in HRMS, we often need to assign a manager to the organization. We ...
Post
API to Define Document Sequence in Oracle APPS R12
API to Define Document Sequence in Oracle APPS R12
4 mins read
Introduction A document sequence uniquely numbers documents generated by an Oracle Applications product (for example, invoices generated by Oracle Receivables). ...
Post
API to Create User in Oracle APPS R12
API to Create User in Oracle APPS R12
2 mins read
Introduction Oracle user is the base of Oracle EBS ERP; Like creating a user from the front-end (Application), sometimes ...
Post
How to Move Table to Another Tablespace in Oracle Database
How to Move Table to Another Tablespace in Oracle Database
4 mins read
This article will explain how to move a table from one tablespace to another in the Oracle database. In some ...
Post
How to Drop and Recreate Tempfile in Oracle Database
How to Drop and Recreate Tempfile in Oracle Database
3 mins read
This article will give examples of how to drop and recreate a tempfile in oracle that is associated with a temporary tablespace.
Post
How to Create Profile Option in Oracle APPS R12
How to Create Profile Option in Oracle APPS R12
2 mins read
This article will explain the steps to create a profile option in oracle apps r12. Sometimes we need a custom ...
Post
How to Resolve ORA-00904 invalid identifier
How to Resolve ORA-00904 invalid identifier
4 mins read
This tutorial will explain what is causing the ORA-00904 error to occur and how to resolve the ORA-00904 invalid identifier error in Oracle.
Post
Decoding ORA-06512 at Line Num: The Ultimate Troubleshooting Guide
Decoding ORA-06512 at Line Num: The Ultimate Troubleshooting Guide
4 mins read
Introduction "ORA-06512 at line num" is a common error message that Oracle Database users encounter while executing PL/SQL code. In ...