My Oracle Support Banner

Error while Creating New Lines on Latin Locations Form (Doc ID 2400225.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Financials for the Americas - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version, Americas Globalization Tax Engine

When trying to create new lines on Latin Locations form failing with following error:

APP-SQLAP-10000: ORA-01403: no data found occurred in JL_ZZ_AR_TX_LOCN_PKG.INSERT_ROW<-JLZZTLOC
with parameters ( ship_from_code = MG ship_to_segment_id = xxxxx tax_category_id = xxx end_date_active = 31-DEC-12)
while performing the following operation: Close cursor C - DATA NOTFOUND

The issue can be reproduced at will with the following steps:
Receivables with Brazil Localizations enabled > Localization -> Setup -> Latin Tax -> Locations


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

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