Starting from Oracle Database version 8, Oracle has introduced one character that came up with the version number of its databases, e.g., Oracle database V8i, 9i, 10g, 12c. What are i,g, and c mean in the oracle database version? These ...
Oraask Latest Articles
Backup a Table in Oracle
Before changing or make a significant update on a database table in all databases and Oracle specifically, we have to take a backup from the table.So in this article, we’ll cover different approaches to perform this task : How to ...
Oracle Case Statement
Introduction: In this tutorial, we are going to explain how to use Oracle Case Statement expression with basic syntax and many examples for better understanding. Oracle Case statement: CASE-WHEN-THEN-ELSE This is similar to the IF-THEN-ELSE statement in PL/SQL but with ...
Check Tablespace Usage in Oracle
When it comes to databases in general and oracle specifically, we hear the term ” tablespace ” when trying to create a database object. there some question that is coming to the picture related to tablespaces in oracle, such as ...
Run Oracle SQL Script From Command Line in Windows
Sometimes we have a requirement to run a particular SQL script from windows command line “CMD” with or without parameters. So that’s why we prepare this article to guide you through the steps required to perform this task to get ...
API to Create Lot Number in Oracle APPS R12
Lot Number is a code that groups items that share the same specifications, and we are generating the lot number to identifying the expiration date of all items. Within Oracle ERP specifically, the Inventory module has complete lot number support for ...
Create AP Invoice using AP open interface in oracle apps R12
Introduction: In this guide we’ll explain how to create AP invoice in oracle apps r12 using Open interface tables. Oracle AP open interface tables are using to create new AP invoices whether from supplier invoices or imported from external systems. ...
How to find SQL query behind LOV in oracle apps R12
Introduction: In oracle E-Business Suite it’s a common task to find an lov query. today we’ll tell you how to find SQL query behind LOV in oracle apps r12. There are two V$ views in oracle (v$sqlarea, v$session) available to ...
API to incomplete AR Transaction in Oracle Apps R12
Introduction: In this guide we’ll explain how to incomplete AR invoice in oracle apps r12 using API, along with standard API parameters explanation. Goal: Set AR Transaction to incomplete status using “ar_transaction_grp.incomplete_transaction” API Forms Or Pages: Example: API IN/OUT Parameters ...
API to create AR invoice in Oracle Apps R12
Introduction: In this guide we’ll explain how to create AR invoice in oracle apps r12 using API, along with standard API parameters explanation. Goal: Create AR Invoice using “ar_invoice_api_pub.create_single_invoice” API Forms Or Pages: Example: API IN/OUT Parameters : — IN ...
