My Oracle Support Banner

Future Date Quotation Is Not Used For Requisition Source Document (Doc ID 3027435.1)

Last updated on JUNE 06, 2024

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

Here are two available quotations, the first one is with current effective date and the second one is with future effective date and it is newly created.

When creating a requisition from OIF with future need by date, quotation with current effective date is used as a source document, although future date quotation is expected to be used.

This happens only when there is no ASL for the item.

EXPECTED BEHAVIOR

When creating a requisition from OIF with future need by date, quotation with future effective date is used as a source document.

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

Current date:2023/11/27 13:44:24

  1. Create Quotations
    - Quotation: 217218 (Current effective date)
    Effective date: Start:2023/4/3 - End: NULL
    Creation date = 2023/11/20 09:44:41
    Price = 11391
    - Quotation: 217219 (Future effective date)
    Effective date Start: 2024/1/1 - End: NULL
    Creation date = 2023/11/20 10:33:29 (Newer than first one)
    Price = 11339
  2. Create and Release Outside processing job to interface PO_REQUISITIONS_INTERFACE_ALL .
    PO_REQUISITIONS_INTERFACE_ALL.NEED_BY_DATE = 2024/01/18. (Future date)
  3. Run Requisition Import.
  4. Requisition is created with price = 11391 (Source document = Quotation: 217218) although Quotation: 217219 is expected.

 

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
References


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