Depreciation run - fa_large_rollback_segment error
Date: Fri, 27 Aug 1999 23:42:25 -0700 (PDT)
From: Ashok kumar_a_s@yahoo.com
Subject: FA_LARGE_ROLLBACK_SEGMENT
Hi,
In the fixed assets, we have multiple corporate books.
But some of the book give problems while running the
deprection. I observed that this problem occurs only
when the last period of a fiscal year's depreciation
is run.
I am enclosing the log for your reference
+-----------------------------------------------------+
Oracle Assets: Version : 7.0.166 - Development
Copyright (c) Oracle Corporation 1979, 1991. All
rights reserved.
FADEPR module: Depreciation Run
+-----------------------------------------------------+
Current system time is 25-AUG-1999 11:06:28
+-----------------------------------------------------+
Depreciation Program Exception Report
Previous Messages (for Support Purposes)
APP-00606 Cannot read value for profile option
FA_LARGE_ROLLBACK_SEGMENT
At beginning of End of Fiscal Year program
Date: 25-AUG-1999 11:06:28
Fiscal Year: 1999
Fiscal Year 1999 is as long as a calendar year
Fiscal Year 2000 is as long as a calendar year
Inserted 0 calendar period records
Inserted 0 convention records
APP-48153 Program End of Fiscal Year completed
successfully
Cost Initial Journal Entry program completed
APP-48152 Asset number 100440
Previous Messages (for Support Purposes)
APP-00606 Cannot read value for profile option
FA_LARGE_ROLLBACK_SEGMENT
/spare/appl107/fa/7.0.166/bin/FADEPR
APP-00969 Program was terminated by signal 11
+-----------------------------------------------------+
Concurrent request completed
Current system time is 25-AUG-1999 11:06:34
+-----------------------------------------------------+
Date: 28 Aug 99 07:01:46 EDT
From: Dinesh Chandra dchandra@usa.net
Subject: Re: FA_LARGE_ROLLBACK_SEGMENT
Hi Ashok,
In Fixed Assets, you need a very large exclusive Rollback Segment 800MB and
assigned to this Profile Option. You may have to shutdown Concurrent Manager
and start again.
Cheers
Dinesh Chandra
Date: Sun, 29 Aug 1999 12:05:01 -0400 (EDT)
From: satyam@sri.lanka.net
To: oraapps-l@cpa.qc.ca, Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: FA_LARGE_ROLLBACK_SEGMENT
Hi
Normally, this problem occurs if you have not defined the years in your FA
calendar. Verify your FA Calendar definition. You can also try generating
the periods of the next year manually and then run depreciation for the
last period of the financial year.
Hope this will solve your problem.
Prabu
Date: Mon, 30 Aug 1999 08:52:41 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FA_LARGE_ROLLBACK_SEGMENT
Hi,
there is a "Large rollback segment" profile option and you need to
set this for your Site / Application.
Otherwise it will error out.
Create a BIG rollback segment , if possible and enter that ROLLBACK SEGMENT
option in this profile option.
We got the same error earlier and solved this problem by entering this
profile option.....
All the best.
-chakrapani
Date: Tue, 7 Sep 1999 10:26:22 -0500
From: James Aesoph jaesoph@ConAgra.com
To: oraapps-l@cpa.qc.ca
Subject: FA Large Rollback
How do I calculate the size needed for the large rollback segment? We will
have
about 500,000 assets with about 2,000 additions per month and 1,000
retirements.
MRC - Opening Bal Conversion with
Date: Sun, 29 Aug 1999 16:51:07 -0400 (EDT)
From: satyam@sri.lanka.net
To: OraApps-L@cpa.qc.ca
Subject: MRC: FA Opening Balance Conversion
Hi all,
Has anyone worked on getting assetwise Opening balance details with MRC.
Our client want to go live without MRC first and subsequently enable MRC,
may be after a year. The documents states that when i do an assets
conversion, while importing from an external system, the FA_MC_RATES table
should also be populated.
However, in the given case, we will not be doing any import when we
subsequently enable MRC. Can someone guide me as to how to get the opening
balances in the Reporting Currency as and when we switch over to MRC.
Thanks in Advance
Prabu
Date: Tue, 31 Aug 1999 18:52:35 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: FA Opening Balance Conversion
In this case you should use the method to run the transactions upgrade at a
subsequent date for the Assets.
We have implemented MRC, but all our implementations went ahead with the
current books being MRC enabled.
However, we had looked at the upgrade utilities and thought better than to
use them because of constraints on time required for testing.
However, I am not sure how this would work for Assets but I beleive there is
a lot of background work to be done on this. This is all mentioned in the
Transactions Upgrade Documentation!
I hope this helps
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Wed, 01 Sep 1999 18:47:57 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply: FA Opening Balance Conversion
Hi Mohan
We are in the commencing the process of loading legacy asset information
into FA and are MRC enabled. It does seem that leagacy asset data cannot be
uploaded through ADI. My questions:
1. Is this information correct?
2. Have you therefore, used SQL Loader for the task?
3. Any particular issues that you think we should be aware of...?
We are on Rel. 11.0.3.
Thanks
Ananth
Senior Applications Consultant
Initial upload from legacy data - errored
Date: Mon, 30 Aug 1999 09:01:06 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
To: oraapps-l@cpa.qc.ca
Subject: FA Initial Upload from Legacy data
** High Priority **
All,
Using FA 10.7, Prod 16.1.
I'm trying to bring assets in from the Mass Additions Interface tables,
with a date of Jan-99. Is there something anyone can see that we may be
doing wrong? Do I have to make sure that the GL date is Jan-99? I
wouldn't think so but I'm not sure. When we tried to run our initial
"Post Mass Additions" to bring our legacy assets into our test database,
the program errored out and we got the log file shown below.
Please Help!!!!!!!
Thanks,
Suev
+-----------------------------------------------------------------+
Application Object Library: Version : 6.1.1 - Development
Copyright (c) Oracle Corporation 1979, 1991. All rights reserved.
FNDRSSUB module: Report Set
+---------------------------------------------------------------+
Current system time is 30-AUG-1999 08:54:14
+-------------------------------------------------------------+
Report Set: Post Mass Additions
Report ID: 5000 Type: Sequential Abort on Error: Yes
Submitted report # 1: Mass Additions Post
Report ID: 5001 Printer: Save Output: Copies: 0
Submitted report # 2: Mass Additions Posting Report
Report ID: 5002 Printer: Save Output: Copies: 0
2 report(s) submitted
+-------------------------------------------------------------+
Current system time is 30-AUG-1999 08:54:17
+-------------------------------------------------------------+
Request restarted at :30-AUG-1999 08:55:55
Report # 1: Mass Additions Post Report ID: 5001
Previous Messages (for Support Purposes)
APP-00406 No message explanation found for message '&MESSAGE'
APP-00231 Report set terminated due to failure of report: Mass Additions
Post
Previous Messages (for Support Purposes)
APP-00406 No message explanation found for message '&MESSAGE'
APP-00241 Cannot process report # 2
Previous Messages (for Support Purposes)
APP-00406 No message explanation found for message '&MESSAGE'
start_next
Report set completed with error
+--------------------------------------------------------------+
Concurrent request completed
Current system time is 30-AUG-1999 08:55:56
+-------------------------------------------------------------+
Date: Mon, 30 Aug 1999 10:20:41 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FA Initial Upload from Legacy data
If this is a new install, call Oracle, there are several p[attaches that
need to be applied before go live and one of them is to the Post Mass
Addition process.
Date: Mon, 30 Aug 1999 16:26:33 +0200
From: Craig Riffel CraigR@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FA Initial Upload from Legacy data
Sue,
There would be three areas I can think that should
be checked:
1. Are the Depreciation Expense Account Combinations entered in the
Assignments Window and if so are they valid combinations.
2. Is the Queue Name set as 'Post".
3. Is the Asset Clearing Account Combination correct and valid.
I'm assuming that the category information is
correctly filled in.
Hope This Helps!!!!!!!!!!!
Thanks Much
Mass Addition programs not working
Date: Tue, 31 Aug 1999 09:05:14 LKT
From: "Sannidhi Kris" sannidhik@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Data Migration for Fixed Assets
Hi Members,
When trying to post opening balances of fixed assets from the mass additions
interface, we have to run the post mass additions program so that the queue
name for the assets brought in from our client's legacy system through SQL
Loader changes from "post" to "posted".Two concurrent programs (report set)
are simultaneously run when running the post additions program.
However, in our case, the 2 programs are not functioning though the asset
opening balances are in the "post" queue status. Can U please advise what
must be done so that the assets are posted by running this program. I don't
think it is a set-up problem. An early response is greatly appretiated.
Vidyuth & Krishna
Date: Tue, 31 Aug 1999 07:03:46 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Data Migration for Fixed Assets
Vidyth & Krishna,
I would be very interested in the response as well - I'm having almost
the exact same issue! However, issue I have is that Post Mass Additions
process has appeared to have posted about 30 out of 1900 assets (dont'
know why). All others are still in "Post" status. And when I try to run
Post Mass Additons again, I can't get reports to default into report set.
Thanks,
Sue
Reclassification of Assets errors
Date: Tue, 31 Aug 1999 01:12:43 -0400 (EDT)
From: wastu@iname.com
To: oraapps-l@cpa.qc.ca
Subject: Asset Reclassification error
Hi all,
I'm having trouble in asset reclassification. When we reclassify the asset
and try to save it, an error occur.
The error is as follow:
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-06550
The history message shows:
ORA-06550: line 1, column 7:
PLS-00306: wrong numer of types of arguments in call to "UPDATE_ROW'
ORA-06550: line 1, column 7:
PL/SQL: statement ignored
The form version is 4.5.10.10.2
We use oracle financial release 11.02 and utilising MRC
Oracle support still haven't be able to solve the problem.
Anyone know how to fixed it? Any suggestion will be much appreciated
Thanks a lot
Wastu Mulyono
Oracle Financial Consultant
Email: wastu@iname.com
Mass Transfer - cost center trfr incorrect
Date: Wed, 1 Sep 1999 15:11:07 -0400 (EDT)
From: satyam@sri.lanka.net
To: OraApps-L@cpa.qc.ca
Cc: Sinteract@listbot.com
Subject: FA - Mass Transfers
I have a query on the Mass Transfer transaction:
In the Mass Transfers Form, I had specified the following parameters:
Depr Expense boldFrom/bold 01.480.7320.000.0000 boldto/bold
01.480.7320.000.0000
(2nd segment is cost center segment and 3rd segment is the
natural account segment)
boldChanged to /bold 01.720.7350.000.0000
Expected Results : Transfer all the assets lying in the Cost Center 480
(depr. exp. a/c 7320) to cost center 720 (depr. exp. a/c 7350)
However in Mass Transfer Preview Report, it gave me changes from all the
existing depr. expense accounts of all the cost centers TO THE new depr.
expense accounts and the new cost center (as mentioned in "Changed To").
After running the final Mass Transfer Program, it changed all the cost
centers to the new cost center and new depr. expense account.
Kindly let me know what could possibly be wrong.
Thanks in anticipation.
Alok
Mass Revaluation errors
Date: Fri, 03 Sep 1999 12:07:42 +1000
From: Ruby Khaw r.khaw@qut.edu.au
To: oraapps-l@cpa.qc.ca
Subject: Fixed Assets Mass Revaluations - error
Hello all
We have not been successful in running the Mass Revaluations program in rel
11.0.2 for any asset. The preview option completes successfully after we
set the FA:Print Debug option to NO. We have had a TAR logged with Oracle
Support since May 1999. Can anyone provide any suggestions?
The log of the Mass Revaluations job is as follows:
+---------------------------------------------------------------------------+
Oracle Assets: Version : 11.0.28 - Development
Copyright (c) Oracle Corporation 1979, 1991. All rights reserved.
FAVRVL module: Mass Revaluation Program
+---------------------------------------------------------------------------+
Current system time is 03-SEP-1999 11:46:10
+---------------------------------------------------------------------------+
Error: function fafbgcc returned failure (called from fadoflx)
Getting account CCID
Error: function fadoflx returned failure (called from fadoact)
APP-47101: Error fetching cursor C1
Cause: You have a database problem.
Action: Contact your system administrator.
Error: function fadoact returned failure (called from faxinaj)
Error: function faxinaj returned failure (called from fareven)
Error: function fareven returned failure (called from main)
/opt/app/applmgr/product/11.0/fa/11.0.28/bin/FAVRVL
Program was terminated by signal 11
Cause: The program completed execution - in particular it was terminated
by signal 11.
Action: If the program completed normally, no action is required.
Action: If the program completed with a statu
+---------------------------------------------------------------------------+
No completion options were requested.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 03-SEP-1999 11:46:16
+---------------------------------------------------------------------------+
Regards,
Ruby
Ruby Khaw
Accounting Systems
Financial Services
Queensland University of Technology
2 George Street
Brisbane, Qld 4000
e-mail: r.khaw@qut.edu.au
Tel no.: 07-38642986
Fax no.: 07-38641806
Date: Fri, 3 Sep 1999 09:17:19 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: Fixed Assets Mass Revaluations - error
Unless is a bug, please check what kind of JE the Mass Rev is going to
generate : are they in compliance with any CVRS defined in GL.
Accounting Question
Date: Fri, 03 Sep 1999 15:28:35 PDT
From: "Surendranath Muttukuru" surenm@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: FA accounting question
Hi all,
I have got an accounting doubt. Can anybody help?
From PO to AP the accounting flow is as follows
Dr. Receiving Inspection
Cr. AP Accrual
Dr. Inventory
Cr. Receiving Inspection
Dr. AP Accrual
Cr. Accounts Payable
During FA interface the following accounting flow takes place
Dr. Asset Clearing
Cr. Accounts Payable
Dr. Asset Cost
Cr. Asset Clearing
My confusion is during the FA interface. This asset item has been
received. So the liability is being borne by AP Accrual account. When is the
transfer of liability from AP accrual to Asset Clearing? What I mean is how
does Asset Clearing account get into the picture, when till the AP Invoice
stage it will not be mentioned anywhere. Can anyone please explain the
accounting flow from PO to FA through AP?
Any meaningful help will be highly appreciated.
Thanks all
Date: Mon, 6 Sep 1999 17:47:22 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FA accounting question
Hi, this is my understanding:
If you are Dr. Inventory (from the PO receipt) then I can't understand why
you take it to assets.
Assuming you have a destination type of Expense, at Po receipt (from PO
distribution line) you would DR the Asset Clearing Acct.
In this case, the first set of entries in FA as you described
Dr. Asset Clearing
Cr. Accounts Payable
do not happen at all.
Rgds,
Kermiz.
Date: Mon, 6 Sep 1999 17:42:23 +0200
From: Craig Riffel CraigR@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FA accounting question
Hi Surendranath,
Ithink the Asset Clearing Account comes into the picture upon receiving,
while the AP Accrual comes in at invoicing. When you run depreciation and
post your Asset Journals, the Asset Clearing Account is cleared and Asset
Cost Account is debited. The AP Accrual account is cleared on Payment of the
invoices.
Hope this helps.
Date: Mon, 06 Sep 1999 09:19:17 PDT
From: "sharad chandra" tandale@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: FA accounting question
Hi surendernath,
You are aware that during FA interface
accounting flow takes place as under:
Dr. Asset Clearing
Cr. Accounts Payable
Dr. Asset Cost
Cr. Asset Clearing
That means,the Asset Clearing is getting squared up by debit and credit
entries and what remains is the Dr. Asset Cost ( because inventory is a
current asset and it has to be shown in balance shhet as an asset,i.e.,
current asset)Am I clear.
sharad
Date: Mon, 06 Sep 1999 16:24:43 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply: FA accounting question
Hi
When you raise a Purchase Order for an Asset, you provide a Debit account
as the distribution. This account is transmitted to AP during the matching
process. The accounting thereafter is farily simple.
Hope this helps. In case you need detailed accounting entries, do let me
know.
Ananth
Senior Applications Consultant.
Date: Mon, 6 Sep 1999 18:26:26 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: RE: FA accounting question
Be careful, fixed assets have nothing to do with inventory. We are talking
about fixed assets, not current assets....... It will not be presented in
the same order in the financial statements (from the most liquid to the
least liquid assets.....).
Regards.
Date: Mon, 06 Sep 1999 16:59:39 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply(2): FA accounting question
Hi
The procurement process in any organisation deals with both Current and
Capital Asset purchases. You are correct in stating that Fixed Assets, by
their very nature, are very different from current assets. However, I think
the issue here is NOT whether Inventory interfaces with Purchasing for Fixed
Asset Purchases - for it doesn't.
Do correct me if I am wrong. But this is how I think we can get this process
to work.
You can enter a line on the PO with a description (rather than an inventory
item - which points to the MTL_SYSTEM_ITEMS table and hence is current in
nature). Have your accounting distribution point to an Asset Clearing
Account. The Destination type will default to expense. All this should pass
over to AP during matching. Transfer AP to GL. And then to FA. FA transfer
to GL. The Asset Clearing gets reversed and the Asset cost is debited. In
case, cash is paid for the asset the liability account gets cleared.
Hope this helps.
Ananth
Senior Applications Consultant
Depreciation error - CCID generation failure
Date: Sat, 4 Sep 1999 14:22:56 +0800
From: Lee Joseph-EMLY54 Joseph.Lee.Tat.Kee@motorola.com
To: "'Multiple recipients of list'" oraapps-l@cpa.qc.ca
Subject: FA Depreciation Run Errors
To All,
When we start to initiate the depreciation run in FA module, I got the
following error message :-
xx
xxError: function fadcje returned failure (called from FADEPR)
xx
xxPrevious Messages (for Support Purposes)
xx
xxAPP-01756 Value 05 is not defined
xx
xxAPP-01929 FlexBuilder failed to generate a CCID for row 0 in fdfmap
xx
xx
I have checked thru' all the setting and found that all of the account
(CCID) do exist in account combination screens. Pls help.
Regards,
Joseph Lee
email : Joseph.Lee.Tat.Kee@motorola.com
Popi Classification:
General Business Information []
Motorola Internal Use Only [x]
Motorola Confidential Proprietary []
Date: Sat, 04 Sep 1999 19:17:16 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FA Depreciation Run Errors
Hi,
Check the value for profile option
Flexfields: Validate on Server.
Hopefully the trick lies there. Please convey the results.
Prasanna Jena
Sunnyvale, CA.
Date: Mon, 6 Sep 1999 10:18:11 +0530
From: sgupta@dfuture.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FA Depreciation Run Errors
Hi Lee,
This is an error which arises due to flexbuilder definition.Run your
flexbuilder test.Maybe the combinations it is generating are not
valid.Check all the account combinations especially with value 05.If these
combinations are not enabled in Gl and the dynamic insertion is not on,then
you can get rid of this either by changing your flexbuilder assignments or
by changing segment defaults in your corporate book.
HTH,
Shinu Gupta
MRC Conversion : Accumulated Depreciation calculation
Date: Mon, 6 Sep 1999 11:55:09 -0400 (EDT)
From: satyam@sri.lanka.net
To: OraApps-L@cpa.qc.ca
Subject: MRC Conversion : Accumulated Depreciation calculation
Hi All,
While converting the Opening balance of Assets with MRC Enabled, the
document says that i need to populate the FA_MC_MASS_RATES table with the
Exchange rate for each of the Mass addition being loaded from the legacy
system. This rates are
used by the system to arrive at the Asset cost value for the converted
assets.
But there seems to be no mention of calculation of Accumulated Depreciation
Value. Can any of you clarify as to how this Accumulated depreciation is
calculated in the Reporting currency during conversion.
Thanks in Advance
Prabu
Date: Mon, 06 Sep 1999 16:33:40 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply: MRC Conversion : Accumulated Depreciation calculation
Hi
Fixed Assets is arguably the most complex to implement in a MRC enabled
install. However, this is limited to the initial stages. Once the logic of
the system is made clear, one would be in a position to rationalise the
whole situation.
The FA_MC_MASS_RATES Table must be populated with the exchange rate for EACH
LINE in the Mass Addition Table. This is represented by the
MASS_ADDITION_ID. Hence for each reporting set of books associated with the
primary depreciation book, the exchange rate must be populated - for each
line in the Mass Additions Table.
Now, in so far as it relates to asset information, the exchange rate
provided will do the trick.
Further, you CANNOT use ADI to upload assets from the legacy system. Simply
because ADI is not MRC enabled.
In case you need any detailed clarifications on the issue, do let me know.
Hope this helps.
Ananth
Senior Applications Consultant
Date: Tue, 7 Sep 1999 10:01:22 -0400 (EDT)
From: satyam@sri.lanka.net
To: oraapps-l@cpa.qc.ca
Subject: Re: Reply: MRC Conversion : Accumulated Depreciation
Hi Ananth,
Thanks for the Info. As I understand, the Asset cost will be converted into
the Reporting Currency Value as per the Exchange rate supplied through
FA_MC_MASS_RATES table. But for the accumulated depreciation amount which i
populate for my conversion assets, i want to know what rates will the
system uses.
Thanks in advance
Prabu