My Oracle Support Banner

No Requisitions are Created by Requisition Import Program with Error 'Preparer is not an on-line user' (Doc ID 2509206.1)

Last updated on AUGUST 06, 2020

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Requisition Import program to create requisition, it completes normally, but no requisitions are created successfully.

 Interface record errors out with process_flag as 'Error'.

Find  below error in the PO_interface_errors table:

-----------------------

Preparer is not an on-line user

Cause: The preparer must be an on-line user if the requisition is unapproved.

Action: Make the preparer an on-line user.

Action: Enter a preparer who is also an on-line user.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Populate data into Requisition interface tables:PO_REQUISTION_INTERFACE_ALL and PO_REQ_DIST_INTERFACE_ALL.

2. Run Requisition Import program.

3. Then it completes normally, but no requisitions are created successfully.

4.In the Requisition Import output file, see below information:

  No Requisitions are Created

  Number of interface lines in error = xxx

5. Find below error in the PO_interface_errors table:

   Preparer is not an on-line user

   Cause: The preparer must be an on-line user if the requisition is unapproved.

  Action: Make the preparer an on-line user.

  Action: Enter a preparer who is also an on-line user."

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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