Adding Sequence in Receipt Number in Oracle Applications by Form Personalization


As we have a good advantage in using oracle apps forms that is easy to customize. I had a requirement to create a sequence number in Receipt number on receivables. So I have followed the below steps while customizing I came through a error by which the seeded functionality was overriding. However i have resolved it, check the below steps for more Information.

Step 1 : Create a function or a package with Sequence Number

As I have created a function and my below sql statement will give the sequence number.

select xxhw_Invoice_status.gen_receipt_sequence_number from dual

Step 2 : Note the Block and the Field that we are going to customize.

Step 3 : Go the Personalize form and add the rules as shown in the screenshot.

Step 4 : After adding the rules and condition add the action as shown in the below screenshot

From the above screenshot the sequence will be added to the value of the

 

Advertisements

About pacesettergraam

A good and realistic person

Posted on March 8, 2017, in Oracle, oracle apps and tagged , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: