Search This Blog

Wednesday, May 22, 2013

Essential Date functions for ADF


    public static java.util.Date convertSqlToUtilDate(java.sql.Date date) {
        Date utilDate = null;
        if (date != null) {
            utilDate = new Date(date.getTime());
        }
        return utilDate;
    }

    public static oracle.jbo.domain.Date convertSqlToJboDate(java.sql.Date date) {
        oracle.jbo.domain.Date jboDate = null;
        if (date != null) {
            jboDate = new oracle.jbo.domain.Date(date);
        }
        return jboDate;
    }

    public static java.sql.Date convertUtilToSQLDate(java.util.Date date) {
        java.sql.Date sqlDate = null;
        if (date != null) {
            sqlDate = new java.sql.Date(date.getTime());
        }
        return sqlDate;
    }

    public static oracle.jbo.domain.Date convertUtilToJboDate(java.util.Date date) {
        oracle.jbo.domain.Date jboDate = null;
        if (date != null) {
            jboDate = new oracle.jbo.domain.Date(convertUtilToSQLDate(date));
        }
        return jboDate;
    }

    public static java.sql.Date convertJboToSqlDate(oracle.jbo.domain.Date date) {
        java.sql.Date sqlDate = null;
        if (date != null) {
            sqlDate = (Date)date.getValue();
        }
        return sqlDate;
    }


    public static java.util.Date convertJboToUtlDate(oracle.jbo.domain.Date date) {
        java.util.Date sqlDate = null;
        if (date != null) {
            sqlDate = (java.util.Date)date.getValue();
        }
        return sqlDate;
    }

Friday, May 10, 2013

Oracle Projects Navigation Paths

Accounting Calendar : Setup > Financials > Calendar > Periods

Agreement : Billing > Agreements

Agreement Template : Setup > Billing > Agreement Templates

Agreement Types : Setup > Billing > Agreement Types

AR Payment Terms : Setup > Billing > Payment Terms

Assign AutoAccounting Rules : Setup > AutoAccounting > Assign Rules

Assign Descriptive Security Rules : Setup > Flexfields > Descriptive > Security > Assign

Assign Key Flexfield Security Rules : Setup > Flexfields > Key > Security > Assign

AutoAccounting Lookup Sets : Setup > AutoAccounting > Lookup Sets

AutoAccounting Rules : Setup > AutoAccounting > Rules

Bill Rate Schedules : Setup > Billing > Bill Rate Schedules

Billing Extensions : Setup > Billing Extensions

Budget Change Reasons : Setup > Budgets > Change Reasons

Budget Entry Methods : Setup > Budgets > Entry Methods

Budget Types : Setup > Budgets > Budget Types

Budgets Budgets

Burden Cost Codes : Setup > Costing > Burden > Cost Codes

Burden Schedules : Setup > Costing > Burden > Schedules

Burden Structures : Setup > Costing > Burden > Structures

Capital Projects

Class Categories and Codes : Setup > Projects > Classifications

Compensation Rules : Setup > Costing > Labor > Compensation Rules

Contact Types : Setup > Project > Customers > Contact Types

Control Actions : Setup > Activity Management Gateway > Control Actions

Control Billing by Top Task : Billing > Control Billing by Top Task

Cost Bases : Setup > Costing > Burden > Bases

Credit Types : Setup > Billing > Credit Types

Cross Validation Rules : Setup > Flexfields > Key > Rules

Customers : Setup > Customers > Customer Entry

Descriptive Flexfield Security Rules : Setup > Flexfields > Descriptive > Security > Define

Descriptive Flexfield Segments : Setup > Flexfields > Descriptive > Segments

Descriptive Flexfield Values : Setup > Flexfields > Descriptive > Values

Dimensions : Setup > Collection Pack > Dimension

Employee Cost Rates : Setup > Costing > Labor > Employee Cost Rates

Enter Person : Setup > Human Resources > Employees

Event Entry and Inquiry Windows : Billing > Events

Event Types : Setup > Billing > Event Types

Expenditure Batches : Expenditures > Pre-Approved Batches > Enter

Expenditure Batches Summary : Expenditures > Pre-Approved Batches > Review

Expenditure Categories : Setup > Expenditures > Expenditure Categories

Expenditure Inquiry : Expenditures > Expenditure Inquiry Project

Expenditure Inquiry Across Projects : Expenditures > Expenditure Inquiry All

Expenditure Items : Expenditures > Expenditure Inquiry Project or All

Expenditure Types : Setup > Expenditures > Expenditure Types

Find Expenditure Batches : Expenditures > Pre-Approved Batches > Review

Find Invoices : Billing > Invoice Review

Flexfield Security Rules : Setup > Flexfields > Validation > Security > Define

Flexfield Value Sets : Setup > Flexfields > Validation > Sets

Flexfield Values : Setup > Flexfields > Validation > Values

GL Accounts : Setup > Financials > Accounts

Implementation Options : Setup > System > Implementation Options

Invoice Formats : Setup > Billing > Invoice Formats

Invoice Summary : Billing > Invoice Review

Job : Setup > Human Resources > Jobs

Key Flexfield Security Rules : Setup > Flexfields > Key > Security > Define

Key Flexfield Segments : Setup > Flexfields > Key > Segments

Labor Cost Multipliers : Setup > Costing > Labor > Cost Multipliers

Location : Setup > Human Resources > Locations

Maintain PA Period Statuses : Setup > System > PA Periods

Mass Update Batches Project : Maintenance > Mass Update Batches

Non-Labor Resources : Setup > Expenditures > Non-Labor Resources

Organization : Setup > Human Resources > Organizations > Define

Organization Hierarchies : Setup > Human Resources > Organizations > Hierarchies

PA Periods : Setup > System > PA Periods

Payment Terms : Setup > Billing > Payment Terms

Percent Complete Project : Status > Percent Complete

Period Types : Setup > Financials > Calendar > Types

Personal Profile Values : Other > Profile

Pre-Approved Expenditure Batch Review : Expenditures > Pre-Approved Batches > Review

Pre-Approved Expenditure Entry : Expenditures > Pre-Approved Batches > Enter

Project Customer Relationships : Setup > Projects > Customers > Relationships

Project Funding Inquiry : Billing > Funding Inquiry

Project Role Types : Setup > Projects > Role Types

Project Status Inquiry : Project Status > Project Status Inquiry

Project Status Inquiry Columns : Setup > Project Status Columns

Project Statuses : Setup > Projects > Statuses

Project Types : Setup > Projects > Project Types

Projects Templates Summary : Setup > Projects > Project Templates

PTE Employee Assignment to Operating Unit : Setup > Expenditures > PTE-Multiple Org

QuickCodes : Setup > Human Resources > QuickCodes

Request Set  : Other > Requests > Set

Resource Lists : Setup > Budgets > Resource Lists

Revenue Categories : Setup > Expenditures > Revenue Categories

Revenue Review Windows : Billing > Revenue Review

Review Online Time and Expense : Expenditures > Online Expenditure Review > Supervisor

or

Expenditures > Online Expenditure Review > All

Review Transactions : Expenditures > Transaction Import > Review Transactions

Role Types : Setup > Projects > Role Types

Rollup Groups : Setup > Flexfields > Key > Groups

Segment Values : Setup > Flexfields > Key > Values

or

Setup > Flexfields > Descriptive > Values

or

Setup > Flexfields > Validation > Values

Service Types : Setup > Projects > Service Types

Set of Books : Setup > Financials > Books

Shorthand Aliases : Setup > Flexfields > Key > Aliases

Source Products : Setup > Activity Management Gateway > Source Products

Submit Requests : Other > Requests > Run

System Options : Setup > Customers > System Options

Transaction Controls Projects. Find the project for which you want to enter transaction controls. Choose Open. Select Transaction Controls from the Project Options.

or

Projects. Find the project. Choose Open. Select Tasks. Chose the task for which you want to enter transaction controls. Choose Options. Choose Transaction Controls from the Task Options.

Transaction Sources : Setup > Expenditures > Transaction Sources

Units : Setup > Expenditures > Units

Value Sets : Setup > Flexfields > Validation Sets

View Burdened Costs : Setup > Costing > Burden > View