Yearly Archives: 2021

Validating the Duplicate values using JavaScript in Oracle APEX

Introduction: To avoid duplicate values in Interactive Grid in Oracle APEX. Cause of the issue: In newly created APEX Page, there is user requirement to validate the duplicate values on…

Read More

Query to Extract the IPV Report Data

Introduction This Query will help to Fetch the IPV Report Data in Oracle Apps. SQL Query: BEGIN fnd_client_info.set_org_context (:p_org); END; SELECT glps.set_of_books_id, msi.organization_id, pov.vendor_id, glps.period_name, api.invoice_num invoice_num, aid.accounting_date invoice_date, DECODE…

Read More

MANUAL DATAGUARD SWITCHOVER 19c

MANUAL DATAGUARD SWITCHOVER 19c Switch over: It is reversal of role between a standby database and a primary database. The primary database assumes role of standby database and the standby…

Read More

Oracle Dataguard physical Standby configuration in 19c(Active method)

  Oracle Dataguard physical Standby configuration in 19c:(Active method-without using rman backup) Overview steps: Step:1 we have to enable the archive log mode ,flashback  on primary databases. Step:2 Then enable the force…

Read More

To Create New AutoAccounting in Oracle Apps R12

To Create New AutoAccounting in Oracle Apps R12: Define AutoAccounting to specify the general ledger accounts for transactions that you enter manually or import using Auto Invoice. AutoAccounting helps to…

Read More

Invalid objects due to multiple database editions

There are around 1000 plus invalid objects, while looking further observed that this object do not exist in current run edition and there are duplicate/multiple entries observed for RUN and…

Read More

Resolving ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

SQL> Startup upgrade ORACLE instance started. Total System Global Area 1.3262E+11 bytes Fixed Size                  2304584 bytes Variable Size        …

Read More

Oracle Invisible Columns

Oracle allows columns to be hidden from application. Columns can be made invisible in the CREATE TABLE statement or using an ALTER TABLE statement.By default columns are visible. Invisible columns…

Read More

How to check Oracle Application Modules Licensed or Not

Below script to find Oracle Application Modules are Licensed or Not. Script: SELECT fat.application_name ,fa.application_id ,fpi.patch_level ,decode(fpi.STATUS,’I’,’Licensed’, ‘N’,’Not Licensed’,’S’,’Shared’,’Undetermined’) STATUS ,fpi.* FROM fnd_product_installations fpi ,fnd_application fa ,fnd_application_tl fat WHERE fpi.application_id…

Read More

How to find the OPP log file location in oracle application 11i/R12.1 and R12.2

Below script to find the OPP log file location in oracle E-Business Suite. Script: SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp WHERE fcpp.processor_id = fcp.concurrent_process_id AND fcpp.action_type…

Read More