Usage of FND_TERRITORIES_B to get Currency linked to a Country — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Usage of FND_TERRITORIES_B to get Currency linked to a Country

Summary:

We're using a BICC Extract calling FND_TERRITORIES_B to get the default currencies mapped to Country in Oracle Fusion. This will be used in cross functional reasons in our ERP. We noticed that the default currency mapped to Territory Code is incorrect and needs to be updated.

Now I have found where we can update this in Manage Territories setup. A few questions:

  1. Our Oracle Consulting partners implemented our Oracle Fusion and in most of the reports they have used table FND_TERRITORIES_B table to get country related data. Now a functional from our new supporting partner (consulting company) is adamant in his view that FND_TERRITORIES_B table should not be used and is used in CRM only and not for HCM, FIN, SCM. Is his claim correct and does it mean all reports done by Oracle Consulting needs to be updated?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!