Windows |Rotate your display

August 4, 2014

 

Once in a while, awkwardly you press a combination of keys and all of sudden your display is upside down or either by right or left side and you are baffled without an idea how to bring it back to the normal position? Here is the magic key combination

CTRL+ALT+UP Arrow Key (Normal position)

image

Try the following ones

  1. CTRL+ALT+Down Arrow key (Inverted/upside down)
  2. CTRL+ALT+Left Arrow Key (Taskbar by your right side vertical)
  3. CTRL+ALT+Right Arrow Key (Taskbar by your left side vertical)

Enjoy

rajesh


Android | Google PlayStore “No Connection”

July 11, 2014

 

I’m not an Android guy yet, but I have unmatched faith in Google search Smile

Today my daughter’s friends brought a touchmate 7” tab to me, complaining the Google play store doesn’t work. I didn’t have a clue, and my very second Google search brought me to the correct solution. Solution was something we hardly think of at the first place.

Those kids changed the system date and time to a past one! Reconfiguring the system date and time to the current resolved the issue.

Google should have better and meaningful error messages for such important components of Android system! What you think?

for Windows7bugs

rajesh


Educational | Download old question papers from “Annamalai” university portal

July 11, 2014

 

Navigation –> Your favorite browser

http://annamalaiuniversity.ac.in/

Click on “DDE” (Refer attached image below)

image

Now point mouse to “Academic Activities” –> “Old Question Papers”

image

Now you can start downloading the question papers

Select a semester from the left-hand side listing, easily locate your course from the listing using ctrl+f (Search as there are hundreds of courses listed) and start downloading

image

image

image

I can’t remember the portal being so simple earlier, anyway, it is never too late to have the things organized Smile

for Windows7bugs

 

rajesh


10 ways to be more efficient in the new Visio | Re-Blogged //Microsoft reference

July 1, 2014

Using Visio 2013? Well below link should make your life bit easier

  1. Move/Reshape/Resize etc
    1. http://blogs.office.com/2012/09/25/10-ways-to-be-more-efficient-in-the-new-visio/
  2. Edit/Rotate Text etc
    1. http://office.microsoft.com/en-001/visio-help/add-edit-move-or-rotate-text-on-shapes-HA102749355.aspx

 

for Windows7bugs

 

rajesh


Oracle Payroll | R12 | Simple view for employee paid salaries

June 19, 2014

 

Recently I were requested to build a report by the HR/Payroll team, running which they can generate the salary paid details for employees. Ie, a tabular listing with paid month, and total salary earned, grouped by year factor

0046

I found the request being one of the toughest, as my exposure to Payroll module and base tables was limited almost none, other than knowing the person and assignment tables and views!

Gradually I started going through the custom reports developed by our implementer and restructured few of their custom functions into a best possible view what meets our current requirements. As we are not using customized packages for the salary calculations, you should able to alter the below SQL and create your own with almost no efforts. We hope you will enjoy the solution!

Script for view

CREATE OR REPLACE VIEW XXEMPLOYEE_SALARIES_MONTHLY
AS
SELECT pap.person_id, pap.employee_number,to_char(ppa.date_earned,'Mon-YYYY') earned_month,
TO_NUMBER(to_char(ppa.date_earned,'MM')) MONTH_NUMBER,
TO_NUMBER(to_char(ppa.date_earned,'YYYY')) YEAR_FACTOR,
 sum(to_number(prrv.result_value)) PAID_AMOUNT
 FROM PAY_ELEMENT_TYPES_F petf
   ,PAY_INPUT_VALUES_F pivf
   ,PAY_PAYROLL_ACTIONS ppa
   ,PAY_ASSIGNMENT_ACTIONS paa
   ,PAY_RUN_RESULTS prr
   ,PAY_RUN_RESULT_VALUES prrv
   ,PER_ALL_ASSIGNMENTS_F paaf
   ,PER_ALL_PEOPLE_F pap
   ,PAY_ELEMENT_CLASSIFICATIONS pec
WHERE 1=1
  AND pec.classification_id = petf.classification_id
 and prrv.input_value_id = pivf.input_value_id
AND CLASSIFICATION_NAME IN ('Earnings','Supplemental Earnings')--Add in more based on your setup
  and pivf.name in ('Pay Value')
  AND petf.element_type_id = prr.element_type_id
  AND paa.assignment_action_id = prr.assignment_action_id
  AND prr.run_result_id = prrv.run_result_id
  AND petf.business_group_id = 81
  AND ppa.business_group_id = pap.business_group_id
  AND ppa.payroll_action_id = paa.payroll_action_id
  AND SYSDATE BETWEEN TRUNC(petf.effective_start_date) AND TRUNC(petf.effective_end_date)
  AND last_day(ppa.date_earned) BETWEEN TRUNC(pap.effective_start_date) AND TRUNC(pap.effective_end_date)
  AND last_day(ppa.date_earned) BETWEEN TRUNC(paaf.effective_start_date) AND TRUNC(paaf.effective_end_date)
  AND paaf.assignment_id = paa.assignment_id
  AND paaf.person_id = pap.person_id
 --and prrv.result_value > '0'
  AND paaf.business_group_id = pap.business_group_id
 AND pap.business_group_id = 81--double check
 GROUP BY pap.person_id,pap.employee_number, to_char(ppa.date_earned,'Mon-YYYY'),to_char(ppa.date_earned,'MM'),to_char(ppa.date_earned,'YYYY')
UNION ALL
SELECT  pap.person_id, pap.employee_number,to_char(ppa.date_earned,'Mon-YYYY') earned_month,
TO_NUMBER(to_char(ppa.date_earned,'MM')) MONTH_NUMBER,
TO_NUMBER(to_char(ppa.date_earned,'YYYY')) YEAR_FACTOR,
nvl(sum(to_number(prrv.result_value)),0)*-1  PAID_AMOUNT
                     FROM PAY_ELEMENT_TYPES_F petf
                                                 ,PAY_INPUT_VALUES_F pivf
                           ,PAY_PAYROLL_ACTIONS ppa
                            ,PAY_ASSIGNMENT_ACTIONS paa
                            ,PAY_RUN_RESULTS prr
                           ,PAY_RUN_RESULT_VALUES prrv
                           ,PER_ALL_ASSIGNMENTS_F paaf
                           ,PER_ALL_PEOPLE_F pap
                           ,PAY_ELEMENT_CLASSIFICATIONS pec
                    WHERE 1=1
                                    AND pec.classification_id = petf.classification_id
                  and prrv.input_value_id = pivf.input_value_id
                  AND CLASSIFICATION_NAME IN ('Voluntary Deductions','Involuntary Deductions','Social Insurance')--Add in more based on your setup
                  and pivf.name in ('Pay Value')
                               AND petf.element_type_id = prr.element_type_id
                  AND paa.assignment_action_id = prr.assignment_action_id
                  AND prr.run_result_id = prrv.run_result_id
                               AND ppa.business_group_id = pap.business_group_id
                  AND ppa.payroll_action_id = paa.payroll_action_id
                AND SYSDATE BETWEEN TRUNC(petf.effective_start_date) AND TRUNC(petf.effective_end_date)
  AND last_day(ppa.date_earned) BETWEEN TRUNC(pap.effective_start_date) AND TRUNC(pap.effective_end_date)
  AND last_day(ppa.date_earned) BETWEEN TRUNC(paaf.effective_start_date) AND TRUNC(paaf.effective_end_date)
                AND paaf.assignment_id = paa.assignment_id
                  AND paaf.person_id = pap.person_id
    --              and prrv.result_value > '0.00'
                    AND paaf.business_group_id = pap.business_group_id
                    AND pap.business_group_id = 81--double check
                  GROUP BY pap.person_id,pap.employee_number, to_char(ppa.date_earned,'Mon-YYYY'),to_char(ppa.date_earned,'MM'),to_char(ppa.date_earned,'YYYY')
 order by 2,5,4;

Sample Query

SELECT PERSON_ID, EMPLOYEE_NUMBER,earned_month,year_factor,
 SUM(PAID_AMOUNT) PAID_SALARY
 FROM XXEMPLOYEE_SALARIES_MONTHLY
 WHERE
 1=1
 AND EMPLOYEE_NUMBER =:P_EMPLOYEE_NUMBER
 AND YEAR_FACTOR BETWEEN NVL(:P_START_YEAR,YEAR_FACTOR) AND NVL(:P_END_YEAR,YEAR_FACTOR)
 GROUP BY PERSON_ID,EMPLOYEE_NUMBER,earned_month,YEAR_FACTOR, MONTH_NUMBER
 ORDER BY YEAR_FACTOR, MONTH_NUMBER

Enjoy another quality post from us guys :)

for Windows7bugs

rajesh


Oracle Applications | Making references to fnd_message package from custom PL/SQL library

May 22, 2014

 

Until recent times I didn’t have a single idea that, fnd_message package was NOT a database, instead PL/SQL library object, through which forms based modules were calling various elements like

fnd_message.set_string

fnd_message.show

image

image

One of the main reasons for believing the same was as soon as I type the name of the package, both Toad  and SQL Developer identify it as already existing object!

However, few days back I decided to shed my laziness and to revamp the core retailing application I have developed two years back, using Oracle’s public APIs for Order Management & Inventory modules.

Hence, I started designing my own PL/SQL libraries and bit the bullet while trying to make a reference to fnd_message package. The call was returning errors (please refer the below image)

image

Which forced me to start googling for relevant and dependable pointers towards this particular situation and came across a forum thread where one person who I respect as a “geek” tried to explain why there is a package in the database and within an PL/SQL library with the same “fnd_message”, and gradually giving it up saying “Only oracle could explain why”

Hence I opened up the Template form and try to see which attached PL/SQL library has the listing for fnd_message component calls

image

image

and the PL/SQL library “FNDSQL” attached to the TEMPLATE.fmb by default has all the components referenced with the forms modules. Once identified, I attached the same library with my custom library

image

and the next compilation attempt was successful!

I do hope, this information is useful to few others out there, who are trying to call the fnd_message package references with their own custom PL/SQL libraries.

regards,

rajesh


File Manager, File Picker for Windows Phone 8.1

May 11, 2014

 

Update: If you create your own folders in your phone using Windows Explorer, the same may not be listed under “Phone folders” service provider. We guess the API what provided by Microsoft restricts the access to a pre-defined list of folders as listed below

  1. Pictures
  2. Music
  3. Videos
  4. documents
  5. downloads
  6. ringtones

Anything other than the listed above, ie, folders created by the phone user will not be listed or available to attach with “Pocket File Manager” app!

 

I recall the furious arguments and personal level attacks over Microsoft tech forums about missing file manager over Windows Phone platform until recent days & joe belfiore during reddit AMA got all excited when one of the participants shot a question about “File manager”

joeredditama

We “heard” about it earlier, through some leaks, didn’t ? Anyway, the official app for the file explorer should be available by the end of May 2014, and the speculations are that, the file explorer will be bundled along with “OneDrive” application. let us wait and see how the implementation is going to happen.

Meanwhile let us assess couple of third party applications what are already available for managing your files (Music/Video/Documents/Downloads) in your phone!

During next few days we will be analyzing

  1. Pocket File Manager(Paid, you can try)
  2. Pocket Explorer(Paid, you can try)

apps which are already available in the Windows Phone store. We already bought Pocket File Manager (PFM as widely called by techies) and had few hands on exercises and very much pleased with the end results.

wp_ss_20140511_0001

We opted to keep the “Warning” (Should it be called as “Quick help”?) appearing each time while the app is restarted

wp_ss_20140511_0002

When the app is initially used, the “Root” has it’s own file system called “Local storage” with few sample folders and files. We will not be digging much into it as our primary aim is to see “what else we could do with the file manager”. The below image shows the couple of “Phone folders” we have added to the app by following instructions. Touch the + button and, you will be provided two options

“add image”(Capitalization standards)? Winking smile

“Add Provider”

wp_ss_20140511_0003

Now you can select a provider from total seven (7) available right now as on while this document is prepared (this list could grow with later versions)

For our exercise we will select “Phone folder” and proceed

wp_ss_20140511_0004

Once the “Phone Folder” selected, you will be provided a windows listing available Phone folders what you can attach with this little wonderful app!

wp_ss_20140511_0005

Now touch the folder name you want to attach with the app and touch the done (tick) button!

wp_ss_20140511_0006

The app may say the folder is empty, just ignore and complete the activity

wp_ss_20140511_0007

Touch the folder name you just attached with the app and wait few seconds…and the file listing starts building up! You can use the refresh button if you think the listing was not done completely (which is almost a never happening case)

wp_ss_20140511_0008

 

The beauty with such a listing is, you can almost do all file manipulations against the chosen file!

Have a look at the features

wp_ss_20140511_0010

wp_ss_20140511_0011

wp_ss_20140511_0012

So, if you were eager for a file manager, you may don’t have to wait until May 2014, you can start exploring the possibilities of these applications which will not burn holes in your pockets and start managing your files as you wished until recent days.

 

We hope you enjoyed another quality post from windows7bugs

for windows7bugs

rajesh


Follow

Get every new post delivered to your Inbox.

Join 48 other followers