Sign Up

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In
Continue with Google
or use


Have an account? Sign In Now

Sign In

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Sign Up Here
Continue with Google
or use

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Continue with Google
or use

Forgot Password?

Need An Account, Sign Up Here

You must login to ask a question.

Continue with Google
or use

Forgot Password?

Need An Account, Sign Up Here

Sorry, you do not have permission to add post.

Continue with Google
or use

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Oraask Logo Oraask Logo
Sign InSign Up

Oraask

  • Write
    • Add A New Post
    • Ask A Question

Oraask Navigation

Search
Ask A Question

Mobile menu

Close
Ask A Question
  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
    • Oraask XML Formatter
    • Oraask JSON Formatter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials

Hassan AbdElrahman

MasterOracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
Ask Hassan AbdElrahman
1k Visits
29 Followers
0 Questions
Home/ Hassan AbdElrahman/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Polls
  • Asked Questions
  • Comments
  1. Asked: October 1, 2021In: Oracle Forms

    Integrate this dialog fonts to work in Oracle forms 12c

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on October 1, 2021 at 11:38 pm

    Hi, you can look into "WebUtil", because most of old features that available in "D2KUTIL" were converted to the web based utility by oracle. For more information about available functions in "WebUtil" and how to use them go to Oracle form builder online help from here Also another option if any funcRead more

    Hi, you can look into “WebUtil”, because most of old features that available in “D2KUTIL” were converted to the web based utility by oracle. For more information about available functions in “WebUtil” and how to use them go to Oracle form builder online help from here

    Also another option if any function not available in “WebUtil”, you would need to create your own Java Bean and use it inside your form.

    See less
      • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  2. Asked: February 19, 2020In: Oracle SQL

    ORA-01017 invalid username password logon denied

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on August 27, 2021 at 10:36 pm

    Please make sure of the credentials, because this error is quite clear enough that either the username or password is incorrect. Note : In Oracle 11g the credentials are CASE sensitive it's a default feature of newly oracle 11g database creation. Now if you want to make sure whether this feature isRead more

    Please make sure of the credentials, because this error is quite clear enough that either the username or password is incorrect.

    Note : In Oracle 11g the credentials are CASE sensitive it’s a default feature of newly oracle 11g database creation.

    Now if you want to make sure whether this feature is enabled or not you can go to sqlplus then execute the following SQL command.

    SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

    if you get ” TRUE ” value then the the password is case sensitive otherwise it isn’t.

    you can also disable this feature by executing the following SQL command :

    SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;
    
    System altered.
    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  3. Asked: October 3, 2018In: Oracle EBS SCM

    ORA-00976 Error While Approving Internal Requisitions ?

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on August 27, 2021 at 10:24 pm

    In most cases this error is coming due to the location value is incorrect. for example you have location_id = 100 , location_code = AE while expecting " UNITED ARABEMIRATES " value. follow this step to include the country inside address information of a location : 1- Open location form. from Setup -Read more

    In most cases this error is coming due to the location value is incorrect.

    for example you have location_id = 100 , location_code = AE while expecting ” UNITED ARABEMIRATES ” value.

    follow this step to include the country inside address information of a location :

    1- Open location form. from Setup –> Organization –> Locations

    2- Query about the location above.

    3- Update the address information to include the Country, then save.

    Now try to approve your internal requisition.

    Please test this solution on test environment first. once everything is working fine then move it to appropriate environment.

    See less
      • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  4. Asked: August 26, 2021In: Oracle SQL

    ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on August 26, 2021 at 11:32 pm
    This answer was edited.

    ORA-00054 referring to the table you are trying to update it is already locked by another session that made a query for an update on the same table and not committed or rolled back yet. It could be a form or another session. The action you could take to solve the problem is to commit or roll back thRead more

    ORA-00054 referring to the table you are trying to update it is already locked by another session that made a query for an update on the same table and not committed or rolled back yet. It could be a form or another session.

    The action you could take to solve the problem is to commit or roll back the changes from the other session, causing the lock before performing the current action. There is a query also to help you identify which session that causing the lock on your table so that you can kill the session immediately.

    SELECT S.USERNAME
    ,S.SID
    ,S.SERIAL#
    ,T.USED_UBLK
    ,T.USED_UREC
    ,RS.SEGMENT_NAME
    ,R.RSSIZE
    ,R.STATUS
    FROM V$TRANSACTION T
    ,V$SESSION S
    ,V$ROLLSTAT R
    ,DBA_ROLLBACK_SEGS RS
    WHERE S.SADDR = T.SES_ADDR
    AND T.XIDUSN = R.USN
    AND RS.SEGMENT_ID = T.XIDUSN
    ORDER BY T.USED_UBLK DESC;

    Above query has been taken from oracle-base then from the output of above query you can use SID and SERIAL# to kill the session by executing the following statement.

    alter system kill session 'sid,serial#' IMMEDIATE;  
    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  5. Asked: April 26, 2020In: Java

    How to get absolute value in java?

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on August 11, 2021 at 1:25 am

    Firstly what is absolute value ? it's basically the number value regardless of it's sign so for example if we have a -5 number. So the absolute value of it is 5 without the sign. try below example on any editor to get clear idea : double doubleVar = -130.63; int intVar = 931; double doubleVar2 = 64.Read more

    Firstly what is absolute value ?

    it’s basically the number value regardless of it’s sign so for example if we have a -5 number. So the absolute value of it is 5 without the sign.

    try below example on any editor to get clear idea :

    double doubleVar = -130.63;
    int intVar = 931;
    double doubleVar2 = 64.11;
    System.out.println("absolute value of a: "+Math.abs(doubleVar));
    System.out.println("absolute value of b: "+Math.abs(intVar));
    System.out.println("absolute value of c: "+Math.abs(doubleVar2));

    The output of above example is :

    the absolute value of doubleVar: 130.63
    the absolute value of intVar: 931
    the absolute value of doubleVar2: 64.11

    Best Regards.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  6. Asked: August 9, 2021In: Oracle Application Framework - OAF

    JBO-25058: Definition Attribute10 of type Attribute not found in XXPickSlipVO

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on August 11, 2021 at 1:14 am

    Hello @Ovilia, Such an error could happen because other regions or items are using the same attribute10. Still, when deleting the VO or removing it from the application module, it won't change the dependencies automatically. The solution is to find the region that utilizing this VO and delete the whRead more

    Hello Ovilia,

    Such an error could happen because other regions or items are using the same attribute10. Still, when deleting the VO or removing it from the application module, it won’t change the dependencies automatically. The solution is to find the region that utilizing this VO and delete the whole region and recreate it again. It will solve your problem.

    regards.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  7. Asked: July 9, 2021In: Oracle EBS Financial

    Is this PA_CUSTOMERS_ALL table name available in Oracle EBS R12

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on July 13, 2021 at 10:57 pm

    Hi, There is a table called "PA_PROJECT_CONTACTS" its used to stores customer representatives involved with projects. Check this table it might help. The second idea would be to create an event alert on the customer address table once changed you can update the address that resides on the project byRead more

    Hi,

    There is a table called “PA_PROJECT_CONTACTS” its used to stores customer representatives involved with projects. Check this table it might help. The second idea would be to create an event alert on the customer address table once changed you can update the address that resides on the project by passing the new address ID. for sure the update process should be from standard API.

    Note : I didn’t tried this before, Just to give you an insight that might help you in this regard.

    Regards.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  8. Asked: August 9, 2016In: Oracle Application Framework - OAF

    oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: Could not find the specified responsibility.

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Replied to answer on June 7, 2021 at 9:34 pm

    is application developer responsibility assigned to the user in above property: username password try to give sysadmin user because sure this user has application developer responsibility

    is application developer responsibility assigned to the user in above property:
    username
    password
    try to give sysadmin user because sure this user has application developer responsibility

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  9. Asked: August 9, 2016In: Oracle Application Framework - OAF

    oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: Could not find the specified responsibility.

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on June 5, 2021 at 5:06 pm
    This answer was edited.

    Hello Sri Harsha, First thing this happened only when trying to run a custom page from JDeveloper on your local machine. So this will not happen if you register and upload the page to the server. I use APPLICATION DEVELOPER responsibility under the FND application in the development phase, and everyRead more

    Hello Sri Harsha,

    First thing this happened only when trying to run a custom page from JDeveloper on your local machine. So this will not happen if you register and upload the page to the server.

    I use APPLICATION DEVELOPER responsibility under the FND application in the development phase, and everything works fine. Please see the screenshot below:

    Jdeveloper project properties

    Also, don’t forget to enter the user that has application developer responsibility.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  10. Asked: February 4, 2021In: Oracle EBS Queries

    Query to get all inventory periods for a specific organization

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on May 31, 2021 at 8:58 pm
    This answer was edited.

    Hello @Waqas, You can use the following query to get inventory periods with it's status for one or more inventory organization also there is a condition hashed for period name if you want to query about particular period. you just need to un hash the condition. SELECT OOD.ORGANIZATION_CODE,OAP.PERIORead more

    Hello Waqas,

    You can use the following query to get inventory periods with it’s status for one or more inventory organization also there is a condition hashed for period name if you want to query about particular period. you just need to un hash the condition.

    SELECT OOD.ORGANIZATION_CODE
    ,OAP.PERIOD_NAME
    ,OAP.OPEN_FLAG
    ,X.MEANING
    FROM ORG_ACCT_PERIODS OAP, ORG_ORGANIZATION_DEFINITIONS OOD, MFG_LOOKUPS X
    WHERE OAP.ORGANIZATION_ID = OOD.ORGANIZATION_ID
    AND OOD.ORGANIZATION_CODE = ('&ORG_CODE')
    --AND UPPER (OAP.PERIOD_NAME) = UPPER ('&PERIOD_NAME')
    AND X.LOOKUP_TYPE(+) = 'MTL_ACCT_PERIOD_STATUS'
    AND X.ENABLED_FLAG(+) = 'Y'
    AND X.LOOKUP_CODE(+) =
    DECODE (NVL (OAP.PERIOD_CLOSE_DATE, SYSDATE), OAP.PERIOD_CLOSE_DATE, DECODE (OAP.OPEN_FLAG, 'N', DECODE (OAP.SUMMARIZED_FLAG, 'N', 65, 66), 'Y', 4, 'P', 2, 4), 3)
    ORDER BY OOD.ORGANIZATION_CODE;

     

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
1 … 4 5 6 7 8 … 17

Sidebar

Adv 250x250

Explore

  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
    • Oraask XML Formatter
    • Oraask JSON Formatter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials

Footer

Oraask

About

Oraask is a website for developers and software engineers who want to learn new skills, share their knowledge, and solve their coding problems. Oraask provides free content on various programming languages and topics, such as Oracle, Python, Java, etc. Oraask also allows users to ask questions and get answers from other members of the community.

About Us

  • About Us
  • Contact Us

Legal Stuff

  • Privacy Policy
  • Terms & Conditions

Follow

Oraask is licensed under CC BY-NC-SA 4.0Oraask CopyrightOraask CopyrightOraask CopyrightOraask Copyright

© 2019 Oraask. All Rights Reserved
With Love by Oraask.