Answer posted by Thangs on 2005-05-20 17:01:08: Columns tracking the audit trial(user) information. CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, LAST_UPDATE_LOGIN

Lokanath Reddy

• Apr 27th, 2017

How to get last_update_login?

bharath

• Jan 31st, 2012

WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the W...

Answer Question  Select Best Answer

How to upload the any file e.g .doc, .xls etc through D2K form, on any particular loaction on the hard disk from any location?

Guru Prasad

• Mar 28th, 2016

Here is a sample code for Forms 6i Example Builtin Function to Popup the windows explorer from Forms "oracle8 PROCEDURE get_client_filename IS l_filename varchar2(200); BEGIN l_f...

PULKIT_MEHTA

 Profile Answers by PULKIT_MEHTA Questions by PULKIT_MEHTA

• Jan 28th, 2016

Below is brief description To enable webutil, do following: 1) Attach webutil_lib.pll library into the form 2) Subclass webutil object group 3) Move webutil block as last block You can use webutil_f...

Answer Question  Select Best Answer

How to exit Form when button is pressed to open another Form?

PULKIT_MEHTA

 Profile Answers by PULKIT_MEHTA Questions by PULKIT_MEHTA

• Jan 29th, 2016

NEW_FORM builtin should be used

tarek fouad

• Dec 3rd, 2014

New_form
This procedure exits the existing form and open the required new form

Answer Question  Select Best Answer

How do I customize forms in AP.Can I also customize reports in PO. Thank u.

Hossam Gamal

• Oct 3rd, 2015

Forms Personalization.
Form and click on "Help -> Diagnostics -> Custom Code -> Personalize".

sajasand

 Profile Answers by sajasand Questions by sajasand

• May 4th, 2009

You can customize any form by modifiying Custom.pll or by Form personlization.

Answer Question  Select Best Answer

How to call one form from another form?

shraddha

• Oct 24th, 2014

You can use call_form to call one form from another. But this method is old. So better option is to use FND_FUNCTION.EXECUTE. FND_FUNCTION.EXECUTE allows you to open forms without bypassing Oracle E-Business Suite security, and takes care of finding the correct directory path for the form.

kiran897

 Profile Answers by kiran897 Questions by kiran897

• Oct 23rd, 2010

By using Zoom function in custom.pll

Answer Question  Select Best Answer

Is it possible to disable a standard menu items like "Edit, Delete" using form personalization? If yes, How?

Sanyam Kaushik

• Aug 27th, 2014

By using this command-
Set_item_Property(Name of item, Enabled/ Disabled , Property_false/Property_true);

Answer Question  Select Best Answer

What is the difference between forms trigger and a database trigger?

raghu

• Sep 27th, 2013

Form triggers are application level triggers which fire on form level events while database triggers fire on database events

venkat kareedu

 Profile Answers by venkat kareedu Questions by venkat kareedu

• Nov 25th, 2010

Forms triggers used to fire in forms itself for enduser validations.where as database triggers are created on table and whenever we perform dml operation on table automatically will fire trigger.

Answer Question  Select Best Answer

sagar

• Jan 2nd, 2013

It is a number of variety of application according to the client requirements.

chakri

• May 25th, 2012

Making products that suits customer needs

Answer Question  Select Best Answer

What are the important Libraries in Template.fmb ?

bharth

• Jan 31st, 2012

There are mainly 3 packages are their in custom form
APPCORE
APPDAYPK
FNDSQF

sajasand

 Profile Answers by sajasand Questions by sajasand

• May 4th, 2009

There are mainly two type of library in Template.fmb[a] Core Lib [b] Application specific libraries CORE Libraries are:1. APPCORE.pll : This is used for Application Standards specific uses 2. FNDSQF.p...

Answer Question  Select Best Answer

How to get value from barcode scanner in Oracle Forms 6i?

jaalioracle

 Profile Answers by jaalioracle Questions by jaalioracle

• Feb 8th, 2011

We have to develop interface program and if you are not using SCM application or wms app you have to develop a custom form with?custom table based on requirement to join this table to existing tables.

Answer Question  Select Best Answer

How can I change default trigger firing sequence in Oracle Forms?

abhi4apps

 Profile Answers by abhi4apps Questions by abhi4apps

• Dec 3rd, 2010

By using Execution Hierarchy we change triggering firing sequence Execution Hierarchy contains three values 1. override2. before3. afterDefault is: overrideDepending on our requirement we can change either?before or after.

Answer Question  Select Best Answer

Which program is required to be executed after defining messages in the Oracle applications?

prasad_gv

 Profile Answers by prasad_gv Questions by prasad_gv

• Nov 19th, 2010

The program 'Generate Messages' must be run.

Answer Question  Select Best Answer

How to Show apps standard Calendar in Query Mode ?. Can anyone tell me how to show calendar in query mode in Standard/Custom forms. It is working fine in insert mode.RegardsSatish Shrivastava

kiran_marla

 Profile Answers by kiran_marla Questions by kiran_marla

• Jun 9th, 2010

1. Create one text item2. Goto text item properties -> goto lov section -> SELECT            1. Subclass information->text-item-date &nb...

mcheruku

 Profile Answers by mcheruku Questions by mcheruku

• Feb 6th, 2009

Define a Key-listval trigger for that item and use calendar.show;?Calendar will be shown next to the field in query node. Hope I answered your question correctly.

Answer Question  Select Best Answer

Sathyan271

 Profile Answers by Sathyan271 Questions by Sathyan271

• Sep 14th, 2009

The sorce codes (FMB files) are present in $AU_TOP/forms. ?- Under this directory, there are language folders like US, PTB etc where the language specific forms are stored.?- Once the forms are comp...

Bonthu N Reddy

• Feb 14th, 2006

$AU_TOP/forms/US is the path u can find it.Cheers,Bonthu N Reddy.

Answer Question  Select Best Answer

What are the differences between Forms 6i and Forms 10gWhat are the differences between Reports 6i and Reports 10g

fazalmca

 Profile Answers by fazalmca Questions by fazalmca

• Aug 2nd, 2009

Forms 6i is a client server based and Forms 10g is an web server based application.

Answer Question  Select Best Answer

How to connect user-defined menu with forms.

bheemathulasikrishna

 Profile Answers by bheemathulasikrishna Questions by bheemathulasikrishna

• May 30th, 2009

Go to property palletee of the Menu moduleThere you will find some thing like DEFAULT&SMARTBAR for MenuModuleRemove it and give the path of your Menu(.mmx)

Answer Question  Select Best Answer

How to call text or word file from form 6i?

rajulogin

 Profile Answers by rajulogin Questions by rajulogin

• May 25th, 2009

You can use the below API function to execute the files from forms6i.Win_api_shell.winexec('C:/Program Files/Microsoft Office/OFFICE11/winword.exe c:/temp1.doc');

Answer Question  Select Best Answer

Answer posted by Thangs on 2005-05-20 17:05:36: Routines for handling Message Dictionary, felxfields, prpfiles, concurrent processing, mulicurrency, WHO etc

sajasand

 Profile Answers by sajasand Questions by sajasand

• May 5th, 2009

This Library used in form for the following function and related to them:Desc Flexfield,
Currency,
Concurrent Request Submission,
Record History,
Message Dictionary-Thanks S Jain

Thangs

• May 20th, 2005

Routines for handling Message Dictionary, felxfields, prpfiles, concurrent processing, mulicurrency, WHO etc

Answer Question  Select Best Answer

What is 'post' command in Oracle forms?

jananiss

 Profile Answers by jananiss Questions by jananiss

• Oct 31st, 2008

Writes data in the form to the database, but does not perform a database commit. Form Builder first validates the form. If there are changes to post to the database, for each block in the form Form Builder writes deletes, inserts, and updates to the database.

Answer Question  Select Best Answer

prasmok

 Profile Answers by prasmok Questions by prasmok

• Sep 17th, 2008

HOST('unix command <full path of file>',NO_SCREEN);

Answer Question  Select Best Answer