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.
This promise is immense; every day and every night, we are trying our best to fulfill it by helping others, leaving something worthwhile behind us, and living for a purpose that is "Enrich & Spread knowledge everywhere".
How to Find Queries Running For More than 5 Minutes
To find the queries running for more than 5 or x of minutes you can try the below query and change the seconds parameter as per your need: Query: SELECT S.USERNAME ,Q.SQL_ID ,ROUND (S.LAST_CALL_ET, 2) TIME_IN_SECONDS ,ROUND (S.LAST_CALL_ET / 60, 2) TIME_IN_MINS ,S.SID ,Q.SQL_TEXT FROM GV$SESSION S,Read more
To find the queries running for more than 5 or x of minutes you can try the below query and change the seconds parameter as per your need:
Query:
Output:
Note: 300 is (5*60). change it as you want to.
See lessQuery to get posted AP invoice in Oracle APPS R12
There is a seeded standard function provided from oracle to identify whether the invoice is posted or not. Which is (AP_INVOICES_PKG.GET_POSTING_STATUS) . This function take the invoice_id parameter and return one of four values: 'Y' - Posted 'N' - Unposted 'S' - Selected 'P' - Partially Posted ThesRead more
There is a seeded standard function provided from oracle to identify whether the invoice is posted or not. Which is (AP_INVOICES_PKG.GET_POSTING_STATUS) .
This function take the invoice_id parameter and return one of four values:
‘Y’ – Posted
‘N’ – Unposted
‘S’ – Selected
‘P’ – Partially Posted
These values is the invoice posting status flag.
Example:
Output:
INVOICE_NUM
————————————————–
INVOICE_POSTING_FLAG
——————————————————————————–
ERS-9163-109073
Y
19879-781
N
ERS-4400-109091
Y
ERS-9164-109093
P
ERS-6970-109094
Y
ERS-6971-109095
See lessY
Directory Object vs BLOB
It depends on the number and size of files you want to store. If you have a small amount of files you can store them into the database however, the database size will get bigger by time. On the other side the directory you can assign a specific space you need based on your size of the files and youRead more
It depends on the number and size of files you want to store. If you have a small amount of files you can store them into the database however, the database size will get bigger by time. On the other side the directory you can assign a specific space you need based on your size of the files and you can leverage other advantages like to open the file write into it and so on.
This a brief and for sure there are other benefits for each option but hopefully my answer give you a little insight.
See lessFont 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 less