GL Inquiry
Date: Mon, 14 Jun 1999 09:31:44 -0700 (PDT)
From: rajendra nagaraju rnagaraju@yahoo.com
Subject: GL Inquiry- URGENT
On the account inquiry in GL,
when you inquire on a AR/AP account, the transactions show up in
detail, on a distribution line basis.
Our client wants it on a transaction level detail, i.e., at the
payment/receipt and invoice HEADER LEVEL and not at the line level.
Is there a way of doing this at the reportinglevel OR is it a POSTING
option?
Appreciate your help,
Regards,
Raj
--- kbrown@es.com wrote:
Are they running their AP/AR interface to GL
processes in detail or summary?
Date: Mon, 14 Jun 1999 14:04:36 -0700 (PDT)
From: rajendra nagaraju rnagaraju@yahoo.com
Subject: RE: GL Inquiry- URGENT
Hi,
They are running it in detail.
But, even if we run it in summary, it will roll up all distribution
lines for a single account into one line.
And, when you drill down into the subledger using 'Subledger Details'
on the account inquiry screen, details show up on a distribution level
and not on the header level.
Thanks,
Raj
GL Balances
Date: Mon, 14 Jun 1999 14:37:56 -0400
From: ddicondina@SUNGARDRS.COM
Subject: GL_Balances
I'm hoping someone can help me. I'm trying to extract translated amounts
from the gl_balances table and I'm getting no records.
The functional currency for set_of_books_id = 2 is Canadian dollars and
set_of_books_id = 6 is Mexican Pesos. I'm trying to query
the US $ amounts to no avail. Below is my SQL statement for you to review.
CREATE VIEW pre_con AS
select code.segment1, code.segment10, period_net_dr,
period_net_cr, balance.period_name Month, books.short_name
from gl_code_combinations code, gl_balances balance, gl_sets_of_books books
where code.code_combination_id = balance.code_combination_id
and books.set_of_books_id = balance.set_of_books_id
and books.chart_of_accounts_id = code.chart_of_accounts_id
and books.currency_code = balance.currency_code
and balance.actual_flag = 'A'
and balance.period_name = '&period_name'
and books.set_of_books_id in (2,6)
and balance.translated_flag = 'Y'
and code.account_type in ('R','E')
/
spool dom.lst
SELECT segment1, segment10, month, short_name, period_net_dr,
period_net_cr,
sum(period_net_dr) - sum(period_net_cr) "Balance"
FROM pre_con
GROUP BY segment1, segment10, month, period_net_dr, period_net_cr,
short_name
Thanks,
Dominic DiCondina
SunGard Recovery Services Inc.
610-341-8016
Changing GL periods
Date: Wed, 16 Jun 1999 17:56:58 PDT
From: Harish K har23@hotmail.com
Subject: changing GL periods
Hi:
Is there any solution for changing the GL periods. The fiscal year needs
to be changed from Nov-Oct to Jan-Dec?
Thanks,
OVERRIDE FUNDS - BUDGETARY CONTROL SETUP
Date: Fri, 18 Jun 1999 10:56:53 -0400
From: "Vinod Kompally" KompallyV@DRMS.ci.detroit.mi.us
Subject: GL-OVERRIDE FUNDS (BUDGETARY CONTROL-SETUP)
Hi,
I have a problem :To Automate the overriding of Funds when transactions
are transferred from Legacy system (Pension payroll system-PPS) to
Oracle General Ledger .
In AOL when we go to Journal Enter screen we find MORE ACTIONS
Button and in that we find CHECK FUNDS and RESERVE FUNDS .
So we are running this process every week and there are lot of
transactions for a week . So the problem is when we CHECK FUNDS
it is Failing and after that when we do RESERVE FUNDS it is
giving the Below ERROR :
"YOUR TRANSACTION OF AMOUNT 213.67 ON ACCOUNT 5513-345435-23423432
FAILED FUNDS RESERVATION . DO YOU WANT TO OVERRIDE THIS FUNDS RESERVATION
FAILUIRE ?
NO YES
So we are saying YES,YES for each and every line (JE lines) . This
process
is taking 2hrs to Run .Is there a process where I can say YES_TO_ALL by
doing Customization of Form ?
Or Any thing I can manage in BUDGETARY CONTROL SETUP'S .
What Oracle is providing is manually override the process . I want this
to be Automate .Please suggest me . I appreciate your Response ...
Thanks,
Vinod Kumar
kompallyv@drms.ci.detroit.mi.us
Budget transfer - offset line problem
Date: Tue, 22 Jun 1999 19:49:25 -0400
From: Andre Lauzier andrel@synapse.net
Subject: Budget Transfers
In our organization we do process many budget transfers using Oracle
Financials 10.7. Through the processing/reserving funds of budget
transfers, occasionaly just the one line is posted to GL and the offset
line is absent completely or only the amount is missing. Did other Oracle
Financials users experienced such a problem, and if yes what is the
approach to correct this problem.
Thanks
Andre Lauzier
Fisheries and Oceans
Ottawa, Canada
lauziera@dfo-mpo.gc.ca
Date: Tue, 22 Jun 1999 21:45:00 -0400
From: "Farber, Andy" farban@consumer.org
Subject: RE: Budget Transfers
How are you entering your budget transfers?
Budget journal entries do not have to be balanced. You can create a
one-sided budget journal via Enter Budget Journals, or by Mass Budget
Allocations without specifying an offset; both of these can generate a
single-side budget journal that is postable.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Journal Import with Security Rules
Date: Fri, 25 Jun 1999 15:01:07 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
Subject: GL: Security rules
Hi,
I have a question regarding the security rules. I've
a SOB defined which will have 2 companies C1 and
C2(balancing segment). So I've defined 3 security
rules.
Rule 1: Include both companies C1 and C2
Rule 2: Include C1 only
Rule 3: Include C2 only.
Then I've 3 responsibilities - 'C1C2 SuperUser' which
is assigned with Rule 1. 'C1 User' assigned to Rule
2. 'C2 User' assigned to Rule 3.
Then I import a batch through Journal Import, logging
in as 'C2 User'. I've journal lines with both C1 and
C2 in them.
When I log into 'C1 User', I show the correct total,
but only the lines with company C1. (which makes
sense). The same behaviour with C2 as well. But when
I go into 'C1C2 SuperUser' responsbility, the journal
line shows only some of the journals with C2. The
rest of journal lines with C2 and all journal lines
with C1 are not displayed. I would have expected to
see all the journal lines in this responsibility.
The fact that the journal import was run with 'C2
User', be the cause of this problem??. Should we
always import with 'C1C2 SuperUser' resp.? OR are we
missing any setup?
We're on 11.0.2
Thanks,
Murali
Retrieving deleted infro from Gl_IMPORT_REFERENCES
Date: Mon, 28 Jun 1999 04:30:10 PDT
From: moses rajasingh mosesrajasingh@hotmail.com
Subject: Deleted from GL_IMPORT_REFERENCES, try to get it back ????
Hi
Can anybody help me to retrieve the data, I deleted from
GL_IMPORT_REFERENCES. The following happened
1. The posting was done on AR.
2. AR records are properly updated, (gl_date,posting_control_id etc.)
Help to retrieve it back.
regards
Moses
Date: Mon, 28 Jun 1999 17:51:00 +0530
From: skkumar@dfuture.com
Subject: Re: Deleted from GL_IMPORT_REFERENCES, try to get it back ????
If you have transfered your data from AR to GL as detail only then it is
possible to see the same information from gl_je_lines table ,
you will find the same columns (e.g. reference_1...reference_10).
Hope it will help u
Sudhir
Date: Mon, 28 Jun 1999 06:54:31 PDT
From: moses rajasingh mosesrajasingh@hotmail.com
Cc: skkumar@dfuture.com
Subject: Re: Deleted from GL_IMPORT_REFERENCES, try to get it back ????
Thanks Sudhir
But the problem is the records I tranfered from AR to Gl, it was lying in
GL_IMPORT_REFERENCES, before I posted into GL, I deleted it through the
option in the GL Menu. Is there anyway I can retrieve back the details.
Regards
Moses
Drill down to external Subledger from GL
Date: Tue, 29 Jun 1999 09:34:52 -0400
From: "Marzieh Hariri" mhariri@russelmetals.com
Subject: Drill down to external subledger from GL.
Hello all:
We are seeking information with regards to drill down from GL to an
external subledger.
Requirements:
Posting to GL should be done in summary.
Drill down info should be in detail.
Example:
Posting CCID 01-020-8900-1000-0000 in GL ,drill down should be able to
see all 10 detailed lines that summarize into this account from the
subledger.
At this point we are thinking of importing subledger info in a custom
oracle table which has the same layout as gl_interface. Summarize the
info and load GL_interface.Keep some id in one of the ref#'s which can
tie back to our custom table related lines.
And ofcourse we'll have to customize forms and .......
Anybody else done this?
Are there 3rd party software with this capability?
Please share your experience with us it is very much appreciated.
Thanx.
--
Marzieh Hariri
Senior Oracle Support Analyst
Russel Metals Inc.
(905) 819-7295x5005
Mhariri@russelmetals.com
Date: Tue, 29 Jun 1999 08:38:18 PDT
From: DASARI SUBRAHMANYAM srdasari@hotmail.com
Subject: Re: Drill down to external subledger from GL.
Hi Marzieh Hariri,
I think u may think of another alternative. GL_IMPORT_REFERENCES table
should solve the problem. It stores the reference information of which
transactions are clubbed and sent to gl_je_lines. Set up journal source
being used to import references.
-dasari
Date: Tue, 29 Jun 1999 11:51:04 -0400
From: "Marzieh Hariri" mhariri@russelmetals.com
Subject: Re: Drill down to external subledger from GL.
Thanx for the reply:
We have also considered that table but the problem is then we have to import
the data in detail and we don't want that.
Any other ideas.
Setting up multiple SOBs
Date: Mon, 8 Feb 1999 15:49:29 -0500 (EST)
From: Johnson Huen jhuen98@yahoo.com
Subject: Setting up mutti-set of books
I was trying to setup another set of books. And I also setup new
responsibilities ans attached the new set of books to them. However,
only the GL responsibility works. If I use the payables
responsibility, I can only see the old set of books and I cannot
change to the new one.
Can someone tell me what I need to do to get this work? I am
10.7 SC. Thanks a lot.
Encumberance and reporting
Date: Wed, 7 Jul 1999 13:35:48 -0700 (PDT)
From: Jim Phillips mars_60521@yahoo.com
Subject: GL: Encumbrances and Reporting
All,
Once we do the Encumbrance carry forward of prior year budget
encumbrances, related budget and funds available into the next years
budget, are there standard reports that allow for reporting on prior
year budget encumbrances separately from current year encumbrances. Or
do we need to use FSGs for this purpose.
In short, is Reporting possible segregating last year encumbrance and
budget from current year encumbrance and budget info.
Thanks allo for all the replies.
Jim.
Funds carry forward
Date: Wed, 7 Jul 1999 13:48:52 -0700 (PDT)
From: Jim Phillips mars_60521@yahoo.com
Subject: GL: Funds Carry Forward URGENT
All,
I have two budgets 98 and 99.
Funds available are being carried forward from 98 budget to 99 budget.
When i navigate to Funds CarryForward form and choose Funds Available
carryforward, the "FROM BUDDGET" field does not have any list of value
for budget entries. It is a required field to carry forward funds one
budget to another.
Any thoughts or suggestions where i might be erroring out here.
Thanks,
Jim
Date: Thu, 08 Jul 1999 05:12:58 0000
From: "rameshkumar av" av@mailcity.com
Subject: Re: Reply GL: Funds Carry Forward URGENT
--Funds carry forward is for budgetary control . If funding budget is
created it will carry forward.
avrk
Inter Company Account Balances
Date: Mon, 12 Jul 1999 14:40:46 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: GL - Inter Company account balances
Hi GL Experts,
We are implementing GL on 10.7 SC and have the following requirement;
1. We have 4 companies (say A, B, C, D) within a single set of books.
The balance inter-company option has been enabled.
2. The requirement is to get separate inter company balance for each
company. i.e. in the books of Company A,
- Interco A -B
- Interco A - C
- Interco A - D
3. Similarly, the balances are required for company B, C & D.
4. The inter- company journals arises from transactions in AP (as only
1 AP control account used and payment is also from 1 account) and Inventory.
The Automatic offset accounting option in AP is not used, as Cash Management
is also installed.
5. I defined separate categories such as A & B- invoices, A & B-
payments, etc and defined intercompany account for the same. The idea was to
enter inter company transactions in a separate batch and then transfer it
separately to GL. But I note that when journals are imported from AP to GL,
the default categories for AP invoices (Purchase invoices) and AP payments
(payments) cannot be changed, even if the 'Freeze journal import' option for
Payables source is disabled.
Can anyone please share their experiences for workarounds, if any.
Regards,
Chetan Banglorewala
Reports on items after being translated into different currency
Date: Tue, 13 Jul 1999 14:57:34 -0400
From: clare_cruickshank@dofasco.ca
Subject: General Ledger: Translation
Is anyone able to run a detailed report in a translated currency. My
functional currency is US and after translation to Cdn $, when I run an
account analysis or general ledger report, I only get information on items
that were entered in the translated currency, and not items that are entered
in US and translated. With the translated trial balance I can get balances,
but for reconciliation purposes it would be useful to have detailed
information.
How to get details after posting Journals in summary mode
Date: Thu, 15 Jul 1999 12:16:28 -0600
From: ORA_APPS ORA_APPS@sodak-gaming.com
Subject: Posting receipts to GL in summary
We are currently using 10.7SC. All of our receipts are direct delivery.
This means that it creates one entry debiting and crediting a receiving
accrual account for the receiving and another entry debiting raw materials
and crediting the receiving accrual account for delivery into inventory. We
are currently posting our purchasing receipts to GL in detail weekly, but
would like to post in summary. Does anyone know of a report that we could
run if we ever want to go back and find the detail of that GL batch for the
receiving side? I can run a material distribution report for the delivery
to inventory, but haven't had any luck finding a report showing the detail
of the first entry into receiving. Since purchasing is not a direct
subledger to GL, I cannot drill back from GL. I cannot specify a particular
GL date on the accrual rebuild report, so this does not help. Any
suggestions would be appreciated.
Thanks, Kathleen
Average Balance processing
Date: Fri, 16 Jul 1999 19:00:47 LKT
From: "Sannidhi Kris" sannidhik@hotmail.com
Subject: General Ledger-Average Balancing
Hi All
Can any body let me know about the features and the modus operandi of
Average Balance processing in General Ledger. I want to share knowledge of
anybody who has used it. I want to know the pros and cons of enabling this
option. We are impimenting APPS for a financial institution and this is the
requirement for the Client.
Thnanks in Advance
Krishna
Creating Opening Balances post implementation
Date: Tue, 20 Jul 1999 12:31:29 IST
From: "niitsrei Ora" niitsrei_ora@hotmail.com
Subject: Opening Balance Creation
Dear Everybody,
Creation of opening balances after the implementation seem to be a very
tricky issue. In our case the same have become very debatable because
1. the client has drastically changed the chart of accounts.
2. the client has a strict requirement for ability to view the legacy data
balances via Ora Apps itself.
I will appreciate if you could throw some meaningful light into this area of
implementation.
Looking forward to a qucik response.
Thanks in advance
Pawan Singh
How to correct an account having outdated translated balance
Date: Tue, 20 Jul 1999 11:45:16 -0400
From: clare_cruickshank@dofasco.ca
Subject: Translation
Help:
Does anyone know how I can correct an account which has an outdated
translated balance?
Thanks
Budget - Fund reservation
Date: Tue, 20 Jul 1999 15:40:54 EDT
From: "john lee" johnlee321@hotmail.com
Subject: GL-Budgetary Control setup / GLXJEENT.fmb Form
Hi Friends ,
I have a question in GL Budgetary Control Setup .....
We are on Oracle Govt. General Ledger 10.7 SC GUI
Here we are posting all the transactions from Project Accounting
to General Ledger every week (i.e a Batch) . So when I go to Journal
Enter form and go to "MORE ACTIONS" button in it there is another
button called "CHECK FUNDS" that checks the funds and as there is
no budget for us so the Check Funds Failure Occurs and we go to
view results it prints the Report by pressing the "PRINT ERRORS
AND WARNINGS" After that we are hitting the button "RESERVE FUNDS"
the main problem here comes as soon as I hit the RESERVE FUNDS button
that process is taking a hour after that it is asking """YOUR TRANSACTION OF
AMOUNT 213.8 ON ACCOUNT 123-2143123-123123-123123 ..
FAILED FUNDS RESERVATION . DO YOU WANT TO OVERRIDE THE FUNDS RESERVATION
FAILURE ? """ SAY --- YES OR NO
So we are saying yes,yes,yes etc.... for each and every line in the
batch (i.e may be 4000 lines for a week we are pressing 4000 times
yes,yes,yes, etc......) . Our client want this to be Automated or is there a
way to remove the Alert which is coming in the Form .. (i.e GLXJEENT.FMB
FORM) .. Or anything we can do in the Budgetary control setup Our budgetary
control here is ABSOLUTE ....
Shall I do the form Customization or Budgetary control setups ? If Form
Customization where should I find this message ?
Any suggestions are greatly appreciated .
Thanks,
John
Account Analysis with Sub-ledger Detail Report
Date: Thu, 22 Jul 1999 19:06:45 +1200
From: Neroli Anderson nanderson@swichtec.co.nz
Subject: GL/AP - Account Analysis with Sub-ledger Detail Report
Hello
Has anyone experienced recent problems with this report? We have found that
it is no longer producing vendor amounts for journals entered after we
applied an AP megapatch. The journal total still appears. Thanks for your
help.
Neroli Anderson
Oracle Development Consultant