Untitled
Oracle Flashback Query allows us to view and repair historical data. We can perform queries on the database as of a certain time or specified system change number (SCN). Flashback…
Read MoreOracle Partitioned Index
There are two types of partitioned Indexes in Oracle Local Partitioned Index and Global Partitioned Index a. Local Partitioned Indexes Local index is a separate index for each partition. A…
Read MoreOracleasm lib commands
ASMLIB is a storage management interface. ASMLIB is not required for ASM to function; it is like an add-on library that simplifies the tasks of managing and discovering the disks.…
Read MoreAll About Oracle DB Audit
The auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time when a user attempts anything in the database…
Read MoreASMCMD useful Commands
Below are some of the useful ASM commands which will be helpful all the time. ASMCMD > showversion ASMCMD > showversion –releasepatch –softwarepatch ASMCMD > showpatches ASMCMD > showclustermode ASMCMD…
Read Moreadcfgclone return code = .16.17.18.19.20.21
Where I Faced this Issue? When I ran adcfgclone appsTier on EBS 12.2 I got this error, and it said got error while running autoconfig, but the actual error is…
Read MoreQuery to fetch on hand quantity of an item for historic date
Introduction This blog explains to get the On hand quantity if a item in inventory for a specific date #Code# SELECT SUM (TRANSACTION_QUANTITY) TARGET_QTY FROM MTL_ONHAND_QTY_COST_V MOQV WHERE MOQV.ORGANIZATION_ID =…
Read MoreWhich type of Database release customer should follow? Long Term Release and Innovation Release?
Long Term Release: Oracle Database Long Term Releases offers highest level of stability including lot of bug fixes developed over the period of years. It typically has highest premier…
Read MorePGP Key Encryption in AP Payment Outbound Interface
PGP Key Encryption in AP Payments Generally, the PGP keys will be used to Encrypt and Decrypt the messages transferred between one system to another to enable the security. In…
Read More