You Will Never Get Stuck Again!
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".
Join 15000+ Exceptional
Latest Python Wiki's
Python isdigit vs isnumeric vs isdecimal
Python deals with a wide variety of data types. This includes numbers, strings, objects, etc. We generally treat the digits, numerals, and decimals as different names of the same entity. However, in Python, there are significant differences between ...
Python Program to Check Prime Number using While Loop
Prime numbers are an essential concept in mathematics and computer science. They are numbers that are only divisible by 1 and themselves. In this article, we will explore the concept of prime numbers and learn how to write ...
How 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 lessJBO-25058: Definition Attribute10 of type Attribute not found in XXPickSlipVO
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 lessIs this PA_CUSTOMERS_ALL table name available in Oracle EBS R12
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 lessQuery to get all inventory periods for a specific organization
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.
See lessWhich one do better performance NOT IN vs NOT EXISTS ?
Hi @Maran Firstly It’s not about the difference in performance only because they are not the same when dealing with nulls in the data. for example, we want to check how many employees are not managers of other employees by using NOT IN SELECT COUNT (*) FROM EMPLOYEES WHERE EMPLOYEE_ID NOT IN (SELECTRead more
Hi Maran Firstly
It’s not about the difference in performance only because they are not the same when dealing with nulls in the data.
for example, we want to check how many employees are not managers of other employees by using NOT IN
the result will be :
This means all employees are managers in this case.
let’s then take the same example but using NOT EXISTS
the result will be :
So here, out of 101 employees, there are 89, not managers.
The most crucial thing is NULL represented in the manager_id column for the first employee 101 (Steven King). So wherever null is there while using NOT IN or IN, the evaluation of the inner query will be either FALSE or NULL and will return no records.
So now, when it comes to performance, it depends on the amount of data that both subquery and the outer query returns. If they are small, then IN is typically more appropriate. And vise versa. But remember, we have assumed that there are no nulls in the subquery result.
Regards
See lessHow to select a random row in SQL& MySQL?
Hi Sam I don't know what the case you need this to, but anyway you can use the following query to get random row from employees table as an example. 1- Oracle : SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM = 1 2- MySQL : SELECT column FROM table ORDER BY RAND() LIMRead more
Hi Sam
I don’t know what the case you need this to, but anyway you can use the following query to get random row from employees table as an example. 1- Oracle :
2- MySQL :
The idea here in both examples is to get all rows in employees table but in random orders then using ROWNUM in Oracle and LIMIT clause in MySQL to return one row from them.
See less