Actual Summary Page Error For Charges And Taxes After An ELC Update (Doc ID 2102175.1)

Last updated on FEBRUARY 27, 2020

Applies to:

Goal

After applying <Patch 22223681:R12.INL.C> there is an error in the Actual Summary page:

The Actual Summary page does not work, for Charges and Taxes, after an ELC update

Steps

LCM Responsibility > Workbrench > Shipments
Entered the org.  , click Go (B)
Entered the Shipment number XXX, click Go (B)
Shipments > Actions (View landed cost) > click Go (B)
Click actual history -> Get error :

Error
You have encountered an unspecified error. Please contact System Administrator for assistance.
Click here for exception details.

Error Page
Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT *
FROM (-- Bug 14619245 https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=14619245
SELECT DISTINCT ima.ship_header_id, ia.ship_line_id,
ima.match_type_code, ia.from_parent_table_name,
ima.to_parent_table_name, ima.to_parent_table_id,
ima.charge_line_type_id, (select flv.meaning from fnd_lookup_values_vl
flv where flv.lookup_code = ima.from_parent_table_name and
flv.lookup_type = 'INL_ACTUAL_MATCH_SOURCE' and flv.enabled_flag = 'Y')
AS match_source, DECODE(ima.match_type_code, 'CHARGE', (select
hp.party_name from hz_parties hp where hp.party_id = ima.party_id),
'ITEM', (select hp.party_name from hz_parties hp, inl_ship_lines_all
isl, inl_ship_line_groups ilg where isl.ship_line_group_id =
ilg.ship_line_group_id and hp.party_id = ilg.party_id and
isl.ship_line_id = ia.ship_line_id), NULL) AS party_name,
DECODE(ima.match_type_code, 'CHARGE', (select hps.party_site_name from
hz_party_sites hps where hps.party_site_id = ima.party_site_id),
'ITEM', (select hps.party_site_name from hz_party_sites hps,
inl_ship_lines_all isl, inl_ship_line_groups ilg where
isl.ship_line_group_id = ilg.ship_line_group_id and hps.party_site_id =
ilg.party_site_id and isl.ship_line_id = ia.ship_line_id), NULL) AS
party_site_name, ai.invoice_num || ' - ' ||
aid.distribution_line_number AS actual_reference, aid.
 

Solution

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