My Oracle Support Banner

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.

Symptoms

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


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

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.