Numbers to words in any language

This code snippet is primarily used for converting numbers to words in any language. We had an instance where we needed to print French checks while logged into Oracle Applications as an English user. Here's how we did it.

NOTE: This should work for any language that is installed on the database. We have French and English. For the main language the user could use the

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle applications best practices Where can I get more information on the Oracle CRM E-Business Suite? Oracle vs. SAP Oracle apps DBA interview questions The BI application consolidation challenge Upgrading PeopleSoft, part 3: Application-specific conversions and going live Upgrading PeopleSoft, part 2: Installation and the move to production Upgrading PeopleSoft, part 1: The first steps Nine steps for successful CRM implementation: Check IT List Keep downtime short on 11i migration: Reusing a prepared software stack Predictable Oracle applications tuning, part 3 Oracle E-Business Suite Ellison sees new opportunities for Oracle with Java on mobile devices Oracle Application Integration Architecture: Where it is going? OAUG president talks Collaborate '09 and the future of Oracle apps Oracle president touts Sun buy, new releases of Beehive, AIA Special Report: Collaborate '09 Oracle building momentum in eSourcing software market with new SaaS products Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed Oracle's Fusion Applications: Way behind or right on track? Oracle OpenWorld 2008 Special Report Special report: Collaborate '08

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

Oracle built-in function AP_AMOUNT_UTILITIES_PKG.ap_convert_number. I have manipulated and created a view and a function based on this function.

1. Created a custom view based on ap_lookup_codes, and forced it to use French instead of userenv('LANG').
2. Created a custom function to convert numbers to words. Used for dollar amount.
3. Executed function.
   

   Rate this Tip To rate tips, you must be a member of SearchOracle.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.