R12 PRC: Update Project And Resource Base Summaries Ends with the Warning "The following periods were not found" Due to Need by Date on PO.
(Doc ID 2021157.1)
Last updated on NOVEMBER 04, 2020
Applies to:Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.
PRC: Update Project And Resource Base Summaries Process Ends With Warning: "The following periods were not found."
Run the following to determine how many records are affected:
select p.segment1 "Project Number",
t.task_number "Task number",
EXPENDITURE_TYPE "Expenditure Type",
to_char(to_date(RECVR_GL_TIME_ID,'J'), 'YYYY/MM/DD') "GL date",
to_char(to_date(RECVR_PA_TIME_ID,'J'), 'YYYY/MM/DD') "PA date",
to_char(to_date(EXPENDITURE_ITEM_TIME_ID,'J'), 'YYYY/MM/DD') "EI date",
h2.name "Expenditure Organization",
PRJ_RAW_COST "Raw cost",
h1.name "Operating Unit",
DECODE (RECORD_TYPE, 'M', 'Commitment', 'A', 'Actual', 'Unknown')
DECODE (CMT_RECORD_TYPE, 'I', 'Invoice','P','Purchase
Order','R','Requisition','O','Other','Unknown') "Transaction Type"
from PJI_FM_DNGL_FIN d, pa_projects_all p, pa_tasks t,
hr_all_organization_units h1, hr_all_organization_units h2
where p.PROJECT_ID=d.PROJECT_ID and
The same rows appear to be returned in select * from PJI_FM_DNGL_FIN
The first script shows a gl date (need by date) in 2015 (future period) but the po tables shows GL_ENCUMBERED_DATE around the expenditure item date. The customer will not be defining the next calender year until AUG-15.
Why is the process using the PO's need by date for gl date? The customer does not use the need by date and wants to know how to point the process to look at a date other then the need by date. They want to know if there is a
setup or profile that we can set to ignore need by date
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