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 ...
APP_SPECIAL
Hi, APP_SPECIAL Program unit (Package) is a part of APPCORE.pll library, so if you open APPCORE.pll or APPCORE2.pll on oracle form builder you will find the source code of APP_SPECIAL inside. Note: APPCORE2.pll is a duplicate of APPCORE.pll, however APPCORE2.pll is shared a cross custom.pll while APRead more
Hi,
APP_SPECIAL Program unit (Package) is a part of APPCORE.pll library, so if you open APPCORE.pll or APPCORE2.pll on oracle form builder you will find the source code of APP_SPECIAL inside.
Note: APPCORE2.pll is a duplicate of APPCORE.pll, however APPCORE2.pll is shared a cross custom.pll while APPCORE.pll is referenced inside the standard forms itself. So whenever we want to use APPCORE inside custom.pll we have to use APPCORE2 not APPCORE
Regards.
See lessHow to delete concurrent program in oracle apps from front end ?
Hi Maram, You can`t delete by the front end, but by the back end; The API call to delete Concurrent Program fnd_program.delete_program (l_prog_short_name, l_appl_full_name); The API call to delete Executable fnd_program.delete_executable (l_exec_short_name, l_appl_full_name);
Hi Maram,
You can`t delete by the front end, but by the back end;
The API call to delete Concurrent Program
fnd_program.delete_program (l_prog_short_name, l_appl_full_name);
The API call to delete Executable
fnd_program.delete_executable (l_exec_short_name, l_appl_full_name);
See lessValueError: invalid literal for int() with base 10: ” Python 3
The error message invalid literal for int() with base 10 would seem to indicate that you are passing a string that's not an integer to the int() function . In other words it's either empty, or has a character in it other than a digit. You can solve this error by using Python isdigit() method to checRead more
The error message invalid literal for int() with base 10 would seem to indicate that you are passing a string that’s not an integer to the int() function . In other words it’s either empty, or has a character in it other than a digit.
You can solve this error by using Python isdigit() method to check whether the value is number or not. The returns True if all the characters are digits, otherwise False .
if val.isdigit():
The other way to overcome this issue is to wrap your code inside a Python try…except block to handle this error.
Python2.x and Python3.x
Sometimes the difference between Python2.x and Python3.x that leads to this ValueError: invalid literal for int() with base 10 .
With Python2.x , int(str(3/2)) gives you “1”. With Python3.x , the same gives you (“1.5”): ValueError: invalid literal for int() with base 10: “1.5”.
See lessIndexError: list index out of range in python
Hi, this happens because you have specified wrong index number here is the example of how this error are raised: alphabet=[‘a’,’b’,’c’];print(alphabet[3]) IndexError: list index out of range in above example we want to to print the last element in the list which is ('c'), but we have passed the wronRead more
Hi,
this happens because you have specified wrong index number here is the example of how this error are raised:
alphabet=[‘a’,’b’,’c’];print(alphabet[3])
IndexError: list index out of range
in above example we want to to print the last element in the list which is (‘c’), but we have passed the wrong index number because the correct one is print(alphabet[2]).
that’s because list index starts with 0 not with 1
This example have been taken from this article here
you can refer to it for better understanding.
I hope this will help you.
See lessPython new line
Hi you can use "/n" like this example: myString = "I likenPython Programming Language" file.write(myString) result is: I like Python Programming Language
Hi
you can use “/n” like this example:
result is:
See lessWhat is FNDLOAD Commands to Download and Upload Concurrent Program ?
Hi @albert FNDLOAD to download concurrent program from the source instance: FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="INV" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM_SHORT_NAME" FNDLOAD to upload concurrent program to dRead more
Hi albert FNDLOAD to download concurrent program from the source instance:
FNDLOAD to upload concurrent program to destination instance:
Notes:
See lessProjects tables in oracle apps r12
Hi @KenDonald Most common used oracle projects tables & views are : 1.PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. 2.PA_TASKS stores user-defined subdivisions of project work. Tasks can be broken down into multiple levels of subtasks. 3.PA_PROJECT_TYPES ImplementaRead more
Hi kenDonald
Most common used oracle projects tables & views are :
1.PA_PROJECTS_ALL
stores the highest units of work defined in Oracle Projects.
2.PA_TASKS
stores user-defined subdivisions of project work. Tasks can be broken down into multiple levels of subtasks.
3.PA_PROJECT_TYPES
Implementation-defined project classifications that supply default information and drive some project processing.
4.PA_PROJECT_PLAYERS
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
5.PA_AGREEMENTS_ALL
Customer contracts that serve as the basis for work authorization
6.PA_BUDGET_VERSIONS
stores the versions of project budgets. There are three categories of budget versions: Draft, Baselined, and Original.
7.PA_BUDGET_LINES
stores the detail information of a project or task budget, including the resource, time period and budget amounts entered. The time period may be PA period, GL period, or any user-defined period.
8.PA_DRAFT_REVENUES_ALL
Stores information about draft revenue generated for projects
9.PA_DRAFT_REVENUE_ITEMS
stores the lines of a draft revenue.
10. PA_DRAFT_INVOICES_ALL
Information about draft invoices generated for projects.
11. PA_DRAFT_INVOICE_DETAILS_ALL
Inter company invoice details for cross charged transactions.
12. PA_CLASS_CATEGORIES
Implementation-defined categories for classifying projects.
13. PA_CLASS_CODES
Implementation-defined values within class categories that can be used to classify projects.
14. PA_EXPENDITURE_COST_RATES_ALL
Cost rates for non-labor expenditure types
15.PA_BILL_RATES_ALL
See lessInformation about bill rates and markups of standard bill rate schedules.
Note: this is not all the tables and views are available in oracle projects application, however this may help you to get a small insights about what are these tables ? and small description of each one.
Regards.
How to check if a list is empty Python?
use isempty()
use isempty()
See lessREP-52262 Diagnostic output is disabled when using oracle reports 11g
Hi @albert To fix this error, you will need to apply the following: Go to %DOMAIN_HOME%\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.#\configuration and open rwservlet.properties (make a backup first). Add the following parameter below the <inprocess> parameter: <!–webcommanRead more
Hi albert
To fix this error, you will need to apply the following:
- Go to %DOMAIN_HOME%\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.#\configuration and open rwservlet.properties (make a backup first).
- Add the following parameter below the <inprocess> parameter:
- <!–webcommandaccess>L1</webcommandaccess–>
- Then change the value from L1 to L2
- <webcommandaccess>L2</webcommandaccess>
- Save and close the file
- Restart WLS_REPORTS
See lessOperating Units Merge
Dear Isa, I hope you are having single instance, even under single instance unfortunately this is not possible in oracle, if you want to merge the LE it's like re-implementation. I came across one of the company (eprentise) who claim they "offers software for merging LEs. The reorganization softwareRead more
Dear Isa,
I hope you are having single instance, even under single instance unfortunately this is not possible in oracle, if you want to merge the LE it’s like re-implementation.
I came across one of the company (eprentise) who claim they “offers software for merging LEs. The reorganization software lets you move and merge Ledgers or Sets of Books, Operating Units,and Inventory Organizations. It takes care of all history and transactions in the subledgers.” (Sic)
You can connect with them @ http://www.eprentise.com
Best Regards,
Syed Mustafa Shah
See less