Home » Applications » Oracle Fusion Apps & E-Business Suite » create DFF which should be unique and Non Mandatory
create DFF which should be unique and Non Mandatory [message #358627] Wed, 12 November 2008 00:13 Go to next message
radhavijay
Messages: 29
Registered: July 2008
Junior Member
Hi All,
I want to create a DFF the filed which must be unique and non mandatory in AP-->Supplier-->entry form

when we are entering values in DFF then the Values must be in 3 formats

1. for local companies(yyyynnnnnX)
2. for business (nnnnnnnnX)
3. for others entity tpyes(TyyPQnnnnX)

where y=year
n=0-9 numbers
X= a,b,c,d.....
Tyy= year of issuance T standsfor 20
PQ = entity type
available with in respective agency.

i had created the DFF but im not getting how to create the value sets in above formats

so any one please help me.

Im new to this work.
please this is an Urgent work for me.
this same DFF im must Create in AR-->Customers-->Standard form also

Thanks in Advance

Regards,
Radha
Re: create DFF which should be unique and Non Mandatory [message #358684 is a reply to message #358627] Wed, 12 November 2008 02:51 Go to previous messageGo to next message
ggr88
Messages: 31
Registered: October 2007
Location: Wellington, New Zealand
Member
Hi,
Part 1. Validation - Trivilal - this is just where clause on a select from dual - possibly with use of regular expressions to ease the pain.
Part 2. Uniqueness - 2 options here:
- 2a) create a unique index on the attributeXX column. Best option if you plan to report with parameter based on this attribute.
- 2b) value set that selects on existing values in table (harder) but trivial - needs to tie into 1.

Regards,
Gareth

Re: create DFF which should be unique and Non Mandatory [message #358938 is a reply to message #358684] Thu, 13 November 2008 00:52 Go to previous messageGo to next message
radhavijay
Messages: 29
Registered: July 2008
Junior Member
please can u explain me in detail by giving a sample.
as im new to this work im unable to understand.
Re: create DFF which should be unique and Non Mandatory [message #381951 is a reply to message #358627] Tue, 20 January 2009 07:07 Go to previous message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi
DFF has fixed type of format types. the format which your asking i dont think it is possible but you can do workaround

create three context field values

1. for local companies
2. for business
3. for others entity tpyes

based on the selection you can divide the fields like

if you select
1. for local companies
create three
1. segment yyyy,
2. segment nnnnn,
3. segment xxxxx
in this way you can fix the format type validation.

In reports you can concatinate all the segments
Previous Topic: Error in Autoinvoice import ra_interface_lines all
Next Topic: Workflow email customisation
Goto Forum:
  


Current Time: Sat Dec 03 07:43:35 CST 2016

Total time taken to generate the page: 0.09533 seconds