Best Of
PeopleSoft Query - No Hyperlinks embedded in query for user
User is the only one in her group that doesn't have access to query hyperlinks. She is able to navigate to the Peoplesoft pages provided within the query links
Re: Option to not upgrade some package
Hi,
Welcome to Oracle Solaris Communities!
Just change the facet for the incorporation to false, and then freeze the package,
Example,
pkg change-facet version-lock.consolidation/java/java-8-incorporation=false
pkg freeze runtime/java/jre-8@1 .8.0.421.9
I hope it helps.
Regards
Saravanan
Re: Option to not upgrade some package
Hello,
From the document linked above,
Note
Unlocking packages can result in an unsupported configuration. Best practice is to keep systems updated and keep version locks set to true. See Applying Support Updates.
Do keep this into consideration.
Regards,
TLe-Oracle
Re: Retainage in Contracts (Grants-Research) - PeopleSoft
Hi Armand,
Hope you are doing well.
Have you checked the KM article below. This helps in providing the overall flow of transactions.
How To Create BRT (Billing Retainage) And RRT (Release Retainage) Transactions In Project Costing ? (Doc ID 1584226.1)
The retainage is currently associated at contract lines level via Contract Terms page.
Retainage can be defined at - Set Up Financials/Supply Chain > Product Related > Billing > Setup > Discount & Surcharge. I see not additional transaction criteria.
I will let other customers review and respond as how they are managing this use case.
But If you want to have the Retainage at transaction level, it can be reviewed as an idea. Please create an idea using idea space link providing the details of your requirement.
Hope this helps.
Thanks and have a great day!
Vijay
Re: SAP on Oracle 19c — Multiple SIDs Mapped to Same OS Process
Never looked with that detail into such a thing, why must it be a problem ?
If you kill a database session, it would just kill one database session … even if on same OS process ?
What database version are you running ?
Mr. C
Webinar: Troubleshooting & Monitoring of Oracle EBS Using OCI Observability & Management Platform
Live Webinar: Hear about the new technology and best practices designed to help troubleshoot and proactively monitor E-Business Suite, both in the cloud and on-premise. See how you can eliminate risk and manual work by automating simple, repetitive tasks using alerts and notifications.
You will see how to monitor, analyze, and manage multicloud applications and infrastructure environments with full-stack visibility, prebuilt analytics, and automation using Oracle Cloud Observability and Management Platform.
Register for the webinar: OCI/ERP - Improve Troubleshooting, Performance, and Monitoring of Oracle E-Business Suite Using OCI Observability & Management Platform that will take place on November 8, 2022 at 10am PST. Click this link to register: https://community.oracle.com/customerconnect/events/604146-oci-erp-improve-troubleshooting-performance-and-monitoring-of-oracle-e-business-suite-using-oci-observability-management-platform
Re: Adding cipher suites to SBC version 10. Is it possible?
Hi Daureen
that info shows just the negotiated cipher , but it does not show the list of ciphers supported by the client so it is unknown if ciphers included in version 10 are supported by the clients .
Cheers
Antonio
Re: Convert xml/clob to readable varchar
Well GazinOz , your post is just a hint . A good but the simple one. In fact in mean time I have already found a solution.
SELECT bv.name name,
bv.pos position,
bv.TYPE TYPE,
bv.VALUE VALUE
FROM gv$sql_monitor s,
XMLTABLE ('/binds/bind'
PASSING xmltype (s.binds_xml)
COLUMNS name VARCHAR2 (30) PATH '@name',
pos NUMBER PATH '@pos',
TYPE VARCHAR2 (15) PATH '@dtystr',
VALUE VARCHAR2 (4000) PATH '.') bv
WHERE s.sql_id = '2mf4jt8s968kb' AND s.sql_exec_id = '33689343'
ORDER BY bv.pos;
KP_2