What is the difference between Attribute and Global Attribute in Oracle Apps

Pulkit

• Mar 31st, 2016

Descriptive flexfield configuration: A descriptive flexfield enables you to add two types of custom attributes to a page global and context sensitive. Global attributes are always available as fie...

DP

• Mar 2nd, 2016

Attribute columns on oracle tables are used for Descriptive Flexfields to enter additional information on a form. Global attributes are used for country specific information that is used in Oracle localization.

Answer Question  Select Best Answer

agouthaman

 Profile Answers by agouthaman Questions by agouthaman

• Feb 19th, 2010

Standard GL period types are Month, Quarter and Year. But User defined periods can also be used.

vmbv

• Nov 30th, 2005

Then come to Oracle Apps.It is best for u

Answer Question  Select Best Answer

naveen nagula

• Dec 12th, 2006

hi,CUSTOM.PLL is an library which exists in TEMPLATE.fmb ,it is an oracle form devloper PL/SQL library , which alows the developers to attach thier own custom code to the oracle applications without...

Bonthu N Reddy

• Feb 14th, 2006

         Custom Library allows extensions of oracle application modules with out modifying module code       Custom Library can fo...

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

In R122 we use to store supplier/customers data in different tables, where as In R12 Oracle has introduced TCA(Trading Community Architecture) which will bring both Supplier/Customer data under one umbrella(TCA).

All the data stored in HZ tables in R12.

Sridhar

• May 9th, 2013

HZ_ stands for human Zone

Answer Question  Select Best Answer

JIT

• Mar 26th, 2007

The Connection Manager manages the MPI listener (not the SQL*Net V2 listener process TNSLSNR) and data pumps for the MPI.   It also assigns each connection request dedicated by the MPI liste...

Srinivas Garnepudi

• Dec 1st, 2006

Hooks.if you are looking for the API Hooks, see the following detailsAPI HooksAPI User Hooks allow users to extend the business logic of the standardbusiness rules that are executed by APIs. This is d...

Answer Question  Select Best Answer

nayeem

• Jul 1st, 2016

What is the static table and dynamic table in Oracle? Please say What are the difference between 10g and 11g

Andy Noble

• Oct 25th, 2007

You can tell based on the TABLESPACE the table belongs to - this is the new Oracle Applications Tablespace Model (OATM)Run the following code to see:SELECT tablespace_name, table_nameFROM all_tablesWH...

Answer Question  Select Best Answer

waseem

• Oct 21st, 2011

You need to define independent values set for country and dependent for states on the independent values set(which you created for country).

Amit

• Sep 13th, 2011

Hi Kiran,
You need to define independent Value set for Country and dependent for States, on the independent value set(Which you created for Country). That will solve your issue.
Hope it is clear.
Regards,
Amit

Answer Question  Select Best Answer

raman av

 Profile Answers by raman av Questions by raman av

• Jun 12th, 2008

Differences between D2k Report and Apps Report(1) in D2k Report there is no fecility to schedule the program where as in Apps report we have that fecility(2) in D2k Report we can't use User-Exits ...

AMIT SONI

• Aug 15th, 2007

D2K reports and Oracle Reports basically have no difference the main difference between them is only that simple D2k report run in any environment and we always use Tables if we want to run a repo...

Answer Question  Select Best Answer

J. Diwakar reddy

• Mar 2nd, 2007

Why because 1) Is there any internal problem of your system.2) Another one is you didn't write procedure correctly.

Kranti Shah

• Feb 27th, 2007

APPLPTMP is a special directory used only for PLSQL temporary files.  When a concurrent program uses the FND_FILE package, the concurrent manager uses APPLPTMP as the directory to which it writes...

Answer Question  Select Best Answer

selvaspak

 Profile Answers by selvaspak Questions by selvaspak

• Dec 28th, 2010

ERRBUFF is used for display the error in the log file andRETCODE is used to decide the status of the concurrentthere are 3 types of RETCODE they are:-# 0 : Success# 1 : Warning# 2 : Error

amit_exl

 Profile Answers by amit_exl Questions by amit_exl

• Sep 12th, 2008

Common values passed by procedures in variable (ERRBUFF and RETCODE) are:ERRBUFF := SQLERRM;andRETCODE := ERRCODE;Thanks & RegardsAmit Gupta

Answer Question  Select Best Answer

Why we register a table in apps schema by using ad_dd.register_table procedure

jith_in

 Profile Answers by jith_in Questions by jith_in

• Feb 25th, 2010

We register the table using ad_dd for the sole purpose of using the same in flexfields and alerts.

VijayAkumalla

 Profile Answers by VijayAkumalla Questions by VijayAkumalla

• Nov 18th, 2008

We register a custom table in the custom schema. Then give all permissions to APPS schema. Reason being, when stored procedures or functions are written to perform DMLs on the custom table, it is done from APPS schema.

Answer Question  Select Best Answer

How can we restrict the duplicate records from table value set?

Goutham

• Aug 1st, 2017

By using the Distinct Command we can restrict duplicate records in table value set

Nilima

• Aug 17th, 2016

Please tell us the specific example.

Answer Question  Select Best Answer

How to define parameters from and to range in oracle apps reports and also at where condition from and to range of numbers

waseem

• Oct 21st, 2011

Based on your requirement like from data and for this take bind parameter while registering in concurrent program in parameter form give range low and high....

whenkat

• Sep 24th, 2011

Based on your requirement...like from_date and to_date for this take bind parameters... while registering in concurrent program...in parameter form...give range low and high....

Answer Question  Select Best Answer

Praveen

• Oct 6th, 2014

Organization is means inventory level..

org_id means operating unit level...

nilanjan de

• May 22nd, 2013

Organization id is mainly related to Inventory Organization and Org_id is belongs to Operating Unit. whenever we are doing any transaction based on different inventory organization in the business tha...

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

We will set the org by using "MO_GLOBAL.SET_POLICY_CONTEXT(S,101)" in reports in R12.

kvijay5924

 Profile Answers by kvijay5924 Questions by kvijay5924

• Mar 6th, 2012

In 11i
BEGIN
FND_CLIENT_INFO.SET_ORG_CONTEXT(204);
END;

Answer Question  Select Best Answer

There is parent frame and for that parent frame there is child frame, suppose child field is placed in parent frame what message you will get.

Debasmita Sur Dam

• Jul 17th, 2015

REP-1213: Field XXX references column YYY at a frequency below its group. Actually the repeating frame frequency is equal to your group frequency. So the field of parent repeating frame is placed in c...

venu

• Jun 27th, 2014

Frequency below group/abouve group

Answer Question  Select Best Answer

What is the difference between MTL_SYSTEM_ITEMS_B and
MTL_SYSTEM_ITEMS_KFV?

Poonam

• Jun 14th, 2017

_b is the item master table and _kfv is the flex field view where we can get the concatenated segments

NITIN

• Nov 3rd, 2015

B is Base table and KFV Key Flex Field Value

Answer Question  Select Best Answer

prasad

• Jun 2nd, 2014

Cross Validation Rule:Rules that define valid combinations of segment values a user can enter in an account. Cross-validation rules restrict users from entering invalid combinations of account segment...

audiresri

 Profile Answers by audiresri Questions by audiresri

• Feb 25th, 2009

Security rules is nothing but restrict the user to enter invalid accounting values means we are restricting the to enter manually. If dynamic insert is on is checked then we can define the security r...

Answer Question  Select Best Answer

prashant

• Sep 21st, 2011

P2p PROCURE TO PAY CYCLE

Amit

• Sep 13th, 2011

Hi Soumya, P2P(Procure to pay Cycle): 1. Requisition 2. RFQ(Request for Quotation) 3. Quotation 4. PO(Purchase Order) 5. Receiving 6. Invoicing 7. Validation of Invoice 8. Accounting of Invoice 9. Pay...

Answer Question  Select Best Answer

kader_bathusha

 Profile Answers by kader_bathusha Questions by kader_bathusha

• May 14th, 2008

Template is predefine , future purpose like expenses template,or quick codes ,Token is unique no every user entering orcle gateway  used owen token same thing any problam or issuse share probalm ...

knarender

 Profile Answers by knarender Questions by knarender

• Jun 27th, 2007

Template.fmb is a predefined standard form ,which is having 21 libraries to support oracle application structureToken is a field in the parameter window  of a concurrent program which is used to map concurrent program parameter with the report builder  bindvariable.

Answer Question  Select Best Answer