R12 PATTAR - Multi Line Invoice From Project Not Transferring All Lines To Receivables

(Doc ID 1326364.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Billing - Version 12.1.2 and later
Information in this document applies to any platform.
Form:PAXINRVW.FMB - Invoices
Executable:PATTAR - PRC: Interface Invoices to Receivables


On release 12.1.2, in the PAXINRVW Invoice Review form a Projects draft invoice #1 has 2 lines and has status as 'Accepted in Receivable'.  However, the PATTAR PRC: Interface Invoices to Receivables process only sent one line of the invoice to Receivables.

To verify, run the Reporting Script to Identify Corruption 

select distinct ppa.org_id , ppa.segment1 , ppa.project_type ,
ppa.project_status_code , di. draft_invoice_num
from pa_draft_invoices_all di, pa_draft_invoice_items dii , pa_projects_all
where di.transfer_status_code = 'A'
and di.project_id = dii.project_id
and di.project_id = ppa.project_id
and ppa.template_flag <> 'Y'
and ppa.project_status_code <> 'CLOSED'
and di.draft_invoice_num = dii.draft_invoice_num
and dii.amount <> 0
and exists( select 1 from ra_customer_trx_lines_all ra
where ra.interface_line_attribute1 = SUBSTR(ppa.segment1,1,25)
and ra.interface_line_attribute2 = to_char(dii.draft_invoice_num) )
and not exists(select 1 from ra_customer_trx_lines_all ra
where ra.interface_line_attribute1 = substr(ppa.segment1,1,25)
and ra.interface_line_attribute2 = to_char(dii.draft_invoice_num)
and TRIM(ra.interface_line_attribute6) = to_char(dii.line_num))
order by ppa.org_id , ppa.segment1 , di. draft_invoice_num ;



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