Posts

Showing posts from August, 2012

When respond a notification with smartphone item does not approved?

Image
Today a lot of process has a approval flow on ERP systems. I got a problem on Oracle E-Business Suite recently. When we approve a notification with computer (like outlook) or on worklist (oracle self service responsibility) it approved. We got no error. But when we give approve response with smartphone ( like blackberry or i-phone ) approve answer didn't come inbox folder on mail server. So po didn't approved. Then I run " Synchronize Workflow LOCAL tables" concurrent from sysadmin responsibilty and it solve the problem. You can get more information from  the following link. http://vivekrajendran.wordpress.com/2011/02/23/about-po-approval-and-workflow-notification-mailer-integration-with-blackberry/

Oracle EBS User & Responsibility İlişkisi

Image
Oracle E-Business Suite içerisinde hangi aktif kullanıcıya hangi sorumlulukların atalı olduğunu görmek isterseniz aşağıdaki sorgu size yardımcı olacaktır. Comment'lenmis satıralardan istediğinizi açarak ister kullanıcı adı, isterseniz sorumluluk adına göre arama yapabilrisiniz. SELECT     fuser.USER_NAME USER_NAME     , per.FULL_NAME FULL_NAME     , per.EMPLOYEE_NUMBER EMPLOYEE_NUMBER     , frt.RESPONSIBILITY_NAME RESPONSIBILITY FROM     FND_USER fuser     , PER_PEOPLE_F per     , FND_USER_RESP_GROUPS furg     , FND_RESPONSIBILITY_TL frt WHERE     fuser.EMPLOYEE_ID = per.PERSON_ID     AND fuser.USER_ID = furg.USER_ID     AND (to_char(fuser.END_DATE) is null         OR fuser.END_DATE > sysdate)     AND frt.RESPONSIBILITY_ID = furg.RESPONSIBILITY_ID     AND (to_char(furg.END_DATE) is null         OR furg.END_DATE > sysdate)     AND frt.LANGUAGE = 'US'     -- AND   fuser.USER_NAME   = 'P_USER_NAME'     -- AND   frt.RESPONSIBILITY_NAME RESPONSIBILITY  li