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.
PA_EX_PROJECT_DATE
PAAPIMPR

Symptoms

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
    Receiving
    Receive Items
    Receipt Quantity = 1000
    Order Number = 746
 
   For Receipt Date: 14-May-2012 13:23:12
 
   Review and Submit
   Message
   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
 

Cause

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