R12: PA: Generate Intercompany Invoices (PAICGEN): PA_DRAFT_INVOICE_DETAILS Incorrect If The 20th Character Of Task Name Is A 'space'
(Doc ID 2198575.1)
Last updated on FEBRUARY 18, 2019
Applies to:Oracle Project Billing - Version 12.2.3 and later
Information in this document applies to any platform.
PRC: Generate Intercompany Invoices (PAICGEN) does not update PA_DRAFT_INVOICE_DETAILS correctly if the 20th character of Task Name is a 'space'.
Using workplans and when a task name has a NULL value in the 20th position, then the process does not update the PA_DRAFT_INVOICE_DETAILS table correctly.
Specifically, the DRAFT_INVOICE_NUM and DRAFT_INVOICE_LINE_NUM columns are assigned values 'NULL', and the CC_IC_PROCESSED_CODE in PA_EXPENDITURE_ITEMS_ALL is being marked as 'B' instead of 'Y'.
The expenditure inquiry form shows the status as: The expenditure item is billed but not invoiced.
PRC: Generate Intercompany Invoices (PAICGEN) should update the tables correctly regardless of the value in the 20th character space
The issue can be reproduced at will with the following steps:
1. Create a task where the 20th character in the file is a space, i.e. 3K RIG - Travelling xxxxxetc
2. Generate the Intercompany Invoices
3. The DRAFT_INVOICE_NUMBER and DRAFT_INVOICE_LINE_NUM fields are NULL and the CC_IC_PROCESSED_CODE in PA_EXPENDITURE_ITEMS_ALL is being marked as 'B' instead of 'Y'.
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