foalabs

Unable to Open Log and Output file in the Browser in Oracle Apps EBS Error: We have seen this issue very recently in our EBS instance where users were not able to open Log & Out files in browsers in our EBS R12.2 instance. The browser page was showing a blank page. The below process was followed to troubleshoot and fix the issue ASAP. “FS Diagnostic Test Program” is usually used to Troubleshoot FNDFS and FNDWRR (Problems Viewing Concurrent Request Output. When we ran this diagnostic program, it gave us the below error: Issue: The main focus was on FNDWRR.exe and its affiliated files at the server end to see for any changes and it was finally located that txkFNDWRR.pl perl file under $EBS_ORACLE_HOME/common/scripts/ was showing up as a NULL size file. The same file was showing up as a NULL file in Non-Production instances too. As a quick solution,  this file was copied from Patch Edition to Run Edition under $EBS_ORACLE_HOME/common/scripts/ which resolved the issue for users. As...

Step-by-Step guide on creating a DB adapter in Oracle WebLogic Server Step 1: Login to Oracle WebLogic Server Console Open a web browser and navigate to the Oracle WebLogic Server Console URL. Log in using your credentials.  http://funebs.lan:7001/console Step 2: Accessing the Resource Adapter Configuration Once logged in, navigate to the domain's home page in the WebLogic Server Console. Click on the "Deployments" link under the "Domain Structure" section. Search for the "eis/DB" entry and click on it. Step 3: Configuring the DB Adapter On the "eis/DB" page, click on the "Configuration" tab. Click the "Outbound Connection Pools" link. Step 4: Creating an Outbound Connection Pool Click the "New" button to create a new outbound connection pool. Fill in the required details, such as Name, JNDI Name, and Database Driver. Configure the necessary properties, including database URL, username, password, and any addition...

Unable to find an Output Post Processor service to post-process request Error: Concurrent Requests fail during Post Processing with the following errors: 'Unable to find an Output Post Processor service to post-process request 123456. Check that the Output Post Processor service is running' Solution: 1. Find the active processes for OPP: SELECT fcp.concurrent_process_id FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp WHERE fcq.manager_type in (select service_id from FND_CP_SERVICES WHERE service_handle='FNDOPP') AND fcq.concurrent_queue_id = fcp.concurrent_queue_id AND fcq.application_id = fcp.queue_application_id AND fcp.process_status_code = 'A'; Output example: CONCURRENT_PROCESS_ID --------------------- 83557 83558 2. Find the OPP subscribers: select name from APPLSYS.AQ$FND_CP_GSM_OPP_AQTBL_S; The name in the table is the concurrent_process_id prefixed with 'OPP'. The output should normally correspond to the output of first query: have ...

Creating a Physical Standby database using RMAN restore database from service In this post I am sharing step by step method for instantiating a standby database using the RMAN “from service” clause to copy directly from the primary database through an Oracle Net connection. This method is valid for   Oracle Database Server versions 12.1 to 19c and higher. SECTION SIZE support is available. The section size clause used with multiple RMAN channels enables parallelization of individual files by dividing large files into smaller pieces.  This improves the overall efficiency of parallelization across channels. Encryption is supported. Compression is supported. The RMAN ‘from service’ clause enables the restore and recover of primary database files to a standby database across the network. This functionality can be used to instantiate a standby database in lieu of the RMAN DUPLICATE DATABASE command and is more intuitive and less error prone thus saving time. This ‘FROM SERVICE‘ met...