Actual Summary Page Error For Charges And Taxes After An ELC Update
(Doc ID 2102175.1)
Last updated on JUNE 08, 2021
Applies to:
Oracle Landed Cost Management - Version 12.1.2 to 12.2.4 [Release 12.1 to 12.2]Information in this document applies to any platform.
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.XXXXXXX.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
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 |