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