R12:PA: Generate Intercompany Invoices (PAICGEN): PA_DRAFT_INVOICE_DETAILS Incorrect If 20th Char Of Task Name Is A 'space'
Last updated on NOVEMBER 14, 2017
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 20th char 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 & 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'.
The issue has the following business impact:
Due to this issue, users cannot see the data in the intercompany invoices correctly and the expenditure items are still billable so future invoices include these as well.
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