OTN Discussion Forums Update

A guest post from:

Sonya Barry
Director of Community Infrastructure
Community Manager Java.net and Oracle Technology Network

The OTN Discussion Forums are about to get a major overhaul. More than a simple upgrade, we're doing a complete content migration to a brand new platform for the Oracle Technology Network Community. The new Community space will have vastly improved search and performance out of the box and the ability for users to configure their own dashboards. Over the next few months we'll be adding other features like reply by email and direct messaging between users. We're also doing a lot of cleanup - many of the existing forums are for older product versions so we're moving them to the archives, which will be searchable. The biggest makeover will be in the Java space, with new forums for several products and merging some content areas together where it makes more sense to simplify them.

We'll be taking the forums offline at 9pm Pacific on Friday May 3 for a few hours, and then they will be back a few hours later with read-only access while we do the data migration. We expect to switch over to the new platform in production on Monday morning.


August 12, 2015 

The Forums overhaul described in the original blog post has long since been completed. The new forums are available here: http://community.oracle.com

The new site has been expanded to include technical articles and other content, organized by product and technology. Technical questions about any Oracle product should be posted in the relevant product space. 


How do we customize categories to refine catalog search in OIM 11g R2?

Hi All,

We have Application Instances, roles and Entitlements in categories in order to refine catalog search in OIM 11g R2.
I need to customize catalog search to add another search item "Module" to the categories so that when I select a particular module, catalog search should result in data related to that module selected.

How to I customize the above scenario?

Thanks in Advance.

Posted by Swetha on September 02, 2013 at 11:08 PM PDT #

Hello, when i am trying to set the variable plsql_debug=TRUE using the command

alter package package_name compile BODY plsql_debug=TRUE reuse settings ;

through PUTTY, the changes are getting reflected in the database, and can view the same using the SQL developer,
but when I compile the packege again through PUTTY using the command:

alter package package_name compile BODY;

The change gets revert, the value of plsql_debug in the table 'USER_PLSQL_OBJECT_SETTINGS' becomes FALSE.

How to make it permanent, so that its value does not get changed after every cmpilation..
I am using oracle 11g as database and PUTTY on Linux.

Posted by guest on September 04, 2013 at 11:58 PM PDT #

I have my tow table structures as

create table Uem_HCIpGwServerGroup (
hcIpGwServerGroupId NUMBER(12,0) NOT NULL,
hcIpGwServerGroupName VARCHAR2(50) NOT NULL,
numberOfPrimaryServers NUMBER(1) NOT NULL,
CONSTRAINT C25141 PRIMARY KEY (hcIpGwServerGroupId),
CONSTRAINT C25142 UNIQUE (hcIpGwServerGroupName)

create table Uem_HCIpGwServer (
hcIpGwServerId NUMBER(12,0) NOT NULL,
hcIpGwServerGroupId NUMBER(12,0) NOT NULL,
hcIpGwServerName VARCHAR2(60) NOT NULL,
primaryServerFlag NUMBER(1),
CONSTRAINT C25145 UNIQUE (hcIpGwServerName)

create table IPGWINDIV add (
primaryHcIpGw NUMBER(1),
hcIpGwServerGroupId NUMBER(10),
hcIpGwServerId NUMBER (10),
ipgwenvcfmultipleinstanceid NUMBER(1),
CONSTRAINT C25146 FOREIGN KEY (hcIpGwServerGroupId) REFERENCES Uem_HCIpGwServerGroup (hcIpGwServerGroupId),
CONSTRAINT C25147 FOREIGN KEY (hcIpGwServerId) REFERENCES Uem_HCIpGwServer (hcIpGwServerId)

I have the data in the Uem_HCIpGwServerGroup & Uem_HCIpGwServer but still I am getting foreign key constraint error C25146 . This error occurs occasionally. Why?

Posted by rai_hsc on September 11, 2013 at 03:43 AM PDT #

Hi there,
i am currently running Oracle Business Intelligence 10g. I am using MS Excel 2007. At our company we currently have an issue where if i run a report and it has more than 65,000 rows of data, it won't export corretly from business intelligence into excel..it will only export the 65,000 rows. How can i fix this so that it will export all the data in my report?

Posted by Roxanne on January 14, 2014 at 10:58 AM PST #

Hi All,
I have got an issue in OATS. I have created a Project in OTM and managing/scheduling scripts through OTM ( oracle Test Manager ) in my VM. Now i want to Export the project( which is in OTM) in my VM and import on to another VM where OATS has been installed.
In OTM Once i have exported the project, a zip file has been created in my VM. Now i have logged on to another VM through OTM and while importing tat zip file, i m getting an error.
**** INFO: Time for importing this file was 11 seconds

**** ERROR: while executing imports

Can any one please suggest what is the issue and how can i over come it.


Posted by Kiran G on March 02, 2015 at 03:25 AM PST #

For answers to your technical questions, please visit the OTN Community, where you will find discussion forums for all Oracle products.

Posted by Bob Rhubart on March 02, 2015 at 04:33 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed