Mass Allocation
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: MASS ALLOCATIONS
Date: Fri, 16 Apr 1999 21:30:34 -0400 (EDT)
Wow-either I'm an idiot (with which a lot of people would probably
agree) - or
I'm really getting old and a step slower (which is also truer than I
care to
think)
but I can not figure out how to do this simple (little?) mass
allocation.
Let's assume 3 segments- company, dept and account
assume 3 parents called COMPANY, DEPT and ACCOUNT (all
segment values
are included in the parents except that DEPT does not include dept
1000)
All I want to do is to roll up all the amounts by dept into dept
1000
(which is
actually more like a backwards allocation doing many to one instead
of the
typical one to many) !!!!
So how do/can I set the formula:
A
B
C
Target
Offset
and if I can't do this as an allocation, anybody got any good ideas
on how to do
this some other way?
jeanne!
Joe Lichtefeld wrote:
Line A Company (Looping)
Department (Looping)
Account (Looping)
Line B Constant -1
Line C Constant 1
Target Company (Looping)
Department (Looping)
Account (Looping)
Offset Company (Looping)
1000 (Constant)
Account (Looping)
This should zero out the existing account code combination and move
the balance to each Company and Account combination with department
1000. If this is not want you want to happen, feel free to contact
me
direct and I will be happy to assist you.
Joseph Lichtefeld
Financial Systems Specialist
ResCare, Inc.
502 394-2412
email:J_lichtefeld@hotmail.com
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: MASS ALLOCATIONS
Date: Mon, 19 Apr 1999 17:11:09 -0400 (EDT)
Actually the target is where I need the constant;
the problem is that it violates the rules that say
'you can only use a looping segment type in your offset line if the
corresponding segment type in your target line is looping'
and
'if you use a looping segment type in your offset line, you must use
the same
parent as in your target line'
thanks for the effort though...
jeanne!
Joe Lichtefeld wrote:
I am on 10.7 charachter and it does allow me to have a Constant value
defined in the offset line even though the target is Looping. The
reason that you multiply by -1 is to change the Target line to the
Offset line and vice versa. This should allow you to leave the
department constant. This will keep line A segments the same as the
Target line which has to be the same in a MassAllocation.
Date: Tue, 20 Apr 1999 13:10:03 +0100
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: MASS ALLOCATIONS
Thanks to all those who thought about this- and particularly to Joe M., Steve
and Joe L. for their responses. Using a -1 as the usage factor and swapping the
target and offset lines worked.
Thanks again
jeanne!
Journal Import from non oracle systems
Date: Thu, 12 Aug 1999 11:39:52 -0700 (WIB)
From: hernawan hrn@makro.co.id
Subject: Jurnal import
Hi,
Curently we use Ora Fin 10.6 char mode (unix box).
Where can I find documentation about importing jurnal
from other sources (text file generated by other system)
I want to insert payroll data into GL (jurnal) from
other system (not oracle).
I will appreciate any help.
rgrds,
hernawan
Date: Thu, 12 Aug 1999 09:54:03 +0500
From: "Javaid Ansari" JMANSARI@mail.arco.com
Subject: Re: Journal import
Hi,
U have to populate the GL_INTERFACE table through
SqlLoader from the text file.
I have adopted this practice to load JEs into GL.
Regards
Date: Thu, 12 Aug 1999 05:46:53 PDT
From: "DASARI SUBRAHMANYAM" srdasari@hotmail.com
Subject: Re: Jurnal import
Mr.Hernawan,
U can get information from applications side like which columns are
mandatory, which are optional, which are conditionally mandatory in the
interface manuals.
For importing into interface tables u may use tools like SQL Loader, etc.
good luck
dasari
Journal import, modify and reimport
Date: Mon, 2 Aug 1999 16:31:03 +0800
From: Han Allen-A11606 a11606@Tianjin.mot.com
Subject: GL Journal Import
Hi G/L Experts,
Is there anyone has the experience to fixed the error which I mention as
below. It's urgent!
After we ran Journal Import, we found errors in execution report. The error
code is 'EC06 There are no conversion rates for this currency'. We checked
the daily rate and found we didn't set up conversion rate for that
accounting date. So we navigated to Journal Import Correct Screen, changed
the accounting date and currency conversion date to a right date which has
been set up daily rate. Then we re-ran the journal import. It completed
successfully. But we found in journal lines, there was only entered amount,
the accounted amount was zero.
Any comments will be highly appreciated. Please send to me at
a11606@email.mot.com directly.
Thanks,
Allen
Date: Mon, 2 Aug 1999 11:52:37 -0400
From: Cavazos Fausto-FFC007 Fausto.Cavazos@motorola.com
Cc: Han Allen-A11606 a11606@Tianjin.mot.com
Subject: RE: GL Journal Import
Allen,
Where is the Journal data coming from? AP? PO?
Fausto Cavazos
Motorola PCS
SCORE Team
Fausto.Cavazos@Motorola.com
Date: Tue, 3 Aug 1999 08:59:01 +0800
From: Han Allen-A11606 a11606@Tianjin.mot.com
To: Cavazos Fausto-FFC007 Fausto.Cavazos@motorola.com,
Subject: RE: GL Journal Import
Hi Fausto,
Thanks to your response. Some of our data come from external system
(Non-Oracle), some come from Oracle AP, AR, etc. Actually, I think the
source data has no problem. Now that Oracle provides the journal import
correct function, the system should allow us to change accounting date and
currency conversion date if we found the original date doesn't set up
conversion rate.
Thanks a lot.
Allen
Journal Import not working
Date: Tue, 17 Aug 1999 09:53:08 LKT
From: "Sannidhi Kris" sannidhik@hotmail.com
Subject: Error in Payables transfer to General Ledger
Hi All
We are working on 10.7 and 10sc. When we are running the payables transfer
to General Ledger program the journal import is not working.
The log file of the journal import is showing the following messages
LEZL0008: Found no interface records to process.
LEZL0009: Check status, set_of_books_id,je_source_name of interface records.
SHRD0119: Deleted 1 record(s) from gl_interface_control.
Payables transfer to General Ledger exception report is not showing any
records. It is saying no data found.
Has any body has an idea of addressing this. Did require any patch to be
applied.
Thanks in advance
Sannidhi
Date: Tue, 17 Aug 1999 15:54:43 +0100
From: naresh.patel@barclayscapital.com
To: Oraapps-L@cpa.qc.ca
Subject: Re: Error in Payables transfer to General Ledger
Check that you have run the Payables Transfer to General Ledger Job in AP
first and this job reported that invoices & payments have been interfaced.
If this is not the case, then you need to approve your invoices.
Naresh Patel
Journal Import not finding records in interface
Date: Tue, 17 Aug 1999 12:54:57 +0100
From: "Sabarad, Sateesh (GEAE, Caledonian)" Sateesh.Sabarad@ae.ge.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: GL Import.
Hi Friends,
We were trying to Transfer Invoices/Payments from AP to GL. This program
failed while importing into GL bcos of Rollback segment problem. Now, the
entries are in GL_INTERFACE table with status NEW.
If we try to Import them into GL using Import Journal screen, the request
ends with the following message :
" Journal Import finds no records in gl_interface for processing.
Check status, set_of_books_id, je_source_name and interface_run_id of
import records. "
The status, SOB_id, source name seem to be correct.
I appreciate any help in this. I use Apps 11.0.200.
Regards,
Sateesh Sabarad
g GE Caledonian
Date: Tue, 17 Aug 1999 09:06:54 -0300
From: Melanie Perry Melanie.Perry@moncton.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GL Import.
Hi Sateesh
We recently had the same problem on our Production system. Since the status
is NEW on the gl_interface table, all you have to do is rerun that
particular group id. You should check the GROUP_ID column on the
GL_INTERFACE table to ensure that is the group id you want to re-run with.
Also, there is a table called GL_INTERFACE_CONTROL table that has a STATUS
column on it. Ensure that the group_id is the same group id there too you
want to run with. The status should be set to 'I' for incomplete I believe.
With the data set as above, we simply reran the journal import and it picked
up those journal entries from the interface table fine.
Let me know if you need anymore help.
Melanie Perry
SSA \ DBA
The City of Moncton
Moncton, NB
Date: Tue, 17 Aug 1999 13:32:12 +0100
From: "Sabarad, Sateesh (GEAE, Caledonian)" Sateesh.Sabarad@ae.ge.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GL Import.
Melanie,
That's wonderful suggestion.
I didn't have a clue why it was failing. Now, it has imported correctly.
U r an angel.
Thanks,
Sateesh.