Friday, September 28, 2018

Tips & Tricks for Navigating Oracle Applications

Tips & Tricks for Navigating Oracle Applications

Tips & Tricks for Navigating Oracle Applications


Help : Keyboard Help or – Lists Hot Keys

Tools : Close Other Forms – check box to auto close forms when a new form is opened

Query Tips and Tricks
to enter query by example
to recall the last query parameters
to Execute Query
Query : Count Matching Records (after putting in the query parameters)
Exit Query

Query Wild Card Characters
% one or more characters
_ exactly one character

Query Operators
#between and 
#is null, #is not null
> Greater Than
>= Greater Than or Equal
< Less Than <= Less Than or Equal = Equal != Not Equal View : Record : First Record or Last Record – shows first or last record returned by query

What SQL Statement did the Oracle Applications run to fill the form? 
Help : Diagnostics : Examine (requires apps password)
Block = SYSTEM
Field = last_query

Other ways to determine the underlying table structure:
1) Help : Record History
2) Trace the form (requires apps password)

XML Publisher
The XML Publisher concurrent program joins the XML concurrent report data with the registered templates to generate PDF output. The following template types are supported: Portable Document Format (PDF), Rich Text Format (RTF) and XSL-FO.
- www.norcaloaug.org, Training Day 2004, Paper by Brent Mosher,
‘Oracle Tech update part 1: XML Publisher/Oracle Applications Framework’
- Metalink Note:269605.1, ‘About Oracle XML Publisher Release 4.5’
- Metalink Note:276691.1, ‘XML Publisher and Concurrent Manager Integration’
- Metalink Note:258332.1, ‘About Oracle XML Publisher Minipack XDO.H’
- Metalink B13817-01, ‘Oracle® XML Publisher User’s Guide Release 11i

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...