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’…
In order to get multi-record blocks on tabs here is all that you need to do:
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.
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:
(:system.mode = ‘ENTER-QUERY’)
and (cus_id in (10,20,30))
or (not :system.mode = ‘ENTER QUERY’)
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.
You can also do it from the command line: execute your report with the
arguments DESFORMAT=XML, DESTYPE=FILE, and DESNAME=[name].XML.