R12 PATTAR - Multi Line Invoice From Project Not Transferring All Lines To Receivables
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