Autoinvoice PA to AR
Date: Mon, 14 Jun 1999 10:24:14 -0700
From: Patrick Krause patrick_krause@itconvergence.com
Subject: AutoInvoice from PA to AR
Any help with the following would be appreciated...
AutoInvoice from PA to AR
I have enabled the following segments in Line Transaction Flexfields:
1.Project Number - Interface_Line_Attribute1
2.Draft Invoice Number - Interface_Line_Attribute2
3.Agreement Number - Interface_Line_Attribute3
4.Project Organization - Interface_Line_Attribute4
5.Project Manager - Interface_Line_Attribute5
6.Line Number - Interface_Line_Attribute6
7.Type -Interface_Line_Attribute7
8.Line Type - Interface_Line_Attribute8
And segments 1-5 above in the Invoice Transactions Flexfields.
Step 1. Ran AutoImport In AR
AutoImport process selected and rejected all my invoices. Reason: All
enabled segments of transactions flexfields must have a value.
Step 2. I tried to unfreeze my flexfields and disabled what I thought
had no
value. And tried to run the AutoImport again. (After doing the Tieback
process in PA). The system did not select any invoices at all.
Step 3. I tried to undo step 2. But I guess, I've just committed a big
no-no
in step2. Aside from not choosing any invoice to process. I am also
getting
an additional error of: error getting profile
AR-enable_credit_card_preproc
and all my And_Link_To_Line_Attributes1-15 are null.
So now I am in a bigger mess and I need help to get the AutoInvoice to
work.
Any help would be appreciated.
Rosalie & Patrick
ITConvergence
San Francisco, CA
Toll Free USA/Canada: 1-800-675-0032
International: 1-415-675-7935
Fax: 1-415-675-7940
http://www.oraclenow.com
Date: Mon, 14 Jun 1999 22:12:16 -0500
From: "Hendrix, Deborah A." HendrixDA@bvsg.com
Subject: RE: AutoInvoice from PA to AR
You didn't say what version of the apps you are on, but on 11.0.2 a new
field was added to the PROJECTS INVOICES set of segments in the Line
Transaction Flexfield which the PATTAR program doesn't populate. The only
way to get by this is to disable the field that is not getting populated.
This should only be a problem if you are either a brand new install or have
set up a new operating unit that uses the PROJECTS INVOICES set of segments
rather than the PA INVOICES set of segments. Specifically, you need to:
1) From the Descriptive Flexfield Segments form you need to unfreeze the
Receivables Line Transaction Flexfield.
2) With your cursor on the PROJECTS INVOICES record open up the Segments
window.
3) Set the Line Type field which is INTERFACE_LINE_ATTRIBUTE8 to be
disabled.
4) Save the record.
5) Close the window.
6) Check the Freeze box.
7) Save the record which will spawn a job to create the compiled definition
and the views.
After we did this, AutoInvoice was just fine. I had already done this
workaround before I logged a TAR on this, but the official word from Oracle
is to do the workaround -- there isn't a patch of any kind as of last week.
I have no idea why you are seeing the odd error about the credit card stuff;
looks like maybe a profile option has been enabled that shouldn't be?
Regarding your invoices that didn't get accepted into AR, the PA Tieback
should delete the records from the ra_interface tables and set the status in
PA so that they can be transferred again.
Debbie Hendrix
BV Solutions Group, A Black & Veatch Company
hendrixda@bvsg.com
Date: Tue, 15 Jun 1999 07:23:32 -0500
From: "nkumar" nkumar@se-tech.com
Subject: Re: AutoInvoice from PA to AR
The AR : Enable credit Card transactions is a profile option which needs to
be set to Yes or No
HTH
Nand
Project Owning Org Field
Date: Tue, 30 Mar 1999 17:11:38 -0500
From: Oracle_Users_MEDSTAT OracleUsersMEDSTAT@medstat.com
Subject: PA Project Owning Org Field--what to do when the project owning o
Once expenditures hit a project or invoices are processed, the project
owning organization field cannot be changed. This makes sense from an audit
trail perspective, but in reality companies reorganize all the time and want
project revenues and costs to show up in the new departments. Short of
closing the old project and transferring revenue and costs to a new project,
has anyone come up with another method for accommodating organizational
changes?
We developed a descriptive flex field, but that has created problems of its
own.
Date: Wed, 31 Mar 1999 00:08:50 -0500
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: PA Project Owning Org Field--what to do when the project owni
For Oracle Projects Release 10.7 and prior, there is no functional way to
accomodate a re-organization without closing old projects and creating new
projects. In Release 11, Oracle has finaly addressed this [based on many
requests]. In Release 11, you can:
Use the new 'Mass Update Batches' window to change the organization of
multiple projects and tasks. The Mass Update window performs both of the
following functions:
- Creates a batch for mass update of organization for projects and/or tasks.
- Initiates a process that updates the organization on all the projects and
tasks specified in the batch. You can optionally mark expenditure items
charged to the project or task for recalculation based on the new
organization. You can also run the update as a concurrent program by
submitting a request to run the PRC: Process Mass Update
Batches program.
Hope this helps.
Bart Robey
KPMG - Oracle Consulting Practice
Date: Wed, 31 Mar 1999 09:28:53 +0200
From: "Dina Rotem (h)" dinar@rafael.co.il
Subject: PA: Mass Update Owning Org.
Hi Bart
We are on release 11. Our test of that process didn't create any change
in expenditure items. Could you, kindly, further explain what is the
exact process to affect the expenditure items, which were already
charged to the project.
Dina
Date: Thu, 01 Apr 1999 08:35:12 -0800
From: "Donna M. Armstrong" donnabsc@gte.net
Subject: RE: PA Project Owning Org Field - what to do when the project owning org changes
Hi,
I can share what two of my clients on 10.7 do when the org changes.
Client 1 - Updates the carrying_out_organization_id using sql
Client 2 - Uses a class category for Reporting Org, and changes
the Org class code. They also have a data warehouse
for all project reporting, so the change becomes
"effective" in the period the change was made. That is,
cost/revenue incurred prior to the change is still
reported as belonging to the old org, current period
cost/revenue belongs to the new org
Hope this info helps!
Regards,
Donna
======================================================================
Donna M. Armstrong Office: (310) 457-4200
Business Systems Consultant Voice Mail/Pager: (888) 886-1564
E-Mail: donnabsc@gte.net
======================================================================
Date: Thu, 1 Apr 1999 12:15:56 -0700
From: "Martha McKillip" mmckillip@projectp.com
Subject: RE: Mass Update Owning Org.
Dina:
You will see changes to the expenditure items for a couple of reasons.
1. If your project was burdened, then the organizational change might
affect the burdening, the expenditure item should be recalculated and a
change noticed.
2. If any of your accounting segments for autoaccounting are based on
project owning organization or task owning organization, then the
expenditure items would need to be recalculated.
When you state that it did not affect any of the expenditure items, did it
mark any for recalc?
Martha Anne McKillip
Project Partners, LLC.
http://www.projectp.com
mmckillip@projectp.com
Date: Fri, 2 Apr 1999 00:35:05 -0500
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: PA Project Owning Org Field - what to do when the project own
The Client 2 solution sounds very interesting, although it must only be for
projects where all the tasks for a given project equate to the same cost
center or organization, since the Class Category is a project-level option.
With the Client 1 solution, my only concerns would be [1] how would you
ensure the right organization is picked-up when doing re-calc's on old
expenditures and [2] the risk, you would lose any Oracle Support help if
problems occur because of the SQL*PLUS change. Although, I guess it might
be worth it as opposed to closing and opening a large number of projects.
Just my thoughts. Thanks.
Bart Robey
KPMG - Consulting
brobey@kpmg.com
Date: Fri, 02 Apr 1999 07:57:18 -0800
From: "Donna M. Armstrong" donnabsc@gte.net
To: brobey@kpmg.com, OraApps-L@cpa.qc.ca
Subject: Re: PA Project Owning Org Field - what to do when the project owning org changes
Hi Bart,
You are correct, Client 2 reports everything by the Project
Reporting Org. We even do P&Ls at that level.
Re: Client 1 SQL approach. . .When you recost expenditure items
the expenditure org is not changed. The expenditure org is only
determined upon entry or import, not during costing/re-costing. It is
the expenditure org that is used in burdening, so there is no change
from that perspective. There could be an autoaccounting affect, if the
project owning org was used, but in this case it is not.
Hope the info helps,
Donna
Date: Fri, 2 Apr 1999 11:31:00 -0700
From: "Martha McKillip" mmckillip@projectp.com
Subject: RE: Mass Update Owning Org.
A correction to my previous email.
The "organizational change" that might affect your project and the burdened
cost is if you change the organizational hierarchy for burdening (which is
allowed in Release 11).
The potential need for recosting expenditures when updating the owning
organization is for autoaccounting reasons, if you used project owning
organization or task owning organization to determine any of the segments.
My apologies for the previous miscommunication of information.
Martha Anne McKillip
Project Partners, LLC.
http://www.projectp.com
mmckillip@projectp.com
Date: Sat, 03 Apr 1999 06:04:48 -0800
From: "Donna M. Armstrong" donnabsc@gte.net
To: brobey@kpmg.com, OraApps-L@cpa.qc.ca
Subject: Re: PA Project Owning Org Field - what to do when the project org changes
Hi Bart and All,
I just realized that I did not explain enough about the potential
impact of using SQL to update the project owning org, and I certainly
would not recommend this approach to anyone without completely
understanding their implementation. I did not even recommend it to
the client that is doing so.
The client that uses this approach uses the EVENT/EVENT revenue
distribution rule almost exclusively. In some earlier testing I had
done a while back, there seemed to be a problem interfacing revenue
and invoices if the project owning org was changed with the WORK/WORK
revenue distribution rule.
My best recommendation is that anytime you think you might want
to use SQL to "fix" things you had better test the potential impacts IN
YOUR OWN development/test environments to fully understand any impacts
to burdening, autoaccounting, adjustment actions (splits, transfers),
revenue, invoicing, any extensions you might have developed for all
classes of projects (indirect, contract, capital). The bottom line is
that it probably should not be done (hence the warning in all the
manuals from Oracle about being in violation of your Maintenance
Agreement).
I apologize to anyone who may have been mislead by my earlier
posting. Hope this explains it better!
Best regards,
Donna
Integration of PA and OE Invoices to AR
Date: Mon, 14 Jun 1999 23:21:00 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: PA/OE: Integration of PA and OE Invoices for One Customer Invoic
I believe it is possible (maybe not standard functionality) to combine or
integrate invoices from Projects and Order Entry into one invoice in AR
through unique Transaction Types, Order Types, etc. Can anyone offer an
opinion, from a high level, as to a definitive Yes or No, with a very brief
explanation.
Thanks in advance -
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Date: 17 Jun 99 08:04:44 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: RE: PA/OE: Integration of PA and OE Invoices for One Customer Invoic
Hi Bart,
The answer is mostly No. If all the invoices were in the interface table
at
one time you might be able to get the system to conolidate the different
invoice lines onto one invoice, but I think you would lose the link back
to PA
or OE since the Invoice Source would have to be changed to a common sourc
e
(along with other fields I'm sure). That would make RMA's in OE and cred
its
and the Reconciliation process in PA impossible.
You could try the consolidated invoice functionality in AR. You might ha
ve to
customize it since the functionality is not very robust. I only investig
ated
it, I never used it, but unless it's changed recently, you can't consolid
ate
by order number or customer PO number; it's either on or off for all invo
ices
for that customer billing site.
Good Luck, Craig
Craig Yedinak
Independent Consultant
Project Time and Expense reports
Date: Fri, 18 Jun 1999 03:28:40 PDT
From: "flora candida" flora.candida@excite.com
Subject: Project Accounting: Time & Expense
Has anybody modified PTE to report monthly and/or bi-monthly timesheets and
expenses. What steps did you take?
Thanks
Flora Candida
Date: Fri, 18 Jun 1999 09:14:34 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: Project Accounting: Time & Expense
I think it would be much easier to just create custom reports directly from
the PA database than to create reports from PTE. PTE does have some
standard reports that might meet your needs below. There is also a query
tool that works with PTE but I just cannot think of it at the moment. It
should be in the PTE documentation though.
Hope this helps some.
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Link Between PA and ABT Suite
Date: Wed, 16 Jun 1999 10:10:46 -0400
From: "Paradis, Dany" DParadis@teleglobe.ca
Subject: Link Between PA and ABT Suite
Hello,
We actually start to implement project accounting 10.7 NCA and we want
to
use a project management tool. I would like to know if somebody is
using
project accounting and the ABT suite. How the link works between those
to
product? Are you using the timesheet of ABT or Personnal time and
expense
from Oracle.
Thanks for your help
Date: Wed, 16 Jun 1999 19:49:12 EDT
From: Jpkozicki@aol.com
Subject: Re: Link Between PA and ABT Suite
I am currently working on a project to interface ABT to Oracle Projects in
release 10.7 NCA. Projects are being created in ABT Team Workbench and we are
in process of creating an interface using the AMG (Activity Management
Gateway) for project-related information. We are also writing an interface
between ABT and Oracle Projects for time reporting which passes through the
open interface table. All information is extracted out of the ABT data
repository (which is also an Oracle database).
We are currently completing the design phase and will start to build next
week. Most of the information you will need for extraction comes from ABT
documentation on the repository table structure and schema diagrams.
You will need to build the interface as a two-way process. Employee
information and some transactional control information will need to be
exported from projects back into ABT. Unfortunately, we don't currently
believe that the existing AMG APIs will be able to be used for this process.
You will need to write your own.
I will be happy to answer any additional questions for you.
Julian Kozicki
Independent Consultant
Atlanta GA
Date: Thu, 17 Jun 1999 17:34:19 -0700
From: "Randy Egger" regger@projectp.com
Subject: RE: Link Between PA and ABT Suite
Dany-
We are working with ABT to build the integration between the ABT Repository
and Oracle Projects (ABT Integrator for Oracle). The ABT product should be
available in July. If interested, I can send you more details about the
planned functionality. Please let me know.
To answer your question, the integration allows for time to be entered in
ABT and then flow into Oracle
Projects.
____________________________________
Randy Egger
Project Partners, LLC
http://www.projectp.com
Bus: 650-726-5008
Fax: 650-726-7975
mailto:regger@projectp.com
Costed and Cost Burdened Flags not toggling
Date: Fri, 20 Aug 1999 14:54:45 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: PA functional Question ...
Hi All,
As per I have been told by Oracle Functional Consultant, Once we run costing
processes, Costed flag in Expenditure Enquiry Screen
(PA_EXPEND_ITEMS_ADJUST2_v) will be 'Yes' and after running Burdening
processes , Cost Burdened Flag will be 'Yes' .
At our site , Users have run all these processes and also I see Cost
distribution lines for all these expenditure items, still both Costed and
Cost Burdened flag is 'No' (not checked).
Can anybody explain me about this?
Thanks.
Date: Fri, 20 Aug 1999 08:14:37 -0700
From: "Randy Egger" regger@projectp.com
To: oraapps-l@cpa.qc.ca
Subject: RE: PA functional Question ...
Jaayanti -
If the expenditure items in question do not have the costed/burdened flag
set to yes after running the appropriate processes, then you might might to
look at the distribution reports which will detail why it could not process
those transactions.
Randy Egger
Project Partners, LLC
http://www.projectp.com
Bus: 650-726-5008
Fax: 650-726-7975
Date: Fri, 20 Aug 1999 17:12:25 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: PA functional Question ...
Hi Randy,
Distribution process shows no errors and that's why I can see cost
distribution lines.
Any clue ?
Thanks.
Date: Fri, 20 Aug 1999 13:53:23 -0600
From: "Newitt, Mike/COR" mnewitt@CH2M.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: "'vijaay@hotmail.com'" vijaay@hotmail.com
Subject: RE: PA functional Question ...
Two long shots...
1. The costed flag check box is determined by the value of
pa_expenditure_items.cost_distributed_flag... what is this column set to for
the item(s) in question? If it is set to 'Y' but the form is unchecked then
someone has messed with the form or the view.
2. Is it possible that someone marked the expenditure items to be recosted
without your knowledge? This can be done through the form by checking the
Recalc Cost box. This would set the cost_distributed_flag back to 'N' even
though cdls exist.
Date: Fri, 20 Aug 1999 17:39:15 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: PA functional Question ...
Hi Jyanthi,
PA_EXPEND_ITEMS_ADJUST2_V gets the two values
COST_DISTRIBUTED_FLAG
COST_BURDEN_DISTRIBUTED_FLAG from
PA_EXPENDITURE_ITEMS_ALL table. This table gets these two flags updated in
one of the concurrent programmes. The question is which concurrent
programme. The suspected groups of programmes are
PAPBER = PRC:Distribute Expense Report Costs
PALDLC = PRC:Distribute Labor Costs
PACODTBC = PRC:Distribute Total Burdened Costs
PASDUC = PRC:Distribute Usage Costs
etc. or
PAGGLT = PRC:Interface Labor Costs to GL
PACTFTBC = PRC:Interface Total Burdened Costs to GL
etc. or
PAGTIE = PRC:Tieback Labor Costs from General Ledger
PACTBTBC = Tieback total burdened cost from GL
If you have the TRM, (which I do not have at the moment)they will show
clearly which of these programmes updates the above table, i.e.
PA_EXPENDITURE_ITEMS_ALL
As you know, Project Costing follows three stages
Cost Distribution
Cost Interface to GL and
Teiback of costs from GL
You are trying to look for costed status after distribution only. Though I
am not sure, I feel only when cost is distributed,i.e. only distribution
lines are created - the status should not change to costed=yes or burdened =
yes. Looking into the TRM will give a short cut idea, though not cecessarily
Functional.
Prasanna
Date: Sat, 21 Aug 1999 20:50:41 -0400
From: "Robey, Bartley H" brobey@kpmg.com
To: oraapps-l@cpa.qc.ca
Subject: RE: PA functional Question ...
The two columns noted below are set during the 'distribution' processes and
not the interface processes.
Also, the possible explanations given by Mike Newitt are right on the money.
I would check those out. Lastly, just to be sure, have you checked the
flags for the respective expenditures through both the online form and a
SQL*Plus select statement query?
Thanks -
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com
Date: Sun, 22 Aug 1999 10:00:50 +0300
From: "jsasali" jsasali@projectp.com
To: oraapps-l@cpa.qc.ca
Subject: RE: PA functional Question ...
The flag in question "COST_BURDENED_FLAG" is from PA_TRANSACTION_SOURCES and
the flag specifies if the transaction source can contain burden
transactions. Also under PA_TRANSACTION_SOURCES there is a COSTED_FLAG which
indicates whether transactions classified by the transaction source are
already costed.
After running the processes PRC: Create and Distribute Burden Transactions
or PRC: Distribute Total Burdened Cost will you see the flag
"COST_BURDENED_DISTRIBUTED" set to yes after the burden accounting lines are
created. Viewed under PA_EXPENDITURE_ITEMS_ALL.
Hope this helps. I found the flags confusing when viewing them under the
Expenditure Inquiry screen.
Regards,
John
Project Partners, LLC
jsasali@projectp.com
Activity Management Gateway to load data
Date: Fri, 20 Aug 1999 18:46:14 -0400
From: "Bartoletti, Mike" BartolMi@rf.suny.edu
To: "'Multiple recipients of list'" oraapps-l@cpa.qc.ca
Subject: Projects - Migration
Do people suggest to use Activity Management Gateway to load data into
projects?
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rfsuny.org
Date: Fri, 20 Aug 1999 18:22:31 -0500
From: "Hendrix, Deborah A." HendrixDA@bvsg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Projects - Migration
It's the only thing we have used for loading projects and tasks. We have
had to ever so slightly customize it to get to do customers and agreements
the way we needed it for the one-time migration load.
Debbie Hendrix
BV Solutions Group, A Black & Veatch Company
913-458-8519
hendrixda@bvsg.com
Date: Mon, 23 Aug 1999 11:32:50 -0400
From: "muzaffer" muzaffer@suninternet.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Projects - Migration
Inspite of its all undocumented features, I guess you have not many choices,
unless you want to re-invent the wheel.
Regards,
Muzaffar
Email muzaffarl@iname.com
Web http://members.xoom.com/muzaffar/
Work 904.366.4720
Home 904.997.0396