• Category: EBS R12, Scripts & Queries 2014.06.12 No Comments

    When doing an upgrade from Oracle Applications 11i to R12, we often have to mitigate custom code to be compliant with R12. In this process you often come across code that is or might be obsolete, and it would save some time if you could just delete this code. If the code is used for a concurrent […]

  • Category: Fusion Middleware 2014.02.11 No Comments

    Out of the box, the Forms and Reports 11g servers are set to a size suitable for development environments, but typically that is too low for production environments. Determining the memory size Forms and Reports servers use a heap with a minimum and maximum size. So even if your OS environment has memory to spare, […]

  • Category: Uncategorized 2014.02.06 No Comments

    I just finished installing FreeNAS with ZFS at home, and it’s working fine. However, I didn’t read the full documentation first, so I found out after I was done what I should have done. FreeNAS is an open source NAS system based on FreeBSD and as there is a FreeNAS disk image available, you basically […]

  • Category: EBS R12 2014.01.22 No Comments

    If you’re not following the Oracle recommended method for host script concurrent programs (where you use the .prog extension for the scripts), all parameters will be passed as 1 parameter containing all parameters as a string, like XXCUSMYCONCURPROG FCP_REQID=123456 FCP_LOGIN=”APPS/APPSPWD” FCP_USERID=12345 FCP_USERNAME=”SOMEUSER” FCP_PRINTER=”noprint” FCP_SAVE_OUT=Y FCP_NUM_COPIES=0 “FIRSTPARVALUE” , and you will have to extract the values […]

  • Category: EBS R12, Scripts & Queries 2014.01.21 No Comments

    One of the issues with host script concurrent programs is that they can only return 2 statuses: 0 (=success) or 1 (=error), but sometimes we want to return a warning status instead. For example when we run a SQL*Loader script, and records get discarded, and are not put in the bad file. We probably want […]

  • Category: SQL & PL/SQL 2013.11.06 No Comments

    Regularly we come across fields containing a string with multiple concatenated values (e.g. “1234, 5678, 9012, 3456″) and we need to run a query that selects the row with a specific value in that text field, e.g. “9012”. If we would have a table MYTABLE with columns ROW_ID and MYSTRING, with MYSTRING containing the concatenated […]

  • Category: Uncategorized 2013.04.05 No Comments

    If your Linux VM is running out of disk space, this is how you can increase it. It is a 2 step procedure: first you increase the VM file size, then you increase the partition in the VM. In my case I was working with an Oracle VM using VirtualBox on Windows 7. The files […]

  • Category: Fusion Middleware 2013.04.01 No Comments

    Change in formsweb.cfg. On the development server: ~/Middleware/user_projects/domains/<domainname>/config/fmwconfig/servers/AdminServer/applications/formsapp_11.1.2/config/formsweb.cfg On the deployment server: ~/Middleware/user_projects/domains/<domainname>/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config/formsweb.cfg jpi_download_page=http://www.oracle.com/technetwork/java/javase/downloads/index.html jpi_classid=clsId:CAFEEFAC-0017-0000-FFFF-ABCDEFFEDCBA jpi_codebase=http://java.sun.com/update/1.7.0/jinstall-7u17-windows-i586.cab jpi_mimetype=application/x-java-applet

  • Category: Fusion Middleware 2013.04.01 No Comments

    To start the Weblogic Server 11g manually, initially use the following command (assuming you’re running the server in Production mode): nohup $MW_HOME/user_projects/domains/DOMAINNAME/bin/startWebLogic.sh \ -Dweblogic.management.username=weblogic \ -Dweblogic.management.password=PASSWORD \ -Dweblogic.system.StoreBootIdentity=true \ > $MW_HOME/logs/nohup_admin_`date +%Y%m%d%H%M%S`.out 2>&1 & Change DOMAINNAME and PASSWORD to the appropriate values. Also change the username if you changed the default one. This will expose […]

  • Category: EBS R12, XML Publisher 2012.03.13 No Comments

    You can migrate XML Publisher report templates from 1 instance to another by using XDOLOAD and FNDLOAD. The steps to follow are: 1) Extract the data from the source instance. From the OS command prompt, do: java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \ -DB_USERNAME apps \ -DB_PASSWORD <appspwd> \ -JDBC_CONNECTION ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=<port>)) \ (CONNECT_DATA=(SERVICE_NAME=<SID>)))’ \ -APPS_SHORT_NAME <appl_shortname> \ -DS_CODE […]

Ads by Google