Wednesday, July 23, 2014

Project new features


Oracle Project Foundation
New Concurrent Process
  • ADM: Purge Obsolete Projects Data

Oracle Project Costing
  • Federal Budgetary Accounting for Project Expenditures via Subledger Accounting
  • Contingency Worker Clearing Projects to allow CWK to charge multiple projects
  • Additional Project Information in Oracle Time and Labor (Project Name and Task Name)

Federal Budgetary Accounting for Project Revenue
  • Additional journal entries are available in Subledger Accounting for the required Federal Budgetary entries.
Date Effective Funds Consumption
  • Project Type option that requires cost and event transaction dates to fall within the agreement start and end dates.
  • Transactions are only billed against the agreement if the entire transaction amount can be funded (no partial recognition) for both revenue and invoicing.
  • Without enabling this option, revenue generation supports partial billing for transactions.
New Parameters for MGT: Invoice Review
  • Project Status
  • Project Closed After Date
  • Project Range
New Parameters for MGT: Unbilled Receivables Aging
  • Project Status
  • Project Closed After Date
  • Project Range
 Oracle Project Management New Audit Process for Project Performance Reporting Setup
  • AUD: Project Performance Reporting Setup
New Parameters for Refresh Project Performance Data Process
  • Actual or All Amounts (Plan and Actual)
  • Workplan Version
  • Financial Plan Version
 Workplan EnhancementsAbility to Delete Published Workplan Versions (except the latest published version, baseline version, and workplan versions included in a program hierarchy) Usability Enhancements
  • Update Work Breakdown Structure page is now obsolete.
  • View, maintain, and update a workplan structure from the Update Tasks page.
  • Where no latest published workplan version exists, the current working version displays on the Update Tasks page when navigating to the Workplan Tasks.
  • Indent or outdent multiple workplan tasks in a single step.
  • Confirmation, information, and warning messages appear on HTML pages during Apply Latest Progress as well as the Submit Progress processes. Messages include status information during processing and the availability of the latest progress information.

New Public API for Creating, Maintaining, and Deleting Programs
 New set of public API procedures:
  • Designate a project as a program and indicate whether projects linked to the program can belong to multiple programs.
  • Create links from a program to one or more projects
  • Update links from a program to one or more projects
  • Delete links from a program to one or more projects
Budgeting And Forecasting Enhancements Enhanced Automatic Calculation and Derivation Logic
  • For plan lines that do not have a specified a quantity, the amount is no longer copied to the quantity field with the rate value set to 1.
  • Rate now has a lower precedence than quantity and amount in automatic calculations.  The rate will be re-derived when the quantity, rate and amount are entered at the same time for a plan line.
  • When the burden multiplier is overridden by updates to the raw cost or burden cost, subsequent calculations of the burden cost will use the override burden multiplier.  The same is true when the markup percent is updated by changes to plan line components:  the override markup percentage will be used in revenue calculations.
Enhanced Handling of Override Rates on Budget / Forecast Lines
  • Override rates for a planning transaction on Edit Budget and Edit Forecast pages.
o   Raw Cost Rateo   Budened Cost Rateo   Bill Rate
  • Override rates are applied to all existing and new periodic lines for the planning transaction.
  • Average rates fields on these pages are now disabled for entry and are used for display only.
Simplified Addition of Planning Elements and Resources
  • New but unbudgeted tasks and resources can be added to a budget or forecast version.
  • Add either all new tasks and planning resources or new tasks only to the current plan version.
Self Service Expenditure Inquiry
  • Ability to drill into expenditure details from the Financials tab.
Reporting Pack for Generation and Distribution of XML Publisher Reports
  • A reporting pack is a set of report templates and recipients by project role.
  • The Generate Reporting Pack concurrent program emails the reports generated from the report templates based on pre-defined intervals.
  • The report template establishes each report’s layout and content.
  • New reports templates are configured using XML Publisher tools.
  • New or modified reports can be added to an existing reporting pack or be used to create an entirely new report set.
  • Predefined data definition files that contain XML tags for performance measures and project data are provided.
Predefined Reports:
  • Project Change Document Report
  • Project Committed Cost Report
  • Project Cost Detail Report
  • Project Cost Labor Report
  • Project Cost Summary Report
  • Project Earned Value Report
  • Project Financial Summary Report
  • Project Forecast Summary Report
  • Project Revenue At Risk Report
Budget Integration with Federal Budget Execution and/or 3rd Party Budget
  • The budget integration workflow supports integration with the Federal Budget Execution module..
  • The workflow can be customized to interface budget lines to external budgeting applications.
Microsoft Project 2007 Certification
  • Integration with Microsoft Project 2007 is supported.
Project Performance Reporting: Additional MeasuresYTD, QTD and At Completion calculated measures are available on the following pages:
  • Performance Overview Period-to-Date
  • Summary/Analysis
  • Task Summary/Analysis Resource Summary/Analysis
Project Performance Reporting: Inter-Project Revenue / Billing AmountsInter project revenue / billing amounts are available on the following pages:
  • Project List View Workplan Cost
  • Exception Reporting Performance Overview
  • Task Summary/Analysis Resource Summary/Analysis
  • Period-to-Date Summary/Analysis
 Supplier Cost DashboardSubcontractor Payment ControlsSupport for Pay when Paid Scenarios
  • A new “Pay when Paid” payment term for subcontracts automatically places holds on all subcontractor invoices under that subcontract until the corresponding customer payment is received.
  • Subcontract Payment Controls workbench allows project manager to manage the holds, with visibility into both the customer invoices and the related subcontractor invoices.
  • Workflow notifications about the receipt of the customer payment allow the project manager to automatically or manually release the subcontract invoice.
  • Associations between the customer invoices and the subcontractor invoices may be automatically maintained based on the billing of project expenditures for cost-plus contracts, or may be manually maintained for fixed price contracts.
Payment Controls for Subcontract Deliverables
  • Support for the tracking and monitoring of subcontract deliverables that place automatic holds on subcontractor invoices in the case of noncompliance.
  • Oracle Procurement Contracts allow a subcontract administrator to specify payment impact controls that will take effect when a subcontract deliverable is not met.
  • From the Subcontractor Payment Controls workbench, the project manager can view a checklist of the all the current subcontract deliverables, to assist in evaluating the subcontractor status prior to releasing monthly progress payments.
Oracle Project Resource ManagementResource Search Enhancements
  • Resource Search by Email Address
  • Resource Search by Person Type
  • Streamlined Navigation on Staffing Home
Cross Validation of Project and Assignment Dates
  • Requirement start dates are equal to or greater than the project start date and less than the project end date and that finish dates are equal to or less than the project end date but greater than the project start date.
  • Assignments cannot be added beyond the project end date.
  • A project team role end date cannot be beyond the project end date. If the roles are created before the project end dates are entered, users will receive an error if they later try to enter an end date that is earlier than the end date for existing roles.
  • When project transaction dates are moved corresponding assignment dates are validated against the new project dates. If the new project transaction dates fall outside the dates for existing assignments, users are given an option to shift the assignment dates or cancel the date adjustment.
Defaulting of Work Patterns’ From and To Dates
  • Work pattern from and to dates will default from the requirement start and end dates.
Improved Exception Handling of Maintain Project Resources Process
  • PRC: Maintain Project Resources delivers improved exception handling and notification when it encounters errors while processing employee records.
New Public APIs for Resource ManagementThe new PJR APIs fall into the following four categories:
  • Requirement Public APIs
  • Assignment Public APIs
  • Candidate Public APIs
  • Competence Public APIs
Organization Authority: Obsolete Forecast Authority
  • Removes the forecast authority functionality from the organization authority form
  • Removes existing security data relating to forecast authority.
  • Replaces the PJR forecast functionality with the new HTML based forecasting functionality. The new forecasting functionality has its own security mechanism and does not honor the old forecast authority model.
  • Improves the performance of security calls to organization authority because the existing security data is being removed.
Oracle Grants AccountingAward Budgeting Enhancements Budget period validations
  • Budget periods will not be validated across award budgets when those awards fund a single project.
  • Flexibility to establish award budgets based on the actual duration of the award, while not being confined based on the existing budgets already established for the project.
Automatic summarization of project budgets
  • With the new budget period validations, automatically summarize to a project budget viewable in Project Status Inquiry.
  • Two profile options have been added to identify the budget entry methods that will be used to summarize the project budgets.
Budget Line Sorting Option
  • Sort budget lines by Resource name, or by effective dates for budgets with date range periods.  Provides the flexibility to view the budget lines by period or by budgeted resource.
Award Status Inquiry Enhancements View by budget period
  • Allows the Find Award Status window to be limited to a single period, range of periods, or inception to date for a particular award.
  • Reflects the budget periods entered on the award budget.
GL and PA Date Parameters on Find Expenditure Items window
  • GL and PA date parameters have been added to the Find Expenditure Items window.
GL Date Parameters on Find Commitments window
  • GL Date parameters have been added to the Find Commitments window.

Oracle Projects new features and enhancements 



Following are highlights of Oracle Projects new features and enhancements in Oracle E-Business Suite (EBS) Release 12. Most of the features listed here are available from Oracle Projects Family Pack M.

Project Costing
  • Labor Cost Processing for Contingent Workers - Timecard and PO can be linked
  • Changes with respect to Oracle Payables Invoice Lines new feature
  • Adjust supplier cost in Oracle Project Costing under certain conditions
  • New mass adjust concurrent process
  • Oracle Payables now provides a drilldown to the Project Expenditure Inquiry window from the invoice workbench.
  • Integration with Oracle Project Manufacturing
Project Billing
  • Integration with Oracle E-Business Tax
  • Customers can now be attached at Top Task
  • Invoice Method at Top Task: Enables to invoice customers with different methods such as, fixed price and time and materials, within the same project.
  • Invoice Write-Off at line level
  • Invoice Concessions for credit memos
  • Project functional currency conversion attributes
  • Enhanced Billing Review with New Interface
Project Foundation
  • Integration with Oracle Sub-ledger Accounting
  • Multi-Org Access Control
  • Separation of Reporting and Planning Resources
  • Increased granularity for planning and reporting against inventory items and manufacturing resources through increased integration with SCM.
  • Resource Breakdown Structure enhancements
  • Define and utilize contingent workers on projects in the same capacities and manner as employees.
  • Enhanced Configurability of Project Home, Project List, Workbench and Page Layouts
  • Element level options while coping a project to create another project
Oracle Project Management
  • Supports dependencies between tasks within a single project or across projects.
  • Now can assign planning resources to tasks, including people, equipment, material items, and financial resources.
  • Can associate workflow to tasks that can be configured to send notifications depending on various businesses.
  • Expanded Integration with Microsoft Project
  • Can define the deliverables for a project, including all the associated actions needed to complete each deliverable.
Oracle Project Portfolio Analysis

Project Portfolio Analysis is a new product helps companies align their portfolios of projects and programs with their organizational objectives by taking advantage of Oracle Project’s standard project criteria, project scoring and ranking, and what-if portfolio scenarios.

Key Tables in Oracle Projects

Here is a brief description of the key tables in Oracle Projects.
TableDescription
PA_PROJECTS_ALLIt stores the highest units of work defined in Oracle Projects.
PA_PROJECT_ASSETS_ALLIt contains assets information defined for capital projects.
PA_PROJECT_ASSIGNMENTSIt stores details of all Assignments for a project.
PA_PROJECT_CLASSESIt contains the class codes of class categories that are used to classify projects.
PA_PROJECT_ROLE_TYPESImplementation-defined responsibilities or positions assigned to employees on projects are stored here.
PA_PROJECT_STATUSESIt stores valid project status codes.
PA_PROJECT_TYPES_ALLIt stores implementation-defined project classifications that supply default information and drive some project processing.
PA_TASKSIt contains user-defined subdivisions of project work.
PA_TASK_TYPESIt stores implementation-defined classifications of task.
PA_TRANSACTION_INTERFACE_ALLIt is an interface table to import transactions from external sources into Oracle Projects.
PA_TRANSACTION_SOURCESIt stores implementation-defined sources of imported transactions originating in an external system.
PA_IMPLEMENTATIONS_ALLIt contains information about the configuration of an Oracle Projects installation.
PA_ACTION_SETSIt stores action set templates as well as action sets belonging to an object, such as projects, requirements, etc.
PA_ACTION_SET_LINESIt stores action set lines that belong to an action set or an action set template.
PA_ACTION_SET_TYPESIt stores attributes of action set types.
PA_AGREEMENTS_ALLIt has customer contracts that serve as the basis for work authorization.
PA_AGREEMENT_TYPESImplementation-defined classifications of customer agreements.
PA_BILL_RATES_ALLInformation about bill rates and markups of standard bill rate schedules.
PA_BUDGETSIt stores budgets information.
PA_BUDGET_LINESIt stores detail lines of project and task budgets.
PA_BUDGET_TYPESIt contains implementation-defined classifications of types of budgets used for different business purposes.
PA_CLASS_CATEGORIESIt stores implementation-defined categories for classifying projects.
PA_CLASS_CODESIt stores implementation-defined values within class categories that can be used to classify projects.
PA_EVENTSIt stores entries assigned to tasks that generate revenue and/or billing but are not directly related to expenditure items.
PA_EVENT_TYPESIt stores implementation-defined classifications of events.
PA_EXPENDITURES_ALLGroups of expenditure items incurred by employees or organizations for an expenditure period.
PA_EXPENDITURE_CATEGORIESImplementation-defined groupings of expenditure types by type of cost.
PA_EXPENDITURE_ITEMS_ALLIt contains the smallest units of expenditure charged to projects and tasks.
PA_EXPENDITURE_TYPESImplementation-defined classifications of expenditures charged to projects and tasks.
PA_PERIODS_ALLImplementation-defined periods against which project performance is measured.
PA_RBS_DENORMThis table stores normalized resource breakdown structure information.
PA_RBS_ELEMENTSThis table stores the RBS element information and the parent-child relationship.
PA_RESOURCESIt contains resources used in budgeting and project summary amounts.
PA_ROLE_LISTSIt stores lists of roles defined with the system.
PA_SCHEDULESIt displays the schedule details for requirements and assignments. It also displays calendar schedules.

Saturday, March 27, 2010

Printing PDF Output directly from Concurrent Program

It is common requirement to generally print PDF output from concurrent program, so here we will follow the steps to how we are going to achieve that.

1)Below link