Sunday, June 10, 2018

Is ancient India Over rated?

Is ancient India overrated ?
A mindblowing analysis by Chinese Ex Professor from University of Toronto

Tuesday, March 27, 2018

Flutter and Android : Error running Gradle flutter doctor --android-licenses

Got below error when running 1st app developed using Flutter and Android Studio SDK

Error running Gradle: 
Unable to download needed Android SDK components, as the following licenses have not been accepted: Android SDK Build-Tools 26.0.2

Ran below command as told in the log.
flutter doctor --android-licenses

Got below error.
sdkmanager --version failed: 1

Go to Android Studio and click on SDK Manager icon

Select version mention in the error and click on Apply

Once done run your application again.

Thursday, June 30, 2016

How to View Request Output Of Other Users

Set Profile Concurrent:Report Access Level for the user "Responsibility"

Setting this profile will allow you to see output submitted by other user in respective responsibility.

Reference :

Sunday, April 10, 2016

Oracle EBS Missing Responsibilities

In Oracle EBS 12.2.5 Oracle has provided Model Personalization feature. If you give incorrect Instance Name while creating Model Personalization for OAF Page OANavigatePortletAM  (Announcement) you may lose the Responsibility List.
If you see the error log, you may get errors like JBO-25005: Object name View Instance Name for type View Object is invalid

During Model Personalization JDR_ATTRIBUTES, JDR_COMPONENTS, JDR_PATHS tables gets updated.
You can find out your pesonalizations using below query.
Is There A Way To List All Personalizations In An Environment? (Doc ID 1332032.1)

jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
ORDER BY creation_date desc,PERZ_DOC_PATH;

If your Model Personalization is incorrect and JDR_ATTRIBUTES shows 'Activated' equal to 'Y' then there is no way you can fix this error from front end. First set 'Activated' equal to 'N'. Then you will be able to login into EBS successfully. Then you can go to  Model Personalization and delete it from the application.

Oracle E-Business Suite Release 12.2.5 Highlights

      In Aug 2015 Oracle released EBS    
      Below Video’s  shows Oracle E-Business Suite Release 12.2.5 Highlights

      Profile FND: Disable Navigator and Favorites Rich Menu setting it to False enables Global Navigator icon.

     With this profile setting you can get new cloud based look on EBS home page. Click on adds Favorite to add new forms as an apps

Sunday, February 28, 2016

Role Model / Strong Purpose or Desire Is Must to vision Your life

Kid who want to become cricketer, If you ask him who is your role model they will name Sachin Tendulkar in a fraction of second.

Kid who want to becone singer he will say Lata Mangeshkar, Kishor Kumar, Rafi.

Kid who want to become actor will say Amitabh Bacahan.

If someone want to make career in Investing there role model is Warren Buffet.

If someone want to become scientist therr role model is Einstine, Newton, Tesla and lot.

Where is the role model for BCom, BE students?
Most of the BCom student don't know what to do after BCom.

Those who are working as a clark, there is no role model for them because to become CFO you need to be CA or MBA.

Most of the people don't know who is role model  in there career stream of job. They lack the vision and they don't have anyone  who can show them where he can be if he follows his teaching, thinking,  ways to achive goals.

Every BSC, BCOM, BA, BE, MBBS, MBA student should have some role model or some desire to do something different, then only they can make progress in there life.

Otherwise after working few years into Industry they will get stuck at some level and will not be satisfied with there job.

So whether you are in college or college pass out identify your area of passion and find out who is role model into that area and have vision for life.

Friday, June 05, 2015

How to create Parameterzied View?

Here is the simplest way to create Parameterzied view.

CREATE OR REPLACE VIEW xxdd_mtl_serial_numbers
FROM mtl_serial_numbers
WHERE serial_number in ( USERENV ('client_info'));

exec dbms_application_info.set_client_info('49236920');

select * from xxdd_mtl_serial_numbers

Friday, January 09, 2015

ODI 12c RKM E-Business Suite does not pull Synonyms

When I ran RKM E-Business Suite in ODI to pull all %INTERFACE% tables it did not pull tables like MTL_SYSTEM_ITEMS_INTERFACE which is own by INV Schema.

If you run below query you can see that Oracle added # at the end in all_synonyms.table_name column for MTL_SYSTEM_ITEMS_INTERFACE#

select * from   all_synonyms where table_name  LIKE 'MTL%SYS%ITEM%INTERFACE%'

This was creating problem in all the RKM E-Business Suite queries which was using all_synonyms table.

After changing join t.table_name = syn.table_name to  t.table_name = rtrim(syn.table_name,'#') in RKM E-Business Suite Knowledge Module-->Task issue got resolved.