Client Extension - reversal
Date: Tue, 24 Aug 1999 15:41:57 -0700 (PDT)
From: Mohan muthan mmuthan@yahoo.com
Subject: Project Gurus - Problem with Client Extension
Hi,
I have a Client Extension that is written to Calculate the Overtime
Costs for the Employees. It.s 1.5 times the hourly rate.So the Client
Extension creates an another transaction for .5 and calculates the
Amount. Incase if an Employee has worked for 40hrs Overtime then there
will be one row with 40hrs and another row with 20hrs. But the hours
doesnot display instead the Amount is calculated correctly. The split
is working fine.The above thing is done in One Expenditure
Batch(Original Batch).
I am now trying to reverse that due to some data incorrectness. So I
create another batch(Adjust Batch) and try to reverse the original. I
enter the New Batch name and press reverse original and pick up the
employee name,project number and task and Exp Date. I press Reverse1.
The Problem is for 40 hrs of overtime I get -40hrs. But for the .5
times(20 hrs) I get a row in the Orignial Batch and not in the Adjust
batch.
Can anyone help me telling how it is done..
Thanks
Labor Trnsaction Extension - overtime calculation
Date: Thu, 26 Aug 1999 09:03:53 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Labor Transaction Extension in Projects
Hi,
I need help on developing a Labor Transaction Extension in Projects.I want
to use this extension to calculate the overtime for a particular project
Expenditure.
I am getting an error when I run the Distribute Labor costs program from
Projects-The Log explains that error occured in the Add_transactions package
which is in the Labor Transaction Extension.
Any help will be appreciated.
Sunil Wahi.
Date: Thu, 26 Aug 1999 10:25:23 -0400
From: "Klosterman, Lisa H." KlosLH@jea.com
Subject: RE: Labor Transaction Extension in Projects
Hi Sunil,
The Labor Transaction Extension returns a status code in one of the
parameters. I'm not sure, but I think if you run the Distribute Labor Costs
in debug mode, you might get some additional information in the request log
that will help you.
-- Liza Klosterman
PORT Consulting, Inc.
Date: Thu, 26 Aug 1999 07:43:44 -0700
From: "Haseeb, Mohamed" Mohamed.Haseeb@Jacobs.com
Subject: RE: Labor Transaction Extension in Projects
Sunil,
Only possibility I could think of is --- you must be missing some parameter
/ giving an incorrect parameter while calling add_transactions_package. Make
sure you are using the exact number of parameters, the column type is okay
and the value you are passing are valid.
To verify that, try to run the package directly from SQL and see whether it
inserts transactions into the expenditure items table.
Regards.. Haseeb
Date: Thu, 26 Aug 1999 10:29:03 -0700
From: Donna Armstrong donnabsc@gte.net
Subject: RE: PA Labor Transaction Extension in Projects
Hi Sunil,
Have you checked the log file for more detailed error messages?
One thing that people sometimes forget is that it is a LABOR only
extension. Meaning that the expenditure_type you're using for the
overtime transaction you're creating must be STRAIGHT_TIME or
OVERTIME, not USAGES, EXPENSE_REPORT, or MISCELANEOUS system linkage
function or classification I think they call it now.
Hope this helps,
Donna
Donna M. Armstrong
Business Systems Consultant
Office: 310.457.4200
VM/Pager: 800.303.2527
E-Mail: donnabsc@gte.net
Date: Fri, 27 Aug 1999 16:54:45 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: RE: Labor Transaction Extension in Projects
Hi Liza,
Thanks for the mail, I shall try that out ,
The Expenditure type I am using is Straight time.
Error code shows me -1400.Is there any addition to be made to the code d
template which has been provided. I have removed all the REM 's and compiled
the package.
If I have to write code can u tell me what do I add there.
According to the procedure it is trying to pick up those expenditure types
with 'ST' as the Exp. type .The parameters are perfect.
What do I do next.
The Related transaction procedure next has to add new exp type with say
'Double time Premium' as the exp type.
I could not make out whether this is being handled by the procedure or not.
Thanks for the reply, shall await any other help.
Regards,
Sunil Wahi
Project Costing - Refresh Summary Amounts Error
Date: Thu, 26 Aug 1999 09:28:47 -0400
From: frair_patti@adtranzna.com
Subject: Project Costing - HELP - Refresh Summary Amounts Error
We are receiving an error in production with PAXACRPT: PRC: Refresh Project
Summary Amounts:
Last few lines of log file with debug on:
MSG-00001: Refreshing Actual transaction accum
MSG-00001: Records Updated = 3740
MSG-00001: Deleteing Actual transaction accum details
MSG-00001: Records Deleted = 7056
MSG-00001: Refreshing transaction accum
MSG-00001: Refreshing Revenue transaction accum
MSG-00001: Records Updated = 10
MSG-00001: Deleteing Revenue transaction accum details
MSG-00001: Records Deleted = 13
MSG-00001: Accumulating CDLs
MSG-00001: Exception Generated By Oracle Error: ORA-01422: exact fetch
returns more than requested number of rows
MSG-00001: Skipping the accumulation for project ATOE
REP-1419: 'afterreport': PL/SQL program aborted.
We have been running this process for 6 months with no problem. We have not
installed any patches at all and
our current environment is 10.7 SC 16.1 patchset E. This process runs
monthly to appropriate initilize the summary
amounts.
Any help in this area is appreciated.
Thank you,
Patti Frair
frair_patti@adtranzna.com
DaimlerChrysler Rail Systems
Adtranz
(412) 655-5264
Date: Thu, 26 Aug 1999 10:32:14 -0400
From: "Klosterman, Lisa H." KlosLH@jea.com
Subject: RE: Project Costing - HELP - Refresh Summary Amounts Error
Hi Patti,
Hmm, I'm not sure why your would get this error now since it doesn't
sound like your environment has changed. Have you tried calling Oracle
Support?
Also, I'm not sure why you are running this every month. It is my
understanding (according to Oracle Support) that you only have to run the
Refresh Project Summary process once after you have loaded converted data,
and you have to run it once if you install Patchset F (I believe). You can
run the Update Project Summary process to update the summary amounts.
-- Liza Klosterman
PORT Consulting, INC
Date: Thu, 26 Aug 1999 10:43:05 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Project Costing - HELP - Refresh Summary Amounts Error
Patti,
To make the things more simple, I would suggest opening the RDF file
and check the "After report" trigger.
(or)
Run the report with TRACE on and check the TRACE file.
There is some cursor which should return only ONE RWO
but the cursor is fetching more than ONE record now.
Please check for duplicate records somewhere.
You can get the report from Oracle Developer's KIT
or check under $AU_TOP for the RDF file.
I solved souple of such problems earlier by opening the form in Reports
designer (or) by running TRACE.
-chakrapani
Date: Thu, 26 Aug 1999 11:52:56 -0400
From: frair_patti@adtranzna.com
Subject: RE: Project Costing - HELP - Refresh Summary Amounts Error
Hi Liza,
I have a TAR for this problem at a priority 1 now. If you do not run the
Refresh Summary Amounts
and only execute the Update Project Summary Amounts the PTD
(period-to-date) amount is not set to zero
for those Projects that have no activity for the month which distorts
current month reporting.
I appreciate your reply, Thanks!
Thank you,
frair_patti@adtranzna.com
(412) 655-5264
Date: Thu, 26 Aug 1999 16:10:44 -0700
From: Eric Tegenfeldt eric_tegenfeldt@rand.org
Subject: RE: Project Costing - HELP - Refresh Summary....
Hi Patti,
Sorry to hear about the problem. Not sure if this will be helpful or
not but I have two comments, one regarding the problem you reported in
your original e-mail and the other regarding your explanation of the
purpose of the Refresh Summary below.
1. As another individual suggested (sorry, I don't remember the name or
I would give full credit), I would approach this as a potential data
error or as the uncovering of a bug based on a new data condition and
research the logic behind the process accordingly. I looked at the
report code (PAXACRPT.rdf) and saw that a package is being called in the
BEFOREREPORT trigger. The name of the package is PA_PROJ_ACCUM_MAIN.
The good news is that the code is accessible (unlike Generate Revenue,
etc.) if you have SELECT privileges on the DBA_SOURCE table. The bad
news is that the package is over 2400 lines long.
However, I did a select looking for just the word "INTO" (since you
are getting a "Too Many Rows"-type error) and there are not very many
occurences of that word. If you spool the text out to a file, you could
probably track down the places in the code pretty quickly and see if one
of those statements is returning more than one row for your "ATOE"
project. Of course, it is possible that the error is being generated by
a called function or procedure outside of this package, in which case
you will have to do some more digging.
2. I had not heard before that the Refresh process was required to
reset the PTD values. In fact, here at Rand, the Refresh process has
never been run since they first cut over to 10.7 a year ago. I went and
checked a number of projects and the only ones that have PTD values are
the projects that had activity in the current "Reporting" period.
Granted, they are now on patchset H so perhaps it is something that was
just changed between patchset E and patchset H but you might want to
double-check and see if you can get by just running the Update Summary
process.
Hope this helps,
Eric
Eric B. Tegenfeldt Office: 310.393.0411 X7164
Oracle Projects Consultant Pager: 661.538.3896
Business Information Systems
RAND Corporation
Employees - link to a project
Date: Fri, 27 Aug 1999 02:01:51 PDT
From: "simon daniel" ora_apps@hotmail.com
Subject: Employees in PA (project accounting)
Hi ,
How do i link an employee to a project in project accounting if i dont have
employee as one of my flex field structure.
2) Where do i enter the start organisation value that is required while
setting up project accounting.
3) I have project accoutning installed, both billing and costing. when i
attach the costing responsibility to a user, it does'nt show in the
responsibility list for that user. I can only use billing super user.
Appreciate your inputs .
Thanks
DS
Date: Fri, 27 Aug 1999 09:10:56 EDT
From: DIGIACKG@aol.com
Subject: Re: Employees in PA (project accounting)
Daniel -
#1) What do you mean 'link an employee' to a project? Do you mean as a
Project Manager (or other 'Key Player')? Or to be able to enter their
timesheet to the project? Either way, they must be in the HR tables
(PER_PEOPLE_F, etc).
#2) Your start organization value is entered in your implementation options
screen. There are Organization Hierarchy screens to set up an organization
hierarchy structure.
#3) When version are you using. I have not used Release 11, but with 10.7,
most responsibilities are pre-packed as either Character or GUI -- you must
make sure you select correct one.
Hope these answers help. Let me know if I can be of further assistance.
Kevin.
PRC Distribution Expense Report errors
Date: Wed, 01 Sep 1999 08:39:16 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: help for PA (please help it very urgent)
Pa guru,
My user ran the PRC distribution expence report.
The report showing the status is : Incomplete Auto Accounting Rules.
Any one Face this type of problem, Please help it .
What is the problem? please guide me.
Tia
Prince
Date: Wed, 01 Sep 1999 16:03:06 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: help for PA (please help it very urgent)
The best way to trouble shoot this problem is :
1. Put Debug Mode ON in profile for user
2. Then check Request log. It says what is wrong in your Auto Accounting
rule , i.e., it should say PA_AA_NO_LOOKUP or PA_AA_TOO_MANY_ROWS , etc.
Good luck .
Date: Wed, 01 Sep 1999 09:37:06 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: help for PA (please help it very urgent)
I am asking very simple question don't mind it.
how do i put debug mode on in profile for user.
Date: Wed, 01 Sep 1999 19:01:47 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: help for PA (please help it very urgent)
Hi All,
If you login as System Admin and click user profile option and then retrive
for that particular user and you should see 'PA:Debug Mode'. Make that Yes
and you should able to get detail request log for that user once he runs any
process.
Let me know if you have any question.
Date: Wed, 01 Sep 1999 13:01:08 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: help for PA (please help it very urgent)
Hi all,
I put debug mode on to user, and run that expense report i got detail log
file. but i don't have too may rows or pa_aa_no_lookup.
To day only i got this problem. could please help it .
Thanks
Date: Wed, 01 Sep 1999 13:52:01 -0700
From: Donna Armstrong donnabsc@gte.net
To: OraApps-L@cpa.qc.ca, prince_sutha@hotmail.com
Subject: Re: help for PA (AutoAccounting)
Hi Prince,
Have you looked at the AutoAccounting Setup for Expense Reports?
Navigate - Setup - AutoAccounting - Assign
Query up the record for the Distribute Expense Reports (Debit)
function (I forget the title as it changed between releases). Then you
can see the rules that are being executed for the record that got this
error. I seem to recall this message when no value is found in a lookup
set, but it could be a number of things.
Hope this info helps,
Donna
Donna M. Armstrong
Business Systems Consultant
Office: 310.457.4200
VM/Pager: 800.303.2527
E-Mail: donnabsc@gte.net
Date: Wed, 01 Sep 1999 14:03:48 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: help for PA (AutoAccounting)
Hello all,
When i put debug mode on profile , i got detial log. I log file have
- batching totals (by expense report)
1 processed
0 expense eports batched
1 errors
how to find this error
thanks
Date: Thu, 02 Sep 1999 06:19:39 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: help for PA (please help it very urgent)
Hi all,
Thank you very much for all, I solved problem. User made a wrong entry.
Thanks
prince
Enabled Flag in pa_projects_all
Date: Wed, 01 Sep 1999 12:06:53 -0500
From: "Danette Fedock"danette_fedock@ccmail.c-tec.com
To: oraapps-l@cpa.qc.ca
Subject: Projects: Enabled flag
How does the enabled flag in pa_projects_all become anything other
than 'Y'? We thought it would change when you have a close date that
is prior to the current date.
Journals from AP/PO - adjusting incorrect codes
Date: Thu, 2 Sep 1999 10:00:09 +0800
From: "Stankevicius, Jon" Jon.Stankevicius@health.wa.gov.au
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Project Accounting Journals - HDWA
We are running running Oracle Projects Ver 4.1 and Oracle Applications Ver
10.7SC as a basic costing system.
Normal entry to the Projects Module is via Payables Invoices. We do not
currently use 'Expense Reports' as, I understand, these cannot code to the
same Expenditure Types because in Oracle Projects, Expenditure Types are
quarantined to a single document source (eg., Payables Invoices).
Apart for from the Oracle Projects Module itself, the only other Modules
where a project code can be input are Purchasing and Payables.
So the question arises: How do you correct something that has been
mis-coded? OK you say, got to the Projects Module and transfer the
expenditure from one project to another etc. Cost split at will. Fine, but
note that the report audit trail for 'internal' transfers of expenditure is
problematic, in that the two standard reports available to do this can only
be run one project at a time (why not a range!!).
However, the above procedure does not cater for the instance where the
incorrect amount was coded to the Projects Module from a Payables Invoice.
No amount of internal transfers can transfer this expenditure out, or
otherwise advise adjust the distributions (both Project and JL) made on the
original Payables Invoice. You suggest: Adjust the original invoice? I'm not
sure we can do this once the invoice is paid. We have 'funds checking'
enabled through to Purchase Requisition but have not 'switched it on' at
present.
So I believe that Oracle Projects needs a journal facility. I don't know why
the General Ledger Module does not provide us with such a window. After all,
other adjustment journals (to source documents) are done via GL journals. So
why not the ability to manipulate expenditures (both among, as well as, to
and from) for Projects?!!
Our present workaround is to use a 'special vendor' and use a Payables
invoice as our 'journal'. Like any journal, the it must total zero dollars.
Such a method gives us the ability to adjust expenditures between projects
as well as into and out of the Projects Module, ie., we can mix both Project
and GL codes on the one invoice. There are problems with this method I am
happy to discuss, if anyone is interested.
I was just after some feedback from any other Oracle Projects Users on how
they tackled this issue, or whether our own understanding of the Module is
at fault.
JonS
Jon STANKEVICIUS
Date: Thu, 2 Sep 1999 13:46:06 +0930
From: "Hayes , Kathleen" Kathleen.Hayes@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Project Accounting Journals - HDWA
I believe the journal facility is available in a future version.
However, if you currently enter incorrect amounts for an invoice
then it has to be corrected within AP. Transfers within Projects is only
for amounts going from one project to another or for tasks.
Your workaround is a good idea - thanks for the suggestion.
Regards,
Kathleen Hayes
Oracle Applications
BORAL LTD Shared Operations Centre (SOC)
Level 7, 2-10 Wentworth Street
PARRAMATTA NSW 2150
Telephone 02 98486052
Fax 02 98486099
Mobile 0408223059
Email Kathleen.Hayes@boral.com.au
Date: Thu, 2 Sep 1999 08:06:35 -0400
From: Zoe Reyes zreyes@goaa.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Project Accounting Journals - HDWA
I like the idea of being able to adjust the payment voucher better to ensure
that any future reclassifications of expenditures that have been processed
through Oracles Payables are documented in the Payables module.
However, those of us who work in an Oracle fund accounting setting have
found out that Oracle does not allow one to make any reclassifications
against a payment voucher that has been paid, even if the adjustment nets
out to zero, which would be the only type of adjustment one should do to a
paid voucher anyway. The only way we have been able to make
reclassifications against a paid voucher is through a cumbersome,
error-prompt Payables debit/credit memo process. (By the way, has anyone
found a better way of doing these kinds of adjustments?)
However, your point is well taken. There has to be a better way to
reclassify/correct Projects costs.
Date: Thu, 2 Sep 1999 13:27:22 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Project Accounting Journals - HDWA
We have also faced the same issue with needing to correct invoices in
Payables. Because we have balancing offset turned on we cannot make changes
to posted invoices, which is the solution Oracle suggests. Our workaround
is as follows:
Temporarily turn off the balancing offset option and turn on "make changes
to paid invoices" in the Payables options. While this is turned off no one
should approve any invoices because it will cause incorrect fund accounting
entries out of AP. You can then go into the invoice lines, reverse the
incorrect line and enter the correct coding on a new line. This generates
an in and out entry in the payables transfer to GL - just make sure both the
reversed line and the new line have the same GL date. Now (and this is key)
turn the "make changes to paid invoices" off and turn the balancing offset
back on. It is absolutely critical that this is changed back BEFORE the
invoice(s) are approved as it is the approval function that populates the
ap_code_combination_id for the line with the correct balancing segment.
The first time we did this after discussing with support they instructed us
to make sure it was turned back on before we ran the next Payables Transfer
to GL. WRONG. This created a problem for us where our AP Trial Balance by
Fund segment did not balance to each fund in the GL, although it was correct
in total.
The downside of this approach is that it really requires corrections to be
done at a time when no other user could be approving invoices. As all our
invoice approval in done in one location, we have good control over that.
The up side is that is does maintain an audit trail on the original invoice.
I do like your Special Payable "journal" idea; I think we could use it for
some non-Payables adjustments that we'd like to do. We've been trying to
use the expenditure entry to do this, but as you noted, it's not ideal
because of the expenditure types not being the same. What problems have you
encountered in using this as a "project journal"?
I understand there is a project journal in Rel. 11 but I don't know that the
issue of having different expenditure types for each source has changed.
Kathy Farmer
Scott County
Date: Fri, 03 Sep 1999 00:43:50 +0300
From: "Dina Rotem (h)" dinar@rafael.co.il
To: Ora OraApps-L@cpa.qc.ca
Subject: RE: Project Accounting Journals
Kathy
In release 11 we do have the ability to enter journals to Projects using
the "miscellaneous" transactions.
In addition, release 11 enables you to have more than one expenditure
type class per expenditure type. Meaning, cost could be entered to the
same expenditure type through different sources.
Dina
Date: Fri, 3 Sep 1999 10:57:06 -0400
From: frair_patti@adtranzna.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Project Accounting Journals - HDWA
We have written a Developer 2000 program "Project Journal Entry" to
accomodate adjustments that are not feasible from other sources and as a
data
entry process for Project and Ledger entries such as Project reserves,
IAS loss, cost of sales etc. transactions. Basically this process
writes/maintains transaction in the PA open interface table
pa_transaction_interface_all. The
other purpose of the Project Journal Entry program is to permit the users
to correct entries in the interface table without getting IT involved. We
have set up various transaction sources and corresponding autoaccounting
rules to enable this process. We found the Expenditure Batch entry program
to limited in not having the ability to specify a transaction source and
since we are in production under 10.7 SC our expectation is in release 11
we can throw away our custom form. If you are interested in this program
just e-mail me directly.
Thanks,
Patti Frair
frair_patti@adtranzna.com
DaimlerChrysler Rail Systems
Adtranz