TechKnowLogic

Requirement is simple; you want to retrieve/recover the Version Information of your currently installed Oracle Database. Let us discuss most of the ways of doing so in Oracle & SQL Server. Here are some of the ways to get it: 1)  DBA_REGISTRY (Table)       S ELECT * FROM DBA_REGISTRY ; SELECT comp_id, comp_name, version, status, namespace, control FROM DBA_REGISTRY WHERE comp_name LIKE '%Oracle%' ORDER BY comp_name; This will give you the db version along with all the other oracle components installed. Here is the result: COMP_ID COMP_NAME VERSION STATUS NAMESPACE CONTROL CATALOG Oracle Database Catalog Views 9.1.0.3.0 VALID SERVER SYS CATPROC Oracle Database Packages and Types 9.1.0.3.0 INVALID SERVER SYS 2 )       V$VERSION ( View ) SELECT * FROM V$VERSION This is the result: BANNER Oracle Database 9G Enterprise Edition Release 9.1.0.3.0 - 64bi PL/SQL Release 9.1.0.3.0 - Produc

Test automation for SAP R/3 applications using QTP has become quite an interesting topic and in absolute demand by most companies implementing SAP these days worldwide. As a result, it has become necessary to have, in hand, a ready library of functions which assist to implement QTP scripting for SAP R/3 application quickly and easily. In this section, we will discuss how to login to SAP R/3 application using QTP and Vbscript when the user credentials are provided through an external spreadsheet. The steps towards building such script would be; 1)        Close any existing excel process running on the system. 2)        Open the spreadsheet where user credentials have been provided and read the             credentials. 3)        Read the details like Server name, Client details and Language from the spreadsheet 4)        Login to SAP. 5)        Quit Excel process and close all open objects. Following sections helps to understand the code used for each steps. 1)        Close any existin

This article is intended for SAP functional consultants to configure automatic replenishment of a particular storage type for transfer orders. Whenever the stock in a bin falls below the MIN value (predefined minimum quantity), it will trigger replenishment or transfer request (TR) which will in turn get converted into a transfer order, so that the workers in the warehouse can carry out the actual physical transfer of stock. We have a provision of assigning a definite storage type from where the stock will be picked up for replenishment.   Step 1 : Material Master has to be maintained with Warehouse Views. Under Warehouse Mgmt 2 Storage bin, Maximum bin Quantity, Minimum bin Quantity and Replenishment Quantity has to be maintained. Configuration Changes: Step 2 : Movement type 320 is copied from existing movement type 319 under Logistics Execution ->Warehouse management->Activities->Transfers->Define Movement Types. Movement type 320 is configured as the following