Posting Journal - APP 08058 error
Date: Wed, 1 Sep 1999 11:39:16 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: GL/FND Gururs: Getting Error while Posting a Journal ......
Hi all,
I am getting the following error when posting a Journal:
"APP-08058: This form failed to submit your
Posting Concurrent request. Please ensure that
your Concurrent Manager is Running".
Am I missing something ?
Please let me know.
Thanks,
-chakrapani
Date: Wed, 1 Sep 1999 17:59:51 +0200
From: Jean-Guy_Duba@ernst-young.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: GL/FND Gururs: Getting Error while Posting a Journal ......
The Concurrent manager is down; Start it and then resubmit.
Date: Wed, 1 Sep 1999 11:58:19 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GL/FND Gururs: Getting Error while Posting a Journal ......
Hi,
Sorry that I did not mention earlier.
I bounced Conc. Mgr. but no use.
Any other suggestion ?
We just upgraded from 11.0.28 to 11.0.3.
There are no INVALID objects.
Thanks,
-chakrapani
Date: Wed, 1 Sep 1999 13:17:13 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GL/FND Gururs: Getting Error while Posting a Journal ......
All,
This is a BUG in 11.0.3.
We upgraded our database from 11.0.28 to 11.0.3.
We need to specify a "Printer" profile option at Site level.
Until we specify this, we may not be able to submit any concurrent requests.
After I set this to an existing printer, it worked fine.
Cheers.
-chakrapani
Currency field width change
Date: Wed, 1 Sep 1999 12:20:33 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Currency Issue--!
Hi folks,
I am adding a legal entity/operating unit to our
existing Oracle Apps 10.7 The operating unit is
located in Ecudaor. The Currency amount goes up to 18
characters (including decimal and commas) and the
front end shows only 12 characters at a time. The
users do not want to scroll on the amount field to see
the whole amount. Customizing the forms would be too
big of an issue. I was wondering if there is a
workaround for this issue.
Kindly help us.
Thank you in advance.
Siddharth
Date: Wed, 1 Sep 1999 13:30:56 -0600
From: "Kossmann, Bill" BKossmann@mail.dthr.ab.ca
To: "Oracle Applications Forum (E-mail)" OraApps-L@cpa.qc.ca
Subject: FW: Currency Issue--!
Depending upon the form, you could try setting up a folder where the field
has been shrunk appropriately with folder tools. Save that folder
definition, then make it everyone's default (as Sys Admin).
Bill
Date: Wed, 1 Sep 1999 13:14:51 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FW: Currency Issue--!
Bill,
Would this be a viable option, keeping in mind that we
would be facing this issue in all the forms with
amount fields in it?
The modules that we are planning to implement are GL,
AP, Purchasing and Fixed Assets.
Thank you.
Siddharth
Date: Wed, 1 Sep 1999 14:36:19 -0600
From: "Kossmann, Bill" BKossmann@mail.dthr.ab.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FW: Currency Issue--!
Hmm, now that's a problem. If it was a handful of forms, then it would be
manageable--but across multiple modules? Perhaps not.
You would save three spaces (four, if amount 0) by setting the system
profiles "Currency:Thousands Separator" to "No" and "Currency:Negative
Format" to "-XXX" (this might be more objectionable than scrolling, I don't
know).
I guess you have to ask the users how many times they'll be entering
"999,999,999,999.99" in the Ecuador currency, and then decide whether or not
customization is worthwhile (or even possible).
Good luck!
Bill
Date: Wed, 1 Sep 1999 13:51:41 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: FW: Currency Issue--!
Bill,
This is a common occurence in Ecuador. Part of the
problem is that we have GL and AP in character mode
and Fixed Assets and Purchasing in GUI. We are trying
to find a common solution to the problem keeping in
mind the different environment that we have.
Siddharth
Date: Thu, 2 Sep 1999 09:57:33 +0100
From: "Steve Spencer" srs@freezone.co.uk
To: OraApps-L@cpa.qc.ca
Subject: RE: Currency Issue--!
Sid,
I have read Bill's replies but how about this? You know yhou can use
Custom-PLL ("Custom Library") to modify the Forms behaviour - in 10.7SC at
least. Now you can change most properties of most items at
WHEN_NEW_FORM_INSTANCE, WHEN_NEW_BLOCK_INSTANCE, WHEN_NEW_RECORD_INSTANCE,
WHEN_NEW_ITEM_INSTANCE and WHEN_VALIDATE_RECORD_INSTANCE EVENTS.
So for instance you could make a field mandatory or read-only when you enter
the form or a specific block. Now as these are properties of the field, you
could try changing the design properties (like width) in the same way. If
it works, you could widen (and reposition if necessary) fields as soon as
you enter the form.
This Custom-PLL is Oracle allowed method of customisation that does not
change the form itself but is just a .PLL file that sits on the client (or
middle server) and you just use Dorms Designer to amend and compile as
normal. We used it a LOT because our users wanted a lot of changes!
There's an Oracle manual that describes all the APP properties etc but I
cant remember its name. You are supposed to change with
APP_ITEM_PROPERTY.SET_ITEM_PROPERTY instead of the Forms SET_ITEM_PROPERTY,
but I fear that for design properties you will have to use SET_ITEM_PROPERTY
or some other Forms built-in that allows you to set an item's dimensions.
We didnt use the "APP_ITEM..." at all and had no problems! Go to the Forms
help and see if you can change design properties with SET_ITEM_PROPERTY or
anything else - this is the key to the whole issue; if you can't then
Custom-PLL will be no use here...
OR....
You could use Custom-PLL to "disable" the currency field and add your own
currency DFF segment at the same level. Then use the
WHEN_VALIDATE_RECORD_INSTANCE under Custom-PLL to stuff the DFF contents
into Oracle's currency field behind the scenes when you leave the record.
Or do it with a trigger on updating the table? You can even validate &
format (to some extent) the DFF entry too. This solution is not as nice...
Cheers,
Steve Spencer.
Import Spawn Process
Date: Thu, 2 Sep 1999 16:36:32 +0530
From: sujata/Polaris@polaris.co.in
To: oraapps-l@cpa.qc.ca
Subject: Help Urgent : GL_Import Spawns Processes.
Hi Friends,
We are facing a problem in GL_Import Program.
The scenario is this :-
We have to bring in Journals from a legacy system into Oracle Apps. We are
bringing the data thr'u SQL Loader in GL_Interface table.
Then we are running Journal Import program to load journals into GL.
The no of lines/records vary from 1000 to 75000(on rare occasions).
The import program spawns as many no of processes as the no of lines.Then
the spawned processes complete with error.
Please tell us in what situations spawning could happen ? Has this ever
happened to anybody.
We are on Rel 10.7/Oracle7.x.
Thanks & Regards,
Sujata kanchan
Oracle Apps Div.
Polaris software Lab Limited
Noida,
India.
Date: Thu, 02 Sep 1999 07:49:17 -0400
From: "Anand Gonsalves" agonsalves@glenraven.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Urgent : GL_Import Spawns Processes.
Hi Sujata
Could U be more specific about ur problem.We do GL Interface everyday and
don't have any problems.
So if U could give me more detials of ur problem I could try to help U out.
Thanks
Anand
Date: Thu, 02 Sep 1999 06:05:32 PDT
From: "Mohammed Liyakath" liyakath@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Urgent : GL_Import Spawns Processes.
Hi,
It looks like some problem with your setup.
Go to GL superuser -- System -- Control and check the fields NUMBER
LINES TO PROCESS AT ONCE ( Don't give anything there if will take
default value)
This may be a problem.
Regards,
Liyakath
Date: Thu, 2 Sep 1999 09:38:42 -0700 (PDT)
From: DIPANKAR BASU dipankar_99@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Urgent : GL_Import Spawns Processes.
Hi Sujata,
From what I understand, you have to do a one time conversion of your
data from the legacy system.
The first thing you may see is whether the flat file is correct. I am
sure you are loading a .txt file, are you not?
Second, define a new table, name it maybe gl_temp_interface with
exactly the same columns as the gl_interface tables, and with the same
properties.
Third, Insert into gl_temp_interface thru SQL loader. Use a cursor and
define some constant values. If any of the not null columns experiences
a null value, then the constant value will be taken.
Check the number of rows after loading, thru count command.
Follow the rest regular method you are using.
Hope this helps.
Dipankar
Date: Fri, 3 Sep 1999 09:13:03 +0530
From: sujata/Polaris@polaris.co.in
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Urgent : GL_Import Spawns Processes.
Hi ,
Thanks for replying. My control parameters are like this
Control segment -- Account
No of Accounts -- 2500
No of Lines to process at Once -- 1000
Is this OK. Problem is sometimes it does import succesfully.
thanks & regards,
Encumberance and Actual Report
Date: Thu, 02 Sep 1999 09:46:09 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Problem in encumberance
Hello,
I took two Account Analysis report for aug period.
1. BALANCE TYPE = Actual.
2. Balance Type = 'Encumberance' and encumberance type = 'Obligaction';
My problem is In Actual rport, Debit column have values and Credits have no
values. ie correct.
but In Encumberence report, credits having values, but no values debits, it
should be wrong. How do i find this problem.
There no pr and po.
coluld you please help me out.
Thanks
GL Interface reversal
Date: 2 Sep 99 10:47:47 PDT
From: Roger Drolet rdrolet@netscape.net
To: oraapps-l@cpa.qc.ca
Subject: Urgent Problem - GL interface from AR
The General Ledger Interface was inadvertently generated in AR.
Unfortunately, there were numerous transactions that we imported from OE that
needed to be corrected and some had to be voided. After the GL Interface is
generated, you can't make revisions to transactions that were interfaced.
Is there a way to reverse the GL Interface so that the client can make the
necessary corrections to the transactions? I welcome any suggestions. There
are approx 50 invoices involved.
Roger
Journal - unposted Report-All JE lines have same Trx date
Date: Fri, 03 Sep 1999 08:49:42 PDT
From: "BHASKER SHYAMALA" s_bhasker@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Transaction date is same to all journals
I have problem with unposted journal report. When I run this for line item
it is noticed that transaction date is same for all the journals entry
lines. we are using apps 10.7 sc16.1. with Dec-alpha open vms. Also applied
patch gl-498268under GL SERVER SIDE PATCHSET #4. But no change. Can anyone
help us to overcome this.
Thanks
ShayamalaB
End of Year Processing
Date: Fri, 3 Sep 1999 11:57:49 -0400
From: Carolyn DeSimone cdesimone@goaa.org
To: "Multiple recipients of list (E-mail)" oraapps-l@cpa.qc.ca
Subject: PO End of Year Processing
We are approaching the end or our fiscal year (9-30-99) for the first time
using Oracle Applications.
We are using Oracle Government PO, GL, AP, Inv, OE (all 10SC)
Can anyone offer pros/cons, experiences, nightmares about Carry Forward
rules:
Encumbrances Only
Encumbrances and Encumbered Budget
Funds Available
Regards,
Carolyn DeSimone
Purchasing Systems Administration
407-825-2028
page: 570-9439
email: cdesimone@goaa.org
Dual Currency Vs MRC
Date: Mon, 6 Sep 1999 11:26:52 -0700 (PDT)
From: mark liberman m_liberman@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Dual Currency
Hi,
One of the profile options allows to use Dual Currency.
Could someone please help me to understand what does this functionality
do, and how it's different
from MRC ?
Date: Mon, 06 Sep 1999 12:22:52 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Dual Currency
Dear Mark,
Dual currency is the functionality given by Apps before they came up with
multi-currency functionality. It helps you to enter dual currency journal
entries, where you can specify the dual currency's exchange rate or the
converted amount.
Dual currency helps you to translate(in the dual currency) the balances on
account to account basis as well as on weighted-average basis.
Dual Currency is only one currency - specified in
Dual Currency profile option and can use one default rate specified in
Dual currency default rate type.
Its important functionality :-
There may be a situation where the exchange rate of one currency (should be
one of your revenue earning currencies)is very volatile. So instead of
reporting gain/loss on translation on a set of book basis, you would like to
get it on an account to account basis - for important accounts like Accounts
Payable, Accounts Receivable etc.
regards
Prasanna Jena
Date: Mon, 06 Sep 1999 22:04:32 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Dual Currency
Mark,
Dual currency is a feature of ver10.7. By enabling this option you can do
transactation in two currencies.
MRC is a special feature of ver11. You must define the primary and secondary
sets of book and you can view your transaction in any number of currencies
you want.
Ravi
Exchange Rates - define
Date: Mon, 6 Sep 1999 11:46:48 -0700 (PDT)
From: david gordon dg2435@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Exchange rates
HI,
The system doesn't allow me to enter foreign currency transactions, if
there's no exchange rate for that excact day....Does anyone know a way
to setup the system so it would take the last available exchange rate ?
TIA,
David
Date: Mon, 06 Sep 1999 12:24:59 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Exchange rates
Hi,
You can try using the user rate type and enter the last exchange rate
manually.
Prasanna Jena
Date: Tue, 7 Sep 1999 03:43:23 -0700 (PDT)
From: david gordon dg2435@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Exchange rates
Thanks,
but i'm trying to find a way to use spot/corporate rates & have the
system automaticly use the last entered rate
David
Date: Tue, 7 Sep 1999 08:21:39 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Exchange rates
Hi
In V10.7 you need the rate for the day
I read in documentation that V11 or V11i will provide:
the possibility to load rate from XLS
or the possibility to use the last one
please verify
Richard Gorr
Tel 32 4 240 88 37
Date: Tue, 7 Sep 1999 04:10:35 -0700 (PDT)
From: david gordon dg2435@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Exchange rates
Hi,
We're in V11.0.2,
That's what i expected, if there is no rate for the day, the system
should use the last entered rate,
but it doesn't....
I suspect i missed a setup for that....
Do you know which setup is it ?
Thanks,
David
Date: Tue, 7 Sep 1999 12:23:40 +0100
From: aworley3@csc.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Exchange rates
The client I'm currently working with is live on 11.0.2 and using Oracle's
standard exchange rate interface mechanism. This consists of an interface
table which is used to load daily rates for ranges of dates. The table has
a trigger associated with it such that when a row (or rows) are commited a
stored procedure runs to generate the rates. It also generates the reverse
rates (ie. if the user enters a rate fro GBP to USD, the procedure will
create corresponding entries for USD to GBP). It also provides
functionality to change or remove rates.
For useability, we created a concurrent program to accept the parameters
(from/to dates, from/to currency, rate, rate type, and update type) so that
the user can run it themselves.
If you are interested, I can probably dig up some more detailed
documentation.
Regards,
Andy Worley
CSC Computer Sciences Ltd. - Consulting & Systems Integration UK Division
Date: Tue, 07 Sep 1999 10:11:01 PDT
From: "Harish K" har23@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Exchange rates
Hi:
The feature you are talking about is available for MRC purposes.
When you assign your reporting books (setup financials books assign), you
should be able to specify whether to error if rate is not found or use the
last rate defined. In the form, the column is called "no rate action".
One disadvantage of using this option is that you may take a performance
hit. Since MRC is a trigger based solution, it will take more time to look
back at the last defined rate. The number of days it will go back to look
at rates is thru a profile option: MRC: Max Days to Rollforward Conversion
Rate.
Starting rel11, Oracle also provides an interface table-
gl_daily_rates_interface table to upload rates from XLS. There is a trigger
on this interface table and it updates the gl_daily_rates table.
Hope that helps,
Harish
Date: Tue, 07 Sep 1999 22:20:25 +0200
From: "Dina Rotem (h)" dinar@rafael.co.il
To: Ora OraApps-L@cpa.qc.ca, david gordon dg2435@yahoo.com
Subject: RE: Exchange rates
Hello David
Harish is right. In release 11 you can choose to use the
latest rate only for MRC conversion. For entering
transactions in foreign currency you don't have such
functionality.
Our process is to enter each day (afternoon) the current
exchange rates for the corporate conversion type. We are
populating exchange rates upfront for today and the next
working day, based on today current rate. By this method you
always have an exchange rate available for entering
transactions. The current entry of rates will take affect
from the entering moment through the next day, until the next
rates are available.
Dina
Date: Wed, 8 Sep 1999 20:02:15 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Exchange rates
Hi there,
The way to use the foreign currency transaction in Oracle Apps is to specify
a type of rate - the seeded ones are Corporate, Spot and User, maybe more.
You can also enter your own reate types in the system.
When you enter a foreign currency transaction the system will force you to
enter a rate type and an associated rate date, and will then default the
rate in the next field.
In the rate type if you enter Spot the rate date will default to the system
date and you will have to have a rate defined for the type of Spot and the
current system date in the Daily Rates table. If you enter a type of
Corporate then you enter a specific date and you will have to have a rate
defined for the type of Corporate and the date entered in the Daily Rates
table.
If you enter User as the rate type the system defaults the system date and
the user can enter any rate that he wants.
Any other rate that is defined will behave as if it was similar to the
Corporate Rate Type.
I hope this helps clear your doubts a bit.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Consolidation - SOBs with differenct Calendars
Date: Tue, 7 Sep 1999 14:16:43 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Set of Books!
All-
My client has two Set of Books. One SOB has the Fiscal
Calendar and the other has the Monthly Calendar. Any
suggestions on how to Consolidate these two Set of
Books?
Kindly help.
Thank you in advance.
Siddharth Shah
Date: Wed, 8 Sep 1999 20:02:29 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Set of Books!
You can create a rule for mapping the calendar months to each of the
calendar books. Start of with the first period in the Fiscal Calendar and
map it to the first one in the Monthly Calendar and this should do the trick
if only your calendars are different.
When you actually do the concolidation you can specify the period in the
Subsidiary and the Parent Set of books and they can be different.
Hope this helps
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA