-
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.)
-
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 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.
-
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 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...
-
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
-
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.
-
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.
-
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.
-
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.
-
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
-
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.
-
Profie Options and User Exits
Explian What are Profie Options and User Exits
babind
- Aug 15th, 2008
Profile options is a collection of changeble option this option you can?steup then your way of application is running is change.? The porfile option are 4 types they are given below?1=>? user leve...
-
How to add company logo to a report?
rajivgupta780184
- Aug 12th, 2008
Go to file option in menu barclick on import->image window will appear then browse the logoselect the picture quality and press ok
mrutyunjay
- Dec 26th, 2006
If the report is not a text report then,we can add a logo.the navigation path isfile->import->picture
-
Oracle Forms Validations
Hi Everybody..... 1) My query is like i have a form by name employeetest 2) I a form i have two canvases 3) There are many test_fields and list_items in the canvas 4) What my query is like..... 4a) If i don't fill any of the item or text_filed i need...
rajivgupta780184
- Aug 11th, 2008
You can do this validation in two ways 1> You can select all the feild at a time and click F4 or go to the properties of that and make the required feild(required property) =YES2>You can also do it th...
-
Where does the customer information is stored in Oracle Apps tables
When they ask where does the customer information is stored in tables should we say hz_parties or ra_cust
rajivgupta780184
- Aug 11th, 2008
You can enhance processing time by formatting the code in right order.
Use less of cursor if possible
Avoid using conditions and loops as much as possible etc...ThanksRajiv Gupta -
How to pass lexical paramater for example &where_clause from forms 10g to report 10g using web
rajivgupta780184
- Aug 11th, 2008
Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in ...
-
How can we call one report from another report in Oracle Apps Reports?
rajivgupta780184
- Aug 11th, 2008
By Using run_product('reportname')? in-built feature? you can call one report from another.
-
Show report output reocrds in Blue and Black color alternatively
In a report output, How to show reocrds in blue and black color alternatively.
rajivgupta780184
- Aug 11th, 2008
By using conditional formatting in Oracle reports. You can get conditional formatting in reports properties, try it out.
bye Rajiv Gupta -
Steps for loading data from excel file in cash management using data loader?
rajivgupta780184
- Aug 11th, 2008
Firstly, you have to arrange the excel file in same manner as was the table.i.e., first column data in excel file should be of first column in the table and also remember the data in Excelfile shoul...
Oracle Apps Technical Interview Questions
Ans