Hi Andrea,

Instead of manually deleting records from the F4600 and F4611 tables, it's strongly recommended to use the WMS Purge Movement Information program (R4600P). This ensures data integrity and avoids potential issues with related tasks, reservations, and suggestions that may still be referenced by other processes.

The R4600P report is designed to safely purge closed or canceled requests and suggestions, provided all related data (such as tasks and reservations) are also complete or canceled. It allows you to run in proof mode first to review what will be purged, and in final mode to remove the records permanently. You can also opt to move purged data to dedicated purge tables (e.g., F4600PU, F4611PU), maintaining a historical archive if needed.

Using this approach helps prevent unintentional data loss or disruption to WMS functions that might still rely on existing relationships in the data.

For better understanding on this, refer below Oracle resources:
Warehouse Management Implementation Guide: Purge Movement Information
E1: 46: Warehouse Management FAQs (Doc ID 1345962.1)

If the response answered your question, please consider marking it as Answered, it helps others in the community find the solution more easily. You can also like the post if you found it helpful.

Best regards,
Mahesh

Hi @User_B57A5,

This applies to any type of requisition, as long as it is linked to a purchase order that is being canceled or closed through the receipt process.

Best Regards,
Mahesh

Hi @User_B57A5,

Thanks for posting at Oracle Communities.

This is a new enhancement introduced in JD Edwards Procurement Management Release 24.

JD Edwards Procurement Management has been enhanced with an option that enables you to prevent the system from reopening the requisition order when a purchase order line is canceled using receipt option 9 (Cancel the Purchase Order Line) or closed using receipt option 7 (Receive and Close the Purchase Order Line).

You can configure this behavior using a processing option, which determines whether the requisition should remain closed or be reopened based on how the purchase order line is handled during receipt.

For more details, please refer to the following Oracle resources:

• Procurement Management Implementation Guide: Setting Processing Options for PO Receipts (P4312): Process
• Product Catalog: Avoid Opening Requisition Order When Purchase Order Line is Canceled during Receipt

If the information provided resolves your query, kindly consider marking the answer as Answered, this helps other customers who might have the same question.

Best regards,
Mahesh

Dear Mahesh

Thank you for your inputs , Is the processing option applicable to advanced requisitions or RSS requisitions or both?

Could you confirm?

Thanks in advance

Dear All

In JDE 9.2.9.3 , I notice a new processing options in the process tab of P4312 as below

25. Reopen Requisition on Cancel or Close Purchase Order Line

Blank = Reopen the Requisition

1 = Do not reopen the Requisition

Kindly share the relevant Oracle documentation for the above feature , which would help to understand its significance and usage

Thanks in advance

I want to ask if there is any problem if i reduce the number of the record on F4600 and F4611 deleting all request and suggestions closed or cancelled and older than 2 Year.

Are there some procedure that still use these cloed requests and suggestions and can cause a problem ?

best regards

Andrea

Hi,

We're on JDE E1 9.2 with Tools Release: 9.2.8.4

I’ve noticed that the PDPN (Period Number) and PDFY (Fiscal Year) fields in the F4311 table are usually blank, although some records do contain values.

Could you please clarify:

*What drives the population of these fields? Are there specific criteria?

*Why are they blank for most records?

Thanks for your help!