Sevenkb.com

New Post has been published on http://www.sevenkb.com/oracle-apps-technical/oracle-hrms-interview-questions-answers/

Oracle HRMS Interview Questions & Answers

Oracle HRMS Interview Questions & Answers

1. What are the minimum classifications to create a Business Group? (i) Business Group (ii) GRE/Legal Entity (iii) HR Organization

2. What are the Pre-Requisites for creating a Business Group? (i) Value Sets (ii) Key Flexfields (iii) Location

3. What is the use of HR Organization? If we want to assign the employee information to a Business Group then we need to have HR Organization classification under a Business Group.

4. What is People Group? (i) It is a Flexible area for holding user-defined assignment data. (ii) Data can be used for Grouping sets of assignment together. (iii) People group can be used for Element eligibility. (iv) This information is used by the Payroll Run. (v) The data will be held in PAY_PEOPLE_GROUPS. (vi) GROUP_NAME field holds the concatenation of Segment data.

5. What is the KFF structure for SIT? Personal Analysis Flexfields.

6. What is the DFF structure for EIT? (i) Extra Person Information (ii) Assignment Extra Information (iii) Extra Location Information (iv) Extra Position Information (v) Extra Job Information (vi) Organization Developer DF

7. How to enable EIT? Switch Responsibility to ‘Human Resources, Vision Enterprises’ Double click on ‘Security’ Click on ‘Information Types’ Create your own ‘Information Types’ under your ‘Responsibility Name’.

8. How to enable SIT? Switch Responsibility to ‘Human Resources, Vision Enterprises’ Double click on ‘Other Definitions’ Click on ‘Special Information Types’

9. What is the use of Date Track?? 1) It is used to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION. 2) The value of the Data Track record depends on the date. 3) Tables ending with _F are date track tables. 4) To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date. 5) The Effective_Start_Date indicates when the record inserted. 6) The Effective_End_Date indicates when the record updated or deleted.

10. What is the use of Object Version Number? 1) It is used to capture the latest record from the data base table. 2) When a row is inserted its number is set to 1. 3) If any updates performed on the row then the OVN is incremented. 4) Every API has the OVN parameter. 5) For create API this parameter is defined as an OUT parameter. 6) For update API this parameter is defined as an IN OUT parameter. 7) The APIs use it to check a row has been updated by another user, to prevent overwriting their changes.

11. What is the Element? It is a Data Structure which is used to hold information for both Human Resources and Payroll. In Human Resources elements may represents compensation types including Earnings such as Salary, Hourly Wages and Bonuses. In Payroll, elements constitute all the items in the Payroll run process.

12. What are the Classification Priorities? (i) Information (ii) Non-Payroll (iii) Earnings (iv) Pre-Tax Deductions (v) Tax Deductions (vi) Employer Tax (vii) Voluntary Deductions (viii) In Voluntary Deductions

13. What the Element can represent? Earnings –> such as Salary, Wages & Bonuses Benefits –> such as employee stock & pension plans Non-Payroll items –> such as Expenses Absences from work Voluntary and In-Voluntary deductions Employer Taxes and other Liabilities.

14. What are the pre-defined Elements? UK Payroll legislation provides many predefined elements –Tax –National Insurance (Employee/Employer) –Court Orders These Elements cannot be modified.

15. What are the Element Entry Concepts? Recurring à Recurring Entries can exists over many Payroll periods Non-Recurring à Non-Recurring Entries are valid for single Payroll period only.

16. What are the types of Element Entry? There are four types Normal Entry Override Entry Additional Entry Adjustment Entry –Additive Adjustment –Replacement Adjustment –Balance Adjustment.

17. How can we add a new input value to an existing Element? We can add an additional input values to an existing Element if the element has not been processed in a Payroll run and the Effective data is the same date of creation of the Element.

18. What is the use of ID_FLEX_NUM? It is used to define the Structure Definition. The Structure Definition is held in FND_ID_FLEX_STRUCTURES The Structure Segment Definition is held in FND_ID_FLEX_SEGMENTS.

19. What is the Element Link? Links identify one or more assignment components that must be included in an employee’s assignment for them to be eligible.Elements can, but they don’t have to, be linked by: Organization GroupJob PositionGrade LocationEmployment Category (i.e., Fulltime-Regular, Part-time-Regular) Payroll Salary Basis.

20. What is API? 1. API is packaged procedure which can be used as an entry point into Application. 2. The advantage of using an API is we can enter new information or alter the existing data without manual enters the information into the Application. 3. APIs allow users to maintain HRMS information without using Oracle Application forms. How do i use an API to upload the data? 4. API package contains many procedures to insert/update/delete the application data. 5. The API is not executed on its own, the API must be called or executed by other pl/sql program. 6. The API package should never be modified for custom use, if modified Oracle will not be able to support them. 7. None of the HRMS APIs issue commit, the calling module should manage the commit of the transaction. How do i identify the Package name and version of the API?SELECT text FROM all_source

WHERE name like ‘HR_EMPLOYEE_API%’ AND text LIKE ‘%Header%’;

Oracle HRMS Interview Questions & Answers

Oracle HRMS Interview Questions & Answers

New Post has been published on http://www.sevenkb.com/uncategorized/get-facebook-like-share-count-using-php/

get facebook like & share count using php and facebook API

get facebook like & share count using php

By using facebook API we can get facebook like & share count using php

The following example explain how to get facebook like & share count using php.

  <?php $url = "sevenkb.com"; $fql = "SELECT url, normalized_url, share_count, like_count, comment_count, "; $fql .= "total_count, commentsbox_count, comments_fbid, click_count FROM "; $fql .= "link_stat WHERE url = '$url'"; $apifql="https://api.facebook.com/method/fql.query?format=json&query=".urlencode($fql); $json=file_get_contents($apifql); $json_n=json_decode($json,true); echo $data['fb_share_count'] = $json_n[0]["share_count"]; echo $data['fb_like_count'] = $json_n[0]["like_count"]; ?>

get facebook like & share count using php

get facebook like & share count using php

New Post has been published on http://www.sevenkb.com/php/how-to-get-alexa-rank-using-php/

How to get Alexa rank and Alexa backlinks using php

How to get alexa rank & alexa backlinks using php

  Alexa Rank & traffic is impartent factor, Alexa Rank we can get / fetch by using Alexa API , Alexa API is Free to use with Alexa crome plugin Alexa API link to get Alexa rank of website, PHP script to get alexa rank and Alexa Backlinks using alexa API easy to use see PHP code here, Alexa providing paid API to get Alexa Rank and all of Alexa statistics of any website from AWS Alexa API it is free up to 1000 request / month to get Alexa rank and Alexa Backlinks

PHP script to get Alexa Rank & Alexa Backlinks from Alexa API

<?php $url='yourdomain.com'; $xml = simplexml_load_file('http://data.alexa.com/data?cli=10&dat=snbamz&url='.$url); $rank=isset($xml->SD[1]->POPULARITY)?$xml->SD[1]->POPULARITY->attributes()->TEXT:0; $country_rank=isset($xml->SD[1]->COUNTRY)?$xml->SD[1]->COUNTRY->attributes()->RANK:0; $web=(string)$xml->SD[0]->attributes()->HOST; echo nl2br($web." has Alexa Global Rank ".$rank."\n\n and \n\n Country Rank ".$country_rank.".\n"); ?>

To get Alexa backlinks , website load time form Alexa API

$alexabacklinks=(int)$xml->SD[0]->LINKSIN->attributes()->NUM;

 Amazon Web Services Provides Paid Alexa API

   Service Highlights

Gather information about web sites, including historical web traffic data, contact information, related links and more. Access historical web traffic data for web sites to analyze growth and understand the effects of specific events on web site traffic Build a web directory into your web site or service using an Alexa API enhanced DMOZ-based browse service Access the list of sites linking to any given site

Using AWS Alexa API we can get

      URL Information

      Historical Web Traffic

      Sites Linking In

       Browse Category

AWS Alexa API Pricing

Pay only for what you use. There is no minimum fee, and no start-up cost.

Up to 1,000 requests/ month – Free

1,001 to 1,000,000 requests/ month –  $0.00045 per request

Over 1,000,000 requests/ month – $0.00030 per request

For more info on Alexa API Alexa AWS API.

New Post has been published on http://www.sevenkb.com/sql-interview-questions/sql-interview-questions/

SQL Interview Questions

1. What is SQL ? SQL is Structured Query Language pronounced as SEQUEL. SQL language is used to communicate to Many Databases.

New Post has been published on http://www.sevenkb.com/google-adsense/how-to-check-your-google-adsense-ad-code-is-correct-if-your-ads-are-blank/

How to check your google adsense ad code is correct if your ads are blank

During the approval process for AdSense for content ads, your ad units will be blank until you’ve completed the review step.

If you’ve placed your ad unit near or within the content of your page, the other content will shift to make room for the ad unit, in the ad unit size that you selected.

When you highlight the entire content of the page (e.g., CTRL+A on Microsoft Windows, or ⌘+A on a Mac), the blank ad units will be visible as selected — again, in the size of the ad unit that you selected.

  For More Details Visit: Google Adsense Help

New Post has been published on http://www.sevenkb.com/html/css-text-transform-property-make-the-first-character-to-uppercase-in-css/

CSS text-transform Property , make the first character to uppercase in css

CSS text-transform Property is explained bellow, we have a paragraph with some text, now we will see how we can use CSS text-transform Property.

<p>This is sevenkb.com blog.</p>

we can do it with eliment id or class also by adding  text-transform property in style. Convert paragraph text to UPPERCASE

p       text-transform: uppercase; 

Result : UPPERCASE

<p> THIS IS SEVENKB.COM BLOG </p>

  Convert paragraph text to lowercase

p       text-transform: lowercase; 

  Result : lowercase

<p> this is sevenkb.com blog </p>

  Convert paragraph text  first letter of every word to UPPERCASE or CAPITALIZE

p       text-transform: capitalize; 

Result : Capitalize (First Letter Of Every Word To Capital Letter)

New Post has been published on http://www.sevenkb.com/html/how-to-convert-all-text-in-div-to-uppercase-using-css-text-transform-property/

How to convert all text in DIV to uppercase using CSS text-transform property

  We can conver all text to UPPERCASE by using  text-transform property CSS. CSS text-transform property that was introduced in CSS1

Example we have a div having some text.

<div>  Sevenkb.com is Trusted Technology Resource for Tutorials, References, Examples. </div> 

Add following css code to convert above div full text to UPPERCASE , you can do it with eliment id or class also by adding  text-transform property in style. if you make text-transform to input text eliment all text entering in that input eliment are convert in to uppercase automatically

If you want to convert to lowercase simply add text-transform property to lowercase.

div       text-transform: uppercase; 

Now Result will be:

New Post has been published on http://www.sevenkb.com/jquery/how-to-disable-all-html-form-elements-within-a-div-tag-using-jquery/

How to disable or enable all html form elements within a DIV tag using JQuery

We can disable all html form elements within a DIV tag using JQuery

If you want to Enable all eliments simply replace true with false in the following code.

Consider we have a form in DIV and DIV id is “form_box”

Now following code will disable all INPUT elements in the form located in that DIV

$('#form_box :input').attr('disabled', true); //Disabled all input

Now following code will disable all SELECTelements in the form located in that DIV

  $('#form_box :select').attr('disabled', true); //Disabled

Now following code will disable all SUBMIT elements in the form located in that DIV

New Post has been published on http://www.sevenkb.com/jquery/how-to-submit-an-html-login-form-on-button-click-using-jquery/

How to submit an HTML Login Form on button click using JQuery

for example we have a Login form with ID “login_form” now we nee to submit this form on click of a Button with ID “submit_btn”  , following example explain.

Form:

<form id="login_form" action="login.php">   <input type="text" name="username" id="username" /> <input type="password" name="password" id="password" />   <input type="button" id="submit_btn" value="Login" /> </form>

  jQuery form submit:

Now with bellow code if we click on button it will trigger button onclick function which will submit the Login form.

New Post has been published on http://www.sevenkb.com/jquery/how-to-check-and-uncheck-a-html-checkbox-using-jquery/

How to check and uncheck a html checkbox using JQuery

You can check or uncheck a checkbox element or a radio button using the .prop() or .attr() methods both examples given bellow.

The difference between attributes and properties can be important in specific situations. Before jQuery 1.6, the .attr() method sometimes took property values into account when retrieving some attributes, which could cause inconsistent behavior. As of jQuery 1.6, the .prop() method provides a way to explicitly retrieve property values, while .attr() retrieves attributes.

We will assume that we have checkbox or raidio button with id “myoptions”

check or uncheck a checkbox or radio button element using .attr() method , Replace Id myoptions with your checkbox or radio button id or class.

$('#myoptions').attr('checked','checked'); // checked

$('#myoptions').removeAttr('checked'); // uncheck

check or uncheck a checkbox or radio button element using .prop() method , Replace Id myoptions with your checkbox or radio button id or class. .prop() is best to use.

$( "#myoptions" ).prop( "checked", true ); // checked

$( "#myoptions" ).prop( "checked", false); // uncheck

.attr changes the attributes for that html tag.

.prop changes a property for the html tag as per the DOM tree.

As the example in this link suggests. An input field can have the attribute “value”. This will equal the default value you entered. If the user changes the value in the input field, the property “value” changes in the DOM Tree, but the original attribute is left remaining.

New Post has been published on http://www.sevenkb.com/php/how-to-redirect-a-non-www-url-to-a-www-url-using-the-htaccess-file/

How to Redirect a Non www URL to a www URL using the .htaccess file

How to create a 301 redirect to redirect a non www URL to a www URLusing the .htaccess file?

Open Notepad and save name as .htaccess in web directory where all your website files are located.

Add the following code to .htaccess file

  RewriteEngine On RewriteCond %HTTP_HOST ^domain.com$ RewriteRule ^/?(.*)$ "http\:\/\/www\.domain\.com\/$1" [R=301,L]

  Replace domain.com with your website domain name.

3. save .htaccess file in your website home directory

4. If some one enters domain.com it will redirects to http://www.domain.com