ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings to Mailing Lists
ON
PROJECT ACCOUNTING

Attribute Category in PA_TRANSACTION_INTERFACE

From: Danette Fedock [SMTP:danette_fedock@ccmail.c-tec.com]
Sent: Wednesday, July 28, 1999 6:28 AM
Subject: PA: PA_TRANSACTION_INTERFACE

Please help. What is the ATTRIBUTE_CATEGORY asked for in the interface. I don't know where to go to set one up or if I even need one.

Date: Wed, 28 Jul 1999 08:14:15 -0500
From: "Matson, Mark J." MatsonMJ@bvsg.com
Subject: RE: PA_TRANSACTION_INTERFACE

Danette,

All the ATTRIBUTE fields in the pa_transaction_interface_all table get moved directly to the ATTRIBUTE fields in the pa_expenditure_items_all table. Therefore, if your ATTRIBUTE_CATEGORY is null in the items table, you can leave it null in the interface table. I hope this helps...

Mahalo (Thanks).
Mark J. Matson
BV Solutions Group
A Black & Veatch Company

Date: Wed, 28 Jul 1999 12:04:24 -0500
From: Badri Herur bherur@ix.netcom.com
To: danette_fedock@ccmail.c-tec.com, Apps List oraapps-l@cpa.qc.ca
Subject: RE: PA: PA_TRANSACTION_INTERFACE

Hi Danette,

Do you have any context sensitive descriptive flex fields defined at the expenditure group or the item level. If you do, then the values used for the various DFF structures are the attribute category values.

For example, if you capture additional information (airline ticket #, and flight info) for expense reports then the DFF would be setup as context sensitive and the value would be 'PE'(Please confirm) for Pre approved Batch Entry of expense reports. This is the value that needs to loaded into the interface table with the additional information going into the respective attribute columns.

If you need additional information, please e-mail me.
HTH Badri

Billing Extension Code

Date: Sat, 24 Jul 1999 09:18:11 PDT
From: "flora candida" flora.candida@excite.com
Subject: PA: Help billing extension

Would anybody be kind enough to post an example of billing extension code.

Thanks for your help
Flora candida

Date: Mon, 26 Jul 1999 08:11:00 +0100
From: "Mahendra, Anil" Anil.Mahendra@ncp.co.uk
Subject: RE: Help billing extension

I have mailed you a copy of a (PA) Labor Billing Extension to your private mail.

I don't think attachments get expedited via the list server.

'For the code please click here'

Regards AJM

Runing PACOANOR job

Date: Tue, 3 Aug 1999 12:01:31 -0600
From: "Campbell, Donna S" dscampb@sandia.gov
Subject: PROJECT ACCOUNTING ""Add New Organization Compiled Burden

PA Job name = PACOANOR
"Add New Organization Compiled Burden Multipliers"

1 input parameter - organization
Questions: For those companies that use this job, is there a performance and/or space problem with running this job? What input parameters are other companies using? How often do they run this job? What can we do to improve performance? We are finding (in development) that this job runs 12-19 hours when the table PA_IND_COMPILED_SETS gets to be 1.5 million rows. Has anyone run this job for a year or more on a weekly basis?

Appreciate any help.
Thanks,
Donna Campbell, Sandia National Laboratories
dscampb@Sandia.gov, Albuquerque, New Mexico

Date: Tue, 03 Aug 1999 11:58:17 -0700
From: "Donna M. Armstrong" donnabsc@gte.net
To: dscampb@sandia.gov, OraApps-L@cpa.qc.ca
Subject: Re: PA Add New Organization Compiled Burden Rates

Hi Donna,

I've been involved in quite a few Projects implementations and can tell you that you only need to run this job when you get an error in a Distribute Cost process that tells you that no Indirect Compiled Multipler was found. Then, you should specify the organization that the error was for. For a labor transaction this would be the person's home org on the expenditure item date. For other transactions it is the expenditure org or the override org (if you're overriding them).

The packages that create these records does not discriminate as to whether or not it will create a new line that is simply a duplicate of a line that was previously created, so the table will grow VERY LARGE and degrade your performance if you run this process indiscriminately. The same is true if you Compile the schedules via any other mechanism (process or form) when you don't really need to.

Feel free to contact me directly if you have any further questions about this.

Best regards,
Donna
==========================================================
Donna M. Armstrong Office: (310) 457-4200
Business Systems Consultant Voice Mail/Pager: (888) 886-1564
E-Mail: donnabsc@gte.net

Date: Tue, 3 Aug 1999 14:05:16 -0600
From: "Campbell, Donna S" dscampb@sandia.gov
Subject: RE: PA Add New Organization Compiled Burden Rates

From what we can tell your info is correct and our table is growing very large. Really appreciate the help.

Thanks again, Donna Campbell

Add a custom Project Status

Date: Wed, 04 Aug 1999 08:29:14 -0500
From: "Danette Fedock"danette_fedock@ccmail.c-tec.com
Subject: PA: Project Status

PA comes with two project status, open and closed. Closed does not allow any charges to hit it. We created a new status 'Cancelled' which we do not want any charges to hit. Does anyone know how to do this?

Date: Wed, 4 Aug 1999 08:06:25 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'Danette Fedock'" danette_fedock@ccmail.c-tec.com
Subject: RE: Project Status

Danette,

One idea would be to write a transaction control extension to look for that project status.

I'm not sure what version you are on, but I would recommend looking in the Projects User Guide for the Case Study: New Charges Not Allowed (Release 10SC page 11-367) and in the file PAXTTCXB.pls in the Projects admin/sql directory. It appears to be very applicable to your question.

Hope this helps.
Sarah Aronovici
aronovis@augsburgfortress.org

Date: Wed, 04 Aug 1999 14:16:20 -0500
From: Badri Herur bherur@ix.netcom.com
To: danette_fedock@ccmail.c-tec.com, Aronovis@augsburgfortress.org,
Subject: RE: RE: Project Status

Hi

Once you create the project status of "Canceled", the easiest approach to disallow charges is to end date the project. If the project has an end date, then the project does not pop up on any LOV during entry.

This is based on the assumption that you are on 10.7. This has been addressed in rel 11, where you can enable a list of functions (incur charges, generate revenue, generate invoice for example) that can be performed in a particular state.

HTH Badri

Date: Thu, 5 Aug 1999 15:29:21 +0930
From: "Hayes , Kathleen" Kathleen.Hayes@boral.com.au
Subject: RE: Project Status

Hi Danette,
the information I have states that Oracle user-defined statuses are classified as active and are therefore chargeable.

Regards,

About Activity Management Gateway

Date: Thu, 05 Aug 1999 07:38:03 PDT
From: "Ronald Young" ronaldyoung@hotmail.com
Subject: PR: Activity Management Gateway

I think that PR is the proper subject line heading for Oracle Projects.

It looks like I will be using the AMG to import project demographics from my client's old Oracle database into Oracle Projects. The Oracle Projects User's Guide talks briefly about AMG, but refers you to the Oracle Projects Activity Management Gateway Technical Reference Manual. I can't find this on Metalink! Does anybody know where I can find this or other information about AMG??

Thank you!

Date: Thu, 5 Aug 1999 09:42:18 -0500 From: "Matson, Mark J." MatsonMJ@bvsg.com To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca Subject: RE: Activity Management Gateway Message-ID: AD80DF48C8F0D11191B100A0C9CA40F80631BEF7@bvmail01.kc.bv.com Ronald, I presented a paper at two OAUG conferences discussing this topic. A copy of the paper and code can be found at

http://www.bvsg.com/papers/oracle.html.

I hope this helps. Please let me know if you have any questions.

Mahalo (Thanks).
Mark J. Matson
BV Solutions Group
A Black & Veatch Company

Date: Sat, 7 Aug 1999 21:19:43 +1000
From: "Mark Schwerdt" mschwerd@front-line.com.au
Subject: Re: Activity Management Gateway

This document does exist (although I don't have the part number available at the moment)

It is not in the same format as the traditional Tech Ref - it lists all of the PL/SQL functions/packages that make up the AMG, but the detail is pretty flimsy.

You should probably try to get it anyway, but expect it to be more of a roadmap rather than a tourguide.

thanks
Mark Schwerdt
Frontline Consulting
Melbourne, Australia

Customize Expenditure Inquiry program

Date: Mon, 9 Aug 1999 10:56:46 -0400
From: frair_patti@adtranzna.com
Subject: Project Costing - Expenditure Inquiry

Hi
We are running 10.7 SC 16.1 release E in production K in test. Has anyone customized the Expenditure Inquiry program to accept the prompt for PA Posting date? Apparently this is an enhancement coming, but not in the near future and we have the need to back date expenditure item dates for Labor entries. As such, the only way a user can find out what actually posted in a given month at the transaction level is to add this prompt. This functionality exists in PSI but only at the task level. Anyone like to share their changes?

Thanks,
Patti Frair
DaimlerChrysler Rail Systems
Adtranz

Date: Mon, 9 Aug 1999 13:45:07 -0500
From: "Matson, Mark J." MatsonMJ@bvsg.com
Subject: RE: Project Costing - Expenditure Inquiry

Patti,

It can be done (we have done it) but I wouldn't recommend it because it can cause problems. If you really want to know how and the problems that can occur, you can write to me directly.

Mahalo (Thanks).
Mark J. Matson
BV Solutions Group
A Black & Veatch Company

Changing Autoaccounting Rule while in Production - Query 1

Date: Wed, 11 Aug 1999 15:15:48 -0400
From: "Klosterman, Lisa H." KlosLH@jea.com
Subject: Projects AutoAccounting Rules

We have been in production with Oracle Projects since January, 1999. The users would like to change some of the Projects AutoAccounting rules. But it seems to me that if you change the rules once you are in production, that expenditure transfers would not work properly. Won't the reversing entry on the project that the expenditure is being tranferred from end up hitting the wrong account? Instead of deriving the same account as the original expenditure, the AutoAccounting Rules will derive the account dictated by the new rules. Am I missing something here? If anyone has a clue as to what I am talking about, please help!!!

-- Liza Klosterman
PORT Consulting, Inc.

Date: Wed, 11 Aug 1999 14:47:29 PDT
From: "Michael Cheng" myc70@hotmail.com
Subject: Re: Projects AutoAccounting Rules

Liza,

Auto-Accounting rules can be changed at any time. Consider the following scenarios:

STAGE:
1) Labor Cost Transaction made using the "OLD RULES" on 01-JAN-1999
DRCR

40008000

2) I than change the auto-accounting rules on 01-APR-99 for Labor to

DRCR

50008000

SCENARIO 1:
On 01-MAY-99 I want to "reverse" a transaction created on 02-JAN-99, using the "OLD RULES"

The following happens:

Reversal entry    DRCR

80004000

SCENARIO 2:
On 01-MAY-99 I want to "transfer" a transaction created on 02-JAN-99 to another project

The following happens:

"TRANSFERRED FROM"   Reversal Entry   DRCR

80004000

"TRANSFERRED TO"New EntryDRCR

50008000

I hope that the above example properly answers your question. Let me know if it helped.

Best Regards... Michael Cheng

Date: Thu, 12 Aug 1999 09:16:07 -0400
From: "Klosterman, Lisa H." KlosLH@jea.com
Subject: Re: Projects AutoAccounting Rules

Michael,
I suppose I should have given an example because it is not the amount I am concerned about: it is the GL account that gets hit. Here is the actual results that I obtained when I changed the autoaccounting rules so that the second segment in the GL account is derived from a different source.

Original transaction created this cost distribution line:

AmountDebitCredit
--------      ---------------------------------                ---------------------------------
235.63021.00381.00000000.00.562101.1005 001.00381.00000000.00.000000.1005

I changed the autoaccounting rules, did the transfer, and the reversing transaction created the following cost distribution line:

AmountDebitCredit
--------      ---------------------------------                ---------------------------------
235.63021.07211.00000000.00.562101.1005 001.00381.00000000.00.000000.1005

Clearly, the wrong GL account is getting hit once the autoaccounting rules are changed.

I hope this is more clear as to problem.
-- Liza Klosterman
PORT Consulting, Inc.

Date: Thu, 12 Aug 1999 09:49:50 -0600
From: "Newitt, Mike/COR" mnewitt@CH2M.com
Subject: Re: Projects AutoAccounting Rules

Liza,
AutoAccounting is self-correcting. It is reversing the entry using the segment in the original transaction (00381). Had the original entry been made after your rule change you would see the 07211 segment being used in the reversal.

Date: Thu, 12 Aug 1999 10:11:26 PDT
From: "Michael Cheng" myc70@hotmail.com
Subject: Re: Projects AutoAccounting Rules

liza,

NOTE: I understood that you were referring to the acounting segments, and not the amounts. The scenarios that I presented was simply listing "one" hypothetical accounting segment. Your original description of the problem was clear.

I had forgotten to include, in my response to you, the steps that you needed to perform.

FOR PROJECT/TASK TRANSFERS

1) You must first adjust by "RECALCULATE" either the Burdened Cost, revenue, or Cost/Revenue. This will properly reverse the "accounting" entries using the "OLD" auto-accounting rules and create an new entry using the "NEW" auto-accounting rules.

2) Now perform your transfer. The new entry created by the step above will be properly transferred.

FOR REVERSALS

1) No recalculation is needed, just perform your reversal. Regardless of how many times you've changed your auto-accounting rules the reversal will only be done using the "ORIGINAL" rules that created the transactions.

Sorry for the lack of detail in my original response to you. Hope this added detail helps......

Best Regards..... Michael Cheng

Date: Thu, 12 Aug 1999 21:28:01 -0700
From: "Donna M. Armstrong" donnabsc@gte.net
To: KlosLH@jea.com, OraApps-l@cpa.qc.ca
Subject: Re: Projects AutoAccounting Rules

Hi Lisa,

I just saw a bunch of postings about your AutoAccounting headaches. The way AutoAccounting has always functioned in the past, when a transaction is recosted (for any reason - e.g. AutoAccounting, Burden Rate Change) the original cdl (pa_cost_distribution_lines_all record) will be copied exactly, except that the amount fields will be multiplied by -1. So, if you had a line with:

Line_num amount   dr_ccid   cr_ccid   burdened_amount
   1           100.00      4000      8000      250.00

In the case of an AutoAccounting change, if the item were marked for recosting, two new cdl's would be created, as follows:

   2           -100.00      4000      8000      -250.00
   3           100.00       5000      8000      250.00

If you are seeing something different in this case, you may have found a bug.

In the case of a transfer, there would be two new expenditure items created, which, as you suggested, would both follow the "new" AutoAccounting rules. If you think that the new AutoAccounting rules should be enforced for the entire fiscal year you are working in, you should mark all items originally costed within the fiscal year for recost when the AutoAccounting is changed. This way the original charge on the original project would be moved from (per my example) ccid 4000 to ccid 5000 before the transfer credits ccid 5000 on one project and debits the same ccid (or another, depending on the type of project and your AutoAccounting setup) on the receiving project.

I have also submitted an enhancement request to make AutoAccounting date effective. This would enable an expenditure item within a certain date range to be accounted for based on one set of rules/lookupsets/etc., versus an expenditure item within a different date range being accounted for using different rules, etc. The PA SIG Enhancement Committee, lead by Ann Rice of RAND, has the documentation for this enhancement.

I hope this helps. Please feel free to e-mail me directly if you have any questions about what I have written.

Best regards,
Donna
Donna M. Armstrong Office: (310) 457-4200
Business Systems Consultant Voice Mail/Pager: (888) 886-1564
E-Mail: donnabsc@gte.net

Autoaccounting Rule change - Query 2 AND PA_AA_TOO_MANY_TOKNS error

Date: Mon, 16 Aug 1999 22:55:44 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
Subject: PA:AA rules ....URGENT

Hi All,

We are live on 10.7SC . we have implemented AA Rules with Sql statements in PA. My client wants to change some of the AA rules.

Question 1 :

Is there any impact of changing these rules after 8 months we went live on existing transactions in PA.

Question 2 :

I am getting following error which I have not encountered before:

PA_AA_TOO_MANY_TOKNS

The sql statement which I want to change is like this

select decode(expenditure_type_class, 'Supplier Invoices' , '22141',
'Usages', '22142' , decode(:2, :3, '22142' , '11110'))
from pa_expenditure_types_desc_v
where expenditure_type = :1 ;

where :1 - Expenditure Type parameter
:2 - Project Organization
:3 - Expenditure Organization

Above Sql statements works very fine from Sql Plus but it doesn't work in AA rules.

Any help would be highly appreciated.
Thanks in advance.

Date: Tue, 17 Aug 1999 12:21:36 +0930
From: "Hayes , Kathleen" Kathleen.Hayes@boral.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AA rules ....URGENT

What sort of changes to AA do u want to make??

Date: Tue, 17 Aug 1999 15:34:05 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AA rules ....URGENT

I want to implement the Sql I have stated in my mail.

Date: Tue, 17 Aug 1999 10:58:54 -0700
From: "Donna M. Armstrong" donnabsc@gte.net
To: OraApps-l@cpa.qc.ca, vijaay@hotmail.com
Subject: Re: PA:AA rules ....URGENT

Hi,

As to your first question, the only thing you'll have to consider is whether or not the transactions that were processed before the change need to be "corrected" to reflect the new rule. There were some questions on the listserver in the past two weeks about this very issue.

When a transaction is marked for recosting (Recalculate Cost or Recalculate Cost/Revenue) the transaction will get two new cost distribution lines (cdls). The first will be a copy of the last one (same dr and cr code_combination_ids) with the amounts * -1. The second will use the new autoaccounting rules to derive the accounts. However, when a transaction is transferred, two new expenditure items are created and the new autoaccounting applies to both the new transactions. So, if the original transaction debited account 3100 and the new autoaccounting would debit account 3500 (on both the old and new projects) the debit amount would still be sitting in account 3100 because the two new transactions would net to zero with account 3500.

On your second question, I would change the code you've written as follows:

select decode(expenditure_type_class, 'Supplier Invoices' , '22141',
'Usages', '22142' , decode(:Proj_Org, :Exp_Org, '22142' ,
'11110'))
from pa_expenditure_types_desc_v
where expenditure_type = :Exp_Type ;

where :1 - Project Organization
:2 - Expenditure Organization
:3 - Expenditure Type parameter

Yours would have probably worked as is if you had the parameters in the proper order. It really doesn't matter what you call them, but it parses the parameters in top down order.

Hope this helps,
Donna
Donna M. Armstrong Office: (310) 457-4200
Business Systems Consultant Voice Mail/Pager: (888) 886-1564
E-Mail: donnabsc@gte.net

Date: Wed, 18 Aug 1999 16:41:42 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: PA:AA rules ....URGENT

Hi Donna,

I tried the way you suggested. Still I am getting following error message :

AA=paxsql
pacclb = : Number of parameter sets: 6

pabccrdr : paccdl() returned false
unable to create cost distribution lines
pabccei: pabccrdr() returned error creating debit lines
pabccei() returned error while processing expenditure items
Unable to create cost distribution lines

Can you guess what is the problem? I am just adding second decode function in existing code and I am getting all these errors.

Thanks in advance.

Date: Wed, 18 Aug 1999 13:01:43 -0700
From: Donna Armstrong donnabsc@gte.net
To: OraApps-l@cpa.qc.ca, vijaay@hotmail.com
Subject: Re: PA:AA rules ....URGENT

Well, hmmmmm. . .have you checked that the parameters you are trying to use are valid for the function you are using them in? There is a form that shows the valid parameters by function, as well as a report. I assume the function is one of the Distribute Cost processes, but not sure if it's Labor, Usage, etc.

Another thing would be to check out the view to see if there is only one row per expenditure_type. If more than one row is returned for an expenditure_type that would also force a sql error.

Hope this helps,
Donna
=======================================================
Donna M. Armstrong
Office: (310) 457-4200
Business Systems Consultant Voice Mail/Pager: (888) 886-1564
E-Mail: donnabsc@gte.net

Date: Fri, 20 Aug 1999 10:28:40 PDT
From: "rama gopal" ramagopalan_s@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: PA:AA rules ....URGENT

Hi,

On your second question,

We had this problem, one of the reason for 'TOO_MANY_TOKENS' error is, if you do not use all parameters declared in AA form in your SQL statement.

If the problem persists you may do this.

. Replace parameter numbers with parameter names in SQL statement.
. Create a database package put sql statement in a function, Call the function from Auto Accounting form. You will have more flexibility (write PL/SQL block, handling exceptions, handle complex code ..) by creating a packaged function.

I hope this helps,
Rama