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 ...
Projects 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 lessOracle Alert Error – APP-ALR-04150 –
Hello @mahendra try this code now : SELECT DISTINCT PAA.ABSENCE_ATTENDANCE_ID ,PAA.ABSENCE_ATTENDANCE_TYPE_ID ,PAA.ABS_INFORMATION1 ,PAA.PERSON_ID ,PAPF.FULL_NAME FNA ,PAPF.EMAIL_ADDRESS EM ,PAA.REPLACEMENT_PERSON_ID ,PAPF1.FULL_NAME FNR ,PAA.AUTHORISING_PERSON_ID ,PAPF2.FULL_NAME FNAUT ,PAA.DATE_NORead more
Hello mahendra try this code now :
SELECT DISTINCT PAA.ABSENCE_ATTENDANCE_ID ,PAA.ABSENCE_ATTENDANCE_TYPE_ID ,PAA.ABS_INFORMATION1 ,PAA.PERSON_ID ,PAPF.FULL_NAME FNA ,PAPF.EMAIL_ADDRESS EM ,PAA.REPLACEMENT_PERSON_ID ,PAPF1.FULL_NAME FNR ,PAA.AUTHORISING_PERSON_ID ,PAPF2.FULL_NAME FNAUT ,PAA.DATE_NOTIFICATION ,PAA.DATE_START ,'\ \\\\\\for a period of \\\\\\\' || PAA.ABSENCE_DAYS || '\\\\\\\ days up to\\\\\\\' ,PAA.DATE_END INTO &ABSENCE_ATTENDANCE_ID ,&ABSENCE_ATTENDANCE_TYPE_ID ,&ABS_INFORMATION1 ,&PERSON_ID ,&FULL_NAME ,&EMAIL_ADDRESS ,&REPLACEMENT_PERSON_ID ,&FULL_NAME ,&AUTHORISING_PERSON_ID ,&FULL_NAME ,&DATE_NOTIFICATION ,&DATE_START ,&ABSENCE_DAYS ,&DATE_END FROM PER_ABSENCE_ATTENDANCES PAA ,PER_ALL_PEOPLE_F PAPF ,PER_ALL_PEOPLE_F PAPF1 ,PER_ALL_PEOPLE_F PAPF2 WHERE 1 = 1 AND PAA.ABSENCE_ATTENDANCE_ID = 132128 AND PAA.PERSON_ID = PAPF.PERSON_ID AND PAA.REPLACEMENT_PERSON_ID = PAPF1.PERSON_ID(+) AND PAA.AUTHORISING_PERSON_ID = PAPF2.PERSON_ID(+) AND TRUNC (SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE AND TRUNC (SYSDATE) BETWEEN PAPF1.EFFECTIVE_START_DATE AND PAPF1.EFFECTIVE_END_DATE AND TRUNC (SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE AND PAPF2.EFFECTIVE_END_DATEbut in the next time you create a question could you please leave more details about what you are trying to do or the error text along with error code you face to be able to help you efficiently.
See lessWhat is the difference between searched case and simple case in oracle pl/sql?
1 difference I can c is, when using case <expression> when ….(i.e simple case), u'll do an exact comparison (like a=b). e.g case <expression> when value1 then... when value2 then...etc (i.e ur checking if expression = value1 or expression = value2 & so on) for case when <expreRead more
1 difference I can c is, when using case <expression> when ….(i.e simple case), u’ll do an exact comparison (like a=b). e.g case <expression> when value1 then… when value2 then…etc (i.e ur checking if expression = value1 or expression = value2 & so on)
for case when <expression> then .. (i.e searched case), u’ll do at least 2 comparisons i.e >= x and <=y case when variable >= x & <=y then.. when variable between a and b then…
there may b other differences.. eager 2 know
See lessHow to list all OAF customizations of a particular instance ?
Hi @Chandra You can use this query to list all customizations across all modules SELECT PATH.PATH_DOCID CUSTM_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_DOC_PATH FROM JDR_PATHS PATH WHERE PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS WHERE COMP_SEQ = 0 ANDRead more
Hi Chandra
You can use this query to list all customizations across all modules
SELECT PATH.PATH_DOCID CUSTM_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_DOC_PATH FROM JDR_PATHS PATH WHERE PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization' AND COMP_ID IS NULL) ORDER BY CUSTM_DOC_PATH;and if you want to get only specific module you can use following query:
SELECT PATH.PATH_DOCID PERZ_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_DOC_PATH FROM JDR_PATHS PATH WHERE PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization' AND COMP_ID IS NULL) AND (JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID)) LIKE '%/ar/%' ORDER BY CUSTM_DOC_PATH;See lessWhat is the difference between i++ and ++i in Java?
They both increment the number with value 1 but but ++i increment the number before the current expression is evaluted, whereas i++ increment the number after the expression is evaluated for example int i=5; int z=i++; //z equals 5 here int x=++i; //x equals 6 here
They both increment the number with value 1
but but ++i increment the number before the current expression is evaluted, whereas i++ increment the number after the expression is evaluated
for example
int i=5;
int z=i++; //z equals 5 here
int x=++i; //x equals 6 here
See lessDifference between staticmethod and classmethod in python ?
Maybe a bit of example code will help: Notice the difference in the call signatures of foo, class_foo and static_foo: class A(object): def foo(self, x): print "executing foo(%s, %s)" % (self, x) @classmethod def class_foo(cls, x): print "executing class_foo(%s, %s)" % (cls, x) @staticmethod def statRead more
Maybe a bit of example code will help: Notice the difference in the call signatures of
foo,class_fooandstatic_foo:class A(object): def foo(self, x): print "executing foo(%s, %s)" % (self, x) @classmethod def class_foo(cls, x): print "executing class_foo(%s, %s)" % (cls, x) @staticmethod def static_foo(x): print "executing static_foo(%s)" % x a = A()Below is the usual way an object instance calls a method. The object instance,
a, is implicitly passed as the first argument.With classmethods, the class of the object instance is implicitly passed as the first argument instead of
self.You can also call
class_foousing the class. In fact, if you define something to be a classmethod, it is probably because you intend to call it from the class rather than from a class instance.A.foo(1)would have raised a TypeError, butA.class_foo(1)works just fine:One use people have found for class methods is to create inheritable alternative constructors.
With staticmethods, neither
self(the object instance) norcls(the class) is implicitly passed as the first argument. They behave like plain functions except that you can call them from an instance or the class:a.static_foo(1) # executing static_foo(1) A.static_foo('hi') # executing static_foo(hi)Staticmethods are used to group functions which have some logical connection with a class to the class.
foois just a function, but when you calla.fooyou don’t just get the function, you get a “partially applied” version of the function with the object instanceabound as the first argument to the function.fooexpects 2 arguments, whilea.fooonly expects 1 argument.ais bound tofoo. That is what is meant by the term “bound” below:With
a.class_foo,ais not bound toclass_foo, rather the classAis bound toclass_foo.Here, with a staticmethod, even though it is a method,
a.static_foojust returns a good ‘ole function with no arguments bound.static_fooexpects 1 argument, anda.static_fooexpects 1 argument too.And of course the same thing happens when you call
static_foowith the classAinstead.
See lesssource: stackoverflow
author: unutbu
How to find dbc file in oracle apps ?
Hello @chandra to find dbc file in release 11i $FND_TOP/secure and to find dbc file in release 12 $INST_TOP/appl/fnd/12.0.0/secure hope this help.
Hello Chandra
to find dbc file in release 11i
and to find dbc file in release 12
hope this help.
See less