-
Receive Flat Files from Client
How we will receive the flat files from the Client?
rajivgupta780184
- Aug 18th, 2008
It is possible in oracle forms 10G Oracle provide an inbuilt facility "webutil".From that you can upload you flat file from? client.But for that you have to conigure certain parameters in configuration files.THANKSRAJIV GUPTAYOGIK TECHNOLOGIES PVT. LTD.
-
Grey out
How to grey out when one column is selected in D2K forms?
rajivgupta780184
- Aug 27th, 2008
You have to useset_item_property inbuilt.firstly you create one attribute then use that attribute in set_item_property inbuiltwrite this code in when mouse click item in current item.RAJIV GUPTA?YOGIK TECHNOLOGIES PVT. LTD
-
Tell me about TCA(Trading Community Architecture)?
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.
-
Lexical Parameter
How to use the Lexical Parameter in the Oracle 10g report?
sanjay
- Oct 15th, 2008
Lexical parameter can be used in report for chaning column in query. These has to be defined in parameter with same name.
-
Generate HTML file from Oracle
How to create and generate HMTL file from OracleFor Example : Generate a HTML file with all the rows from a table temp
rajivgupta780184
- Oct 31st, 2008
Set markup HTML on spool c:/temp_table.html select * from temp; spool off set markup HTML off; Thanks & RegardsRAJIV GUPTA(ORACLE CONSULTANT)YOGIK TECHNOLOGIES PVT LTD.
-
What is the difference between standard and open interfaces?
sanjoy.dubey
- Nov 26th, 2008
Standard and Open interfaces are same.Interfaces can be classified as standard or open and custom interface.
ravikiran
- Apr 18th, 2007
Standard interfaces are those which are already present in oracel applications. Using this we are going to insert the data into base tables.Open interfaces are those which we are going to write to insert the data into base tables.
-
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
-
What is in-bound interface and out bound interface
rajeshnrk8
- Mar 25th, 2009
Inbound interface: We load the data which we got from the legacy systems.Outbound interface : We extract the data for legacy systems.
anil kumar
- May 29th, 2007
Inbound Interface: The Data that is being brought in to oracle application from markets?Eg: Purchase Requisitions (From Market-->Oracle)Out Bound Interface: The data that is being sent to markets fro...
-
Profiles Options
What are the different types of profiles options while submitting report through SRS window.
rajeshnrk8
- Mar 25th, 2009
Profiles are nothing but the changable options.While developing the reports we use two user exists i.esrw.user_exist('fnd srwinit'); in before report trigger andsrw.user_exist('fnd srwexit'); in after report trigger.
-
What is an OPEN PURCHASE ORDER, What is the difference between POSTING JOURNALS and UNPOSTING JOURNALS, What is the need for posting journals in GL module?
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
- 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.
-
What is the difference between base table and normal table?what is the difference between character mode and bitmap mode in reports?
rajeshnrk8
- Mar 25th, 2009
Base tables will store the data which is permanent. We should not delete that data. If you see in the purchase order. Base tables are po_headers_all, po_lines_all, po_distributions_all etc. Bit...
-
What are the main points in the report while at the time to register in the oracle Application Environment ?
rajeshnrk8
- Mar 25th, 2009
P_conc_request_id (user parameter)srw.user_exit('fnd srwinit'); ( in before report trigger)srw.user_exit('fnd srwexit'); (in after report trigger.)
-
Direct Path and Conventional Path
What is the difference between direct path and conventional path?
arifmahmud
- Apr 20th, 2009
When you use SQL loader by default it use conventional path to load data. This method competes equally with all other oracle processes for buffer resources. This can slow the load. A direct path l...
-
Why is my Purchase Order closing before a receipt is processed?
Because of the Receipt Close percentage defined in the Default tabbed region of Purchasing Options.
sajasand
- May 5th, 2009
If the invoice approval matching is set to the 2-way matching then the PO will close as soon as it approved
-
Journal Import
What is Journal Import.How do I import vendor info into purchasing.Thank u,
nakul.v
- May 6th, 2009
GL Journal Import is a Standard Open Interface Program provided by Oracle Applications to import Journal Data from legacy systems/or even from Payables,Receivables,Inventory into GL Tables.Interface Table :GL_INTERFACEBase Tables : GL_JE_BATCHESGL_JE_HEADERSGL_JE_LINESGL_BALANCES.
rajeshnrk8
- Mar 10th, 2009
Journal Import is the program is used to import the data from the Interface table to main table.
-
Tell me the difference between Conversions and Interfaces.Give example?
selvakumarapps
- May 20th, 2009
Conversions: It's nothing but transfer of data from other application ?to oracle application(it's one time data transfer). eg SAP(data) to Oracle APPS(data).Interfaces: It's nothing but transfer of d...
Christopher Joseph
- Aug 26th, 2006
Upgrading your data to a newer version is not Conversion, Its Data Migration.Conversion is as correctly mentioned, a One time activity to Convert the Data from a Legacy System to be loaded into Apps Tables. Interfaces: They are periodically run for exchange of data between Apps and Non-Apps Systems.
-
How to handle ' , ' in the data of csv file
hey...if any of the fields in sql loader script.. eg.. empname is Jain,anisha then how can we handle this ' , ' in Jain,anisha while using csv file in a sql loader
siddhshah
- Jun 22nd, 2009
One needs to enter the value with double quotes like "Jain, Anisha" to all the values so the comma can be stored in the columns.
harishkrishnagowda
- Apr 4th, 2008
Its better to remove ',' for that column using replace commandsFor egREPLACE(TRANSLATE(empname, ',{}[]%"?*~&$|/@''', ' '),' ')
-
How to create a new responsibility in the system to provide Inquiry only access?
Will there be any pre-defined responsibility in the system that can be used?
nileshtabhane
- Jun 23rd, 2009
For the responsibility you need to set the profile option HR:Query only mode as yes
-
Difference between Oracle 11i and R12
Hi, Can anyone of you give me some points on what are the major differences between Oracle 11i and R12 on the below modules 1. iProcurement 2. Purchasing 3. iStores Waiting for your reply. Thanks, Vikram
bhaskarapps
- Jul 2nd, 2009
1. In Oracle 11i 3c's i.e Currency, Calendar, Char of AccountIn R12 4c's
include sub-ledger account also2. In invoice screen invoice linesApps_Dragon
- Nov 28th, 2008
1) Oracle Purchasing Release 12.0 speeds up daily purchasing tasks with an enhanced Professional Buyers Work Center. Based on the latest web-based user interface models, the Work Center is a ce...
-
Legal Entity
Define Legal Entity
ash0917
- Aug 30th, 2009
The Legal Entity represents a legal company for which the user prepares tax reports. Tax identifiers and other relevant information are assigned to this entity.
Oracle Apps Technical Interview Questions
Ans