Did You Know? -- October 2001

By Hervé Deschamps, Oracle Corporation.

I am back! I took 2 months off work in order to move from the US back to France where all my family lives. I now work for Oracle, Geneva and live very close on the French side. So this is my excuse for skipping 4 months of ‘Did You Knows’…
 

Designer 6.0: Forms Generators

In order to get multi-record blocks on tabs here is all that you need to do:

• for the module component set property Placement=New Tab Canvas Page
• for the module component set property Rows Displayed=10 (just an example)
• for the module component set property Overflow=Wrap Line (Spread Table is not possible).
• for the module component set preference Layout Block-Use block tabulation table=null.

Designer 6.0: Library Generators

Developer locks libraries. When you generate it again from Designer, it seems to do the job, i.e. says that it successfully generated the library, yet it did not do anything. Solution: close Forms. Same thing when you are running a form that has the library attached.
 
 

Designer 6.i: Forms Generator

If you need to have library names all in lowercase you can get Designer to enforce the rule for the attachments created by the tool, like ofgnavl or the module specific libraries that developers use. Setting preference Generator Runtime-LWCFLN to LOWER will de the job.

You can get LOVs to behave differently in query mode with a where clause like this:

where (
(:system.mode = ‘ENTER-QUERY’)
and (cus_id in (10,20,30))
or (not :system.mode = ‘ENTER QUERY’)

Oracle Apps Tech

select user_id
from fnd_user
where user.name=’<user name>’

From the apps User Interface, to get the value of an app environment variable like $AU_TOP or $ORACLE_HOME, go to Help->Diagnostics->Examine, choose $ENVIRONMENT$ for a Block, pick a variable from the LOV of Field and you will get the value in the field 'Value'. You can use the same method to view
profiles variable values like ORG_ID or LOGIN_RESP_ID: just choose $PROFILES$ for a block.
 
 

Reports 6.i.

You can also do it from the command line: execute your report with the arguments DESFORMAT=XML, DESTYPE=FILE, and DESNAME=[name].XML.