Requirement That All Buy Items Must Have A Planner? Requisition Import Shows Error When a Planner Is Not Assigned To An Item (Doc ID 565861.1)

Last updated on NOVEMBER 17, 2023

Applies to:

Goal

When selecting a planned order for release, if the item does not have a planner code associated, we receive a message

The planner for this item is not defined as a current employee.
Please define this planner as a current employee in the source database and recollect.

We have items that do not have a planner assigned and in earlier versions, the planner code was never a required field in planning. Has that changed?

Do we need to have a planner/employee assigned to every item?

When PO Requisition Import is run, then release will ERROR with messages and we see in the Requisition Import Output file

Requisition Import Run Report Date: 30-APR-08
-------------------------------------------------

Number of approved requisitions created = 1
Number of unapproved requisitions created = 0
Number of interface lines in error = 1

And then when we run the Requisition Import Exceptions Report
with parameters Import Source - MSC
and Batch ID from the Requisition Import parameters
We see in the Output File

DELIVER_TO_REQUEST - The requester is not an active employee

Cause: You entered a requester who is not a valid employee.
Enter: Enter a requester who is a valid employee.

PREPARER_ID - Preparer is not an active employee

Cause: You entered an inactive employee as the preparer.

Action: Enter an active employee as the preparer.
Action: Make the preparer an active employee.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.