"I suggest you go to etrm.oracle.com and search there. You may find an API that you can use. Also, support.oracle.com is another good place to search."
The social network for Oracle people
-
Ram Sharan Mittal
- Male
- Bangalore
- India
- Blog Posts
- Discussions (3)
- Events
- Groups
- Featured Photos
- Photo Albums
- Featured Videos
Ram Sharan Mittal's Discussions
getting project and taks for a employee
1 Reply
Hi,I am trying to get all project for a employee whose user_name(in) is employee id with following query:SELECT PALL.SEGMENT1, PALL.NAME FROM APPS.PA_PROJECT_ASSIGNMENTS PASS ,APPS.PA_PROJECTS_ALL…Continue
Started this discussion. Last reply by Eddie Awad Nov 5, 2012.
username password not working from query but working from browser
2 Replies
In Oracle Time and Labor, we are using employee number and password(employee no: 201456 password: 201456_password). If I go to e business suite in web browser it works fine but if I try select…Continue
Tags: Oracle, time, and, labor, login
Started this discussion. Last reply by Ram Sharan Mittal Nov 4, 2012.
Gifts Received
Ram Sharan Mittal has not received any gifts yet
Ram Sharan Mittal's Page
Latest Activity
Ram Sharan Mittal posted a discussiongetting project and taks for a employee
Hi,I am trying to get all project for a employee whose user_name(in) is employee id with following query:SELECT PALL.SEGMENT1, PALL.NAME FROM APPS.PA_PROJECT_ASSIGNMENTS PASS ,APPS.PA_PROJECTS_ALL PALL WHERE pass.project_id = pall.project_id ANDPASS.RESOURCE_ID IN (SELECT RESOURCE_ID FROM APPS.PA_RESOURCES_DENORM WHERE PERSON_ID IN (SELECT PERSON_ID FROM APPS.PER_ALL_PEOPLE_F WHERE EMPLOYEE_NUMBER= '205172'));and following query for getting assign taskSELECT * FROM APPS.PA_TASKS WHERE…See More
Ram Sharan Mittal replied to Ram Sharan Mittal's discussion username password not working from query but working from browser"thanks, help me a lot."
Eddie Awad replied to Ram Sharan Mittal's discussion username password not working from query but working from browser"The function fnd_web_sec.validate_login accepts a username and a password. It looks like you're passing the employee ID as the username. You should pass a user name that exist in fnd_user.
Instead of using fnd_web_sec.validate_login, which is…"
Ram Sharan Mittal posted a discussionusername password not working from query but working from browser
In Oracle Time and Labor, we are using employee number and password(employee no: 201456 password: 201456_password). If I go to e business suite in web browser it works fine but if I try select fnd_web_sec.validate_login('201456 , '201456_password') from dual it is returning N.Please guide methanks in advanceSee More
Profile Information
- About Me:
- Novice oracle e-business suite OTL developer
Comment Wall
- No comments yet!
© 2013 Created by Eddie Awad.
