Troubleshooting Details

1. Processes error with ORA-04098: Trigger 'APPS.FA_MC_BOOKS_AIUD' is Invalid

Solution:

If MRC is installed, all MRC related triggers must be enabled and valid.
If MRC is not installed, then it is safe to drop the triggers.
1. Verify the owner of trigger:
select trigger_name, owner
from dba_triggers
where trigger_name like 'FA%';

2. Verify version of famcbks.sql. It should be 115.17 or later.
To obtain the file version in Unix:
Navigate to FA_TOP/patch/115/sql directory and type in
strings -a famcbks | grep -i Header:

3. To create the trigger, run famcbks.sql file
Ex: Login to data server, invoke SQL session and type
SQL> @famcbks.sql
At the prompt to "Enter a value for 1", enter trigger owner

Note: Files used to generate the MRC triggers can be found in
./patch/110/sql/famcbks.sql

Troubleshooting Details

1. Processes error with ORA-04098: Trigger 'APPS.FA_MC_BOOKS_AIUD' is Invalid

Solution:

If MRC is installed, all MRC related triggers must be enabled and valid.
If MRC is not installed, then it is safe to drop the triggers.
1. Verify the owner of trigger:
select trigger_name, owner
from dba_triggers
where trigger_name like 'FA%';

2. Verify version of famcbks.sql. It should be 115.17 or later.
To obtain the file version in Unix:
Navigate to FA_TOP/patch/115/sql directory and type in
strings -a famcbks | grep -i Header:

3. To create the trigger, run famcbks.sql file
Ex: Login to data server, invoke SQL session and type
SQL> @famcbks.sql
At the prompt to "Enter a value for 1", enter trigger owner

Note: Files used to generate the MRC triggers can be found in
./patch/110/sql/famcbks.sql

References:
Note: 157148.1 Error ORA-04098: Trigger 'APPS.FA_MC_BOOKS_AIUD' is Invalid and Failed Re-validation
Note: 1015487.102 Create Mass Additions(FAMACR) APP-00988 ORA-4098 In INSERT_FAMA, APP-47966
Note: 164385.1 Post Mass Additions Fails with Insert on FA_BOOKS Table

[top]

2. FAMRCOSPR: FADEPR Errors With Periods Not In Synch

Solution:

Synonyms were generated wrong. Make sure that no user is on the system.
start adadmin and run in this order:
* Recreate grants and synonyms for APPS schema(s)
* Compile APPS schema(s)
* Maintain Multiple Reporting Currencies schema(s)

References:
Note: 199257.1 FAMRCOSPR: FADEPR Errors With Periods Not In Synch
[top]

3. Prepare Mass Additions Screen Errors - ORA-6512, ORA-20000, ORA-4088 when preparing assets uploaded via ADI

Solution:

The fa_mc_mass_rates table needs to be populated. Because there are no AP invoices associated with these assets, the exchange rate needs to be obtained from the fa_mc_mass_rates table. This table needs to be populated separately.

Check to see if the fa_mc_mass_rates table was populated for the mass addition lines. If not, CONTACT ORACLE SUPPORT FOR ASSISTANCE IN RUNNING AN INSERT SCRIPT

References:
Note: 1070443.6 PREPARE MASS ADDITIONS SCREEN ERRORS - ORA-6512, ORA-20000, ORA-4088

[top]

4. Retirement not Processed in Reporting Book

Solution:

Run the Concurrent Request MRC:Calculate Gain Loss in all Sets of Books
Do not run the Calculate Gains and Losses program under Depreciation from the Navigator window.

See the reference guide - Multiple Reporting Currencies One-Step Subledger Processing

References:
Note: 164392.1 Retirement not Processed in Reporting Book

[top]

5. Create Journal Entries Completes Successfully but does not Create Journal Entries or MRC Create Journal Entries in All Set of Books Fails with MRC_OSP_INVALID_RESP

Solution:

Change/Enter the profile option GL:Set of Books Name for the Primary General Ledger Responsibility to ensure the correct GL set of books is seen in the Enter Journals form.

1. Log on to System Administrator
2. Navigate to Profile>System
3. Check Responsibility and select the Reporting responsibility used to submit the process
4. Enter 'GL Set of Books Name' in Profile box
5. Click Find
6. Define the Reporting Set of Books name at the responsibility level
7. Save your changes

Repeat steps 1 - 7 for profile option MRC: Reporting Set of Books.

References:
Note: 162758.1 MRC Create Journal Entries in All Set of Books Fails with MRC_OSP_INVALID_RESP
Note: 168434.1 Create Journal Entries Completes Successfully but does not Create Journal Entries

[top]

6. Depreciation in the Primary Book Failing with APP-OFA-48393 After MRC/EFC Switch

Solution:

After the EFC switch the ENABLED_FLAG was still set to Y for the reporting book in FA_MC_BOOK_CONTROLS table.

Run the following query to update ENABLED_FLAG:

update FA_MC_BOOK_CONTROLS
set enabled_flag = 'N'
where book_type_code = '&reporting_sob'
and currency_code - '&reporting_sob_currency_code';

[top]

7. FADEPR run from FAMRCOSPD in Reporting Book fails

Solution:

This task should be performed by a database administrator.
If DEPRN_STATUS is 'S' - Submitted or 'R' - Running and the concurrent request summary screen does not confirm this is true, then the DEPRN_STATUS will need to be updated via SQL*Plus to 'E' - Error.

1. Verify depreciation status in FA_MC_BOOK_CONTROLS in SQL*Plus:
SQL> SELECT BOOK_TYPE_CODE, DEPRN_STATUS
FROM FA_MC_BOOK_CONTROLS;

2. If depreciation status is 'S', then update FA_MC_BOOK_CONTROLS as follows:
SQL> UPDATE FA_MC_BOOK_CONTROLS
SET DEPRN_STATUS = 'E'
WHERE BOOK_TYPE_CODE LIKE '&BOOK';

3. Run depreciation program again through MRC: Depreciation Run in All Sets of Books
Note: Under no circumstances should the DEPRN_STATUS be set to 'C' - Completed, as this can cause major data corruption to occur.

References:
Note: 189250.1 FADEPR run from FAMRCOSPD in Reporting Book fails

[top]

8. Running Depreciation For Reporting Book Errors With APP-48398

Solution:

Apply patchset 11i.FA.I 2117740 and patch 2144836 on top.
Patch 2144836 includes a call to run adsysapp.sql which in turn compiles admcurrb.pls.

References:
Note: 189251.1 Running Depreciation For Reporting Book Errors With APP- 48398

[top]

9. MRC Depreciation Failing With APP-OFA-48208 Errors

Solution:

A grant is missing. Run "Maintain APPS Schema" and "Maintain MRC Schema". When maintaining APPS schema ensure grants and synonyms are generated.

References:
Note: 189297.1 MRC Depreciation Failing With APP-OFA-48208 Errors
Note: 189653.1 How to make sure that the MRC environment is fine for Oracle Assets

[top]

10. Performance Problem with Assets MRC Transactions Upgrade Utility Phase 2

Solution:

Temporarily use the RULE based optimizer whilst running FAMRCUPG2.

This can be set as follows:

1. Login to System Administrator Responsibility.
2. Navigate to Profiles, System.
3. Query back the profile option 'Initialization SQL statement - Custom'
4. For the Responsibility which will be used to run the FAMRCUPG2 process, set the profile option to the following value:

BEGIN FND_CTL.FND_SESS_CTL('RULE','RULE','','','',''); END;

5. Switch to the Assets Responsibility and submit FAMRCUPG2.
6. Once FAMRCUPG2 has completed, set the profile option back to COST based.

References:
Note: 167316.1 Performance Problem with Assets MRC Transactions Upgrade Utility Phase 2

[top]

11. MRC Assets Transactions Upgrade: Phase 2 fails

Solution:

Please view Note: 189324.1 and have your database administrator follow the instructions.

References:
Note: 189324.1 MRC Assets Transactions Upgrade: Phase 2 fails

[top]

12. MRC Setup-Asset Transactions Upgrade - Phase 2 Errors

Solution:

Phase 1 populates FA_MC_CONVERSION_RATES but it does not populate the exchange rate at all. It will be NULL when Phase 1 completes. Based on the exchange rate relation,
1. If the relationship is a fixed rate scenario the conversion_basis will be R and the rate based on the initial_conversion_date will be used.
2. If the exchange rate relationship between the primary and reporting currency is not fixed then provide the Rate and the BASIS after Phase 1 completes and before Phase 2 is run.

References:
Note: 183157.1 MRC Setup-Asset Transactions Upgrade - Phase 2 Errors

[top]

13. Mass Copy Did Not Copy Data to MRC Tables in a Tax Book

Solution:

1. Run adadmin - Validate Apps Schema
2. Run adadmin - Maintain Multiple Reporting Currencies Schema

References:
Note: 189515.1 ORACLE Assets MRC Responsibility Shows All Asset Books

[top]

14. Incorrect Cost In The Financial Information Form For All Assets Using MRC Responsibility

Solution:

This is due to invalid objects in the APPS_MRC schema Please follow the steps in Note 189653.1 to make sure the MRC environment is fine.

References:
Note: 189663.1 Incorrect Cost In The Financial Information Form For All Assets Using MRC Responsibility
Note: 189653.1 How to make sure that the MRC environment is fine for Oracle Assets

[top]

15. Assets added via Payables are populating MRC book with inverse exchange rate

Solution:

For Release 11i apply one-off patch 2110567 with famcmaad.sql version 115.5
(the currently highest version 115.11 is in 11i.FA.M 2719046)
For Release 11 apply one-off Patch 2311410 with famcmaad.sql version 110.13

Note: The patch only resolves this for newly added assets.

References:
Note: 189429.1 Assets added via Payables are populating MRC book with inverse exchange rate

[top]

16. After installing MRC there are invalid objects for Oracle Assets

Solution:

After applying, FA.K the MRC triggers will not be created. This is new functionality since the patch.

References:
Note: 238621.1 After Installing MRC There Are Invalid Objects For Oracle Assets
Note: 197606.1 MRC: Multiple Reporting Currencies FAQ

[top]

17. Asset Financial Inquiry is Showing Rounded Amounts in Reporting Responsibility

Solution:

There are missing MRC synonyms. The following query will display the MRC synonyms:
select substr(OWNER,1,8) Ownr, SYNONYM_NAME,
substr(TABLE_OWNER,1,8) Tbl_ownr, TABLE_NAME
from dba_SYNONYMS where
Owner = 'APPS_MRC'
and SYNONYM_NAME not like TABLE_NAME
and SYNONYM_NAME like '%FA_%' ESCAPE ''
order by 1, 3, 2;
This query should return 10 synonyms

Run Maintain MRC schema from the adadmin utility to re-create the synonyms

References:
Note: 218036.1 Asset Financial Inquiry is Showing Rounded Amounts in Reporting Responsibility

[top]

18. FAS400 Journal Entry Reserve Ledger Report run from Primary Responsibility shows all amounts in Reporting Currency

Solution:

The 'MRC: Set of Books' profile option should be set to 'N/A' at the Site level. It should not be set to point to a Reporting Set of Books at the Site level. Pointing to a Reporting Set of Books should be achieved by setting this profile at the Responsibility level only. Empty this profile option for the primary responsibility.

References:
Note: 258950.1 Journal Entry Reserve Ledger Report For Primary Responsibility Shows Amounts In Reporting Currency.
Note: 257619.1 Journal Entry Reserve Ledger Report Shows All Values In Reporting Currency
Note: 177986.1 How to set MRC profiles for Set of Books

[top]

19. FADEPR Depreciation Run against a tax book which is MRC enabled, but whose corporate book doesn't have the same reporting currency association, errors

with the following:

APP-FND-01564: ORACLE error 1403 in fazgtbcs
ORACLE error 1403 in fazgtbcs
Cause: fazgtbcs failed due to ORA-01403: no data found
The SQL statement being executed at the time of the error was: and was executed from the file
FA_BOOK_NOT_FOUND
Error: function fazcbcs returned failure (called from faxcms)
Error: function faxcms returned failure (called from faxgcb)
Error: function faxgcb returned failure (called from faxcbs)
Error: function faxcbs returned failure (called from FADEPR

Solution:

Apply standalone patch 3329129 on top of 11i.FA.L

References:
Note: 260484.1 Cannot Run Depreciation For MRC (Tax) Book APP-FND-01564 ORA-1403 FA_BOOK_NOT_FOUND

[top]

20. FAPOST Create Journal Entries Transfers Journal Entries only for Reporting Currency

Solution:

Apply current 11iFA.M rollup patch 3223708
or
Apply Patchset 11i.FA.N when available

References:
Note: 251960.1 Create Journal Entries Transfers Journal Entries only in Reporting Currency

[top]

IMPORTANT: If you did not find the information you were searching for, please review the following Oracle Assets Multiple Reporting Currencies information:

Oracle Assets Interim Patches [Note:140362.1]
Multiple Reporting Currencies Frequently Asked Questions (FAQ's) [Note:197606.1]

Copyright © 2003 Oracle Corporation. All rights reserved. Oracle is a registered trademark of Oracle Corporation. Various product and service names referenced herein may be trademarks of Oracle Corporation. All other product and service names mentioned may be trademarks of their respective owners.

Disclaimer: This document is provided for information purposes only and the contents hereof are subject to change without notice. Oracle Corporation does not warrant that this document is error-free, nor does it provide any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. Oracle Corporation specifically disclaims any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the prior written permission of Oracle Corporation.

Help us improve our service. If you have any comments or questions regarding the solution
as documented in this Note (or ANY other questions related to Oracle Assets), please post on the
Oracle Assets Technical Forum on MetaLink. The FA Forum is monitored on a daily basis
by Oracle Support Services (OSS), and response time is generally within 24 hours.

Thank you for using MetaLink!