-
-
-
Where can we find the Provision
try thisselect a.vendor_name, b.vendor_site_code,u.organization_id, u.name,h.* from Po_headers_all h , po_vendors a, po_vendor_sites_all b,hr_organization_units uwhere h.segment1 = 228and a.vendor_id = h.vendor_idand a.vendor_id = b.vendor_idand h.vendor_site_id = b.vendor_site_idand h.org_id = u.organization_id
-
Demand to Stock Cycle
What is Demand to stock cycle?
-
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.
-
-
-
-
-
Add or Change the LOV
In Receivables, How do you add or change the LOV for telephone type in customer standard?
-
-
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...
Oracle Apps Technical Interview Questions
Ans