OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » List of Values not assign (Oracle 10g,Win 7 32 bit,Apex 4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

List of Values not assign [message #626624]

Thu, 30 October 2014 01:55

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

Report message to a moderator

Re: List of Values not assign [message #626829 is a reply to message #626624]

Tue, 04 November 2014 00:11

Littlefoot
Messages: 21823
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)?

Report message to a moderator

Re: List of Values not assign [message #626830 is a reply to message #626829]

Tue, 04 November 2014 00:53

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Thanks for reply. Nope I am still using 4.0. Smile

Report message to a moderator

Re: List of Values not assign [message #626892 is a reply to message #626830]

Tue, 04 November 2014 09:21

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

Report message to a moderator

Re: List of Values not assign [message #626902 is a reply to message #626892]

Wed, 05 November 2014 01:03

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: List of Values not assign [message #626913 is a reply to message #626902]

Wed, 05 November 2014 03:41

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

Report message to a moderator

Re: List of Values not assign [message #627118 is a reply to message #626913]

Fri, 07 November 2014 06:27

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.

Report message to a moderator

Re: List of Values not assign [message #627189 is a reply to message #627118]

Sat, 08 November 2014 08:33

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Highlight validating Item
Next Topic:	Filter not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 17:31:00 CST 2024