Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Auto complete fields on Tabular Form

TexasApexDeveloperJan 14 2016 — edited Jan 20 2016

Using APEX 5 and Theme 42, I have a form (Page 245) in the below application that has two columns currently as lov popup controls.  My customer has asked if they can be converted to autocomplete textboxes.  Can anyone take a look at this page and suggest how to implement an autocomplete textbox for this style tabular form?  It is built using a interactive report and a collection underneath to hold data until its ready to be saved.. Idea is from Jari Lane's fantastic blog Jari's APEX Blog : Article Yet another way to create "editable interactive report"

URL for application: https://glassfish1.revion.com/apex/f?p=4550:1:6270623494473:::::

Application: recharge (Application # 393)

workspace: homeworld

user: demo

password demo

Any help will be appreciated!

Thank you,

Tony Miller
Los Alamos, NM

Comments

user7417334
If you re-create the join with the exact name / identifier you can still open the workbook without any problem.
Make sure it is similar join which was deleted.
dianap
Thanks for the feedback.

The thing is I don't know the exact identifier anymore of the deleted joins.

Regards,
Diana
user7417334
Do you have any other instance, where you can find the identifier for the same join ?
dianap
No :(
user13716376
There is a workbook DUMP utility that will have a section that will show the EXACT name of the join for updating .. then the the workbook will open
dianap
Thanks,

Where is this workbook DUMP utility?

Diana
dianap
Hi,

After some search, I found how the dump works.
So I executed this.

For some joins, it's showing that the name has been changed:
Example:
*** Found in EUL by id *** Name has changed to r_area_well.r_area_s 1
So now I changed the name of the joins in the BA to the naming showing in the file ( for this example: r_area_well.r_area_s 1).

But still the workbook will not open. It keeps giving the item dependency not found error.

Diana
user7417334
I guess this time its looking for another item and identifier which might have been deleted. More investigation needs to continue
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 17 2016
Added on Jan 14 2016
13 comments
2,413 views