Concurrent Program (CP) Phases

on Monday, February 14, 2011

Phase Phase Description Phase Status Phase Status Description
Pending
The Concurrent Program (CP) is waiting to be run.  Normal The CP is waiting for a concurrent manager (CM)
 Waiting A child request is waiting for the parent process to let it run. 
 Standby The CP1 (in Standby) is waiting for another CP2 to finish. The CP1 may run only after CP2 complete. 
 Scheduled The execution time for the CP has not been reached. 
Running
The CP is running.  Normal The CP process is running. 
 Paused The parent CP is paused because is waiting for a child process to complete. 
 Resuming After the "Paused" Status when the parent CP restart working. 
Terminating The CP is being terminated. 
Completed
The CP has been finished the execution.   Normal The CP completed successfully. 
 Warning The CP completed successfully with a warning message. 
 Error The CP failed to complete due to an error. 
Terminated The CP was stopped before completion. 
 Canceled The CP was canceled before it started  Example: The CP was scheduled for tomorrow but today I cancel the CP.  
Inactive
Describes a CP that cannot be run immediately.    Disabled The CP has not been enabled for execution. 
 On Hold The CP has been placed in on hold.
 No              
 Manager
There is no managers for that type of request. 

Oracle Project Accounting Tables

on Sunday, January 30, 2011

A_PROJECTS_ALL Information about projects
PA_AGREEMENTS_ALL Customer contracts that serve as the basis for work authorization
PA_BILL_RATES_ALL Information about bill rates and markups of standard bill rate schedules
PA_BILLING_ASSIGNMENTS_ALL Assignments of billing extensions to a project type, project, or task
PA_COST_DISTRIBUTION_LINES_ALL Information about expenditure item cost distribution
PA_CUST_REV_DIST_LINES_ALL Information about expenditure item revenue distribution
PA_DRAFT_INVOICE_DETAILS_ALL Intercompany invoice details for cross charged transactions
PA_DRAFT_INVOICES_ALL Information about draft invoices generated for projects
PA_DRAFT_REVENUES_ALL Information about draft revenue generated for projects
PA_EXPENDITURE_COST_RATES_ALL Cost rates for non-labor expenditure types
PA_EXPENDITURE_GROUPS_ALL Groups of pre-approved expenditures
PA_EXPENDITURE_ITEMS_ALL The smallest units of expenditure charged to projects and tasks
PA_EXPENDITURES_ALL Groups of expenditure items incurred by employees or organizations for an expenditure period
PA_PERIODS_ALL Implementation-defined periods against which project performance is measured
PA_PROJECT_ASSET_LINES_ALL Summarized project CIP costs
PA_PROJECT_ASSETS_ALL Assets defined for capital projects
PA_EXPENDITURE_TYPES Implementation-defined classifications of expenditures charged to projects and tasks
PA_EXPENDITURE_CATEGORIES Implementation-defined groupings of expenditure types by type of cost
PA_CLASS_CATEGORIES Implementation-defined categories for classifying projects
PA_CLASS_CODES Implementation-defined values within class categories that can be used to classify projects
PA_PROJECT_CLASSES Class codes of class categories that are used to classify projects
PA_BUDGET_VERSIONS Versions of project budgets
PA_BUDGET_LINES Detail lines of project and task budgets

Enhanced Features in Oracle APEX 4.1

on Monday, January 24, 2011

Development for Mobile Applications Include themes and HTML templates suitable for smart phones and mobile devices.
Charting - Provide for chart rendering without using Flash (to enable display on mobile devices).
Error Handling - Improve error handling and user-defined exception processing.
Interactive Reporting – Allow multiple reports on one page and support pivot queries.
Tabular Forms – Allow multiple tabular forms on one page and continue to expand tabular forms validations.
Master-Detail-Detail – Allow the generation of pages to support master-detail-detail relationships.
Dynamic Actions – Enhance conditional processing and allow dynamic actions to be defined for tabular forms, reports, and buttons.
Plug-Ins - Add plug-in support for additional components and enhance plug-in definitions.
Use of ROWID – Allow usage of ROWID for Automatic DML processing (as an alternative to identifying the PK columns).
Modal Dialogue - Add ability to display a dialog on top of a page (the rest of the page will be grayed out).
Websheets – Allow for greater control over user interface, new page section types, and enhanced spreadsheet / datagrid integration.
Data Upload - Enable end-users to upload data into an existing table (within an application).
Accessibility – Improve accessibility in existing themes and HTML templates.