PAICGEN: PRC: Generate Intercompany Invoices For A Range of Projects checking for unreleased invoices?
Last updated on DECEMBER 11, 2016
Applies to:Oracle Project Billing - Version 126.96.36.199 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
1) PA Patches recently applied were 6075936, 5847645, and 9413884. In the patched instance, PRC: Generate Intercompany Invoices for a Range of Projects is not picking up all eligible expenditure items. The same expenditure items in a non-patched, but otherwise identical instance are picked up okay. The items are processed in both instances when PRC: Generate Intercompany Invoices for a Single Project is run, and it appears to only be an issue with the Range concurrent program.
2) Ran both the range and single processes in debug mode. The range did NOT pick up the expenditures in question and the single DID, as expected. However, ran both in DEBUG and the SQL to retrieve data in each is significantly different, beyond just selecting a single project vs. a range. The following clause is present in the RANGE but is not present in the SINGLE:
AND nvl(PA_BILLING_CYCLES_PKG.Get_Next_Billing_Date(P.PROJECT_ID, P.START_DATE, P.BILLING_CYCLE_ID, P.BILLING_OFFSET,to_date('24-Sep-10'), N
ULL) , to_date('24-Sep-10')+1) <= to_date('24-Sep-10')
AND PA_IC_INV_UTILS.CHECK_IF_UNRELEASED_INVOICE(OUS.INVOICE_GROUPING_CODE ,P.PROJECT_ID)= 'N' AND Exists ( SELECT 'x'
WHERE CC_IC_PROCESSED_CODE = 'N'
AND RECVR_ORG_ID = OUS.RECVR_ORG_ID
WHERE PROJECT_ID = P.PROJECT_ID
AND DRAFT_INVOICE_NUM IS NULL)
ORDER BY P.Segment1
3) After further research, the RANGE process is checking to see whether or not an unreleased invoice exists however the SINGLE is not (per the log file):
AND PA_IC_INV_UTILS.CHECK_IF_UNRELEASED_INVOICE(OUS.INVOICE_GROUPING_CODE ,P.PROJECT_ID)= 'N'
Should either process (single or range) be ignoring items if an unreleased invoice already exists?
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