Monthly Archives: September 2021

R12 E-Business Suite Applications Manager Clone Process Fails With Error ‘AC-50006: Could not assign any APPL_TOP name to this instance’ When Running Adcfgclone.pl AppsTier On An Environment

APPLIES TO: Oracle Applications Manager - Version 12.1.3 and later SYMPTOMS: E-Business Suite R12 Applications Manager, Rapidclone related issues java.lang.Exception: AC-50006: Could not assign any APPL_TOP name to this instance.…

Read More

FNDLOAD SYSNTAX FOR ALL APPLICATION OBJECTS IN EBS R12.2

Description: Following steps are used to upload the application objects using FNDLOAD. FNDLOAD Syntax These are the extensive list which can be done through FNDLOAD — Concurrent Programs, Executables —…

Read More

FORMS COMPILATION IN EBS R12

Description: Following steps are used to compile the forms in EBS R.12. Steps: Step 1: Login to application user in application server through winscp and go to $AU_TOP/forms/US step 2:…

Read More

perl adcfgclone.pl appsTier dualfs ERRORS and SOLUTION

1) perl adcfgclone.pl appsTier dualfs ERRORS and SOLUTION ============================================ ERROR 1 ========= StackTrace: java.lang.Exception: oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Exception : Error executng BEGIN fnd_gsm_util.upload_context_ file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1552: ORA-01552: cannot use…

Read More

ORACLE GOLDEN GATE INSTALLATION IN 19c DATABASE

Environment Details Server Name                         : primegg.localdomain OS Version                           : Oracle Linux Server release 7 Database Version                 : 19.0.0.0 GoldenGate Version             : 19.1.0.0.4 for oracle Oracle Home                        : /u01/app/oracle/product/19.0.0/dbhome_1 GoldenGate…

Read More

Display the multiple errors in OAF

import com.sun.java.util.collections.ArrayList; import oracle.apps.fnd.framework.OAException; import oracle.apps.fnd.common.MessageToken; ArrayList errorMsg= new ArrayList(); for (int i=0; i< hMember.size(); i++) { MessageToken[] token = {new MessageToken(“USER”, getOADBTransaction().getUserName()),new MessageToken(“NUM”,hMember.getChildNumber())}; errorMsg.add(new OAException((String)(getOADBTransaction().getMessage(“XXFKI”,”XXFKI_ERRORS”,token)))); } OAException.raiseBundledOAException(errorMsg);

Read More

How to change the column header dynamically in advance table.

To change the column of a header dynamically use the following code in your controller. import oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean; import oracle.apps.fnd.framework.webui.beans.table.OAColumnBean; import oracle.apps.fnd.framework.webui.beans.table.OASortableHeaderBean; OAAdvancedTableBean tableBean = (OAAdvancedTableBean)webBean.findIndexedChildRecursive(“VendordtlRN”); OAColumnBean columnBean = (OAColumnBean)tableBean.findIndexedChildRecursive(“SupplierID”); OASortableHeaderBean…

Read More

Query to get submitted Request set Parameter details

Query: select name,argument_text from (SELECT prog.user_concurrent_program_name || DECODE (req.description, NULL, NULL, ‘:’ || req.description) name, req.request_id, req.parent_request_id, req.request_date, DECODE (req.request_type, ‘P’, actual_start_date, requested_start_date), req.actual_completion_date, FLOOR( ( (actual_completion_date – DECODE (req.request_type,…

Read More

Query to get Request Set Details

Query: SELECT rs.user_request_set_name “Request Set”, rss.display_sequence seq, cp.user_concurrent_program_name “Concurrent Program”, e.executable_name, e.execution_file_name, lv.meaning file_type, fat.application_name “Application Name” FROM fnd_request_sets_vl rs, fnd_req_set_stages_form_v rss, fnd_request_set_programs rsp, fnd_concurrent_programs_vl cp, fnd_executables e, fnd_lookup_values lv,…

Read More

SSH Key Upload in Oracle Fusion

When we use SSH keys for authenticating third party servers, the Public key will be configured in third party server whereas Private key will be configured in Oracle BI Publisher…

Read More