Oracle Projects的DataLoad Templates

bob

Oracle Projects的Dataload模板，简单介绍如下，相应的模板在附件，希望对大家有用!
Create Project Roles
Create Project Roles used in project Key Member assignments.
Navigation: Project Billing Super User: Projects > Setup > Projects > Roles
Start Field: Name

Create Project Tasks
Use this DataLoad for creating a small volume of project tasks. I use it all the time when creating Project Templates. Use CREATE_TASK or UPDATE_TASK APIs with a custom script to create larger volumes of tasks.
Navigation: Project Billing Super User: Setup > Project Templates > Tasks
Start Field: Task Number

Create Agreements
Navigation: Project Billing Super User: Billing > Agreements
Start Field: Customer Name

Baseline Projects in Funding Inquiry
Note that you can baseline funding in the Funding Inquiry screen only if the Baseline Funding Without Budget option is enabled for your projects.
Navigation: Project Billing Super User: Billing > Funding Inquiry.
Start Field: Project

Create Labor Costing Overrides Define labor rate overrides by employee. These rates are used by the labor distribution process to calculate labor costs.
Navigation: Project Billing Super User: Setup > Costing > Labor > Labor Costing Overrides.
Start Field: Employee Name

Create Transfer Price Schedules
Define the transfer price schedule lines for your cross-charge rules. Manually define schedule name and description, and start the DataLoad at Line Number field.
Navigation: Project Billing Super User: Setup > Costing > Cross-Charge > Transfer Price Schedules
Start Field: Line Number

Create Non-Labor Rate Schedule
Define non-labor bill rates and markups used by the revenue and invoice generation processes in Oracle Project Billing. Manually define the schedule header, click on Non-Labor tab, and start at Expenditure Type field.
Navigation: Project Billing Super User: Setup > Expenditures > Rate Schedules
Start Field: Expenditure Type

Create Project Employee Bill Rate Overrides
Define project specific employee billing rate overrides used by the revenue and invoice generation processes in Oracle Project Billing.
Navigation: Project Billing Super User: Projects > Options > Bill Rates and Discount Overrides > Employee Bill Rate and Discount Overrides
Start Field: Employee Name

Create Project Lookup Set
Define project lookup sets used in AutoAccounting rules or Account Generator. Manually define lookup set Name, and start at the Intermediate Value field.
Navigation: Project Billing Super User: Projects > Setup > AutoAccounting > Lookup Sets
Start Field: Intermediate Value

Update Project Lookup Set
Similar to the DataLoad above, but this one updates the existing lookup sets values.
Navigation: Project Billing Super User: Projects > Setup > AutoAccounting > Lookup Sets
Start Field: Intermediate Value

Create Contingent Worker Expenses as Pre-Approved Batch
The preferred option for upload project transactions is the Transaction Import WebADI Integrator. However, as of the release 10.5.10, it does not distinguish between Person Types, and does not successfully upload Contingent Worker transactions.
Navigation: Project Billing Super User: Expenses > Pre-Approved Batches > Enter
Start Field: Employee Name

Create Percent Complete Amounts
Navigation: Project Billing Super User: Project Status Inquiry > Percent Complete
Start Field: Project Number

[ 本帖最后由 bob 于 2007-8-3 10:07 编辑 ]

gaoyiming

先行者
没办法 不顶不行

安绮琳

你太可爱了，马上down下，正好可以用上呢。

icemannbb

好东西啊，找了好久了！

dsp_chenfx

:/hanx

taihung

謝謝你的文檔

fatdragon

多谢，我本来打算总结一下所有的Dataload Template，结果你倒先上了。

不知从哪里搞来这么好的东西

shinebaby

還不賴~頂頂頂

chenshm329

learning, learning! Thanks...

xdp4507

剛剛會用，這個很及時啊。頂~

xdp4507

要是有更多的實例的話更佳。謝謝

wufen

但愿是我要地 ！

huangxiaopeng8

先下来看一下

sincerebb

感谢楼主的分享！

xiaohu_gz

很好的东西，可惜没有分下载啊