Saturday, May 7, 2016

Tips & Tricks for Navigating Oracle Applications

Function

Icon

Shortcut

Menu Bar (Alt-)

Description

New Record
Ctrl-↓
File > New
Insert a new record on the screen.

Find


View > Find
Bring up a “find” screen, to enter selection criteria to find existing records.

Navigator

F4
View < Show Navigator
Return to the navigator (main menu).  You can also click on the navigator window (it is always available), or close other forms.

Save

Ctrl-S
File > Save
Save your work.
Switch Responsibility

File > Switch Responsibility
Change the responsibility (menu) that you are signed on to. 

Print

Ctrl-P
File > Print
Print hardcopy of the current screen info. 

Close Form


File > Close Form
Closes the current screen.

Clear Field

F5
Edit > Clear > Field
Clears the current field from the screen, without making any changes to the database.

Clear Record

F6
Edit > Clear > Record
Clears the current record from the screen, without making any changes to the database.

Clear Block

F7
Edit > Clear > Block
Clears the current block from the screen, without making any changes to the database.

Clear Form

F8
Edit > Clear > Form
Clears the current form from the screen, without making any changes to the database.
Delete Record
Ctrl-↑
Edit > Delete
Deletes the current record from the database, when you save. 
Edit Field
Ctrl-E
Edit > Edit Field …
Opens an edit window, where you can see the entire contents of a field when the contents are larger than fit in the space on the form. 
Quality

Tools > Enter Quality Results
Indicates the existence of a quality collection plan that must be completed.
Attachments

View > Attachments
Add, modify, or view attachments to the current record.  The empty paperclip indicates the ability to add attachments; the full paperclip indicates the existence of one or more attachments. 
Start Interaction/ Wrap-Up

Tools > Start Interaction
Tools > Wrap Up
Start and end the Interaction History log for this customer touch point.
Folder Tools

Folder > Folder Tools
Brings out the Folders toolbar for tailoring your screen layout.  Refer to the Folder Form Tools.
Quick Menu


Pops up the launch pad Quick Menu to zoom you from the current record to related information in the system.
Help
Ctrl-H
Help > Window Help
Brings up context sensitive help documentation.

Enter Query


F11
View > Query By Example > Enter
Put the screen into Query by Example mode, where you can enter search criteria.  Use % as the multi-character wildcard; _ is the single-character wildcard. 

Re-Enter the same query


F11 + F11

Press function key F11 twice to re-enter the same query.

Run Query


Ctrl-F11
View > Query By Example > Run
Executes a query. 

Cancel Query


F4
View > Query By Example > Cancel
Exits from Query mode.

Count Query


F12
View > Query by example > Count Matching Records
Displays the count of records, the query is going to fetch ( on the message bar)
Duplicate
Field Above

Shift-F5
Edit > Duplicate > Field Above.
Duplicates the field value from the row above. 
Duplicate
Record Above

Shift-F6
Edit > Duplicate > Record Above.
Duplicates the entire row above.

LOV

Ctrl-L

Pops up a list of lookup values in fields requiring a validated entry
Show Keys

Ctrl-K
Help > Keyboard Help
List of keystrokes equivalents.
View Concurrent

Alt+V, R, Enter

To view the concurrent program
New Concurrent

Alt + V, R, Alt + N, Enter

To run a new concurrent
Go to next block up in form

Shift + page up

It navigates to the previous block
Go to next block down in form

Shift + page down

It navigates to the next block
Collapse All

Atl + T, O

Collapse the navigator
Copy from an item or template

Alt + T, C

To copy an item or template into the current master or org items form.
Assign items to Org

Alt + T, O

Assign an item to org(s) when you are on master item form.
Org creation form

S – O – O

To open the org find form
Sub Inventories

S – O – S

To go to function Sub Inventories
OHQ

O – Enter

Open the query material work bench form
Generate Serial Numbers

O – G

Open the forms for generation of Serial Numbers.
Open Inventory Accounting Periods

AC – I

Opens the Inventory Accounting Periods form
Master Items

I – Enter

To open master items
Org Items

I – O

Open the find form of Org item
Misc. Transactions

Enter – M – Enter

Open the Misc. Transaction form
Org parameters

S – O – P – Enter

To open Org parameters
Locations

S – O – L

Opens the Location creation form
Calendar

S – O – C – Enter

Opens the org parameters form

Help : Keyboard Help or <ctrl  k> – Lists Hot Keys

Tools : Close Other Forms – check box to auto close forms when a new form is opened
Query Tips and Tricks
<F11> to enter query by example
<F11> <F11> to recall the last query parameters
<Ctrl F11> to Execute Query
<F12> Query : Count Matching Records (after putting in the query parameters)
<F4> Exit Query


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

Query Operators
#between <low> and <high>
#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

Best Blogger TipsGet Flower Effect