PO Receipt Can Be Created After Project 's Finish Date Leading to Error PA_EX_PROJECT_DATE In PAAPIMPR

(Doc ID 1490075.1)

Last updated on JULY 18, 2017

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle Project Costing - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


PO Receipt can be Created After Project's Finish Completion Date Causing Exception PA_EX_PROJECT_DATE error in PAAPIMPR  
Example: a project's transactions dates: 15-SEP-2010  - 15-NOV-2011
The system will prevent Requisition or PO creation for the project which date is over the finish date (after 15-NOV-2011).

However, if a Requisition, PO is created for the project with date before the project's finish date, then the PO receipt can be created with a date after the Project's finish date (after 15-NOV-2011).

The project expenditure date is the PO receipt's date, thus this will shown as exception in the transfer program.
PRC: Interface Supplier Costs  / Supplier Cost Interface Exceptions report shows error (PA_EX_PROJECT_DATE):

There should be a check on the PO receipt as well which should prevent the
PO receipt creation if the PO is linked to a project and the PO receipt's
date is after the project's transaction date.


Steps to reproduce the problem

The issue can be reproduced at will with the following steps:
1. Project Setup
    In Project, Templates form
    Define Project
    Number = 200
    Duration 15-SEP-2010  - 15-NOV-2011
2. Enter and Approve Requisition 780 / Purchase Order Number 2746 on the same project before the 15-NOV-2011
3. Receive the PO 2746 after the 15-NOV-2011
    Receive Items
    Receipt Quantity = 1000
    Order Number = 746
   For Receipt Date: 14-May-2012 13:23:12
   Review and Submit
   Receipt 46 has been created for you.
   The Receipt may also be entered in Core Purchasing form Receiving / Receipts RCVRCERC form on same date
4. View > Request > Submit new request > PRC: Interface Supplier Costs  
    PAAPIMP_SI module: PRC: Interface Supplier Costs
    Supplier Cost Interface Exceptions report shows
    Document Number = 2746
    Project Number = 200
    Task Number = 050.010
    Functional Amount = 1000
    Expend Item date = 14-MAY-12
    The item date is not within the project active dates


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms