Best Of
Re: JDE user password
Hello,
The default change frequency from Processing Options is taken into consideration when a user is created.
It will populate the change frequency value for the user which is created.
Revise All shouldn't be greyed out. You should investigate why it is greyed out.
Thank you!
Best regards,
Cezar
Re: OL9 ORA 19C OJVM Patch Re-link fails on target "javavm_refresh"
This resolved the issue.
--MOS - Patching fails during relink , with error code 102 :: Fatal error: Command failed for target `javavm_refresh' (Doc ID 2002334.1)
CAUSE
PERL5LIB environment variable is not set
SOLUTION
Oracle provided Perl needs to be referenced at the beginning of the PATH and PERL5LIB for Patch apply or rollback.
Set PATH and PERL5LIB environment variable and apply patch again.
export PATH=$ORACLE_HOME/perl/bin:$PATH
export PERL5LIB=$ORACLE_HOME/perl/lib
=========================================================
$ORACLE_HOME/OPatch/opatch rollback -id 36199232
$ cd /orahome1/orainstalls/PATCHES/DB/OJVM/36199232
$ $ORACLE_HOME/OPatch/opatch apply
=========================================================
Re: Performance issue due to index not being used
Index is on 4 columns and WHERE clause is on index first 3 columns. My guess would be optimizer can't properly access how many rows query returns. Is data skewed? If so, is stats collected with histograms? Also, what happens if you collect extended stats:
SELECT DBMS_STATS.CREATE_EXTENDED_STATS('<table-owner>','KCM_GRP_CONTRIBUTIONS','(POL_LINKED_POLICY_ID,STATUS,DATA_TYPE)')
FROM DUAL;
EXEC DBMS_STATS.GATHER_TABLE_STATS('<table-owner>','KCM_GRP_CONTRIBUTIONS');
SY.
Re: Need to add Collector Field at Receivables Customer Standard Search form in EBS R12
Hi,
It is not possible using seeded functionality to add the Collector to the search window using seeded functionality.
This would be an enhancement request:
If you would like to have Development review this as a possible Enhancement in the future, please do the following:
Please note that we will no longer log Enhancement Requests (ERs) via Oracle SRs. You must now login to the Oracle Receivables and create your own Enhancement Request (ER)/Idea under Content > Ideas.
For more details on this new process, please review Note: 1584210.1 Oracle E-Business Suite Product Enhancement Request to My Oracle Support Community FAQ
When you select to create a new idea, there are a few things you can do to ensure Oracle Development and other community participants understand the idea. This will not only allow for more in depth conversation, should it be required, but a more well formed idea will potentially result in increased voting.
Idea Details:
Please elaborate on and explain the idea as much as possible.
Reported release:
What release are you using (i.e. 12.1.3, 12.2.4)?
Screen shots:
One picture is worth a thousand words. Imagine what several screen shots and/or mock-ups could tell us?!
Business process:
Describe your business process.
Gap and benefits:
Tell us what impact this will have on your process and/or finished result and what the benefit(s) is anticipated to be.
Best Regards,
John
Re: How to Make Supplier code Inactive in JDE , We tried to change the Search Type From V to "VO" but It
Hi,
Thank you guys for your replies.
I have updated the Search Type Field as VO and applied the security by Roles in Security work bench for Table F0101 For Search Type Field AT1, Row Security for range from VO to VO or VB to VZ, both will work , for View/Add/Change/Delete.
They will not be able to do any transactions for these vendors , It will thru an Error, Address number is Invalid until they change the search type from VO to V.
Regards,
Tafsir
Re: Security Hardening Guidance for Primavera P6 EPPM (WebLogic & DB Configuration)
Please review:
Security and Hardening Best Practices For Primavera P6 Database, Application and Web Servers (Doc ID 1198103.1)
Should you have additional questions, please raise an SR via My Oracle Support and we can route to the Security team.
Thanks,
Ron
Re: Activity Sheet - Milestones (zero-day duration & unable to un-milestone)
Hi Mathias
Zero-day durations - this is the same behavior as P6. In P6 for a Start Milestone you can only define the Start date and the Finish Date is set to the Start Date and the duration set to 0. For a Finish Duration it's the reverse but the duration is still 0.
You can swap an activity from Task Dependent to Start Milestone and vice versa as long as there are no assignments. If there are assignments they can be removed and saved and the switch can then happen. We have a backlog item to automate this.
Re: unable to close and drop pdb ORA-01122 ORA-01110 ORA-01204
dba_pdbs is populated from the data dictionary. v$pdbs is populated from the control file. So you now have the two out of sync. I cannot imagine a better example of why following some AI advice on a technical issue is not always a good idea. Is this any sort of production system? If not, I would drop the whole database and start again. If it is a production environment, you could try the routine for PDB point in time recovery.
Re: Generate Award Button
Thank you. The issue was a customization that was missing in the environment. After adding the customization, the issue got fixed.
Announcing Oracle Solaris 11.4 SRU85
We've just released Oracle Solaris 11.4 SRU85.
It is available via 'pkg update' from the support repository or by downloading the SRU from My Oracle Support Doc ID 2433412.1.
The following packages have been updated to address security issues:
- MySQL 8.4 to 8.4.6
- Web Server to 2.4.65
- PHP to 8.4.10
- Firefox to 128.13.0esr
- Thunderbird to 128.13.0esr
- ruby 3.3 to 3.3.9
- Golang to 1.23.12
- utility/cups
Full details of this SRU can be found in My Oracle Support Doc 3103853.1.
For the list of Service Alerts affecting each Oracle Solaris 11.4 SRU, see Important Oracle Solaris 11.4 SRU Issues (Doc ID 2445150.1).
