Best Of
Re: When we are updating run into this error and you can't update any prime locations. Wond
@User_UO6M5 If the response on this thread was helpful, please close this thread by choosing the "YES" on that comment for "Did this answer the question?".
Thanks
Re: 2025 Overtime Deduction Reporting
We have been discussing OBBBA at the monthly Quest Payroll for North America SIG meetings, and yesterday we had a bit of a chat about these topics. If you are interested, the recording has now posted:
Re: purging employee bank account
Hi,
We are beginning to do this regularly, but we are not using the archive process.
If you do it, I'd personally recommend using an SQR or app engine, look for anyone who has a termination date less than [whatever your retention period} and no active empl records.
We're putting in all 9s in the account number field.
In addition to purging DIR_DEP_DISTRIB, you'll also want to look at PAY_DISTRIBUTN, and any audit tables or archive tables that might have the data.
-Nicole
Re: PeopleSoft Payables Freight Allocation Hitting Tariff Line on Invoice
You can go to the Non Merchandise Summary hyperlink on the Voucher and uncheck the line you do not want the freight to be applied to.
Re: P3411 - Planning Request Date for Sales Order
Hello Jay,
MRP planning to scheduled picked date is per design.
Per KM Solution E1: 34: R3482/R3483 Basics of MRP Dates and Leadtimes (Doc ID 660707.1), Sales Order - (PDDJ - Scheduled Pick Date): Pick Date is the Demand date - it wouldn't work to have goods available on the Promised Delivery Date; they need to be available on the Pick Date which might be days earlier in order to meet the other dates (Requested, Ship, Delivery).
Regards,
Jeff
Re: PeopleSoft Payables Freight Allocation Hitting Tariff Line on Invoice
Hello,
The question here seems to be PeopleSoft Payables related.
Therefore, the thread will be moved to Financial Management -PSFT (MOSC) team for further assistance.
Kind regards, Madalina.
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,
