PTD without drill down details
Date: Fri, 10 Sep 1999 11:47:21 -0400
From: "Rusty Kimbrell" RKimbrel@pgahq.com
To: oraapps-l@cpa.qc.ca
Subject: GL: PTD /NO AUDIT TRAIL
Here's one Ive never seen and cant explain. We have several accounts with
PTD activity, (they have no openeing balance and the activity in question
is the only activity). However in inquiry when you try to drill down to
journal activity , there is none(screen is blank). Same happens with the
hard copy analysis report.
I have looked in gl_je_lines,gl_je_sources,and GL_balances , I can find
the activity but it returns no related source or JE information.
WHAT IS HAPPENING!!!
Has anyone ever seen this?
Rusty
Date: Fri, 10 Sep 1999 10:59:33 -0500
From: "Bivens, Jerry" jdbivens@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: PTD /NO AUDIT TRAIL
Check and make sure there is not a misalignment with GL and PA periods. We
ran for 6 months with no problem and started having some similar issues. It
turned out that when the pa calendar was setup a period was skipped. When
we reached that point in the year the data got out of line.
Jerry
Date: Fri, 10 Sep 1999 15:54:16 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: "'RKimbrel@pgahq.com'" RKimbrel@pgahq.com
Subject: RE:GL: PTD /NO AUDIT TRAIL
I have seen this before Rusty. It occurs when the currency provided is not
the functional currency and the currency type is translated. If this matches
your situation, you cannot inquire on the journal details for the translated
balance. Only the balance of the account is translated, not the individual
journal entries. You have to review the journal entries in the functional or
entered currency.
HTH,
Stan
Multiple Calendars for same data
Date: Fri, 10 Sep 1999 10:31:19 -0700
From: Radha.Krishna@Notes.airtouch.com
To: oraapps-l@cpa.qc.ca
Subject: Question on Multi-Org
Hi
Can any of you give me a solution for this problem
How can we report on multiple calendars for the same data ? It's similar to
Multiple Reporting Currencies but this is multiple reporting currencies and
calendars.
Thanks in advance!
Radhakrishna
Date: Fri, 10 Sep 1999 21:42:13 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Question on Multi-Org
The requirment is not very clear.
What do you mean by same data but different calendar?
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: 11 Sep 99 07:28:26 EDT
From: Dinesh Chandra dchandra@usa.net
To: oraapps-l@cpa.qc.ca
Subject: RE: Question on Multi-Org
Hi,
You may like to develop customized reports to cater to your needs.
Cheers
Dinesh Chandra
Historical Data Import
Date: Mon, 13 Sep 1999 09:37:26 -0400
From: Dinesh Makked dmakked@deltadentalva.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: GL Historical Data Import!
We are in the process of installing Oracle Financials for the first time in
our Organization.
My question refers to import of historical data into GL. For some reason, we
are not going to import all of historical GL Transactions into Oracle GL.
Rather we are opting to import balances as of Aug 01, 99 ( Financial Year
Jan-Dec) with no balances/activities for periods prior to Aug. All the
transactions dated on/after Aug 01, 99 will be imported in detail. Would
someone please tell me if doing import this way would cause problems in
future?
I am asking this question because someone had suggested the import in
different way as described below:
1. Import Balances as of start of Financial Year
2. Import activities for each period and close the period which will
automatically calculate opening/closing balances for each period.
I looking forward to your kind help in this matter.
Thanks
Dinesh
Date: Mon, 13 Sep 1999 15:56:13 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GL Historical Data Import!
dinesh
You can import balances without any problems.
In my US company, they loaded using GLDI all monthly balances fro 3
years.
No problems.
Richard Gorr
Tel 32 4 240 88 37
Date: Mon, 13 Sep 1999 07:21:23 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: GL Historical Data Import!
Dinesh,
The question to ask is "What reporting is required?"
If next year, you will want to perform a current
year/previous year, period to period comparison from
Oracle or generate your year-end financial statements
from Oracle, then your second suggestion is required.
Should you continue with the proposed plan, I would
recommend that you import the balances as-of July 31st
and into the July-99 period instead. In doing so,
these population transactions won't be included in
your detailed transactions for Aug-99.
Good luck.
Andy Schindler
NRC, Inc
Date: Mon, 13 Sep 1999 11:22:13 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
To: oraapps-l@cpa.qc.ca
Subject: Re: GL Historical Data Import!
Hi ,
I do not entirely agree with Gorre.
We need to import atleast 1 prior year information in OF.If not in GL
atleast I am aware of that it gives problem in Fixed Asset for running
individual period depreciation.
I suggest that you atleast keep Dec-98 as your first open period ,Load all
prior year info in that period and close the year.Than load each month
balance for current year till Aug -99.
I hope this clarifies.
Bimal Patel
Date: Tue, 14 Sep 1999 10:24:46 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GL Historical Data Import!
Hi
We do not use FA, I spoke only about GL history
Richard Gorr
Tel 32 4 240 88 37
Date: Mon, 13 Sep 1999 20:12:31 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: GL Historical Data Import!
Your question is kind of open ended.
My answer would actually be a repetition of some of the answers you may
already got.
Decide the date when you are going live !
Load all balances for that current financial year.
Depending upon the reporting needs also load previous years' balances.
The least you should do is to load the current financial years balances.
Ofcourse you could choose to load transactions also , that would create
balances!
The best way to load these would be through the GL Interface, and using ADI
would give you a Windows based interface.
I hope this helps you decide hoe to go about the balance load issue.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Tue, 14 Sep 1999 13:48:24 +0200
From: Craig Riffel CraigR@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GL Historical Data Import!
Hi Richard
What we had done in the GL was to load prior year
opening balance and then movements for each month so that Oracle calculated
the closing balances by month. We then checked that the Retained Earning was
calculated correctly by Oracle at the end of that financial year. We then
did the same for current year up to the month preceding the go-live period.
For transactional history we have an archive system in place if any queries
arise.
To answer Bimal on FA, we loaded the legacy balances
as the end of the month preceding the go-live period and at this stage
without problems.
I would say that the GL load would depend on your
reporting requirements as well.
Hope this helps!
Thanks Much
Craig Riffel
Tiger Oats Ltd
South Africa
MRC Triggers
Date: Mon, 13 Sep 1999 19:32:57 -0400
From: Cavazos Fausto-FFC007 Fausto.Cavazos@motorola.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AP: Missing MRC Triggers?
Hello List,
For those of you who have implemented MRC the question is :
Should these MRC Triggers exist in the database?
They DO NOT exist right now.
Thanks for your help!
HP -UX 11.0
Apps 11.0.2 (MRC Enabled)
RDBMS 8.0.4.2.1
After running the following script:
$AD_TOP/admin/sql/advrfmrc.sql
..
..
..
====================================================================
The following scripts check whether the MRC triggers are missing,
invalid, or disabled in your APPS schema. If you have triggers
present below, refer to the section at the bottom of this report
titled "Installation Exception #3"
The following triggers are missing in your APPS schema
ap_mrc_invoice_payments_iiud
ap_mrc_checks_iiud
ap_mrc_invoices_iiud
ap_mrc_invoice_dists_iiud
ap_mrc_payment_dists_iid
ap_mrc_recon_dists_iid
ap_mrc_inv_dists_post_iiud
ap_mrc_inv_payments_post_iiud.
..
..
===================================
Manually Verifying AP MRC Triggers in the Database
Connected as APPS:
1 select trigger_name
2 from user_triggers
3 where trigger_name LIKE 'AP%MRC%'
4*
SQL /
TRIGGER_NAME
------------------------------
AP_MRC_CHECKS_BIUD
AP_MRC_INVOICES_BIUD
AP_MRC_INVOICE_DISTS_BIUD
AP_MRC_INVOICE_PAYMENTS_BID
AP_MRC_PAYMENT_DISTS_BID
AP_MRC_RECON_DISTS_BIUD
6 rows selected.
Date: Mon, 13 Sep 1999 18:29:44 PDT
From: "Harish K" har23@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP: Missing MRC Triggers?
Absolutely...
without the triggers, no transaction willbe recorded in your reporting
books. Furthermore, you will have to run the MRC upgrade utility to get in
all the data that should have been generated in the reporting books (if the
triggers were firing).
-Harish
Date: Mon, 13 Sep 1999 20:12:27 -0700
From: "Mohan Iyer" miyer@fortuna.com
Subject: RE: Missing MRC Triggers?
HI Fausto,
I would think that all the mRC triggers are needed if you want the MRC
functionality to work.
However, there must be a reason for your check to give you such a long list
of missing(?) triggers.
Did you run the Maintain MRC schemas option from adinstall / adpatch??
I have never run the script that you have mentioned, but I could do that and
let you know myt results. We are live on MRC from MAY-99 and are actively
testing as we send each month a separate country into the Apps world.
Let me know if you need more information!
Hope this helps
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Update Journal - FRM 40654 error
Date: 14 Sep 99 19:27:59 GST
From: Ahmed Bham ora-tech@usa.net
To: oraapps-l@cpa.qc.ca
Subject: [GL] Error updating GL Journals
Hi,
We are facing the following problem while updating any record in GL Journal
Voucher Header or Lines. Error Text :
Form Short Name : GLXJEENT
Form Version No. : 11.0.20
FRM - 40654 : Record has been updated.
Requery block to see change
I found out that there were some 221 Invalid Objects in our database, I
ran catalog and catproc (from SYS user) and then tried recompiling
APPS schema but they refuse to go.
NOTE : A similar problem is occurring in the Inventory Organization
definition screen.
Form Short Name : PRWSDOR
Form Version No. : 11.0.11
Hope to hear from you soon.
Regards,
Ahmed.
(For the list of Invalid
Objects referred to above, please click here)
GL Consolidation Setup
Date: Tue, 14 Sep 1999 11:25:22 -0700 (PDT)
From: Siddharth Shah shahsd@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: GL Consolidation Setup Question--Urgent!!
All-
We are on Apps 10.7 Character trying to setup
Consolidation Mapping Rules. The form is for some
reason forcing us to enter the Account Rules (which we
do not want) and after entering the Account Rules, it
still does not allow us to navigate to the define
Segment Rules window. Have we missed something during
the setup or is this a bug?
Kindly help.
Siddharth Shah