Problem: While running patch 9491976 during R12 upgrade, the following error occurs:
AutoPatch error: adprdf(): At line 3 in file G:\patches\9491976\u9491976.drv: This patch cannot be applied to your current release. Patch's intended release is "12.0.0" Your current release is "11.5.10.2"
Solution: Apply patch 9491976 with option ‘preinstall=y’.
Problem:
After installing the R12.1 Vision instance on Windows Server 2003 and patching to R12.1.3, navigated to Purchasing, Vision Operations (USA) > Buyer Work Center > Orders. Selected an order’s radio button, selected View PDF from the drop-down list and clicked Go.
The following error was displayed:
System failed to generate the PDF document. Please contact your system administrator.
Solution:
Navigate to the XML Publisher Administrator responsibility > Home > Administration. Under Properties > General, change Temporary directory from /tmp to C:TEMP and save.
Problem:
When trying to convert the char column (attribute9) to date using the to_date function in SQL Developer, the following error is displayed:
ORA-01843: not a valid month 01843. 00000 - "not a valid month" *Cause: *Action:
Solution:
Dates were stored in two different formats (mm/dd/yyyy) and (dd-mon-yyyy) in the attribute9 column. Convert all dates to one format (dd-mon-yyyy).
‘ap7001are.us.oracle.com’ Target Host in R12 Database Control
Problem:
After enabling and launching Database Control on an R12.1 instance, the instance ‘ap7001are.us.oracle.com’ is seen as a target host and ‘PROD_ap7001are.us.oracle.com’ as the listener.
Solution:
Drop and recreate the Enterprise Manager repository on the R12 instance.
Problem:
While configuring Enterprise Manager Database Control for an R12.1 instance on Windows 2008, the following error is encountered:
tzOffset for America/Caracas is -270(min), but agent is runnning with tzOffset -240(min)
Solution:
Change time zone in emd.properties and operating system.
Problem:
After creating an spfile on an 11g instance (11.1.0.7) on R12.1.3 on Windows 2008, it does not automatically appear when the ‘show parameter spfile’ command is issued in SQL*Plus.
Solution:
When the database is started via the Windows Services panel, it seems that the pfile is used by default, even though the spfile may have been created. Stop and start the database via SQL*Plus to see the spfile.
Problem:
In Windows Server 2003, to increase the memory allocated the applications, we usually modify the boot.ini and add /3GB. However, there is not boot.ini in Windows 2008. How can more memory be allocated to user’s applications?
Solution:
Use the BCDEDIT command.
Customizing R12 Start Page Logo
Problem:
How do I change or customize the Oracle logo on the R12 E-Business Suite Oracle Application Framework (OAF)/Self-Service Pages?
Solution:
In EBS, navigate to System Administrator > Profile > System
Query “Corporate Branding Image for Oracle Applications” and set its value at the Site Level to name of the picture file with the new logo. The file can be PNG, JPG or GIF (you may need to experiment to confirm this).
On the server, place the picture file in the $OA_MEDIA directory (such as F:oraclePRODappsapps_stcomnjavaclassesoracleappsmedia).
Reference:
Customizing the Corporate Branding Image for JTF-based Pages [ID 1464570.1]
Problem:
How do I change the default text, “E-Business Suite”, at the top of all Oracle Application Framework/Self-Service pages?
Solution:
Launch EBS and navigate to:
System Administrator > Application > Functions
In the Function column, query for FWK_HOMEPAGE_BRAND (type F11, type FWK_HOMEPAGE_BRAND, type Ctrl+F11).
One row appears in the form. Under the User Function Name column, type the text that you want to appear on the OAF pages and save the changes.
Problem:
How do I transfer a workflow from one R12 instance to another?
Solution:
Use the WFLOAD command to download or upload the workflow.
Recent Comments