Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
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.
Font in RDF
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 lessHow to get Column Names from a Table in Oracle
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“.
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
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 lessRead Only Status Monitor function
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 lessINV_ITEM_CATEGORY_PUB.update_category_assignment API returned status ‘E’ but without error message
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:
Flexfield – Item Categories
Now retest the API again.
See lessWhat are GL Tables in Oracle APPS R12
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:
Queries and Description of each GL Table:
E37: No write since last change (add ! to override) how to solve
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:
APP-FND-01388: Cannot Read Value For Profile Option FND_DEVELOPER_MODE In Routine &ROUTINE On Asset Workbench
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 lessPO Approval Error: Line # 1 Schedule # 1 Distribution # 1 The Accounting date is not in an open encumbrance period
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 lessHow do I get nth sting from comma delimiter string
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:
Result:
How to check if List empty or null in C#
Check if the list is empty in C# You can check whether the list is empty or not in many ways. The first approach is to check for null, and if the count is greater than zero Example: if (strList != null && strList.Count > 0) { Console.WriteLine("The List has " + strList.Count + " reRead more
Check if the list is empty in C#
You can check whether the list is empty or not in many ways.
Example:
Output:
Example:
Output:
Do you find it helpful? Share to Spread Knowledge
See less