Best Of
Re: Tools for enabling TLS/SSL in on premise Essbase
Hello David_McAffee
Thanks for following up with us via the Oracle Community.
The TLS Tool will use the provided PEM certificates to configure Weblogic, EAS and Essbase with them. After you run the tool, the entire system will be ready to go in SSL mode with the new certificates.
Here is the documentation for the process:
Document: Essbase 21 - Essbase Independent Deployment
Section 6 - Secure Your Communication and Network
Reference:
Please review it and feel free to reach out to us if you have any additional questions.
Thanks for posting your questions on the Oracle Community.
Thanks,
Victor - Essbase Support
How to Configure the Quick Access Bar to Appear on the Side Panel
By default the Quick Access Bar will show in the Homepage Header.
This new KM document for portal admins explains how to configure the Quick Access Bar (QAB) to appear in the side panel. Doc ID 3089979.1. https://bit.ly/3TQtHFh
Re: How to search implicit term/word in support.oracle.com?
Hi @Max Prestes
Search team states this:
Doing "lookup" "responsibility" will get results for documents containing both lookup and RESPONSIBILITY , and only lookup or RESPONSIBILITY. However, the documents with both lookup and RESPONSIBILITY should be scored higher and placed on top over the single word match. We do not support boolean search "lookup" AND "RESPONSIBILITY" from user's input.
That said, you can see this rating better under the "Documents" section of results returned from the Portal search.
I'm asking them for an enhancement to support the boolean operator for AND, but that wouldn't be anytime soon.
Regards,
Margi - MOSC Admin
Re: Limit TLS sessions on Oracle Acme Packet 4600 SBC
Hi,
I have moved this question into the Oracle Sun Technologies (MOSC)› Acme Packet (MOSC) subcategory for those subject matter experts to further engage.
If an answer resolves your question, please choose the "YES" on that comment for "Did this answer the question?".
In the meantime, feel free to review the following information to learn more about our Community:
- How to Find and "Follow" Categories - Learn how to Follow Categories of interest
- Setting Up Category Notifications for New Content - Learn how to get notifications on content
- How to Search and Do Advanced Search - Learn how to get to advanced search and filter options
- Visit our MOSC Resource Center,
- Browse all of our represented Product Categories.
- How to Edit Your Community Username - Details are provided to change your default display name, which will allow for a more personalized profile.
- How to Ask Questions and View Answers - My Oracle Support Community organization details are provided, which can be used to find the product subcategory for your question.
- Community Guidelines: https://community.oracle.com/mosc/kb/articles/27-my-oracle-support-community-guidelines
- How to be a good Community citizen" -- https://community.oracle.com/mosc/kb/articles/23-my-oracle-support-community-posting-etiquette
- Not posting Private Information: https://community.oracle.com/mosc/kb/articles/15-what-is-pi-information-and-why-is-it-important
- How to be a Community Star: https://community.oracle.com/mosc/kb/articles/30-how-to-be-a-community-star-six-behaviors-to-promote-mosc-success
Best Regards,
Margi
My Oracle Support Community Administrator
Re: reconfiguring JDE with the new DB name
Hello,
The database server references are stored and modified through P9654A (Machine Identification) and P986115 ZJDE0002 (Database Data sources).
If it is Oracle, you will also need to change the tnsnames.ora file useed by Oracle DB client.
You will also need to change the references to the database in JDE.INI (for Enterprise Server and FAT client) and in JDBJ.INI (for Java based servers and with the newer tools releases, on Enterprise Server too).
Thank you!
Best regards,
Cezar
Re: Wrong cardinality for a GTT whose stats have juste been gathered
If you have a suitable account you could pass that one to Oracle in an SR - it looks like a bug in parallel processing.
Historically there have been some significant evolutionary stages in parallel execution plans. Once upon a time the QC would "decompose" a statement for the PX processes so that they executed something that looked nothing like the original. Then the version came were the PX processes executed the same statement as the original but (presumably) the QC passed them enough information that there was no t overlap in the data they processed,
Unfortunately since the PX processes were optimising the statement for themselves they would occasionally manage to produce different execution plans from each other which could, of course, cause overlapping data fetches and wrong results. To handle this problem I think Oracle then got the QC to work out the plan and send hints (rather like a stored outline / SQL Plan Baseline etc.) to the PX processes to reproduce the plan the QC expected for some cases - which is why recent parallel execution plans may have a note saying things like:
parallel query server generated this plan parallel query server generated this plan using optimizer hints from coordinator
I've still seen a note on MOS, though, about a case where the PX processes managed to get the wrong plan even after using the hints from the QC ;)
Regards
Jonathan Lewis
P.S. I wouldn't advise it, but there are events you can set to get the optimizer trace file and the parallel execution debug trace file. If you report the issue to Oracle they might tell you to do this as it may help their developers find the source of the anomaly.
Re: E1: 45: line adjustment based on null value of aleternate cost methods
From Oracle Support: thank you for the post Mathieu.
Yes, this would need to be a BC 8 scenario - the closest we come under the standard functionality is the Basis Codes 3 and 4 to look at a specified Cost Method in the adjustment, but no ability to switch to a different Cost Method if the initial method is not valid.
With kind regards,
-Matt
Re: PeopleSoft 9.2 Payables
Hi User_PNY60,
Welcome to the Financial Management - PSFT (MOSC) Community and thank you for posting your question!
If you ran matching and the voucher is matched then there should not be an exception link.
You can provide more details and I would suggest you to log a SR so that we can troubleshoot the issue.
Regards
Vaishali N
