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.
ORA-01427: single-row subquery returns more than one row
Hello Garcia, The message of the ORA error is so descriptive it's pointing the query that causing the issue and the issue it self which is nothing but the sub query returned more than one row and this is not correct specially that you are using "=" operator not logical operator like "IN" or "NOT IN"Read more
Hello Garcia,
The message of the ORA error is so descriptive it’s pointing the query that causing the issue and the issue it self which is nothing but the sub query returned more than one row and this is not correct specially that you are using “=” operator not logical operator like “IN” or “NOT IN”. It’s up to your requirement.
See lessPeformance of CST_CG_COST_HISTORY_V view too much slow
Hello Zulqarnain, The slowness you are facing is because of the vast amount of data inside the mtl_material_transactions table. In such cases, there is one check you can do before getting into the solution to avoid scanning all the data inside the table above. 1- Check the statistics whether it's upRead more
Hello Zulqarnain,
The slowness you are facing is because of the vast amount of data inside the mtl_material_transactions table. In such cases, there is one check you can do before getting into the solution to avoid scanning all the data inside the table above.
1- Check the statistics whether it’s up to date or not. To check this, run the query below:
compare the total number of rows on the table with the number returned from this query and check the last analyzed date.
Suppose you found the number of rows so little than the current one or last analyzed date is old; ask the DBA to submit a concurrent program called “Gather Table Statistics” to update the statistics. Then you can try your query again.
2- The second action is a workaround to avoid accessing all the data on the table MTL_MATERIAL_TRANSACTIONS by converting the column of the last price to be a subquery within your main query or to creating a function to return the last price for each inventory item within an organization. As you said, you are selecting only the price for each item.
I hope this answer helped you or gave you an insight.
See lessHassan
Query to Get The Oracle Application URL From Database in Oracle APPS R12
To find the application URL from the backend use one of the following queries : SELECT HOME_URL FROM ICX_PARAMETERS; Result http://<host.domain:port>/OA_HTML/AppsLogin OR SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTIONS FPO, FND_PROFILE_OPTION_VALUES FPOV WHERE FPO.PROFILE_OPTION_ID =Read more
To find the application URL from the backend use one of the following queries :
OR
See lessOBIEE 12c: External Embedded Content is Not Displayed (This content is blocked.)
Hello @Waqas , As explained here that for security reasons, you can no longer embed content from external domains in dashboards. To embed external content in dashboards, you must edit the instanceconfig.xml file. Note: You can accept embedding content from all external domains or from specific domaiRead more
Hello Waqas , As explained here that for security reasons, you can no longer embed content from external domains in dashboards. To embed external content in dashboards, you must edit the instanceconfig.xml file.
In case you need to embed an external content from all domains into your dashboard, so the DBA has to make the following changes in the presentation server :
Please do this on test environment first to make sure that everything is correct.
See lessIntegrate this dialog fonts to work in Oracle forms 12c
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 lessHow get wwwroot folder path from ASP.NET core
Any Help?
Any Help?
See lessORA-01017 invalid username password logon denied
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.
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 :
See lessORA-00976 Error While Approving Internal Requisitions ?
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 lessORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
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.
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.
See lessHow to get absolute value in java?
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 :
Best Regards.
See less