Best Of
Re: Seeded Business Event for Order Create / Update / Cancel
Hi Mirza,
Based on what I have learned from my experience in XML Gateway :
When Oracle Order Management receives an inbound PROCESS PO or CANCEL PO message, a business event "oracle.apps.ont.oi.po_inbound.create" is raised to start the order import workflow in order to process the received data.
After order import has been run on data received through XML, a business event "oracle.apps.ont.oi.po_ack.create" can be raised to trigger generation of an ACKNOWLEDGE PO XML message.
A business event "oracle.apps.ont.oi.show_so.create" can be raised to trigger generation of a SHOW SO or CHANGE SO XML message.The SHOW SO message contains status information about an order and can be generated on demand or as a result of changes to an existing sales order. The CHANGE SO message is used to notify the buyer of changes to a sales order and can be raised as a result of status or attribute changes on a sales order like Unit selling Price,Ordered Qty,Scheduled arrival date,Shipped Qty,Scheduled Ship Date.
Also No User setup is required for the Show_SalesOrder in event of following status change:
• Booking the order
• Shipping
• Scheduling of lines
When an order or line status changes, the show SO is generated.
Hope all these info helps you.
Please mark the response as helpful or correct when appropriate to make it easier for others to find it.
Regards
sanG1
Re: slow boot when connected to Oracle db19c on Azure
It is mainly due to higher network latency and increased round-trip times that amplify the impact of numerous small, sequential database queries and metadata lookups performed during startup; this is worsened by potential suboptimal JDBC driver and connection pool configurations, Azure-specific network factors such as load balancers causing connection instability or delays, and possibly storage performance differences-thus, resolving this requires minimizing database round-trips during startup (e.g., disabling schema validation), tuning JDBC and connection pool settings for cloud latency, ensuring the application server is deployed close to the Azure database (same region), optimizing Azure storage and network configurations for Oracle workloads, and monitoring startup queries to identify and optimize bottlenecks.
Cheers
Arsalan
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