PO Receipt Can Be Created After Project 's Finish Date Leading to Error PA_EX_PROJECT_DATE In PAAPIMPR
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
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
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