My Oracle Support Banner

Datafix for null invoice_line_number and invoice_distribution_id in FA_ASSET_INVOICES Table Due to Issue Documented in Projects Doc ID 2479392.1 (Doc ID 2639344.1)

Last updated on APRIL 14, 2020

Applies to:

Oracle Assets - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

Datafix needed for the FA_ASSET_INVOICES table for issue identified in Projects Note:   R12: Missing Invoice Information On The Asset Lines Of PA_PROJECT_ASSET_LINES_ALL (Doc ID 2479392.1) 

The INVOICE_LINE_NUMBER column and the INVOICE_DISTRIBUTION_ID column are
blank for some asset lines in the PA_PROJECT_ASSET_LINES_ALL table.
Therefore the Asset Source Lines don't have this information in FA.
 

Solution

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