Best Of
Re: Issue with routing calls from reg-based trunk
Hey Antonio,
Thank you for the responses. Unfortunately, it seems like the SBC is not able to handle surrogate registration in a multi-tenant environment where calls will be sent and received by multiple downstream PBXs. Because of this, I decided to approach an alternative of using a different system specifically for handling registration and bridging calls to the SBC which works flawlessly.
Thank you for you help :)
Re: How to manage upgrade from 8.1.1.10 to 25.4 and move to containerized Siebel servers?
Hello @User_06HV0
Regarding your questions, it requires two-fold approach, the first thing is upgrading the Siebel Database to the latest Siebel version. There is one-step upgrade path to 25.x, you can verify this on the following link:
https://docs.oracle.com/cd/E88140_01/books/UPG/UPG_SimplOver2.html#wp1184825
IP17 is the latest Innovation Pack and the current (latest version) is 25.7.
Below is the link to the latest Siebel Database Upgrade guide:
https://docs.oracle.com/cd/G30557_01/books/UPG/index.html
Regarding containerization, Oracle does provide container images. You can find them by searching for Patch # 38155035 on Patches & Updates. These images are compatible with Kubernetes-based container orchestration platforms, such as Oracle Kubernetes Engine (OKE) and Red Hat OpenShift. You can deploy Siebel containers using tools like Docker, Kubernetes, and Podman. The recommended approach is to use the Siebel Container Management (SCM) utility for containerized deployments.
You can find additional information on the document below:
Scope of Support for Siebel CI/CD, Containers, Kubernetes, DevOps Tools and Siebel Cloud Manager (Doc ID 2872375.1)
Regards,
Michael Harada
Re: How to manage upgrade from 8.1.1.10 to 25.4 and move to containerized Siebel servers?
Regarding your Query1, you don't need any containers. You basically need a Windows VM where you can install the Siebel binaries with access to the current 8.1.1.10 database. You can select any infra that fits your requirements, there is nothing specific, except the supported platforms that you can find on certify matrix on MOS. You may want to explore the Siebel Upgrade Factory, please search on MOS, this can help you expedite the upgrade process if you have an OCI tenancy.
Performing Database Upgrade On Oracle Cloud Infrastructure (OCI) Using Siebel CRM Upgrade Factory (Doc ID 2957429.1)
Regarding your Query2, this should be discussed with our CSS team via a billable service as they have the right expertise to assist on the planning, sizing and even on the whole upgrade and migration process.
Regards,
Michael Harada
My Oracle Support’s PowerView
My Oracle Support’s PowerView.
This feature enables you to filter information located on three tabs
(Dashboard, Knowledge, and Service Requests) using a variety of
different attributes. You have the capability to create multiple PowerViews
each having the ability to display targeted information. This feature
has superhero gripping powers simply by defining filters that will
either display or exclude attributes.
Oh! What a tangled web we weave as there are a few nuances you'll need to know about PowerViews.
• If you use the configuration manager, more advanced PowerView options are available.
• Not all regions respond to all possible PowerViews. Make sure you glance at the filter bar in a region to see which attributes of the current PowerView apply to that region.
• PowerView overrides any filters which are set in the region. When you turn off PowerView, the local filters become active again.
• The PowerView filter does not apply to searches where Documentation is the source.
Want to learn more? Here are a few more helpful links.
• For instructions on how to Create, Edit, or Remove a PowerView, navigate to the document entitled “ My Oracle Support Help – General”, Doc ID 733242.5; specifically the section titled PowerView.
• Click HERE to view a training video about PowerView.
• My Oracle Support Help - Knowledge Search, Doc ID 733384.5, in the section titled “Using PowerView with the Knowledge Home Page and Searching (My Oracle Support Flash Only)”
Re: Question about "19.28 release Update Known Issues (Doc ID 19202507.9) # 1.13 Incorrect results ..."
Yes, after applying the 19.28 DB RU, set the following parameter :
alter session set "_px_single_server_enabled" = false;
Question about "19.28 release Update Known Issues (Doc ID 19202507.9) # 1.13 Incorrect results ..."
I have a question about Doc ID 19202507.9 # 1.13 "Incorrect results may be returned when using "ORDER BY" with parallel execution and rowsets enabled."
I think that every Oracle 19.28 database and its associated applications could be affected.
Does that mean that after applying the 19.28 RU patch, we should implement the specified workaround (alter session set "_px_single_server_enabled" = false; ) in all databases?
And if so, then it certainly makes sense to implement it with "alter system set "_px_single_server_enabled" = false;"?
Regards,
Hans-Martin Ruff
Re: R12.2.10 How to query Sales Order header, lines, DFF values and UDA values
Hi @User_B2273 ,
Below query is to capture order and customer details from Sales order number. You can modify the same as per your requirement:
Thanks,
Vyshali
Re: ASCP- Calendar Impact
Hi @User_YFCRD ,
The question that has to be asked is not what product does. What is that the users want to do with the existing orders?
Changing any transactional calendars means the functioning of your org has changed… with that how can they received or ship the existing orders on non-working days?
SSD and SAD on existing SOs will not get updated automatically. Those orders have to scheduled again to align with the new reality\setup.
Hope the above helps!
Best Regards,
Mohan Balaji
Share An Issue in HAMI We Had With Applying ODA 19.27 in DBS
Hi All,
Think of sharing this with the community to potentially avoid trouble.
What we had was patching our ODA X9-2 HA from 19.25 to 19.27, everything in BM ran well.
There was some trouble with patching dcs-component in DBS after successfully patched dcs-admin, the error looks like this and it's not easy to fix.
DCS-10008:Failed to update DCScomponents: 19.27.0.0.0 DCS-10001:Internal error encountered: Failed to execute action with exception: DCS-10172:DCS infrastructure is not ready: HAMI ensemble is not ONLINE.Skip metadata schema update because current version is same as target version
We've raised a SR and got it fixed at the end. There is a workaround we could do in advance to avoid this issue as once you had it it would be a bit troublesome to fix , which might involve a live meeting with Oracle support.
The error above was because of the new version of HAMI in 19.27 does not like our old HAMI setup in 19.25 and stopped working during the dcs-component patching, which led to dcsagent not able to start, and you know you could not do much especially patching without the agent running.
To check you'd have this issue, run /opt/oracle/dcs/hami/bin/hamictl.sh status and check your /etc/hosts to query your HAMI setup.
[root@dbshost1-1 ~]# /opt/oracle/dcs/hami/bin/hamictl.sh status
Switching current process ID from "root" to "hamictl_oda_dcs" (0 -> 5000)
MEMBER HOST STATUS PID PORT
ODA_DCS0 dbshost1-1-priv ONLINE (2025-07-05 14:07:11 ACST; 2 days ago) 9038 22001
ODA_DCS1 dbshost1-2-priv ONLINE (2025-07-05 14:07:11 ACST; 2 days ago) 9140 22001
[root@dbshost1-1 ~]# grep priv /etc/hosts
192.168.10.111 dbshost1-1-priv.domain dbshost1-1-priv dcs0-priv
192.168.10.112 dbshost1-2-priv.domain dbshost1-2-priv dcs1-priv
If you don't have dcs?-priv in the HOST part of the HAMI output, then you will need to re-config your HAMI to allow it to be liked by new HAMI. In short, new HAMI only like dcs0-priv and dcs1-priv in the HOST part.
I'm not sure if I could/should share the re-config command here, but highlighted step would be stop dcsagent, cleanup current HAMI configuration, change the /etc/hosts to move dcs?-priv to the position right behind IP, then start dcsagent.
This would be what it looks like afterwards:
[root@dbshost1-1 ~]# grep priv /etc/hosts
192.168.10.111 dcs0-priv dbshost1-1-priv.domain dbshost1-1-priv
192.168.10.112 dcs1-priv dbshost1-2-priv.domain dbshost1-2-priv
[root@dbshost1-1 ~]# /opt/oracle/dcs/hami/bin/hamictl.sh status
Switching current process ID from "root" to "hamictl_oda_dcs" (0 -> 5000)
MEMBER HOST STATUS PID PORT
ODA_DCS0 dcs0-priv ONLINE (2025-07-09 17:38:48 ACST; 1 weeks 0 days ago) 3397 22001
ODA_DCS1 dcs1-priv ONLINE (2025-07-09 17:38:48 ACST; 1 weeks 0 days ago) 3391 22001
Then it should be fine to start patching DBS from dcs-admin.
If you already have the dcs?-priv in your configuration then guess you are lucky :)
BTW, our BM it has dcs?-priv already, so no issue with applying the dcs component.
Hope this help.
Cheers :)
Ocean
Ocean
Re: Supplier As Customer In Oracle EBS R12 Module.
Please check the below notes :
R12: AP: How To Create a Supplier That is Also a Customer (Doc ID 1332493.1)
How To Create A Customer And A Supplier Under A Single Party? (Doc ID 1299828.1)
Thanks
