Best Of
Re: Steps to enable Third Party Payment in AP R12
Hi
Refer to the below documents
R12: Technical Brief on Third Party Payments in Oracle Payables (Doc ID 978799.1)
thanks
Nirmal
Re: G-Invoicing Dashboard unable Remove or Disable the Close "X" Button on panels of the ECC Dashboard
Hi Ragha Chillarige,
As the response has provided you with an answer, please click Yes for the prompt ‘Did this answer the question? Yes No’ on the comment.
This helps identify effective solutions within threads and encourages community users to assist others by providing potential solutions.
Thanks
Re: After execution of concurrent program, SQLException encounter while executing data trigger
Hi User_TA6AG,
Please log service request with EBS XML publisher product to validate Data definition setup and validate data.
Thanks,
Hari
Re: Patch Wizard Credentials
Alexandru
Think this is definitely the issue as 37051792 has been superseded by 37059554:R12.ADO.C PASSWORD LIMITATIONS IN UPDATE MOS CREDENTIALS IN OAM.
Patrick
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