Receivables - EBS (MOSC)

MOSC Banner

hz_geographies out of sync with hz_locations after patch 11658285 (add Country Curacao)

edited Jun 26, 2012 1:54AM in Receivables - EBS (MOSC) 3 commentsAnswered ✓

Hi,
After application of patches 11658285 and 12945067 for adding Country Curacao to the system (ISO 3166 Country Codes) we are not able to invoice the customer in that country.
FND debug shows Unable To Determine The Country Code For The Location Id:Xxx And Location Type: BILL_TO when calculating tax

I found note 757848.1 which describes as cause that "ARHGEFTR.sql" was not run during install process.
This sql file should be run at install to sync data between fnd_territories_vl and hz_geographies.
May be the data in fnd_territories_vl got modified after this sql run.

Does anyone have information about where to get this ARHGEFTR.sql as hz_geographies is indeed empty for this country.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Receivables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center