Excerpt from: http://blog.csdn.net/chenxianping/article/details/51861382
Oracle EBS Version:
rdbms:9.2.0.6.0
Oracle Application Products: 11.5.10.2
Advance conditions:
I. Configuration file (System profile)
1.gl:income Statement Accounts Revaluation rule (GL: Profit and Loss Statement account revaluation rules)
Indicates whether the PTD or YTD revaluation balances are available for the income or expense account, which is the default value of YTD
2.GL revaluation:tracking by cost center (GL Revaluation: Follow-up to costs centers)
Indicates whether the revaluation account is balanced by cost center segment, except for the balanced segment, with a default value of NULL or No.
NOTE: This Oracle EBS version must be empty, otherwise submitting program-revalue balances prompts for the following warning:
[plain] view plain copy free allocated memory before exit successfully shrd0019:revaluation-process Exitin G after successful execution. Crvl0051:please set the GL revaluation:tracking by cost Center profiles to null. To track revaluation with any secondary segment, please enable the This option for your set of books instead.
3.GL/MRC revaluation:use Primary Book Currency Instead of entered Currency (GL/MRC Revaluation: Using the main book currency instead of the input currency)
Indicates whether the revaluation program creates a revaluation entry for each reporting book using the primary currency balance for the main book. Default value is empty
4.GL revaluation:validate gain/loss Accounts (GL revaluation: Verify profit and loss account)
5.GL Revaluation: The number of days to roll forward daily rates gl_reval_max_days_to_roll_rate
GL searches for the maximum number of days from the transaction date to search for the fold rate, and in this range finds the revaluation rate with the specified exchange rate type. Default value is empty
Ii. definition of two ledger accounts: No exchange gains or losses are realized. The specific situation to communicate with the financial. Some finance may require the definition of two subjects: no Exchange gains and unrealized exchange losses.
Operation Step:
First, the definition revaluation: gl->currency->revaluation.
1 Enter revaluation name: USD Revaluation
2 Input Description
3 Select all currencies or a single currency, in the case of a single currency, you need to enter a currency.
4 Select exchange rate
A) Period Rates (Period exchange rate): If you select it, you must set the exchange rate during the revaluation. Path: Gl->setup->currencies->rates->period
Note: The revaluation period exchange rate is not set, and the "Program-revalue balances" request warning is as follows:
[Plain]View Plain copy crvl0004:obtained Revaluation rates for 1 foreign currencies. Currency_code = USD Status = M JEH_ID_YTD = 0 Rate = 1 = -1/-1 Crvl0019:no Revaluation rates were found. Crvl0048:no Revaluation journal entries were created. b) Daily Rates (exchange rate per date): If you select it, you must set the daily exchange rate for the revaluation period, path: gl->setup->currencies->rates->daily
Note: The daily exchange rate during the revaluation period is not set, and the submit "Program-revalue balances" request warning is the same as period rates.
c) One-time (disposable), enter the exchange rate. This option is easier to use.
5 Maintain the "not realized revenue" and "not realized loss" ledger accounts.
6 Maintenance Revaluation Ranges, generally recommend all subjects in actual use.
7 Click "Revalue.", Submit request: "Program-revalue balances".
Second, request: "Program-revalue balances" parameter.
After the request runs complete, a revaluation journal batch is generated: Revalues AUG-15 18-dec-2015 224209, where the naming rules for the journal batch: revalues Fiscal Period creation date batch ordinal