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 Program to Check Prime Number using While Loop
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 ...
Python Delete Variable: How to Free Up Memory Space in Your Code
Python Delete Variable: How to Free Up Memory Space in Your Code
Introduction: Python is a popular programming language used in a variety of applications, from data analysis to web development. One ...
How to Swap Characters in String in Python – 3 Techniques
How to Swap Characters in String in Python – 3 Techniques
Swapping the string is one of the most commonly used operations by programmers. The string is a data type to store the text ...
Latest Data Visualization Wiki's
Python Pandas Date: Parsing, Arithmetic, and Resampling
Python Pandas Date: Parsing, Arithmetic, and Resampling
Pandas is one of the most popular libraries of Python. This data visualization library deals with the operations related to data. In data ...
Exploring Python Pandas Options: Your Data Power Tool
Exploring Python Pandas Options: Your Data Power Tool
Pandas is a trendy Python library used for data analysis. One of the essential features of data analysis is the options system. This ...
Python Pandas Join: Where Datasets Converge
Python Pandas Join: Where Datasets Converge
Introduction The topic of Python Pandas join is crucial for data manipulation and analysis. It is a process of ...
Latest Java Wiki's
Java Variable Types: Are You Using Them Correctly?
Java Variable Types: Are You Using Them Correctly?
Introduction Programs manage data stored in memory. On the machine level, data can only be called by the numeric ...
Java Data Types: The Basics Explained
Java Data Types: The Basics Explained
Introduction Each variable in Java must have a data type. There are several Java data types available. The type determines ...
Java Arrays
Java Arrays
Introduction An array is a set of members. Each member can contain an object or primitive value. Arrays in Java ...
Latest Oracle Wiki's
How to Convert Decimal to Hexadecimal in Oracle SQL
How to Convert Decimal to Hexadecimal in Oracle SQL
Introduction Are you struggling to convert decimal numbers to hexadecimal in Oracle SQL? Don't worry; you are not alone. ...
How to Create Table with Foreign Key in Oracle
How to Create Table with Foreign Key in Oracle
Introduction If you are working with large amounts of data in an Oracle database, you may have come across ...
ORA-01034: Oracle Not Available – What is it, Causes, and How to Resolve
ORA-01034: Oracle Not Available – What is it, Causes, and How to Resolve
Oracle databases are widely used in the industry; sometimes, you may encounter errors when working with them. One such error is the ORA-01034 ...
Latest JavaScript Wiki's
Easily Convert Decimal to Hex in JavaScript Today
Easily Convert Decimal to Hex in JavaScript Today
As a developer, knowing how to work with different numeral systems is essential. One such system is hexadecimal, which is commonly used in ...
JavaScript Variables
JavaScript Variables
What are JavaScript variables? Variables are simply containers where we can store values. You can simply place the values in ...
JavaScript Syntax
JavaScript Syntax
Introduction In HTML documents and webpages JavaScript can be included in two ways. One way is to include the JavaScript ...
ORA-12015: cannot create a fast refresh materialized view from a complex query
Hello Albert, generally this the explanation for that error : ORA-12015: cannot create a fast refresh materialized view from a complex query Cause: Neither ROWIDs and nor primary key constraints are supported for complex queries. Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETERead more
Hello Albert,
generally this the explanation for that error :
ORA-12015: cannot create a fast refresh materialized view from a complex query
Cause: Neither ROWIDs and nor primary key constraints are supported for complex queries.
Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple
materialized view.
also to Diagnosing ORA-12015 fast refresh materialized view / complex queries that’s depend on the database version there is some restrictions ex:
Oracle10g – 10.2
——————–
Fast refreshable materialized views must be based on master tables, master materialized views, or synonyms of master tables
or master materialized views. Complete refresh must be used for a materialized view based on a view.
for further details about diagnosing refer to : Note.179466.1
hope this helpful.
See lessWhat is FNDLOAD command to migrate Messages from one instance to another ?
Hi, here is download and upload messages by FNDLOAD DOWNLOAD Command: FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_MESSAGE_NAME.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='SQLGL' MESSAGE_NAME=XX_MESSAGE_NAME UPLOAD Command: FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/Read more
Hi,
here is download and upload messages by FNDLOAD
DOWNLOAD Command:
UPLOAD Command:
Don’t forget to change message name and application short name.
Regards.
See lessUnable To Finally Close Purchase Ordes or Blanket Releases Because of Error: APP-PO-14160
While reversal amounts are calculated, the Final_amt field is updated. This can be null when final_amt is already null. you can refer to Document : Doc ID 1990193.1 to find the solution.
While reversal amounts are calculated, the Final_amt field is updated. This can be null when final_amt is already null.
you can refer to Document : Doc ID 1990193.1 to find the solution.
See lessIs it Possible to Migrate Blanket PO’S in Closed Status Like Standard PO’S?
Hi, Where you need to migrate exactly ? and if their status's is closed why you need them ? Regards.
Hi,
Where you need to migrate exactly ? and if their status’s is closed why you need them ?
Regards.
See lessrep-14015 : beforereport unkhown user exit fnd ?
The USER EXITS are specific to Applications. Try to check the report in builder by commenting those srw exits
The USER EXITS are specific to Applications. Try to check the report in builder by commenting those srw exits
See lessHow to remove duplicate rows by where condition ?
you can use : [code] SELECT * FROM test_table WHERE number_col NOT IN (SELECT number_col FROM test_table GROUP BY number_col HAVING count (*) > 1) [/code]
you can use :
[code]
See lessSELECT *
FROM test_table
WHERE number_col NOT IN (SELECT number_col
FROM test_table
GROUP BY number_col
HAVING count (*) > 1)
[/code]
Fatal Error EXCEPTION ACCESS VIOLATION (0xc0000005) when trying to run WEB (PIA) Server
this may be because of java compatibility, so try to delete all the Java files and cleaned the %PATH% and installed it again.
this may be because of java compatibility, so try to delete all the Java files and cleaned the %PATH% and installed it again.
See lessWould you use flashback query to synchronize two schemas as of a certain point in time?
there is two options here : a) use serializable or read only isolation - the database would be consistent. b) use flashback query themselves - mandate that you set undo_retention to "X" and then they can just flashback and get a read consistent version of the database back "X" units in time. anythinRead more
there is two options here :
a) use serializable or read only isolation – the database would be consistent.
b) use flashback query themselves – mandate that you set undo_retention to “X” and then they can just flashback and get a read consistent version of the database back “X” units in time.
anything else does not really make sense. To synchronize the two scheme’s (using flashback) would mean a big bump and grind – AND – would prove that the data they need is flashback queryable – meaning, they didn’t need to copy it, it already exist.
See lessHow do I append an object to an array in JavaScript?
Use the push() function to append to an array:[code]// initialize array var arr = [ "Adam", "panju", "keri" ];// append new value to the array arr.push("oraask");console.log(arr);[/code]Will print["Adam", "panju", "keri", "oraask"]
Use the push() function to append to an array:
[code]// initialize array
var arr = [
“Adam”,
“panju”,
“keri”
];
// append new value to the array
arr.push(“oraask”);
console.log(arr);[/code]
Will print
See lessHow to to check old and new values for item in Oracle Form ?
to get the database value there is one property (database_value) and here is the example to achieve this: [code] BEGIN IF :BLOCK.ITEM = GET_ITEM_PROPERTY('BLOCK.ITEM', database_value) THEN RETURN; END IF; END; [/code] sometimes this property return value (0) if so you can use another way : -take theRead more
to get the database value there is one property (database_value) and here is the example to achieve this:
[code]
BEGIN
IF :BLOCK.ITEM = GET_ITEM_PROPERTY(‘BLOCK.ITEM’, database_value) THEN
RETURN;
END IF;
END;
[/code]
sometimes this property return value (0) if so you can use another way :
-take the value in the pre text item trigger and keep it in global
– as about this value in when validate item trigger and so on
hope this may help you 🙂
See less