Cumulative Sum, Regular Expressions

I needed a sql to force users to enter data with Capital letters, a friend helped me with a regular expression, of course usage of it is not limited with this:
regexp_substr(:ATTRIBUTE_VALUES.C_ATTRIBUTE6,'[[:lower:]]') is not null

To have cumulative sums following sql can be used:
SUM(SUM( toplam_maliyet/GENEL_TOPLAM_maliyet)*100 )
OVER (ORDER BY sum (toplam_maliyet/GENEL_TOPLAM_maliyet)*100 desc ROWS UNBOUNDED PRECEDING) AS cumulative_total

Effective Software Development Process

It is said that system analysis and development of the software result differently than the real requirement most of the time. I partially agree with that; i see products varies from customers imagination-requirement thus changes are required after the expected completion time. To increase quality of work and descrease time spent, design clarity is important so supporting anaysis text with draft screens, workflows is a good idea. To help with these Lucid Spec software can be used;

"Lucid Spec - Better software through concise functional specifications!
Lucid Spec helps you rapidly prototype software and produce a concise, clear functional specification. Lucid Spec does this by combining screen design, application simulation, and user interface description all-in-one."
http://www.elegancetech.com/ls/ls.aspx

Oracle Time and Labor (OTL)

I have encountered OTL while using Projects. For me time entry was done in OTL and it was integrated with Projects. Three kinds of time entry is possible for OTL; employees entering for themselves via an OAF screen, assigned users entering for different employees (Authorized Delegate method) via an OAF screen and assigned users entering for different employees (Timekeeper method) via a Forms screen.
Following is a more comprehensive definition of the module

"Oracle Time and Labor automates the entire time and attendance record-keeping process and provides an intuitive, web-based interface for time entry and approval. It offers a simplified way to submit, review, track and approve timecards. At the same time, it helps you control costs and time worked, consolidate timecard information, and adhere to organizational time management rules.

Integrate and Streamline Your HR Processes
Oracle Time and Labor is part of Oracle Human Resources Management family of applications, and integrates seamlessly with other Human Resources applications, including Human Resources(core) and Payroll. Oracle Time and Labor also is a key module in Oracle's enterprise project management solution, Oracle Projects.

BENEFITS
Enter Time Anytime, Anywhere

Enter time via web browser, mobile device, or even offline using a timecard template that can be uploaded later.
Streamline Management

Enable approvers to search timecards and view summary information. Perform mass approvals. Gain flexible configurations for approvals workflow.
Enforce Policies

Define rotation plans based on shifts and work plans. Define which employees can charge to which organizations in your company. Support policies for holidays, overtime, and rounding.
Automate Timecard Creation

Automatically generate a timecard or group of timecards from work schedule, last timecard, or a project stored in Oracle Projects Resource Management.
Create Single Source of Entry

Improve reporting, extracting, and processing with a single database of employee time-related information. Share data with Oracle Projects, Oracle Human Resources, and Oracle Payroll."

http://www.oracle.com/us/products/applications/ebusiness/human-capital-management/053631.html

Oracle Application Testing Suite (ATS)

Oracle has an alternative for HP Quality Center and its automated tests. It is described clearly hereafter.

"Application Testing Suite is a comprehensive, integrated testing solution that ensures the quality, scalability, and availability of your Web applications, Web Services, packaged Oracle Applications and Oracle databases.

This integrated, full lifecycle solution enables you to define and manage your application testing process, validate application functionality, and ensure that your applications will perform under load. With Application Testing Suite, you can deploy your Web applications and Web Services in less time while maximizing the efficiency of your testing team.

Application Testing Suite is comprised of the following tightly integrated products:

Oracle Load Testing for scalability, performance and load testing.
Oracle Functional Testing for automated functional and regression testing.
Oracle Test Manager for test process management, including test requirements management, test management, test execution and defect tracking."
http://www.oracle.com/technetwork/oem/app-test/etest-101273.html

Web Service Management in EBS

Previously i have mentioned Integrated SOA Gateway responsibility as a source of information for APIs and interfaces. Though its functions are not limited with these; you can monitor, generate, deploy web services and grant authorizations with the Integrated SOA Gateway responsibility. To be able to manage EBS login should be with SYSADMIN user. SYSADMIN user can also see transaction results, request and response details and their SOAP (Simple Object Access Protocol) information.

Toad Character Problem

You may encounter different kinds of character problems while using Toad. One kind is common and i know it made many developers angry; if your nls_lang setting is not compatible with the country you are working then your code might get corrupted. For example if you write a note like 'İstanbul - Üsküdar' and your nls_lang is set to English then you should expect the corruption. If you are going to use Turkish characters like these then you should set nls_lang to Turkish: Start> run> regedit> search nls_lang > AMERICAN_AMERICA.WE8ISO8859P9 -> TURKISH_TURKEY.TR8MSWIN1254

Another problem I have witness is the results of your query may shown in Chinese characters! In that case your problem is probably the Home of your Toad or Toad Options font selection.

If you have problem while extraction of data then you may use "Excel Instance" for export format as a workaround.