Best Of
Re: Where is Windows Patch for oracle 19.28?
OJVM Patches being incorporated into the DB Patches with 21c and newer is not a "fix", it's simply a change in delivery method (which has been used for the past decade). There is nothing to "fix", as there is nothing "broken".
Upgrading from a Long Term Support release to a Feature Release, just to have a difference in patch delivery method is not a "fix", and would not be recommended as such by Oracle Support.
Re: eProcurement and OBN/OSN Oracle Business Network integration
HI Stacy,
Thanks for posting your question to the SCM community.
If other customers/partners have implemented OBN , I encourage you to share your feedback or provide any insights.
Thanks,
Wael
Re: Performance Issues with INV Tables and Indexes in Oracle EBS R12.2.10 – Need Expert Guidance
Hi Mohammed,
One thing is to make sure you keep the statistics updated. Work with your DBA to find the best parameters to use when running statistics on them. When tables become very large, it takes longer and longer to hit the defaults, so sometimes you are running stats but not getting the impact you could. For example, if the default is to update statistics when a table has grown 10%, but the table has 500M records already, it wouldn't update the stats until there are 50M new rows. When the table grows to 700M rows, it won't update stats until there are 70M new rows. And so on.
Try this to get some basic information: select table_name, num_rows, last_analyzed from all_tables where table_name in (<list of tables>)
Interface tables can become fragmented because data is inserted then deleted. Your DBA will be able to check that for you. Depending on your business processes, there could be a couple of actions. If you can confirm that the interface table is completely empty, you can truncate it to quickly free up space and eliminate all fragmentation. The tables are shared by all organizations, though, and if there is always data in there, the DBA should have some other methods of defragmenting.
Bug 30038164 : R07345 HISTORICAL PAYROLL REGISTER IS COMBINING GROSS WAGES FOR DIFFERENT TAX ID
E1 9.2 - Doing Code Current Testing. Canadian Payroll. Tested fix for bug 30038164 and have EE in RP1 then moved to RP2 within same company. Instead of the original bug issue of getting no gross on the 2nd RPs, the report is instead adding the Gross Wages from RP1 & RP2 together instead of separately and it's doubling the YTD Gross Wages on the RP2. See attachment for R07345 PO settings. Is anyone else getting the same results? We are in the process of creating a SAR but wanted to know if others are having the same issue.
Re: Shared directory rights problem
Hello ,
It is good to know that your problem has been resolved.
Refer below documents as well to explorer other options.
How To Create and Mount an NFS share that is Restricted to Certain Hosts (Doc ID 1527554.1)
How to NFS Share ZFS Filesystem. (Doc ID 1020292.1)
NFS on Solaris PSD (Product Support Document) (Doc ID 1003058.1)
Best Regards,
Sharad
Why does my Solaris 11.4 server require grub username/password every reboot now?
I have recently patched my Solaris 11.4 servers with the SRU. After patches, we reboot to apply the new boot environment. Everything seemed to go pretty standard.
That was until last night when we rebooted a server. It didn't come up right away, so I got on the console and it was asking for the grub username/password. After entering the info, it booted right up as usual. But now, every time the server boots it asks for the name/pass. This is also happening with other servers I've tested so far.
Was this a change in a recent patch?
Thanks in advance!
Re: Why does my Solaris 11.4 server require grub username/password every reboot now?
Hi,
The GRUB (Grand Unified Bootloader) password requirement on a Solaris 11.4 server after a reboot is likely due to a deliberate security measure implemented by the system administrator or a configuration change that was made. Specifically, the bootadm set-menu command can be used to set a password for accessing the GRUB menu.
Regards
Saravanan
Re: Why does my Solaris 11.4 server require grub username/password every reboot now?
The upgrade from Solaris 11.4 SRU 80 or earlier to SRU 81 or later will upgrade GRUB from version 1.99 to 2.12, but it shouldn't prompt for a password unless an admin has configured it to do so. (The actual upgrade of the bootloader happens after you boot into the new SRU for the first time, so it doesn't appear at boot until the second boot of the new SRU.)
Re: Getting Server Busy Error when trying to update field in EBC
Hello,
- Were there any FDR/Crash files generated?
- How was the EBC configured?
I would recommend in this situation to proceed with logging a Service Request with Oracle Siebel Support team. They will be able to analyze the issue, review the available log files and provide a solution.
Thank you!
Best regards,
Stefan
Re: HMR for targetting the second m= line in the SIPREC Invite .
I think this one is better:
sip-manipulation
name testSDP
description
split-headers
join-headers
mime-sdp-rule
name modifySDP
msg-type any
methods
action manipulate
comparison-type case-sensitive
match-value
new-value
sdp-media-rule
name modifyAudio
media-type audio[1]
action find-replace-all
comparison-type pattern-rule
match-value \s120|\s8|\s102|\s103|\s104|\s9\s0
new-value
Rachid