PAICGEN: PRC: Generate Intercompany Invoices For A Range of Projects checking for unreleased invoices? (Doc ID 1216984.1)

Last updated on DECEMBER 11, 2016

Applies to:

Oracle Project Billing - Version 11.5.10.0 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Goal

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'
             FROM    PA_EXPENDITURE_ITEMS
             WHERE   CC_IC_PROCESSED_CODE    = 'N'
             AND     RECVR_ORG_ID  =  OUS.RECVR_ORG_ID
             UNION ALL
             SELECT  'x'
             FROM    PA_DRAFT_INVOICE_DETAILS
             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?

Solution

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