For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi We have a requirement where we need to change text field attribute to Italic and Underline at same time during form run time. How can we achieve this. We are using Form 10g (EBS R12.2).
Any help will be greatly appreciated.
Hi JC
Its for the different DB version with different patch levels . There is one release Oracle 12.1.0.2.0 . Please check it and choose it
Thanks
N Kandasamy
Thanks Kanda,
I have download the 12.1.0.2 versions, but one patch 28259867 is superseded by a very big patch 28833531 (3Gb).
Patch 28833531 - Database Proactive Bundle Patch 12.1.0.2.190115
How do you apply this big patch? Do I need to apply this patch? Is ETCC really reliable?
I understand there are lots of conflicts it will take, and need to rollback?
Please help....
Patch 28833531 is recommend in (Doc ID 1594274.1)
can you share are you using Database In-Memory option ?
I think we are not using in-memory?
We only use generic cheap server configuration.
Hi Kanda, and ALL,
Why does ETCC is listing missing patches but all have conflicts
It seems ETCC is "useless" after all?
Do I just ignore all?
I tried to apply patch 26336977, but it has conflict, and so with all the rest.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
26336977, 26925263, 27322338
Whole composite patch Conflicts/Supersets are:
Patch : 26336977
26654363, 26925263, 27322338
Patch : 26654363
26742604, 27322748
Conflicts/Supersets for each patch are:
Patch : 26742604
26925263, 27322338, 28500816
Patch : 28500816
26925263, 28507324
Patch : 28507324
Kind regards,
not sure. DB support team may suggest you to go for latest DATABASE PATCH SET UPDATE .
for example 12.1.0.2.190115
Patch 28729169: DATABASE PATCH SET UPDATE 12.1.0.2.190115
Oracle just updated the ETCC yesterday to include the latest update.
Find the patch in the patches and update tab -> Search for the patch. When the patch page comes up, click the 'Analyze with Opatch' button. That will take you to the patch conflict checker.
You need to upload opatch lsinventory -details..
It gave me details of the merge patches I needed right away. There was no waiting. it also gave me the patches I could download.
Thanks Imu,
I will try that...brb
Hi Imu,
I download latest ETCC.
Then I run checking and still the same output as before
Can you please explain further the process you have done?
Where do I upload the "opatch lsinventory -detail? to Oracle Support?
Where do I search the missing patch?
Thanks a lot.
$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2019 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
Using context file from currently set database environment:
/u03/ora1228p/P1228/12.1.0/appsutil/P1228_testsvr3.xml
Starting Database EBS Technology Codelevel Checker, Version 120.70
Thu Feb 14 21:05:58 +08 2019
Log file for this session : /u01/PATCH/ETCC/log/checkDBpatch_15692.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database P1228 is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.45
This file will be used for identifying missing bugfixes.
Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.20
This file will be used for mapping bugfixes to patches.
Checking Bugfix XML file for 12.1.0.2_BP
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.2.0.1.8.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2.180116ProactiveBP
Patch mapping not available.
Patch mapping data is not available for 12.1.0.2 ProactiveBP
Some required one-off bugfixes are missing from the Database ORACLE_HOME.
The missing bugfixes are:
26336977
26654363
26742604
28507324
28731800
** Refer to MOS Doc ID "1594274.1:Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes" to find the corresponding patch that delivers the bug fix. If an overlay patch is needed for any particular patch listed, the footnote for that patch also applies to the overlay patch. **
Apply the missing bugfixes and then rerun the script.
Stored Technology Codelevel Checker results in the database P1228 successfully.
Finished checking fixes for Oracle Database: Thu Feb 14 21:06:20 +08 2019
Log file for this session: /u01/PATCH/ETCC/log/checkDBpatch_15692.log
===============================================================================