Transaction Import
Date: Mon, 21 Jun 1999 11:26:17 PDT
From: Pandya Maruti vijaay@hotmail.com
Subject: Transaction Import - URGENT
Hi All,
I am getting error 'NO_MATCHING_ITEM' while running Transaction Import
Process. I have some transactions with negative amount which are getting
following error and I don't have any matching transaction in PA for these
negative transactions .
Can anybody help me in this situation?
Thanks in advance.
Pandya.
Date: Mon, 21 Jun 1999 12:30:53 -0700
From: "Randal B. Martin" randalmartin@worldnet.att.net
Subject: RE: Transaction Import - URGENT
There is a column in the transaction interface table called
'UNMATCHED_NEGATIVE_TXN_FLAG' . If you are importing negative transactions
that are not matched to a transaction existing in PA then you should set
this flag to 'Y'.
PSI Tuning Strategies
Date: Tue, 22 Jun 1999 08:59:08 -0600
From: "Jones, Tracy" tkjones@sandia.gov
Subject: PA: PSI Tuning Strategies
We are running Project Status Inquiry(PSI) setup jobs for Project
Accounting. Does anyone have any tuning strategies for the jobs. They seem
to take forever to run. We are currently running 80,000 transactions and it
is taking over 12 hours to process. We are using 10.7 SC Prod 16.1 and HP
Unix.
Date: Wed, 23 Jun 1999 13:57:43 -0600
From: "Deborah Linke" LINKE@wapa.gov
To: oraapps-l@cpa.qc.ca, tkjones@sandia.gov
Subject: Re: PA: PSI Tuning Strategies
Message-ID: s770e7eb.097@wapa.gov
We have this problem as well and would be very interested in any suggestions.
Deborah Linke
Western Area Power Administration
303-275-1618
linke@wapa.gov
Date: Thu, 24 Jun 1999 09:20:07 -0500
From: Mandar Dewoolkar-G1606C Mandar_Dewoolkar-G1606C@email.mot.com
Subject: Re[2]: PA: PSI Tuning Strategies
Hi,
We have a similar environment (10.7 SC Prod 16.1 and Unix) and I have
been involved in a lot of assignments where jobs taking such long
hours were cut down to a couple of hours or sometimes even minutes.
The PL/SQL book by Steven Feurstein is pretty good and you could find
a lot more in some other books on tuning long running jobs. In no
specific order, some hints that may be useful...
1. Use cursors and multiple SQLs instead of complex SQLs.
2. Design temp. tables or PL/SQL tables to store intermediate data.
3. Use EXPLAIN PLAN to find out which queries are taking more times.
4. Use Cost/Rule based optimizers and appropriate Hints.
Hope this is helpful.
Mandar
Date: Fri, 10 Sep 1999 16:40:04 -0600
From: kbrown@es.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Re[2]: PA: PSI Tuning Strategies
How does this apply to a standard oracle process,
one that is not written by the individual user?
Date: Sat, 11 Sep 1999 10:39:57 +1000
From: Sheila Cruickshank scruickshank@assist.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Re[2]: PA: PSI Tuning Strategies
I think you will find that PA uses HINTS, but if you don't do the Table
Analyze, which most sites don't, then you don't want to use Hints.
It is normally recommended that for Oracle Financials all hints should be
disabled and the rule-based optimizer should be used at all times. This is
accomplished by setting the parameter '_optimizer_undo_changes' to be TRUE,
in the init.ora file.
Hope this helps,
Sheila Cruickshank
ASSISt
Date: Fri, 10 Sep 1999 21:34:50 -0600
From: kbrown@es.com
To: oraapps-l@cpa.qc.ca
Cc: cworkman@es.com
Subject: RE: Re[2]: PA: PSI Tuning Strategies
Thanks, we'll give it a shot
Date: Fri, 10 Sep 1999 23:43:32 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: RE: Re[2]: PA: PSI Tuning Strategies
_optimizer_undo_changes is to revert to old optimization method. e.g.
Oracle 6 optimization methods.
Madhu Sudan Dada
PATTAR spawned process
Date: Tue, 22 Jun 1999 15:39:52 PDT
From: Pandya Maruti vijaay@hotmail.com
Subject: PA : PATTAR spawned process
Hi All,
I am trying to find out the report being run as a part of PAATTAR (PRC:
Interface Invoice to Receivables). Can anybody suggest me how to find that
report ? In concurrent program list, I find only above spawned program but
there is no place I can find where report name is mentioned.
Thanks in advance.
Pandya .
Date: Tue, 22 Jun 1999 19:06:49 -0700 (PDT)
From: Bill Bertolotti billbert@yahoo.com
Subject: Re: PA : PATTAR spawned process
Pandya,
I believe the report that supports the interface to AR process is
contained within the PATTAR Pro*C executable as well. There is no
associated Reports 2.X version report as far as I know.
Bill Bertolotti
Date: Wed, 23 Jun 1999 09:05:14 PDT
From: Pandya Maruti vijaay@hotmail.com
Subject: Re: PA : PATTAR spawned process
Thanks for response Bill. Do you know where we can find this Spawned process
code?
Thanks.
Pandya .
Optimizer_undo_changes=TRUE
Date: Sun, 4 Jul 1999 18:58:07 +1000
From: Sheila Cruickshank scruickshank@assist.com.au
Subject: _Optimizer_undo_changes=TRUE - Projects
Can anyone tell me why we need to add this line
_OPTIMIZER_UNDO_CHANGES=TRUE the init.ora file for Projects.
Is it something to do with projects reports containing HINTS
Does it then not use the HINTs and revert to rule-based optimizer?
Thanks in advance,
Sheila
Date: Sun, 4 Jul 1999 14:49:55 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
Subject: Re: _Optimizer_undo_changes=TRUE - Projects
Hi !
_optimizer_undo_changes=TRUE is an undocumented
parameter. This will override the default optimizer settings
AS you know The SQLs in Oracle Apps are
optimized based on RULE.
The hints will be used if it is RULE.
Even if it is set to COST in INITfile this
undocumented parameter will change the SQLs
whisch has hints for rule to RULE based optimization
HTH
Regards,
K Gopalakrishnan
Database Administrator
GE Medical Systems Limited,
X Ray (South Asia) Pune-INDIA
Pin:411014 Ph # +91 20 6688693 /4
Date: Sun, 4 Jul 1999 20:47:19 -0400
From: fushan@gamma.aei.ca
Subject: Re: _Optimizer_undo_changes=TRUE - Projects
HI :
According to what I understand from this email, if I change the
_optimizer_undo_changes to FALSE and set my optimizer as
COST for Oracle Apps ( suppose to use RULE base ), Oracle Apps
will be switched as COST base.
thanks
Date: Tue, 6 Jul 1999 10:36:45 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
Subject: Re: _Optimizer_undo_changes=TRUE - Projects
Hi
You are absolutely correct
Gopal
Generate Draft Revenue for a single project
Date: Wed, 14 Jul 1999 11:21:02 -0400
From: Rangaraju_Krishna@tmac.com
Subject: Projects :PRC: Generate Draft Revenue for a single project
Hi Folks:
I am running PRC: Generate Draft Revenue for a single project and it returning
an error as follows:
ORA-01427 : single_row subquery returns more than one row while
generating draft revenue.
Intrestingly, it's not happening for all the projects.
Did any one faced similar problem?
Any suggestions are appreciated
Krishna
From: Orafin [mailto:orafin@sohm.soft.net]
Sent: Wednesday, July 14, 1999 9:53 AM
Subject: Re: Projects :PRC: Generate Draft Revenue for a single project
Can you explain what is this PRC...?
Date: Thu, 15 Jul 1999 07:31:04 -0700
From: CFowler@littonapd.com
Subject: RE: Projects :PRC: Generate Draft Revenue for a single project
In Projects the reports have a prefix:
AUD: Audit reports
IMP: Implementation listings
PRC: Processes (updates)
MGT: Management type reports
Date: Wed, 14 Jul 1999 18:32:04 -0700
From: Eric Tegenfeldt eric_tegenfeldt@rand.org
Subject: Re: Projects: PRC: Generate Draft Revenue for Single..
Good afternoon,
In response to both questions, the PRC.... is a standard process in
Oracle Projects for generating revenue against one project.
Until the day when the Projects development team converts their Pro*C
processes to PL/SQL (we can hope, can't we?), we can only guess at the
cause of the errors. However, if I had gotten the error, (and I
haven't), here are some of the things that I might check. My apologies
in advance if you have already considered all of this.
1) Does a search of Metalink turn up anything under either "Generate
Draft Revenue" or "PARGDR"?
2) Knowing the types of data that the Revenue process goes against, you
might look for things like multiple agreements on that project, multiple
customers, multiple active project managers, etc.
3) Extending item 2 even further, pull up all of the project and task
info for this project and see if you see anything unusual that might
result in a "duplicate row" situation. Likewise with the agreement,
funding, budgets, expenditure items and/or events.
By the way, what release are you on? Here at Rand, they are on 10.7 SC.
Hope this helped a little,
Eric
Date: Thu, 15 Jul 1999 15:09:08 -0400
From: "Mull, Carol" MullC@orau.gov
Subject: RE: Projects :PRC: Generate Draft Revenue for a single project
Krishna,
We have had this problem before. Ours was due to a bug in HR which allowed
us to give an employee 2 primary assignments. This caused the Generate
Revenue process for this project to error out. If you run this process with
the profile option PA: Debug Mode set to Yes and then look at the log file
from the process, you may be able to determine what is giving you the
problem. You can then mark that expenditure item as Non-Billable and
generate revenue for the rest of the project until you can resolve the
issue.
Carol
Commitments in R11
Date: Wed, 23 Jun 1999 11:52:21 -0400
From: Elizabeth Macri emacri@prg.com
Subject: Commitments in R11
We are migrating to release 11 and I have been playing in the Vision
database and have a question on commitments.
In 10.7 you see all of the commitments for a project from the Project
Summary screen in PSI. However, I am finding that this is not the case in
R11.
You can still see them if you drill down to the task level but just not all
at once in the summary screen.
Any info would be appreciated.
Thanks.
Elizabeth Macri
Date: Wed, 23 Jun 1999 10:27:43 -0700
From: "Randy Egger" regger@projectp.com
Subject: RE: Commitments in R11
Elizabeth-
The basic commitment processing logic remains the same from R10.7 to R11.
The only difference is that R11 commitments support Project Manufacturing.
Update Project Summary process very slow
Date: Thu, 15 Jul 1999 10:36:07 -0600
From: "Snyder, Stephanie" Snyder.Stephanie@tci.com
Subject: PA: Update Project Summary performance issue
The PA process PRC: Update Project Summary Amounts for a Range of Projects
is experiencing unacceptably poor performance. It is currently processing 1
project per 2 1/2 to 3 minutes. At this rate, it will take days to
complete. We have a tar logged with Oracle, but I was wondering if anyone
else has had this problem and can offer advice to boost performance?
Thanks in advance.
Date: Thu, 15 Jul 1999 10:50:24 -0700
From: "Nuyen, Mike" NuyenM@MTA.NET
Subject: RE: Update Project Summary performance issue
If you are on RDBMS 7.3.x. check the parameter below in your init.ora file.
Make sure it's set to true
_OPTIMIZER_UNDO_CHANGES = TRUE
Date: Thu, 15 Jul 1999 12:08:08 -0600
From: "Snyder, Stephanie" Snyder.Stephanie@tci.com
Subject: RE: Update Project Summary performance issue
Is this an undocumented parameter? Can you tell me a little bit about it?
Thanks!
Date: Thu, 15 Jul 1999 11:30:34 -0700
From: "Nuyen, Mike" NuyenM@MTA.NET
Subject: RE: Update Project Summary performance issue
Prior to oracle7 the internal of the optimizer was modified to change the
way that nested subqueries were handled. A side effect was that I slow down
the performance of financial reports. To offset this the
_OPTIMIZER_UNDO_CHANGES parameter is used. It is one of the parameter that
needs to be set as part of the 10.7 upgrade process. For AIX It is
documented in the system installation manual chapter3.
Autoaccounting and Dynamic insertion
Date: Tue, 20 Jul 1999 16:40:17 -0400
From: "Paradis, Dany" DParadis@teleglobe.ca
Subject: AutoAccounting in Project
Hello,
We are going to implement Project accounting and I would like to no if
dynamic insertion should be on when we are using Auto Accounting.
Thanks
Dany Paradis
Pilote Financiers Oracle
Teleglobe Canada Inc.
T=E9l.: (514) 868-7228
Fax: (514) 868-7729
Date: Tue, 20 Jul 1999 16:48:51 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: AutoAccounting in Project
Yes, dynamic insertion must be enabled in the GL for PA autoaccounting to
work.
Thanks -
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Date: Tue, 20 Jul 1999 19:40:10 -0400 (EDT)
From: Leonard Leung leonardleung@yahoo.com
Subject: Re: AutoAccounting in Project
This is purely a functional decision that you will have to make. If
you turn on dynamic insertion, then you will never know that the wrong
account has been charged. If you turn off dynamic insertion then
Oracle will generate an error each time a bad account is generated.
This error message can be of some use to you. On a recent engagement
of mine, we allowed the the account to error out, indicating to the
user that he/she did not fill in an appropriate field.
Hope this helps,
Lenny
AutoAccounting and Invoice interface
Date: Wed, 21 Jul 1999 17:57:50 -0400 (EDT)
From: karl sta ines karlstaines@yahoo.com
Subject: AutoAccounting & Invoice Interface
PRC: Interface Draft Invoice to Receivables is
failing, error message is: Unable to validate accounting flexfield. We
are
in 11.0.2
I have checked that 1.)the combinations that I am trying to create in
my AA rule is valid. 2.) Dynamic Inserts is on 3.) Cross-validation
rules are allowing these combinations 4.) PA, AR and GL periods are
open.
I'd appreciate any help on where else I need to look.
Thank you very much.
Karl
Date: Wed, 21 Jul 1999 17:12:15 -0500
From: "Sandler, Susan" Susan.Sandler@impacgroup.com
Subject: RE: AutoAccounting & Invoice Interface
Do you have any segments in your flexfield which are defined by not
enabled/displayed? i.e. sometimes people define their COA such that there
is a 'spare' segment for future use. If this segment is not enabled, but
you include it in your autoaccounting, the autoaccouting creates code combos
which have an extra segment. I know that I am reaching here, but this
actually happened to me.
S.
Date: Thu, 22 Jul 1999 07:35:31 -0400
From: "Dawn M. Duvall" dduvall@mitretek.org
To: oraapps-l@cpa.qc.ca, karlstaines@yahoo.com
Subject: RE:PA AutoAccounting & Invoice Interface
Karl,
I've gotten this error on a number of Projects distribute/interface
programs. Usually, there is a very specific message in the log file
that will identify the exact segment/value/rule that is causing the
problem. If the regular log file doesn't provide enough information,
set the PA debug profile option to Yes, rerun the process, and check the
log file again for additional messages.
Hope this helps.
Dawn Duvall
Date: Fri, 23 Jul 1999 15:09:16 -0400 (EDT)
From: karl sta ines karlstaines@yahoo.com
Subject: AutoAccounting & Invoice Import
Dawn & Susan, thanks for the input.
I thought I'd mention what we've found out. The problem was in the AA
rule. We want back to each one of them and put all constants and then
one by one put the more complicated rules back.
Regards. Karl
How to knock off an excecc Credit Memo issued in PA
Date: Wed, 21 Jul 1999 09:22:51 PDT
From: "Pandya Maruti" vijaay@hotmail.com
Subject: Credit memos in PA .... URGENT ...
Hi All,
Any help is really appreciated. My user created write off for an invoice to
nullify the invoice. Since she didn't see that credit memo that time, she
again created write off for that invoice. After some time , she saw to
credit memos for one invoice. that is invoice is $100, and there are two
credit memos of $100.
Is there any way to get rid of one credit memo out of two?
Thanks in advance.
Date: Wed, 21 Jul 1999 12:46:25 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: Credit memos in PA .... URGENT ...
A couple of quesitons . . . Were the write-off invoices entered as 'events'?
What is the status of the credit memo invoices; released, approved,
accepted?
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Date: Wed, 21 Jul 1999 10:08:09 PDT
From: "Pandya Maruti" vijaay@hotmail.com
Subject: RE: Credit memos in PA .... URGENT ...
Thanks for prompt reply. Yes the invoice was entered as 'events' and then
user created write off twice against it. The status of credit memo (write
off invoice) is approved. In fact when user creates write off invoice, it is
automatically approved.
I would appreciate tf I get any solution for this.
Thanks.
Date: Thu, 22 Jul 1999 09:51:47 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: RE: Credit memos in PA .... URGENT ...
Hi,
U can create one more event with type
"Scheduled Payment. A Scheduled Payment classification generates an invoice
for the amount of the event. Oracle Projects marks expenditure items on the
project being invoiced on a first-in first-out (FIFO) basis up to the amount
of the event. When you use this classification, you can show details on an
invoice even though the details are not used to calculate the bill amount."
This can knock off the credit.
Date for processing Revenue
Date: Thu, 22 Jul 1999 15:40:58 PDT
From: "Pandya Maruti" vijaay@hotmail.com
Subject: PA Date .... URGENT
Hi All,
My client wants to process revenue in July 99 but she wants revenue date as
June 99 . Is that possible? We have 10.7SC.
Any help would be highly appreciated.
Thanks.
Date: Fri, 23 Jul 1999 10:11:54 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: PA Date .... URGENT
I am a bit confused. Are you saying that the GL Date (for P&L) should be
June '99 but the PA Date (for PA subledger reporting) should be for July'99?
If so, can't be done.
It also sounds like may you want to open the PA Period to June '99 and
process revenue for June'99. You can do that as long as you GL Date for
June'99 is open, otherwise the revenue will go to the next open, earliest
period in the GL, which may now be July (based on how far along the month of
July is).
Feel free to expand on your question or my comments and I will answer back.
Hope this helps.
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Date: Fri, 23 Jul 1999 13:49:47 PDT
From: "Pandya Maruti" vijaay@hotmail.com
Subject: RE: PA Date .... URGENT
Hi Bart,
The question is :
My user has June 99 and July 99 PA period open. She already generated
revenue for one project last month (June 99). That's why accrue through date
is 17 Jun 99. Then she realised that that revenue is not proper and she
wants to reverse that revenue. when she reverse the revenue, it is going to
July 99 pa period and which she doesn't want. She wants to reverse that
revenue for june 99 PA period only but since july 99 is current Pa period ,
it is going in july 99. in short , though current PA period is July99, she
wants to reverse for June 99 PA Period. Can we do that?
The other question is :
Igf she close july99 temporarily and process reversal of revenue, will it go
in June 99 ? GL is having June 99 as well as Jul 99 GL Period open.
Any help would be appreciated.
Date: Fri, 23 Jul 1999 20:40:43 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: PA Date .... URGENT
Regarding you 1st question, if June 99 PA Period is 'open', and the
expenditure item dates are on or before 17-JUN-99, then the reversal of that
revenue should be for same PA Period (June 99). PA should not flag that
revenue with July 99 if June 99 is 'open' (if June 99 is in fact closed',
then it will assign July 99 as PA Period).
When the user generates (or re-regenerates) draft revenue, is PA picking up
other expenditure for revenue with expenditure dates on or beyond 18-JUN-99?
In your note below, you mention that ' . . . but since july 99 is current Pa
period . . . ', Is the user sure than June 99 is indeed 'open'?
Is the PA Date of the expenditures June 99 or July 99 in terms of costing?
Regarding your 2nd question, if the user closes July 99, the way you
describe what is happening, it may not matter. PA is looking for the
earliest, open PA Period on ofr after the expenditure item date/expenditure
ending date. If the expenditures are costed for June 99, and June 99 is
open, and the revenue is being generated with just these expenditure, then
PA Period of June 99 should be assigned.
Please let me know is this makes any sense. If not, I can forward you my
phone number and we can talk on Monday.
Thanks -
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Time and Expense Billing
Date: Thu, 22 Jul 1999 20:07:49 -0400 (EDT)
From: karl sta ines karlstaines@yahoo.com
Subject: Time & Material Billing in PA
What would prevent the system to not to bill expenditure sitting in my
Time & Material project type? Default distribution rule is Work/Work.
Project type is contract and I have funding and revenue budget. I am
using a standard billing schedule - employee rate.
I also tried bill rate override but did not work either.
I query my project and costs are charged there, but when I run PRC:
Generate Draft Revenue & Invoice, the system comes back with no
eligible expenditures in the project.
There are also no controls in place at the task level, e.g, task
billable or non-billable. We are in Release 11.0.2.
Any input is greatly appreciated.
Regards.
Date: Fri, 23 Jul 1999 08:31:07 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: Time & Material Billing in PA
Hi,
Check out the project status,if its pending what type of actions does
"Pending" allow else change it to "Completed" or any other status which
allows Recognizing Revenue.
This may help.
Regards,
Sunil Wahi
Date: Fri, 23 Jul 1999 10:16:36 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: Time & Material Billing in PA
Are the expenditures labor or materials (or both)? Is the project
authorized (control billing by top tasks flags set)? Any issues with
inconsistent dates (expenditure date vs process date)? Any hints in the log
file or report output file? Do the individual tasks have any unique
attributes setup that my differ from the project level attributes?
Just a couple of things I thought of quickly.
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Date: Fri, 23 Jul 1999 10:45:02 -0400 (EDT)
From: Bill Bertolotti billbert@yahoo.com
Subject: RE: Time & Material Billing in PA
Even though the costs are there, have you run the distribute costs
process, and the burdening process if required? The draft revenue
requires that the costs are distributed and that the lowest level task
is chargeable. Once the revenue is generated, the invoice process then
looks at the cost distribution, revenue distribution and task
chargeability. Also, is there a funded agreement for the project(s)?
Bill Bertolotti
Dynamic Insertion for Cost Distribution
Date: Thu, 29 Jul 1999 16:32:26 -0400
From: "Ynes Coiscou, TRI" YCoiscou@tricom.com.do
Subject: RE: AutoAccounting in Project
Hello all:
One more question about dynamic insertion. I'm trying to run Distribution
Cost for Usage Costs (module PAPBER) and Interface Usage (module PATTER) in
both process I'm getting error PAAACP-E DYNAMIC INSERTION IS NOT ALLOWED.
Accounts combination are defined and active. I opened a TAR with oracle
support and they said I need to have dynamic insertion ON in GL. I thought
dynamic insertion ON or OFF is related with autoaccounting not for cost
distribution processes. Any help will be appreciated. PA 10.7 SC16.1
TIA
Ynes Coiscou
Sub Gerente Sistemas Financieros
MIS, Tricom
Tel. (809) 476-4622
Mail:ycoiscou@tricom.com.do
Date: Thu, 29 Jul 1999 16:56:34 -0400
From: "Lau, Gabby" gLau@wssc.dst.md.us
Subject: RE: AutoAccounting in Project
Dynamic Insertions has to be turn on to allow creating new ccids in GL as
long as the ccid passes the cross validation rules. If the ccid has not
been created in GL, you either have to create the ccid in GL or turn dynamic
insertion on.
Gabby
Date: Thu, 29 Jul 1999 17:17:45 -0400
From: "Ynes Coiscou, TRI" YCoiscou@tricom.com.do
Subject: RE: AutoAccounting in Project
I understand what you said but in my case I'm trying to run Distribution for
usuage cost, the accounts combinations are valid and active. The process
not need to create new accounts combination in GL.
TIA
Date: Fri, 30 Jul 1999 08:44:38 +0300
From: "Dina Rotem (h)" dinar@rafael.co.il
To: "Ynes Coiscou, TRI" YCoiscou@tricom.com.do, Ora OraApps-L@cpa.qc.ca
Subject: RE: AutoAccounting in Project
Ynes
Projects requires you have dynamic insertion turn on, absolutely. It
isn't dependent if you already have the CCID or not.
When you run distribute usages the system is creating the CDL, by using
the auto accounting, and therefore you get the error.
Dina
Employee Cost Rate Date Restrictions (R11)
Date: Wed, 16 Jun 1999 12:00:54 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: PA: Employee Cost Rate Date Restrictions (R11)
Has anyone modifed the Employee Cost Rates form to remove the restrictions
that the 'From' and 'To' dates must equate to the week as is defined in the
implementations options? Basically, the requirement is to cost labor
transactions with labor cost rates not constrained by a certain week format
(e.g., Mon. - Sun.) in order to match to a payroll distribution of the 1st
and 16th of the month. Goal is to collect actual labor costs in PA to
derive the debit expense/inventory entry from autoaccounting.
Thanks in advance -
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Date: Wed, 16 Jun 1999 11:28:29 -0500
From: "Matson, Mark J." MatsonMJ@bvsg.com
Subject: RE: Employee Cost Rate Date Restrictions (R11)
Bart,
We have a similar requirement. I have written an interface that populates
the cost rates in the pa_compensation_details_all table. This interface
populates the actual date of the cost rate change, not the date that would
be computed on the screen. The next problem that you will have is that the
Distribute Labor process does not use this "mid-week" cost rate. It uses
the cost rate that is effective on the last day of the week that the
expenditure occurred (expenditure_ending_date is used and you want it to use
expenditure_item_date). To solve this problem, you can put code into the
Costing Extension (pa_client_extn_costing) to calculate the cost based on
the daily cost rate. I think this should answer your question. If I have
been unclear about any of this, feel free to contact me directly.
I logged this problem as an enhancement request with Oracle Support back in
November or December but nothing has happened with it yet. Perhaps if
enough of us log this as an enhancement request, it will get more attention
and a higher priority.
Mahalo (Thanks).
Mark J. Matson
BV Solutions Group
A Black & Veatch Company
Date: Wed, 16 Jun 1999 14:03:49 -0500
From: Badri Herur bherur@ix.netcom.com
To: Apps List oraapps-l@cpa.qc.ca, brobey@kpmg.com
Subject: RE: PA: Employee Cost Rate Date Restrictions (R11)
Hi Bart,
Our approach to the employee cost rate PA week restriction:
At one of my clients, we implemented Oracle HR/Payroll and Projects and
developed a custom process that keeps the employee salary in HR with the
cost rates in PA. This was to circumvent dual data entry, but the
solution works.
We did not face any issue with the effective dates falling between PA
periods (weekly).
HTH
Badri
Date: Fri, 18 Jun 1999 06:37:23 PDT
From: Rajesh KP appsuser@hotmail.com
Subject: Re: PA: Employee Cost Rate Date Restrictions (R11)
Hi
Can you not use employee cost rate overrides?
Rajesh