You can apply discount on the purchase order by defining a discount type modifier.You can define discount modifier for the line level and group of line.-KH
bobayya
Jan 4th, 2006
For example for a 10% discount you multiply the amount by 0.9 etc..
for knowing the size of the database, you will calculate the size of datafile because database size is nothing your datafile size is database size.select count(*) from dba_data_files;
A concurrent program is an instance of an execution file, along withparameter definitions and incompatibilities. Concurrent programs useconcurrent program executables to locate the correct execution f...
We give Business Group name while defining Security Profile through local HR responsibility.Business Group name is required because in this way we are restricting to this business:- Organization Hiera...
While registering procedure as concurent program there we need to declare two mandatary OUT parameters in procedure.
1.Errbuf
2.Retcode
Errbuf : Errbuf is one the paramter which will define in p...
ram
Sep 20th, 2006
There is another parameter for apps procedure errbuff
Since Question is related to APPS If you want to see particular filed in particular table Go to Form, Click on that field --> press Help Button in Menu -->HistoryPopup window will show Table name
If you know the column name, you can find out what all tables the column is used. Use this SQL> Select table_name from all_tab_columns where column_name = '';
(P to P) cycle: There are different steps involved in P to P cycle they are ` S.NoStepDefined At1Define itemsInventory2Enter item informationPurchase Order3 Raise requisitionPurchase Order4R...
Try to insert/update a row into table <wf_all_user_roles> as per following statement with Role_Orig_System_id =20420select * from wf_all_user_roles where user_name = 'ZZPRASAU' and role_orig_system = 'FND_RESP'AND NOT role_name LIKE 'FND_RESP|%|ANY'
gannesunil
Mar 30th, 2007
we are not able to create table from oracle apps front end.we are suppose to create table from back end by usingAD_DD oracle package (try once)ad_dd.create table andad_dde.create column ue can use the...
In Oracle Apps, to get data from views we have to set the org id for the application so that we can fetch relevant data. This can be done using the following block : beginfnd_client_info.set_org_context( ) ;end;
ratnakar
Jan 24th, 2007
View is a virtual table we can create view by using following query Create view view_name as select * from table_namewe can select data from view by using following query.select * from view...
hi,rapid install uses some scripts ie utilites like adpreclone and adcfgclone . In this process templates r created and all the configuration files are changed and new context file are created automat...
Conversion is transfer of legacy system flat file data into oracle apps tables or from oracle apps table data to flat files like interface, but it is a one time data transfer. Extensions is used for form development/form customization.
harshal
Oct 26th, 2006
Extensions are literally extensions to Oracle Apps.About conversions (if seen independent of extensions), i feel its more to conversions used for currency conversion. Types : corporate etc
11.5.10 having some advance functionality like web-based forms for some selective parts of SCM. and having form persoanlization facility to customize the oracle forms.as well as enhancement of demand planning in ASCP module.
The difference is 11.5.10 is the updated version used for oracle 111i in manufacturing and supply chian management where as 11.5.9 is the older version for 11imanufacturing and scm.
Auto Invoices are also used in Service Contracts as a concurrent Program namely "Auto Invoice Import Program". This program is Owned by Oracle Receivables. It imports the bil...
Vijay Akumalla
Dec 8th, 2006
We can also import Invoices from Legacy systems. Not only invoices, but Credit Memos, Debit Memos, Sales Credits
Ans