Trimbak Mahajan

• Jul 17th, 2006

1) create P_from_date and P_to_date are user bind parameters 2) Create LP_WHERE_CLS lexical parameter.3) Write below code in the After Parameter Form Trigger   If :p_from_date is not Nu...

user_pc

• Apr 11th, 2006

 To use a lexical parameter in the query of your data model, prefix it with a '&' (ampersand)example SELECT ename FROM emp WHERE &lp_lexical_valThe value of p_lexical_val may be set in th...

Answer Question  Select Best Answer

Manikandan.M

• Sep 11th, 2007

Yes we can use the view if you use multiorg view example (oe_order_headers)?then we need to set the operating unit for that view so we need to execute the following package before report triggerfnd_client_info.set_org_context(org_id);

Denzy

 Profile Answers by Denzy Questions by Denzy

• Feb 13th, 2006

Yes we can use a view.If the table on which the view is based is updated, we can call a procedure in the Before report trigger of the report to update the view and then retreive the data from the view...

Answer Question  Select Best Answer

Nitin Motghare

• Sep 26th, 2006

Hi,I Struck up with API used to Create a Value Sets Runtimely.Can u Help Me to know the name of API to Create a values Set Runtimely in Oracle AppsThanksNitin9823564113

Denzy

 Profile Answers by Denzy Questions by Denzy

• Feb 13th, 2006

set heading offset echo offSet pages 999set long 90000spool C:\TEMP\create_script.sqlselect dbms_metadata.get_ddl('VIEW','AP_INVOICES','APPS') from dual;spool off

Answer Question  Select Best Answer

rahul.gatade

 Profile Answers by rahul.gatade Questions by rahul.gatade

• Apr 13th, 2008

For Registering any PL/SQL stored Procedure as a concurrent program we need to include two mandatory parameters for that procedure,1) ERRBUF    OUT VARCHAR22) RETCODE OUT NUMBERThe 1st ...

Vijay Gurme

• Jun 21st, 2006

There are two two types of codes that arereturn while registering the PL/SQL procedureThese are 1) errbuf2)retcode

Answer Question  Select Best Answer

kashinath

• Aug 2nd, 2006

Hi, request sets holds a group of request in a particular sequence. the requests can be reports or procedures. by submitting a single request ,u can run many concurrent programs at once.

Bonthu N Reddy.

• Feb 13th, 2006

                Request sets define run and print options and possibly parameter values for a collection of reports or c...

Answer Question  Select Best Answer

kashinath

• Aug 2nd, 2006

There r 8 types of value sets,they r1. none2.pair3.special4.table5.translatable dependent6. translatable independent7.dependent8.independent

Amit Chintawar

• Mar 29th, 2006

Different types of Value sets are,1) Independant- This Value set contains list of values which does not depends on any other value2) Dependant- It contains values which ...

Answer Question  Select Best Answer

poojar

 Profile Answers by poojar Questions by poojar

• Mar 3rd, 2006

there are 8 types of valuesets in apps 11.5.9. they arenoneindependentdependenttabletranslated independenttranslated dependentspecialpairtrns independent and trns dependent are used for multilanguage support.--oraclehari@gmail.com

Manivannan .S

• Feb 21st, 2006

  The valueset are like how we define constraints in Oracle Database. In oracle Apps there are six value sets1. Independent - The Value which we provide to the Segments are independent (Ex. Compa...

Answer Question  Select Best Answer

Ajay Kunde

• Feb 21st, 2007

1. When you get MD050, first take some time to analyse the MD50 and understand the functionality of the report.2. See the layout given in MD050.3. Try to find out the Tables involved in that.4. Develo...

fanish

 Profile Answers by fanish Questions by fanish

• Aug 30th, 2006

Let me first tell you about MD50, it a functional document which we receive from Client for technical development MD70. MD50 defines the functional requirement of customization.Suppose if the MD50 say...

Answer Question  Select Best Answer

Guest

• Jun 11th, 2006

Import data from Legacy system to GL1> Trasnfer data from Legacy sytem to GL_INTERFACE table by creating PLSQL Procedure with related defined Source name in GL setups. 2> Open Standard form...

thomas

• Apr 22nd, 2006

1. Load the data in GL INTERFACE.2. Call Journal Import3. Call Journal PostingYou can do virtually all the above from a single PL/SQL package. This information is alo available in the GL trm, and help can be takn from the Oracle metalink.

Answer Question  Select Best Answer

fanish

 Profile Answers by fanish Questions by fanish

• Aug 30th, 2006

Errbuff Varchar2 and retcode Number-Fanish

Siva

• Jul 24th, 2006

 errbuf:This is out parameter which will through the error messges in to the log file.retcode: This is also out parameter,  it will tells the status of the concurrent program.if sucess it wi...

Answer Question  Select Best Answer

Bonthu N Reddy

• Jan 11th, 2007

Sql * plus, Pl/sql, Forms & Reports ( latest versions ) , Financial and Accounting  knowledge!!Thanks n Rgds,Bonthu N Reddy.,

Rupash

• Jul 3rd, 2006

SQL, PL/SQL, SQL Loader, Forms, Report

Answer Question  Select Best Answer

Bonthu Nagi Reddy

• Jan 11th, 2007

Once you define Request set you can only see or access that request set until you attach to any  responsiblity which has attached to any one !! In other words attach the request se...

Raju

• Oct 5th, 2006

Hi, You need to attach the request to responsibility. and the responsibility to the user. 

Answer Question  Select Best Answer

gajendra_nath

 Profile Answers by gajendra_nath Questions by gajendra_nath

• Sep 11th, 2008

TCA API's brought a fresh approach to standardise DML's in Oracle Apps. I think this is one of Oracle's best written modules in APPS, but the flaws that exist are primarily because Oracle developed TC...

anil

• Oct 4th, 2006

Trading Community Architecture (TCA) is a structure designed to support complex trading relationships within an organization. The TCA model revolves around the party concept and the relationships associated with it.

Answer Question  Select Best Answer

sudheer12d

 Profile Answers by sudheer12d Questions by sudheer12d

• Jan 18th, 2007

Hi Navigation Changed for all the modulesFeel & look is chnaged.Email notification is enabled in 11.5.9Extra Forms are added to the modules for the ease understanding for the usersMany DFF's are&n...

sravan

• Oct 19th, 2006

some extra colourswork flowadditional segments in gl modulethese r some of the changes

Answer Question  Select Best Answer

vipulgosai

 Profile Answers by vipulgosai Questions by vipulgosai

• Apr 25th, 2008

Hi,Use Base table instead of multi-org table. Mean to say...use AP_INVOICEs_All instead of AP_INVOICE(view) as AP_INVOICE is multi-org view and it fetch rows based on org_id.

PREM

• Oct 30th, 2006

IN THE CONCURRENT PROGRAMM FORM OR WINDOW U HAVE "COPY TO' OPTION AT THE BOTTOM LEFT. CLICK THAT OPTION AND THE SAME REPORT CAN ATTACH TO OTHER ORGANIZATIONS REPEAT IT FOR MULTI ORGANIZATIONS.

Answer Question  Select Best Answer

rajeshnrk8

 Profile Answers by rajeshnrk8 Questions by rajeshnrk8

• Mar 25th, 2009

Posting journals will have the status as 'P'. We need to post the journals in order to reflect the journals amount in the financial statements.

rakesh.apps

 Profile Answers by rakesh.apps Questions by rakesh.apps

• Aug 8th, 2007

Purchase Order whose status is OPEN is called?OPEN?Purchase?OrderThat means the PO is raised say some item x 50kgs,?but?the?supplier?send?the?x?item?say?25?in?one?shipment i.e?still?supplier?has?to?send the another 25kgs to fulfill?the?PO,?then?that?PO?is?said?to?be?OPEN?Purchase?Order.

Answer Question  Select Best Answer

subbupdk

 Profile Answers by subbupdk Questions by subbupdk

• Apr 14th, 2008

Go to concurrent progam define window and see the out put style, if it's text means character mode or it's in PDF means bitmap.

Answer Question  Select Best Answer

Antony

• Aug 22nd, 2007

First the report should be developed in XML tag,because it is easier to convert into optio.2.The driver for optio you have to install it in Apps server.3.Make a queue setup in Optio.4.Make a setup for...

Answer Question  Select Best Answer

harshad

• Dec 29th, 2005

invoices for the periodic expenses are called as recurring invoiceseg, electricity bill,      home rent

kc

• Dec 13th, 2005

Recurring invoices are those invoices which re occur after a specific time interval eg. Monthly Rent

Answer Question  Select Best Answer

diwaker

• Dec 22nd, 2005

Types of Invoices: 1)standard invoice,2)pre-payment,3)debit memo,4)credit-memo,        5)with-holding tax,6)PO DEFAULT 7) Quick Match 8)Expense ReortRecurring Invoic...

chenna

• Dec 2nd, 2005

hi,    standard invoice,pre-payment,debit memo,credit-memo,with-holding tax, and two more are there .But generally we use these five only.If u want more information then send a mail to chenna_darapaneni@yahoo.co.in. I'll send u indetail.

Answer Question  Select Best Answer