Best Of
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
Re: Supplier As Customer In Oracle EBS R12 Module.
Hi
Supplier won't appear as Customer unless you create a customer account.
If you want to use supplier as customer then create a account using supplier party , and also create Site and Bill to under that site.
Best Regards,
Bharat
Re: WebLogic 14.1.2- is "make" utility needed now for running spbat or we get OPatch error code 73?
Have a look at the system requirements guide. It lists make.
x86-64 Oracle Linux 9 (UL2+) and RHEL Linux 9 (UL2+)
x86-64 Oracle Linux 8 (UL6+) and Red Hat Linux 8 (UL6+)
![Nick [Application Server] -Oracle](https://us.v-cdn.net/6032256/uploads/userpics/99FV8E0EEW09/n1DRCNFJ5LDAF.jpg)
How to Create a Manual Contract Billing Invoice and Batch for a Lump Sum Billing Line
This new document explains how to manually create a Contract Billing invoice and batch for a Lump Sum Billing Line (P48221/P48222/P52121/P5222/P52221/R52121). Doc ID 3086152.1. https://bit.ly/3TEpxjr #E1Financials #ContractBilling
