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


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

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.

Forgot Password?

Need An Account, Sign Up Here

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

Sorry, you do not have permission to add post.

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
  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials

Walaa Mohamed

Junior
Ask Walaa Mohamed
47 Visits
3 Followers
0 Questions
Home/ Walaa Mohamed/Followers Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Polls
  • Asked Questions
  • Followed
  • Favorites
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. Asked: January 12, 2018In: Oracle Ebs Api’s

    It’s possible to call an oracle API from custom schema ?

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Replied to answer on November 17, 2022 at 8:27 pm

    All custom objects should resides on the custom schema like tables, sequences. when it comes to procedures and functions if they will read from the custom objects we have to create it on the custom schema. but if you have a procedure that calls standard API this procedure should be created on APPS sRead more

    All custom objects should resides on the custom schema like tables, sequences. when it comes to procedures and functions if they will read from the custom objects we have to create it on the custom schema. but if you have a procedure that calls standard API this procedure should be created on APPS schema.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  2. Asked: September 15, 2022In: Oracle Reports

    Font in RDF

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on September 18, 2022 at 12:37 am
    This answer was edited.

    I am wondering why to use a report builder template to create a PDF report layout while you have the XML publisher with all its facilities and the ease to design any template using MSWord. But generally, the update of the character set shouldn't have any impact on the report layout or output. Also,Read more

    I am wondering why to use a report builder template to create a PDF report layout while you have the XML publisher with all its facilities and the ease to design any template using MSWord.

    But generally, the update of the character set shouldn’t have any impact on the report layout or output. Also, is this issue exists in all reports or only in this report? try to delete this repeating frame or create a new one, the same as the one that has the issue, and observe the new one.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  3. Asked: August 17, 2022In: Oracle SQL

    How to get Column Names from a Table in Oracle

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on August 17, 2022 at 1:35 am
    This answer was edited.

    To get the list of columns of a table in Oracle, we use to query the view "USER_TAB_COLUMNS" to get the columns of the tables or views owned by the current user. Or use the other view "USER_TAB_COLS". SELECT table_name ,column_name ,data_type ,data_length ,nullable ,data_default FROM user_tab_columnRead more

    To get the list of columns of a table in Oracle, we use to query the view “USER_TAB_COLUMNS” to get the columns of the tables or views owned by the current user. Or use the other view “USER_TAB_COLS“.

    SELECT table_name
    ,column_name
    ,data_type
    ,data_length
    ,nullable
    ,data_default
    FROM  user_tab_columns
    WHERE table_name = '&YOUTABLENAME'
    ORDER BY column_id;

    in the above query, we selected 7 columns to retrieve the most important information that you might be looking for in table columns which are

    • table names: the table name.
    • column name: column name.
    • data type: column data type like varchar2, number, etc.
    • data length: the value length.
    • nullable: whether the table accepts the null value or not.
    • data_default: whether the column has a default value or not.

    Note: you have to specify the table name parameter in uppercase.

    Note 2: If you use the above view, you will get all unhidden columns, but if you query the view “USER_TAB_COLS” you will get all columns, including hidden columns.

    Another view is “ALL_TAB_COLUMNS” this one is the same as “USER_TAB_COLUMNS” except that the “ALL_TAB_COLUMNS” view has a column called “OWNER” in which you can specify the owner of the table that you want to get its columns list.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  4. Asked: August 10, 2022In: Oracle E-Business Suite

    Read Only Status Monitor function

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on August 13, 2022 at 5:17 pm

    Yes, It's possible to achieve this by following these steps: 1- create a menu that has status monitor function and two other sub-menu, "Workflow Configuration tab" and "workflow administrator notification tab". 2- assign this menu to your responsibility. 3- create a grant through a functional adminiRead more

    Yes, It’s possible to achieve this by following these steps:

    1- create a menu that has status monitor function and two other sub-menu, “Workflow Configuration tab” and “workflow administrator notification tab”.

    2- assign this menu to your responsibility.

    3- create a grant through a functional administrator for your responsibility to all or specific users

    4- exclude the above two menus from the responsibility.

    That’s it.

    And for the detailed steps with screenshots, I will write an article to showcase this process step by step and will update this answer later on by leaving the article link.

    stay tuned 🙂

    See less
      • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  5. Asked: August 1, 2022In: Oracle Ebs Api’s

    INV_ITEM_CATEGORY_PUB.update_category_assignment API returned status ‘E’ but without error message

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on August 2, 2022 at 12:07 pm

    Sometimes this due to Item Categories Key flexfields needs to be recompiled. So, follow this steps to recompile Item Categories KFF: Go to System Administrator > Application > Flexfield > Key > Segments Query for: Flexfield - Item Categories Query or Select your KFF Structure Uncheck theRead more

    Sometimes this due to Item Categories Key flexfields needs to be recompiled.

    So, follow this steps to recompile Item Categories KFF:

    1. Go to System Administrator > Application > Flexfield > Key > Segments
    2. Query for:
      Flexfield – Item Categories
    3. Query or Select your KFF Structure
    4. Uncheck the option “Freeze Flexfield Definition” if it’s checked and then save (ctrl+s)
    5. Recheck the option “Freeze Flexfield Definition” and then save (ctrl+s)
    6. System throws a message that the flex-field is being recompiled.

    Now retest the API again.

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  6. Asked: July 29, 2022In: Oracle EBS Queries

    What are GL Tables in Oracle APPS R12

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on July 29, 2022 at 7:37 pm
    This answer was edited.

    The list of GL Table are: GL_LEDGER GL_JE_HEADERS GL_JE_LINES GL_CODE_COMBINATIONS GL_BALANCES GL_JE_BATCHES GL_IMPORT_REFERENCES GL_PERIODS GL_CURRENCIES GL_DAILY_RATES Queries and Description of each GL Table: gl_ledgers stores all ledger pieces of information. SELECT * FROM gl_ledgers; gl_je_headRead more

    The list of GL Table are:

    1. GL_LEDGER
    2. GL_JE_HEADERS
    3. GL_JE_LINES
    4. GL_CODE_COMBINATIONS
    5. GL_BALANCES
    6. GL_JE_BATCHES
    7. GL_IMPORT_REFERENCES
    8. GL_PERIODS
    9. GL_CURRENCIES
    10. GL_DAILY_RATES

    Queries and Description of each GL Table:

    • gl_ledgers stores all ledger pieces of information.
    SELECT * FROM gl_ledgers; 
    • gl_je_headers stores GL Journals Header Information.
    SELECT * FROM gl_je_headers;
    • gl_je_lines stores GL Journals Lines Information.
    SELECT * FROM gl_je_lines;
    • gl_ledgers stores GL code combination pieces of information.
    SELECT * FROM gl_code_combinations;
    • gl_balances Stores actual, budget, and encumbrance balances for detail and summary accounts.
    SELECT * FROM gl_balances;
    • gl_je_batches stores GL Journal Batches Informations.
    SELECT * FROM gl_je_batches;
    • gl_import_references is holding the reference keys between journals and sub-ledger transactions like AP&AR.
    SELECT * FROM gl_import_references;
    • gl_periods stores all GL period pieces of information like name, start date, and end date.
    SELECT * FROM gl_periods;
    • gl_currencies stores all GL the GL currencies pieces of information.
    SELECT * FROM gl_currencies;
    • gl_daily_rates stores all GL currencies’ Daily rates in the system.
    SELECT * FROM gl_daily_rates;
    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  7. Asked: July 26, 2022In: Linux

    E37: No write since last change (add ! to override) how to solve

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on July 27, 2022 at 4:30 am
    This answer was edited.

    Since you didn't change anything in the file, just exit the file using :q! Instead of :q In this way, you will exit the file without saving it. Discard the changes. For your further information: :q! : /* This Command is used to quit without save the changes */ :wq : /* This command is used to save tRead more

    Since you didn’t change anything in the file, just exit the file using :q! Instead of :q

    In this way, you will exit the file without saving it. Discard the changes.

    For your further information:

    :q! : /* This Command is used to quit without save the changes */
    :wq : /* This command is used to save the changes and then quit */
    :w : /* This command is used to save the changes */
    :q : /* This command is used to quit only */
    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  8. Asked: July 25, 2022In: Oracle EBS Financial

    APP-FND-01388: Cannot Read Value For Profile Option FND_DEVELOPER_MODE In Routine &ROUTINE On Asset Workbench

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on July 26, 2022 at 12:28 am

    Error Cause: The profile option FND:Developer Mode is set to Yes Solution: Set the profile option FND:Developer Mode to No If the developer mode is on, this verifies numerous coding standards and ensures that you can see detailed error messages for unexpected exceptions.  It is not recommended to usRead more

    Error Cause:

    The profile option FND:Developer Mode is set to Yes

    Solution:

    Set the profile option FND:Developer Mode to No

    If the developer mode is on, this verifies numerous coding standards and ensures that you can see detailed error messages for unexpected exceptions.  It is not recommended to use developer mode for a testing environment as all
    the code is not compliant to pass the developer mode coding standards.

    As reference from Doc ID 1513711.1

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  9. Asked: July 24, 2022In: Oracle EBS SCM

    PO Approval Error: Line # 1 Schedule # 1 Distribution # 1 The Accounting date is not in an open encumbrance period

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on July 25, 2022 at 3:03 am

    Error Cause: The PO distributions have a GL Date of a Closed period. Therefore, the error message "The Accounting date is not in an open encumbrance period" is correct. Solution: In order to approve the PO, do one of the following: a) Re-open the SEP-15 period, or b) Change the GL Date on the distriRead more

    Error Cause:

    The PO distributions have a GL Date of a Closed period. Therefore, the error message “The Accounting date is not in an open encumbrance period” is correct.

    Solution:

    In order to approve the PO, do one of the following:

    a) Re-open the SEP-15 period, or
    b) Change the GL Date on the distributions to a new date that is within an ‘Open’ period.

    The PO cannot be approved/reserved if the dates on the distribution do not fall within an open period.

    As reference from Doc ID 2076668.1

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  10. Asked: July 17, 2022In: Oracle SQL

    How do I get nth sting from comma delimiter string

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    Added an answer on July 17, 2022 at 1:24 pm

    You can use REGEXP_SUBSTR to find the nth specific string from comma delimiter string Example: SELECT REGEXP_SUBSTR ('Oraask,Google,yahoo,new,old,etc','[^,]+' , 1, 3) third_value FROM DUAL; Result: yahoo  

    You can use REGEXP_SUBSTR to find the nth specific string from comma delimiter string

    Example:

    SELECT REGEXP_SUBSTR ('Oraask,Google,yahoo,new,old,etc','[^,]+' , 1, 3) third_value
    FROM DUAL;

    Result:

    yahoo

     

    See less
      • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
1 2 3 4 … 17

Sidebar

Adv 250x250

Explore

  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
  • 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.