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 MoreIntroduction 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 MoreMANUAL 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 MoreOracle 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 MoreTo 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 MoreThere 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 MoreSQL> Startup upgrade ORACLE instance started. Total System Global Area 1.3262E+11 bytes Fixed Size 2304584 bytes Variable Size …
Read MoreOracle 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 MoreBelow 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 MoreBelow 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