Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » List of Values not assign (Oracle 10g,Win 7 32 bit,Apex 4.0)
List of Values not assign [message #626624] Thu, 30 October 2014 01:55 Go to next message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
Hello,

I have one application "System Tool" when i export this application and import it into another schema then i have seen one strange problem like all the columns those are based on the LOV's in interactive reports, LOV are not set into the Named List of Values column.All Lov's are present into the shred component section but not assign into the interactive reports column.

Its happen in all the interactive reports, Please help me to sort out this problem.

Thanks,
Xandot

Re: List of Values not assign [message #626829 is a reply to message #626624] Tue, 04 November 2014 00:11 Go to previous messageGo to next message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Looks like a bug. I don't know how to fix it, sorry.

Did you consider upgrading Apex to the latest version (4.2.x)?
Re: List of Values not assign [message #626830 is a reply to message #626829] Tue, 04 November 2014 00:53 Go to previous messageGo to next message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
Thanks for reply. Nope I am still using 4.0.Smile
Re: List of Values not assign [message #626892 is a reply to message #626830] Tue, 04 November 2014 09:21 Go to previous messageGo to next message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
Can you please give me the proper steps to export the application because i think this problem was related to the export. I have exported application 3 times and all the time the lov's disappear from the interactive reports.

Thanks,
Xandot
Re: List of Values not assign [message #626902 is a reply to message #626892] Wed, 05 November 2014 01:03 Go to previous messageGo to next message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Export is wizard-driven, you can't fail that process. Either you come to an end (and do the export), or you don't (and don't do the export).

As of preferences I use, here you go (although, I don't think that any of these is meaningful for LOVs):
- File format: unix
- Owner override: empty
- Build status override: run and build application
- Debugging: yes
- As of <empty> minutes ago

- Export supporting object definitions: yes
- Export public interactive reports: yes
- Export private interactive reports: no
- Export interactive report subscriptions: no
- Export developer comments: yes
- Export translations: no
Re: List of Values not assign [message #626913 is a reply to message #626902] Wed, 05 November 2014 03:41 Go to previous messageGo to next message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
I have found one Issue in Oracle forum
https://community.oracle.com/message/9484188

Its Similar to my problem but I am not find any feasible solution.

Thanks,
Xandot
Re: List of Values not assign [message #627118 is a reply to message #626913] Fri, 07 November 2014 06:27 Go to previous messageGo to next message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
I found the solution for this problem.

By manually I added the wwv_flow_api.g_id_offset value to p_rpt_named_lov, in export file of Apex 4.0 and import it. After all the changes its working properly, all lov's are assign correctly.



Re: List of Values not assign [message #627189 is a reply to message #627118] Sat, 08 November 2014 08:33 Go to previous message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm glad you solved the problem - thank you for letting us know the outcome. Anyway, it looks like a bug.
Previous Topic: Highlight validating Item
Next Topic: Filter not working
Goto Forum:
  


Current Time: Wed Aug 05 11:53:09 CDT 2020