Best Of
Re: Set Selection Group Issues
Hello Rich,
David here in support. Thank you for posting your question and the detailed information. I am not getting any solid hits per se, I did search on 'Start Selection Group' and 'End Selection Group'
I do see enhancement request Bug 19284756 : ENHANCEMENT REQUEST - SET SELECTION GROUP, ALLOW MULTIPLE GROUPS
=============
Suggestion is an enhancement, either adding a new parameter to Set Selection Group indicating whether to continue the current group or start a new group, or a new System Function "End Selection Group" which will close the current selection group by adding a ")" to the query so that a new Selection Group can be started. This would allow selections with arbitrary numbers of optional parameters to be constructed with ease, relieving development burden and making maintenance of code more manageable.
=============
If this is something of interest, then open up a SR to be added to this desired enhancement.
Here is some knowledge I found on a quick search,
E1: FDA: Documentation for System Function "Set Selection Group" (Doc ID 656635.1)
E1: FDA: ER System Function "Set Aggregate Selection" in Form Design Aid Starting With Tools Release 9.2 (Doc ID 2912801.1)
I look forward to any other community ideas and suggestions. This may ultimately need to be presented to development via an SR.
Kind regards,
David
Re: Error in P4210 failed to open cursor due to reach the max #cursors (100)
Hi @2011,
Thank you for visiting My Oracle Support Community and posting your question here! I want to let you know I have moved your thread to our Distribution - JDE1 (MOSC) subcategory for those subject matter experts to 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 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 a Question and View Answers in the My Oracle Support Community - My Oracle Support Community organization details are provided, which can be used to find the product subcategory for your question
- Community Guidelines
- How to be a good Community Citizen
- Not posting Private Information
- How to be a Community Star
Thanks,
Gail
Re: PAYCALC Error Return Code 00805
Just wanted to save this question and replies saved us today. Thanks all!
Re: Error in P4210 failed to open cursor due to reach the max #cursors (100)
Hello,
You logged this post with the Manufacturing Communities for the Sales Order Entry Application. The P4210 should really fall under the Distribution communities.
Nevertheless, this problem seem to be a memory leak. Which Release are you on? Do you know if you are current in Code for for all Business functions related to the P4210? What are the steps and the process you are taking to cause this failure? The first thing I would suggest making sure you are current in code.
Once you confirmed you are current in code, It would probably be best for you to open a Service Request with Oracle Support.
Thank you,
Re: Expense Report: Enhanced the Automobile Mileage feature to provide address auto-complete options
I have now successfully implemented the autofill functionality.
What we found was that a delivered object with Bug 35149380 was not moved into our testing/qa/production environments when we implemented PUM 48.URL Definition: EX_ELOC_APPID was missing. Once this was moved into the environment, the autofill functionality worked, and we are now calculating correctly.Thanks for your response to this, Pere! Greatly appreciated.Re: Mandatory Enrollment Notification for managers
Hi User_J8J9Q,
Yes, it is possible to send a notification email to the managers when a direct report is enrolled into a mandatory learning.
Please find below the explanation from PeopleBooks:
Notification Emails
When the Mandatory Enrollment process (LM_ML_ENROLL) runs, it stages data in the notification records which are then used to notify learners/managers/both about their enrollments. All learners, by default, are notified when they enroll into a class. Email notifications are also sent to alert them about the approaching due dates and when classes are overdue. Depending on the rules set, the process also sends out email notifications to managers about the enrollment of team members. All managers receive one email notification for every event (i.e. enrollment, approaching due date or overdue) during the enrollment period with an attachment of the consolidated list detailing the enrollment status of team members.
The LM_NOTIFY process can be run to send out notifications to both learners and managers about the enrollments in a Mandatory learning.
Note: The LM_NOTIFY process sends out notification emails to all enrolled learners, even when no ‘Enrollment’ notification is set in the Mandatory Learning Setup page.
The LM_ML_NOTIF process can be run to notify learners/managers/both about the approaching due dates and overdue enrollments.
The following delivered notification templates are used to define the content of the notifications that the system sends:
- LM_MAND_ENRL_CONF_ILT – Template used to send notification when learner is enrolled into a mandatory learning.
- LM_MAND_ENRL_CONF_MGR – Template used to send notification to manger when a direct report is enrolled into a mandatory learning.
- LM_ML_LRNR_APRCH_DUE_DT – Template used to send notification to learner when learner reaches approaching due date given in the mandatory learning setup.
- LM_MAND_ENRL_APRDUE_MGR – Template used to send notification to manger when learner reaches approaching due date given in the mandatory learning setup.
- LM_ML_LRNR_OVERDUE_DAYS – Template used to send notification to learner when learner has a mandatory learning which is overdue in days.
- LM_MAND_ENRL_OVRDUE_MGR – Template used to send notification to manager when learner has mandatory learning which is overdue in days.
source: https://docs.oracle.com/cd/F45080_01/elm92pbr22/eng/elm/aelm/DefiningClassDetails.html
In order to run the Mandatory Enrollment process, you need to navigate to the following page: Enterprise Learning > Learner Tasks > Mandatory Learning > Mandatory Notifications
For the benefit of your community peers, if you find that a response has provided you 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.
Best regards,
Virginia
Re: Need SQL query used for generating AP Check Prints
Hi @User_CIC1L ,
You can use the query
SELECT t.DOCUMENT_NUMBER,
t.PAYMENT_SERVICE_REQUEST_ID,
EXTRACTVALUE(XMLTYPE(t.PAYMENT_DOCUMENT), '//InvoiceNumber') AS invoice_number
FROM IBY_TRXN_DOCUMENTS t
WHERE INSTR(t.PAYMENT_DOCUMENT, '>0.00<') > 0;
Hope this helps to design your report.
Regards,
Sadeesh
Re: How to develop PO PDF document for change requests?
Hi @Arika Johnson,
Query the required data (use PO_REVISIONS, PO_LINES_ALL, etc. to capture changes).
Option 1: Customize the standard “Purchase Order” report to display modifications.
Option 2: Build a new concurrent program/report in XML Publisher (BI Publisher).
Regards,
Sadeesh
Re: Any command to export and import OA Framework Model Personalization ?
Hi @User_T4UH1,
You can review
How To Export/Import Personalization in E-Business Suite (Doc ID 2451954.1)
Regards,
Sadeesh
