My Oracle Support Banner

Error "The definition of the view JAI_SUPPL_TRX_HEADERS_V is incorrect " (Doc ID 2718553.1)

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Reported Issue
-----------------
Error when trying to apply patch e invoicing patch.
This is specifically observed if and only if the DB is on 11.1.0.7 version.
Unable to skip the failed adworker

Error (from adworker log )
------
AD Worker error:
Unable to compare or correct views because of the error above

AD Worker error:
The following ORACLE error:

ORA-01719: outer join operator (+) not allowed in operand of OR or IN.
The definition of the view JAI_SUPPL_TRX_HEADERS_V is incorrect.
The view text is incorrectly defined as:


SELECT jstl.customer_trx_id customer_trx_id ,jstl.trx_number trx_number
,jstl.trx_date trx_date ,jstl.customer_id customer_id ,party.party_name
customer_name ,jstl.cust_acct_site_id cust_acct_site_id
,party_site.party_site_number customer_site_name ,jstl.org_id org_id
,hou.name operating_unit ,jstl.ledger_id ledger_id ,gll.name ledger_name
,jstl.organization_id ,ood.organization_name organization_name
,jstl.process_status process_status ,MAX(jstl.processed_date)
processed_date ,jstl.suppl_invoice_type_code
,DECODE(jstl.suppl_invoice_type_code ,'INV' ,'Supplementary Invoice' ,'CM'
,'Credit Memo' ,'DM' ,'Debit Memo') suppl_invoice_type
,jstl.suppl_trx_source_name ,jstl.suppl_trx_source_id
,jstl.suppl_trx_type_name ,jstl.suppl_trx_type_id ,jstl.suppl_batch_id
,SUM(jstl.original_line_amount) original_net_sales_amount
,SUM(jstl.revised_line_amount) revised_net_sales_amount
,SUM(jstt.original_tax_amount) original_tax_amount
,SUM(jstt.revised_tax_amount) revised_tax_amount FROM
jai_suppl_trx_lines_v jstl ,(SELECT SUM(original_tax_amt_tax_curr)
original_tax_amount ,SUM(revised_tax_amt_tax_curr) revised_tax_amount
,interface_det_factor_id FROM jai_suppl_trx_taxes_v GROUP BY
interface_det_factor_id) jstt ,hz_parties party ,hz_cust_accounts_all hca
,hz_party_sites party_site ,hz_cust_acct_sites_all hcas
,hr_operating_units hou ,org_organization_definitions ood ,gl_ledgers gll
WHERE jstl.customer_id = hca.cust_account_id AND hca.party_id =
party.party_id AND jstl.cust_acct_site_id = hcas.cust_acct_site_id AND
hcas.party_site_id = party_site.party_site_id AND jstl.org_id =
hou.organization_id AND jstl.ledger_id = gll.ledger_id AND
jstl.organization_id = ood.organization_id(+) AND
jstl.interface_det_factor_id = jstt.interface_det_factor_id GROUP BY
jstl.customer_trx_id ,jstl.trx_number ,jstl.trx_date ,jstl.customer_id
,party.party_name ,jstl.cust_acct_site_id ,party_site.party_site_number
,jstl.org_id ,hou.name ,jstl.ledger_id ,gll.name ,jstl.organization_id
,ood.organization_name ,jstl.process_status ,jstl.suppl_invoice_type_code
,jstl.suppl_trx_source_name ,jstl.suppl_trx_source_id
,jstl.suppl_trx_type_name ,jstl.suppl_trx_type_id ,jstl.suppl_batch_id

 

Expectation 
-------------
Expectation is that the GST e invoicing patch should be allowed for application successfully even if DB is on 11.1.0.7.

Changes

 

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