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 MARCH 07, 2019
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
Changes
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 |
Changes |
Cause |
Solution |
References |