ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings to Mailing Lists
ON
GENERAL LEDGER

Enter a Journal after having run Translation

Date: Wed, 04 Aug 1999 11:04:52 IST
From: "seetha raman" seeethu@hotmail.com
Subject: Translation

Hi All,

Is their any problem if I enter journals after translation.

I know we have to run translation after posting the new journals. But there are some account combination which are with different translated amount.

What I did.
Functional Curr: INR

1 Translation was run to USD
2 Foreign JE was entered debitng X a/c(Receivable) with USD 1733 which had no balance.
3 posted the je.
4 Revalued the je entered(Only X a/c)
5 Posted the Revalued JE created by the system.
6 Again ran Translation to USD
7 Now X a/c is supposed to have dr of 1733 but it gives a different number.

Where did I go wrong.

Pl help me out. In case you require Rate info I can give it.
Thanks in adv for the help
seetha

Cannot find an existing Journal Batch

Date: Wed, 4 Aug 1999 11:37:19 +0300
From: mohammed alshaarawi m_sharawy@tccbce.com
Subject: GL:cannot find batch

Hello

I tried to find a batch I got 'Query caused no records to be retrieved'. but when I tried with new bacth and then press Journals I got a batch with this name already exists for this period !!!

what cause this problem? and where I can find this batch?
thanx

Add freight lines to Posted Invoices

Date: Tue, 10 Aug 1999 15:49:50 -0400
From: "nkumar" nkumar@se-tech.com
Subject: Posted AR Invoice- Add line

I have posted a batch of AR invoices to GL but now need to add freight lines on some of them. I am unable to incomplete these invoices. Is there a work-around for this problem.We are on Rel. 11.0.2

Thanks Nand

Create automatic Journal and Batch Sequences

Date: Mon, 16 Aug 1999 04:23:53 -0700 (PDT)
From: mark liberman m_liberman@yahoo.com
Subject: GL: Automatic sequential batch & journal numbering

GL: Automatic sequential batch & journal numbering

Hi all,

I need to create automatic numbering for journal batches & journals, I thought to create a document sequence ( in Sys-Admin) and assign it to the GL batches & journals.

1.Journal numbering:

I used the seeded document categories for transaction types – using the table : GL_JE_HEADERS.
The result was: a sequential numbering of the “document number” field, but not of the journal name (as I needed)

2.Batch numbering:

When creating a document category, in order to link between the document type and the sequence I need to call the category name the exact same name as the name of the associated transaction type, but a journal batch isn’t associated with a transaction type..
how should I call it so the system would know to connect them?

Could some one advise me,
Thanks
Mark

Translation at transaction detail level

Date: Mon, 16 Aug 1999 18:25:24 PDT
From: "YOU HIN TAN" tanyouhin@hotmail.com
Subject: Local Currency Book

Hello,

We are currently using Oracle 10.7 SC161 and our functional currency is US$ as per our corporate. We need to have a local currency book to meet the local statutory reporting requirements. We would prefer to have the translation at transaction detail level if possible.

Any ideals ?
Thanks, YH

Journal Approval Heirarchy

Date: Mon, 23 Aug 1999 12:18:56 -0400 (EDT)
From: satyam@sri.lanka.net
To: OraApps-L@cpa.qc.ca
Subject: GL : Journal Approval Hierarchy

Hi All,

The default Journal Approval Hierarchy is working based on the Highest amount in a journal line. We need to configure it to compare the approval limit to the journal total and not the journal line.

I'm sure some of you would have worked on a similar requirement. Can someone guide me how do i go about doing this?.

Thanks in Advance
Prabu

Date: Mon, 23 Aug 1999 12:18:59 -0400 (EDT)
From: satyam@sri.lanka.net
To: OraApps-L@cpa.qc.ca
Subject: Journal Approvals
Hi All,

How do i view the approval path taken by the journal when i have set the profile option

Approval Method : Go Up Management Chain.

We are on Rel.11.0.3 on Sun Solaris.
Thanks in Advance
Prabu

Date: Fri, 27 Aug 1999 08:11:06 GMT
From: "GopalaKrishna Surapaneni" srisri47@hotmail.com
Cc: satyam@sri.lanka.net
Subject: Re: Journal Approvals

Hi Prabu,

The journal moves up on the basis of employee-supervisor relationship which you define in the assignments screen of HR. If A's supervisor is B and B's supervisor is C, and if C is the ultimate approver, then the Journal will move from A to B and then from B to C. If the profile option is Direct instead of Go up management chain then the journal will move from A to C directly.

Gopal

Date: Fri, 27 Aug 1999 19:08:39 -0400 (EDT)
From: satyam@sri.lanka.net
Subject: Re: Journal Approvals

Hi,

What i wanted to know is if suppose i'm the final approver, and the Journal has travelled through various people, How do i view the path taken by the Journal. I need to see the employees who have seen the Journal and the comments they have recorded.

TIA

Date: Mon, 30 Aug 1999 12:48:27 GMT
From: "GopalaKrishna Surapaneni" srisri47@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Journal Approvals

Hi Prabu,

Unfortunately there is no screen in GL from which you can view the action history. You can navigate to Sysadmin-Workflow-Status, which provides a log of all workflow activities. I am not sure whether you can view notes recorded by users in a hierarchy in this screen.

Regards
Gopal

Calendar Name - change

Date: Mon, 23 Aug 1999 15:55:52 +0800
From: jian.hu@cn.pwcglobal.com
To: oraapps-l@cpa.qc.ca
Subject: Calendar Period Name Change

We found that the name of a Period in Calendar was typed incorrectly after printing the month-end report using the calendar. Is it possible to modify the name after the calendar be assigned to a set of books?

Thanks a lot and regards Jian

Merger and Migration

Date: Tue, 24 Aug 1999 16:17:04 IST
From: "ANIRBAN ROY" anir_ray@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: GL: Merger and migration

Dear All

I have the following situation:
Company A is in Oracle Apps Rel 10.7 and wants to close its books as at 31.10.99 because of merger with Company B (which does not use Oracle Apps). Now Company A wants to have the merged balances of Comapany A and B transferred as Opening balances as on 01.11.99 and wants to close the Books of the merged Company (say A&B) as at 31.03.2000 under REl 10.7 and then wants to migrate to Rel 11 as on 01.04.2000.

The solution which has come up to my mind is as follows:
1 Close the Books of Company A under Oracle Apps 10.7 as at 31.10.99 as usual
2 Close the Books of Company B under their current system as usual as at 31.10.99
3 Create a new set of books (probably with the same Chart of Accounts as that of A) and enter the total balances of A&B as opening balances in the new set of Books and then close the new set of books as at 31.03.2000.
4 Then migrate to Rel 11 as on 01.04.2000.

Could anybody suggest:
1 If the above is correct or what is the other solution.
2 What are the things to be kept in mind while preparing the new set of Books specially with respect to periods etc.

The matter is a little urgent.Thanks in advance.
Anirban

Date: Wed, 25 Aug 1999 15:25:48 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: GL

Roy,

Your route seems OK, but what about the historical data (JE details) ?

You will need access to the closed SOB after the merge of A + B into the new SOB.

If you purge and archive your data, be careful to already plan the retrieval associated procedure.

Date: Wed, 25 Aug 1999 07:39:54 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: GL

Roy,

what solution you have in mind is perfect. go ahead.

Ravi

BUG gl 937591

Date: Wed, 25 Aug 1999 07:34:14 +0100
From: "Sangster, Simon" Simon.Sangster@viasystems.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: BUG gl 937591

Hi all,

Has anyone applied this patch, I'm interested in hearing about any problems that have resulted from the patch (before I apply it!) The patch is for v11.0.2 of GL running on Digital Unix v4.0d cya,

oooooooooooooooooooooooo
oo
o       BUG  gl    937591     o
oo
oooooooooooooooooooooooo

BUG DESCRIPTION
---------------
Problem: If the posting program failed, then under some very unusual circumstances balances were committed inappropriately.

Solution: Now they are not.

Simon A. Sangster
I.S. DBA
Desk : (+44) 191 206 2218
Mobile : (+44) 802 480 149
Fax No: (+44) 191 206 2107

Budget - calendar for

Date: Wed, 25 Aug 1999 11:48:13 -0400 (EDT)
From: liza@instructor.net
To: OraApps-L@cpa.qc.ca
Subject: Is There a Different Calendar for Budget?

What would cause for the GL calendar to not be available in the quick pick for period in the Budget-Entry screen? Am I missing a step here?

Many thanks for your help.

Date: Wed, 25 Aug 1999 12:30:16 -0400
From: "Farber, Andy" farban@consumer.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Is There a Different Calendar for Budget?

The Budget you selected might not be opened for the periods...

Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org

Date: Wed, 25 Aug 1999 11:08:31 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Is There a Different Calendar for Budget?

Hi
After defining the Budget, Budget Year has to be opened. Unless it is opened, how can you budget for those periods? I hope you have also made sure that the budget does not span for more than sixty accounting periods.

Prasanna Jena
KAY Software Inc.
Silicon Valley

Date: Wed, 25 Aug 1999 14:13:56 -0400
From: "Farber, Andy" farban@consumer.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Is There a Different Calendar for Budget?

Is there a limitation on the number of accounting periods?

Our budgets currently run from Jun-91 thru May-00 (9 fiscal years, or 108 periods)...

Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org

Encumberance - Advisory Fund Checking - system does not advise violation

Date: Wed, 25 Aug 1999 13:09:57 -0700 (PDT)
From: Jim Phillips mars_60521@yahoo.com
Subject: GL: Funds Check URGENT HELP!!!!

All:

We are in encumbrance environment with Funds Checking.

The funds checking level is set to be ADVISORY.

I am entering a journal with amount that exceeds what is available in the funding budget. When funds are checked and reserved, the system passes the transactions and does not provide online ADVISORY notification that sufficient funds are not available in the budget.....Any thoughts where i might have erred in setup or any profile option that needs to be set...Thanx for all the replies.

URGENT HELP please.

Date: Wed, 25 Aug 1999 21:36:22 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
Subject: Re: GL: Funds Check URGENT HELP!!!!

Jim,

In the set of books option enable the budgetary control. It will work.

Ravi

Date: Thu, 26 Aug 1999 10:05:06 -0400
From: "Cunningham, Ronald" rcunningham@noblestar.com
Subject: RE: GL: Funds Check URGENT HELP!!!!

Jim,

In addition to Ravi's info. make sure that the account combinations in your journal are in the budget organization you set up when implementing budgetary control. Also look at your budget control group and make sure you have included journal entries (both manual & imported) and have selected an advisory funds checking level.

Good luck!
Ron
Ronald A. Cunningham
Oracle Consultant
Noble(star Systems Corporation
http://www.noblestar.com
Email: rcunningham@noblestar.com
Phone (Voice Mail): 703.464.4000
Phone (Home Voice/TDD): 803.732.1713
FAX (Home): 803.749.8878

Date: Thu, 26 Aug 1999 14:30:57 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
Subject: Re: GL: Funds Check URGENT HELP!!!!

Hi Philips,
You have set up Budgetary Control at what level? Are you trying to control the Budgetary expenses by Journal Source and Category only? In such a case there can be a conflict arising out of the Budgetary control set up at Summary and Detail account level.

If the Budgetary control at Summary Account/Detail Account is None, then all the control set up by you at the Journal Source and Category level will result in None only. The table below discusses the conflict resolution between the two types of Budgetary Control available.

Summary/Detail account Budgetary Controls
NoneAdvisoryAbsolute
Journal------------------------------------
Source & None| NONENONE ABSOLUTE
Category|
Budgetary Advisory| NONEADVISORYABSOLUTE
Controls Absolute| NONE ABSOLUTE ABSOLUTE

Please check that this conflict is resolved to your requirements. Before that of course check other set up issues. Hope this helps.

Prasanna Jena
KAY Software Inc.
Silicon Valley

MRC for Euro requirements in French Apps

Date: Thu, 26 Aug 1999 11:25:33 +0200
From: Bohdan Paszkiewicz paszkie@ibm.net
Subject: MRC : Any known problems ?

We are running French version of Apps (11.0.28) and we are planning to use MRC for our Euro requirement. Does anybody know of any problems with MRC?

Regards Bohdan Paszkiewicz

Date: Thu, 26 Aug 1999 12:58:48 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: MRC : Any known problems ?

Hi,
We went up on production 9 months ago with Rel. 11, using the MRC. We are working with all finance modules (AR, AP, GL, FA, CM) and others (OE, INV, Purchasing etc.).

We experienced lot of problems. Most of them were because of Oracle's bugs. I can't start going through all the problem but you can search in Oracle's bug DB for more information.

Now we are upgrading to 11.03 and most of the MRC problems which we had patches, workarounds or datafix for them, are been solved in this version.

Probably we will have knew bugs with this version but regarding the MRC, it looks better (specially the AR, CM and AP which I'm more familiar with).

Regards,
-- Suzie Roth
MIS (Ext. 7151)

Date: Fri, 27 Aug 1999 20:20:08 -0700
From: "Mohan Iyer" miyer@fortuna.com
Subject: RE: MRC : Any known problems ?

Hi,

We are running MRC on our R11 instance but have yet to go live in France.

We did have a few teeting problems, like some processes having inconsistencies in the MRC books but they were resolved I think we are in testing on some of the resolutions and I could ge back to the Forum later when we have them tested and resolved totally.

Other wise there have been some issues and I think they were in the way we understood or read the manuals and other comments in MEtalink and other places.

Hope this helps
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA

Journal Approval process not working

Date: Mon, 30 Aug 1999 07:42:47 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Journal approval

30.8.99

Hi!

We are in 11.0.3 version. we have set the following:
1). Enabled journal approve in the set of books.
2). Set the two profiles for journal. Preparer can approve & approval method.
3).Defined the employees and assigned the supervisor.
4).enabled require journal approval in journal source.

After completing the journal and clicking the more option we find that the approve batch button not getting highlighted. The notification to the supervisor is not going through in case of excess over limit?

Have we missed any steps?

thanks in advance,
Ravi

Date: Mon, 30 Aug 1999 17:56:50 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: Journal approval

I think you missed the Workflow Engine on which Journal Approval is based.

x-------------x

Date: Tue, 31 Aug 1999 14:28:59 -0400
From: John Sweeney jsweeney@goaa.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Very Urgent Reg.Journal Entry

I don't know much about workflow, but sometimes when a button or check box is grayed-out, the function or process that the button/check box launches has been specifically excluded at the responsibility level. Check the exclusions on the responsibility you are using when you are entering the journal.

John Sweeney
GOAA, IT Department
407-825-3280

Euro upgrade in 10.7

Date: Fri, 13 Aug 1999 15:12:16 +0200
From: Ian Taylor Ian@Brynteson.com
Subject: Euro upgrade in 10.7

Help please on this and maybe a warning for others to keep in mind when doing upgradework for one of your customers. For some reason we did NOT implement the Euro upgrade on January 1st this year in 107SC. But our DBA installed this part of the software straight into our test environment (together with a copy of our production database). From that moment on we ran into various problems, especially in the financial modules. So perhaps we have to do the work (install of the complete NCA environment and testing) once again.

Any ideas?

Ian Taylor
European Practice Manager
Brynteson Consulting, Inc.
http://www.brynteson.com
ian@brynteson.com
Europe (from EU): 00 31 650 682 336
Europe (from US): 011 31 650 682 336

Consolidation rule defined not in LOV

Date: Tue, 31 Aug 1999 05:57:49 PDT
From: "simon daniel" ora_apps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Consolidation (urgent)

Hi

I have a strange problem . I have defined a consolidation rule and when i try the run option nothing comes up. The pick list does not show the one that i have defined. I fully understand that the pick list will only show those rules defined for the current SOB which the responsibility is attached.I dont know where i am going wrong or is there any patch for the above problem

Please help me to solve this issue.

Thanks
Daniel

Date: Tue, 31 Aug 1999 09:29:05 -0400
From: "Epp, Charles A" cepp@kpmg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Consolidation (urgent)

I'd say retrace the steps or create another consolidation just to be sure. If you have defined and saved it, it should come up. Did you:

1) Define the consolidation (selecting a parent and sub)
2) Define the consolidation rules (I've used segment rules without any problem)
3) Run it (selecting both a period and parent / sub)
4) When you run, you should be prompted to select an accounting flexfield range (easiest to select entire range for all segments)

We're using 10.7 NCA and have had no problem with the consolidation so I don't think there is a patch out there, at least for 10.7 NCA. Hope that helps.

Retained Earning Account

Date: Tue, 31 Aug 1999 16:37:56 -0400
From: "Bill Keenan" billek@ccai.net
To: "Oracle Forum" OraApps-L@cpa.qc.ca
Subject: GL Set of Books/Retained Earnings question

I am about to set up a set of books, and to do so Oracle requires a default Retained Earnings Accounting code combination. I have a few questions regarding this account which I need clarified after reading the documentation.

1. This is just a default Retained Earnings account, correct? Actual Retained Earnings Account Code Combinations that are posted to are within the individual company when you close out your P&L at year-end, right? ie. If you are closing a year within a set of books, and you have several companies within these set of books, the retained earnings accounts being updated by the closeout fo the P&L will be the the related Company and retained earnings accounts for that particular set of books, not the default retained earnings combination you enter when you set up your set of books, correct?

2. When setting up a set of books, can the default company within a flexfield be a parent value? I think I know the answer to this already. You cannot post to a parent value, thus you cannot create a code combination with that parent value (such as A1-000-000-39000, where A1 is a Parent value of several companies).

I realize some of this is basic, however I haven't set up a G/L for quite some time, so I don't remember some of these issues.

Thank you very much in advance for your help.
Bill

Date: Wed, 1 Sep 1999 10:44:50 +0930
From: "Savory, Aaron" Aaron.Savory@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GL Set of Books/Retained Earnings question

1) If your individual company is the balancing segment then this will post to the correct company.
2)You are right you can not use the parent value.

Date: Wed, 1 Sep 1999 09:26:11 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: GL Set of Books/Retained Earnings question

Bill,

If we take as an example the following Retained Earnings account for SOB A is : 01-1000-SITE-SECTION, the first segment of this accounting flex being the balancing segment:

1) When the first period of the next calendar year is open (let's say JAN 2000), the system will compute revenues accounts minus expenses type accounts and will post the net result in 01-1000-SITE-SECTION. If you have then new transactions posted in the GL period DEC 1999, this net amount will be adjusted automatically.

Note that this automatic entry is not seen as a JE (you do not have any document attached to it on which you can inquire via JE inquiry).

2) Most of the companies will then make manual JE to split this amount once the books are closed to take into consideration the appropriated part (for Financial statements purposes) or simply the dividends distributed to shareholders.

3) If you have more than one value in your balancing segment, the process will be similar. For each of this value, you will have a posting of the net result : if you have company 02, then automatically, you will get 02-1000-SITE-SECTION despite the fact that your default was defined with 01-1000-SITE-SECTION. The system will screen all revenues and expenses type accounts posted under 02 company.

4) You cannot use a parent value in this accounting flex.

Hope this will help.