Siebel CRM 8.2 for Public Sector

With the release of Oracle's Siebel CRM 8.2 for Public Sector, Oracle delivers the industry's most complete social services solution, enabling agencies to simplify eligibility determination, increase case management efficiency, and improve program effectiveness.

Oracle's new social services solution provides a comprehensive view of clients across programs and integrates with financial management systems to streamline the entire social services lifecycle. Now, agencies can rapidly and accurately update eligibility rules and policy changes. Additionally agencies are able to provide clients with a self-service solution to initiate screening across programs and automate changes in circumstance. read more

Celebrate Oracle's Challenge for the 33rd America's Cup

BMW ORACLE Racing wins the 33rd America's Cup. Visit bmworacleracing.com for the latest news.

On January 27, 2010, Oracle announced it finalized it's acquisition of Sun.

This combination transforms the IT industry. With the addition of servers, storage, SPARC processors, the Solaris operating system, Java, and the MySQL database to Oracle's portfolio of database, middleware, and business applications, we plan to engineer and deliver open and integrated systems—from applications to disk—where all the pieces fit and work together out of the box. Each layer of the stack will be architected to improve performance, leverage innovation and centralize management so that IT will be more predictable, more supportable, and more secure. Customers will benefit as their system performance, reliability and security goes up and their system integration and management costs go down.

Join Larry Ellison at a Live Webcast, Unveilling the Oracle + Sun Strategy: Wednesday, January 27

Register Now

Attend the Primavera Enterprise Project Portfolio Management Live Virtual Summit
The Oracle Primavera Enterprise PPM Virtual Summit promises to be an action-packed day featuring a keynote from Joel Koppelman, Senior Vice President & General Manager, Oracle Primavera Global Business Unit, live sessions, and live chats with Primavera experts.

Date: Wednesday, January 20, 2010
Time: 10:00 a.m. – 4:00 p.m. ET/ 7:00 a.m. – 1:00 p.m. PT/ 3:00 p.m. – 9:00 p.m. GMT

Register now.

20 of the Top 20 Global Retailers Rely on Oracle to Transform the Economics of Retail

The world's leading retail companies—including Carrefour SA, Costco, Lowe's Companies, Metro AG, Tesco, Walmart, and others—know that insight-driven retailing is the key to enhancing profitability and serving their customers better. Oracle's unique portfolio of retail solutions allows retailers to create a unified view of the information that delivers economic value to the entire business, from in-store operations to corporate strategy to supply chain and logistical management. The advanced analytic capabilities of Oracle solutions transform retailers' ability to make decisions—so they will carry the right items and train their employees to execute flawlessly on the right merchandising programs. Oracle's innovative solutions enable retailers to do this by providing accurate, actionable information, fully integrated among store, merchandising, and financial systems. Only Oracle provides all the components—applications, middleware, database, and infrastructure software—that support insight-driven retailing, allowing companies to become more competitive.

Oracle at the National Retail Federation Convention
Oracle is a proud sponsor of the National Retail Federation 99th Annual Convention, held January 10-13, 2010, at the Jacob Javits Center in New York City. Please join Oracle just inside the entrance of the show floor, where our bi-level booth will feature several kiosks covering the entire Oracle Retail footprint, including several demonstrations. Find out how Oracle is helping retailers around the world transform the economics of retail.

• Visit Oracle at the NRF

Smart Strategies: Your Roadmap to the Future

Join Oracle executives for Smart Strategies: Your Roadmap to the Future, an exclusive briefing on the latest business trends and technology shifts—and their pervasive impact on organizational strategies. You'll gain insight into "the new normal" of today's economic and competitive climate and learn how leading organizations are adapting the way they plan, operate, execute, and work. You'll also hear how the latest innovations in Oracle Applications including Oracle E-Business Suite, Oracle's PeopleSoft, Oracle's JD Edwards, Oracle's Siebel, and more can help accelerate the execution of your organization's roadmap. Register now.

Tune into this podcast series to get the latest information on Oracle Database from Oracle technical experts. Read more.

Oracle's Second Quarter Fiscal Year 2010 Earnings
Results will be announced after the close of the market on December 17, 2009. A webcasted conference call with the financial analyst community will follow at 2:00 p.m. Pacific.

• Listen to the live Webcast (archived through December 28)
• Safe harbor statement (PDF)
• Q210 Earnings Press Release and Financials (PDF)

Now, with Configurable Retroactive Pay, you have the chance to define in the system, what fields trigger a retro request.You have total control over what triggers a retro request, and you can prevent unwanted retro requests.

Any Changes that come through Online (Job or Additional Pay Data) , MSS or through component interface create triggers and not through SQL's

In order to use the Trigger Program, the first step in the retro process is to define what fields trigger a retro request. This would be only for fields in PS_JOB & PS_ADDL_PAYA_DATA tables; Then use this fields to define your retro pay trigger values, you can choose whether any change to a field triggers retro, or you can use the Dependent on Field Value check box to configure the trigger so that only specific changes trigger Retro:

Also, once you load the data to PSHUP Table (PS_PSHUP_TXN) either through other modules or through your custom process and before the delivered Load Payhseet PSHUP Process is run, if you ever wanted to stop or inavtivate certain transactions to load into Paysheets, either you would have run a SQL behind the scenes which is fruastuating during the busy payroll period or through your own custom developed process; Now PeopleSoft 9.1 came up by delivering a new Update Paysheet Transactions page where you can inactivate/stop the transactions that you do want to load to paysheets:

PeopleBooks:

Effective Date:

The effective date is critical in determining how an employee is paid. When you hire an employee, the effective date becomes the hire date and the original hire date. If an employee is hired in the middle of a pay period, the system automatically calculates the percentage of pay that the employee is due, and creates a corresponding paysheet entry.

Similarly, if you add an entry to an employee's job record, such as a promotion or pay rate change, and that change goes into effect in the middle of a pay period, the system creates two pay earnings entries on the paysheet and prorates the earnings accordingly. The system stores rules for proration on the Pay Group table.

When the effective date falls in the middle of a pay period, the paysheet process prorates the employee’s pay for the period by creating additional pay earnings records. Earnings are prorated for all frequencies. Proration rules in Payroll for North America process a single week at a time, Sunday through Saturday. Because of this, problems with proration may occur with employees whose schedule may not fit this pattern.

Proration Rules

An employee is considered eligible for partial pay whenever a job record has an effective date in the middle of a pay period. The system uses work schedule to determine the number of workdays per year and the number of workdays per week.

Mid-period Job Changes

On the Pay Group table, specify a work schedule and a proration rule to calculate prorated pay when there is a partial pay period due to mid-period job changes:

An employee is considered eligible for partial pay whenever a job record has an effective date in the middle of a pay period.Mid-period job changes that can cause partial pay include hiring, termination, or pay data changes. Transfers and promotions might result in pay data changes.

Elements of the Proration Calculations :

The work schedule and proration rule work together to calculate prorated pay. Other factors are the employees standard hours and standard work period, and frequencies specified on the Pay Group table.

This table defines the variables used in the proration rule formulas:

Proration Rules for Mid-pay Period Changes

Setup the SMTP server ip-address and port number in App. Server / Process scheduler
Invoke the PSADMIN.exe in the PS_HOME/appserv directory and in the application server configuration, SMTP settings section specify the ip-address for the machine where SMTP server is installed.



Under the Setup WorkFlow Defaults:

Make sure the check boxes ‘Worklist Active’, ‘Worklist Active’ ‘HR installed’ and checked. If not, check the checkboxes and reboot the application server

For the users who will be using workflow routing (e-mail, Worklist) make sure that the following things are done.
1. They have a valid Worklist-id in PeopleSoft User profile.
2. E-mail and Worklist are enabled for the users

• Locate an SMTP mail server that you specified in SMTP settings under your App or Prcs Server SMTP settings
• Prove the mail server is accessible by connecting via telnet or pinging it.

3) Make sure the email id specified is active and exists.

Here’s the screen shot of Flat Rate Table (in PS version 8.8 or 8.9) showing the Provider Amount:

How It Can Work in 9.0 and above:

The different Rate Tables of 8.8 or 8.9 are lumped into 1 component in 9.0 and above, differentiating them by Benefit Rate Type in new Benefit Rate Table

what’s missing is the previous Provider Rate of 99.0. This can easily be defined in 9.0 and above by using same component with Benefit Type of Flat Rate as illustrated below with Employee Rate of 99.0:

Then in your SQR or batch program, add logic to match up Employee/Employer Rates to the corresponding provider rate, e.g.:

IF RATE-TBL-ID = ‘RT1’
THEN TOTAL-DEDUCTION = BN-EMPL-RATE + BN-EMPLR-RT

IF RATE-TBL-ID = ‘RT1P’
THEN PROV-COVRG-RATE = BN-EMPL-RATE

CO-ADMIN-FEE = TOTAL-DEDUCTION - PROV-COVRG-RATE

Or if you have naming convention schema for RATE_TBL_ID’s between the Employee/Employer Rates and Provider Rates, e.g. 1st 3 characters of the RATE_TBL_ID match, then you can join or add it in the program instead of hard coding it in the program.
You can also use the Benefit Rate Type to identify Coverage Provider Rates, e.g.:

To extract Provider Rate Types from table and corresponding Provider Rate:

SELECT
,R.RATE_TYPE
,P.BN_EMPL_RATE
FROM PS_BN_RATE_DATA P
, PS_BN_RATE_TBL R
WHERE P.RATE_TBL_ID = R.RATE_TBL_ID
AND (P.EFFDT=
(SELECT MAX(P1.EFFDT)
FROM PS_BN_RATE_DATA P1
WHERE P1.RATE_TBL_ID=P.RATE_TBL_ID
AND P1.EFFDT <= current date or whatever effective date required)
AND P.EFFDT = R.EFFDT

In batch program, add the logic to match up the Provider Coverage Rate to its corresponding Employee/Employer Rates. In our example the Rate Table ID ‘RT1P’ Rate Type ‘RT1’ in Benefits Rate Table matches with Rate Table ID ‘RT1P’. Hence you can create a schema where the Provider’s Rate Type matches with the corresponding Rate Table ID of Employee/Employer Rate in Benefits Rate Table.

Another option is to have one Provider Rate Type that applies to multiple Employee/Employer Rates, e.g. Benefit Rate with Rate Type of ‘RT1’ contains the Provider Coverage Rate for Benefit Rate ID’s ‘RT1’, ‘RT2’ and ‘RT3’.

TAM Question:

I have a question regarding multiple Sites. How do we enable multiple sites on the same Portal?

Answer:

What is PeopleSoft TAM related Site ID:

Site IDs define the default parameters for an organization’s online application website and determine which job openings appear on the organization’s internal and external websites.

Row security is used to determine which job openings are available to the site. Job search criteria, such as Recruiting Locations and Job Family, use Set ID to display appropriate drop-down values.

Navigation of Site Set Up > Set Up HRMS -> Product Related ->Recruiting, Sites :





Define multiple Site ID's as you need in the Site ID Setup:
Also, make a note of the Site ID here,which is 1111.



This is the Internal Career's Portal CREF (through self-service) which is linked to default site id:




The Portal structure will not allow multiple instances of the same menu.component combination. However, the use of Additional Parameters in the Component Parameters groupbox allows the Portal to recognize the entry as unique. For example, adding a CREF to the Careers Home page for TEST Site (Site ID 1111) would look like this:

When CREFs exposed, the menu would then look like this in your portal:

The Recruitment Source is linked to the Site in the second page. Here one or more sites can be selected for a Recruitment Source. When a recruiter or hiring manager creates a job opening and selects to post the job opening to this source, the system posts the job opening to all of the sites that you select here.



Hope this helps...

Question:


Dear Gurus

Does PS Timekeeper allow for the assigning of percentages to specific hours in the workday, so that if a non-exempt employee works those hours, they get a differential paid to the for that hour only.

For example, Jane Doe works the even shift (6pm to 2am) one day a week. When putting her hours in the timekeeper, she records normal hours (8am to 5pm) Monday through Thursday, and 6pm to 2am on Friday. Would she be assigned a shift code at the employee level (lets say 5%) that gets applied to all hours no matter what? OR could the system recognize normal pay for Monday - Thursday, and apply the differential to the hours worked Friday night only?

I Appreciate your early response.

Thanks in Advance

Keyrun

Answer:


You need to understand how Shift Differential is paid through PeopleSoft. here's some background on how you can setup shifts and shift differential or shift premium payment.

Methods to Setup Shift Pay:

This diagram lists some methods for setting up and calculating shift pay:



Earnings Code Based on Other Earnings.

This is the preferred method if you need to express shift pay as separate earnings on the paycheck or advice. Create a separate earnings code for shift differential based on another earnings code or a special accumulator of earnings and pay it out as additional pay. You can set it up as a percentage or a flat rate. A flat rate must be hours-based. Do not select Eligible for Shift Differential on the Earnings table.

Pay Group SetID and Shift Table
Create each applicable shift type on the Shift table. Assign each employee to one of these shifts. Select Eligible for Shift Differential for eligible earnings codes.

Earnings Code With Earnings or Rate Adjustment Factor
Add a rate adjustment factor to applicable earnings on the earnings table to add that rate to the employee’s hourly rate. Or add an earnings adjustment factor to the total earnings. This method does not result in a separate earnings line on the paycheck


Compensation Rate Codes
You can define non-base compensation rate codes to indicate the rate that is paid on the paycheck when assigned to an earning. For example, if the employee is paid overtime at time and half and the employee’s hourly rate is $10.00, the paycheck would show the $15.00 rate for overtime.

Use Time and Labor Rules
Customers who license PeopleSoft Enterprise Time and Labor set up rules to define shift differential.

One important thing to note is that: The Eligible for Shift Differential check box has no bearing on PeopleSoft Enterprise Time and Labor.

So for your case, you need to define a Time and Labor rule for calculating a shift premium instead of using payroll shift differential.



You can try using the Premium Zone Templates:

1) Template 100 :

If a time reporter works between x and y o'clock, then pay premium. i.e. When a time reporter works between (1)SPECIFIED_START_TIME and (2)SPECIFIED_END_TIME, create a shift premium only for those hours worked within the specified time, to be charged to TRC (3)SPECIFIED_TRC.

2) Template 090:

If a time reporter clocks in between x and y o'clock, then pay premium. i.e When a time reporter punches IN between (1)SPECIFIED_START_TIME and (2)SPECIFIED_END_TIME, create a shift premium for all hours worked, to be charged to TRC (3)SPECIFIED_TRC.
If the time reporter punches in within the specified time period, this rule creates a TRC for all hours worked, even when the time reporter punches out after the specified time period.


So, in your case, you would put the start time and end time of friday to pay .05 percent shift premium. Your Shift Premium TRC should have .05 as the multiplication factor.

Hope this helps. Please add comments.

Question:

Hello - We are having errors show on the Presheet Audit Report pay034 where theerror description is blank. Any ideas on where the error messages are stored and how to correct this problem?


Answer:


The Presheet Audit report is used to provide a detailed error listing of set up data (employee, benefit, deductions) that can cause errors in the Create Paysheet process (PSPPYBLD). So basically you need to run to identify setup issues prior to creating and calculating paysheets



The SQR uses descriptions that are defined in PS_STRING_tbl. There are 95 rows defined for Pay034.sqr program in 9.0 version.



Navigation to the String Table is - PeopleTools -> Utilities -> Administration -> Strings Table and look for PAY034 program id.