R12:PA: Generate Intercompany Invoices (PAICGEN): PA_DRAFT_INVOICE_DETAILS Incorrect If 20th Char Of Task Name Is A 'space' (Doc ID 2198575.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
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.


EXPECTED BEHAVIOR
-----------------------
PRC: Generate Intercompany Invoices (PAICGEN) should update the tables correctly regardless of the value in the 20th character space

STEPS
-----------------------
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'.


BUSINESS IMPACT
-----------------------
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.

Cause

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