How to get distinct value for any column in value set.E.g Table is emp, to Type value set for job then in lov it has to display distinct job.

Bhaskar Bethi

• Aug 12th, 2011

select PERIOD_YEAR
from gl_periods
where rowid in (select max(rowid) from gl_periods group by
PERIOD_YEAR )
order by PERIOD_YEAR

Follow the same with required table.

sridutta

 Profile Answers by sridutta Questions by sridutta

• Dec 8th, 2008

Use select distinct column name from table instead of table name

Answer Question  Select Best Answer

What is the journal entry for Reversal?

Shweta P

• Aug 17th, 2011

Journal entry used to reverse accruals, estimates, errors or temporary adjustments. You can reverse the journal by assigning reversal period or reversal effective date to a journal entry which you...

Answer Question  Select Best Answer

Hi,while running reports in oracle applications ,i also Defined a Value Set With parameters. Moreover i have defined The Correct Mask for the date field in the properties of report & i got the following errors:APPLLCSP Environment Variable set to:Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are:American_America.UTF8'.,'ERR REP-0613 : Value Does Not Match Mask 'DD-MON-RR'ORA-018161...

Pullareddy Mukkamalla

• Aug 17th, 2011

Use the value set FND_STANDARD_DATE and in the user parameters defined in the report use the following as input mask against the date field.

RRRR/MM/DD HH24:MI:SS

Answer Question  Select Best Answer

Sunil Kaswan

• Aug 20th, 2011

Steps done in project creation 1.create project i.e. copy from existing projects. go to projects and you can create here , for key members and remaining things you can see the project which you are c...

Answer Question  Select Best Answer

How to join the tables in PO modules?

CP

• Sep 2nd, 2011

Following should work for standard POs "sql SELECT * FROM po_headers_all pha ,po_lines_all pla ,po_line_locations_all plla ,po_distributions_all pda WHER...

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

Hi! Any one can you send me the details and process of item conversion?1.What are the interface tables in item conversion?2.What are the base tables in item conversion?3.what are the validations and what is the standard program in item conv.?

sree

• Oct 1st, 2011

Oracle Apps process of item conversion and interface tables. Interface tables involved in Item Conversion: MTL_SYSTEM_ITEMS_INTERFACE Base Tables: MTL_SYSTEM_ITEMS MTL_PARAMETERS MTL_UNITS_O...

Madhu

• Jul 21st, 2011

BASE TABLE: MTL_SYTEM_ITEMS_B INTERFACE TABLE: MTL_SYSTEM_ITEMS_INTERFACE ERROR_TABLE :MTL_INTERFACE_ERRORS VALIDATIONS: ORGANIZATION IS VALID OR NOT MA...

Answer Question  Select Best Answer

Krishna

• Oct 21st, 2011

There are total 6 Types of Journals 1. Functional Journals, Where functional currency will be used. 2.Foreign Currency journals, where Foreign currency will be used. 3.Reversal Journals, this will be...

Pallavi

• Jul 21st, 2007

Seketon, formula and Standard JE are types of Recurring JE. The JE types are only five:1. Basic JE2. Importing from other subledgers3. Recurring4.Reversal5. Mass Allocation

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

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

How to create India localization setups?

raju

• Dec 3rd, 2011

Hi,

Please share R12 Indian locailzation setup and Procedural documetns to me.

Regards
Raju

raghu.nandana

 Profile Answers by raghu.nandana Questions by raghu.nandana

• Oct 4th, 2008

For this there is a diff module called India localization in that there are separate setup is the based on the tax, local area its depend for ex. in standard when you create an organization in India l...

Answer Question  Select Best Answer

How to run the GL posting through custom program?

Sarath

• Dec 14th, 2011

In two ways we can post the journals.

Journals> Post function will helps you to post specific journels or we have a request "Program - Automatic Posting", this program will post all the journals.

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Feb 12th, 2012

It is a part of Oracle Order Management Implementation. Seeded meaning initial data or pre-defined data provided with the system. Order Management sends invoices and credit memos to Receivables via t...

Answer Question  Select Best Answer

Prakash

• Jul 30th, 2011

Revaluation: adjusts asset or liability accounts that may be materially understated or overstated due to a significant fluctuation in the exchange rate between the time the transaction was entered...

Answer Question  Select Best Answer

Which attributes need to be checked in order to get the item in PO form?

PRAHASITH

• Jul 16th, 2012

Inventory
purchasing
bom
om

Answer Question  Select Best Answer

How to restrict the item in INV?

GANESH RONGALI

• Jul 16th, 2012

Dropshipment

teja

• Feb 23rd, 2012

Uncheck purchasing

Answer Question  Select Best Answer

Which table holds the Master Vs child Organization Details?

priyanka

• Aug 2nd, 2012

Mtl_parameters , ORG_ORGANIZATION_DEFINITIONS

priyanka

• Jul 31st, 2012

Mtl_system_items_b consists all master and child items details

Answer Question  Select Best Answer

What are the different types of accounting entries available in AP?

Vinod

• Oct 5th, 2012

As you know there are three types of items: Inventory Expense Item a) Create Receipt Inventory Receiving A/c Dr Accrual A/c Cr b) Receiving Transaction Expense A/c Dr Inventory Receiving...

Answer Question  Select Best Answer

What is the Item Revision?

Krishh

• Dec 26th, 2012

Item Revision:

Suppose we have an item and if it requires some changes or adding something like a new item/modification in the qty at that time we a Revision takes place called as Item Revision. It is stored in MTL_ITEM_REVISIONS.

Thanks,
Krishh

Answer Question  Select Best Answer

I am a CRM function consultant, is there any certifications available in oracle for oracle apps service modules such as field service,teleservice,depot repair,service contract & even want to know if there any certifications available on oracle apps sales & marketing.