ORACLEAPPS 10.7 Import Orders Choose MRDRECEIVABLES SUPER USER 1

Document Sample
ORACLEAPPS 10.7 Import Orders Choose MRDRECEIVABLES SUPER USER 1 Powered By Docstoc
					                                                                           Page 1 of 3
ORACLE APPS 10.7
Import Orders:
Choose MRD RECEIVABLES SUPER USER
1: Interface: Customer - Open
Click In Name Box - Hit List of Values Toolbar Button(123)
Hit Submit
Orders
Orders, Returns - Import Orders-edi-tab-ok-submit

ORACLE APPS 11I
Add Customers:
Add Customers-Customers Standard to Top Ten List and select and hit Open
Name: SUPER MAN hit Find in bottom right to make sure the name is unique
Classification TAB - Class:Direct
Address TAB - add sample street address like 2121 Rosecrans 90245
Usage: BILL TO Primary Checked, Active Checked
SHIP TO Primary Checked, Active Checked
Zoom in Tax Code CA
Save

Add Orders:
MRD ORDER ENTRY SUPER USER
Add Order Organizer to Top Ten List and select and hit Open
Hit New Order
Customer Number: 7484
Order Type: DIRECT - DIRECT ORDER
Line Items Tab Order Item: 10032 Qty:1 UOM:EA

Create new Categories ==> mtl_categories_b was updated as follows:
1. Apps MRD MANUFACTURING SUPER USER
2. INV-Setup-Items-Categories-Category Codes
3. Structure Name
4. Category ==> come up with a new brand,ctgy,type combo
Rare Brands(ARTH,HAIR,TSF), Rare Categories(SPA), Rare Types(NA)

Create new Salesrep ==> jtf.jtf_rs_salesreps was updated as follows:
1. Apps MRD ORDER ENTRY SUPER USER
2. Setup-Sales-Salespersons-New
3. Category , Salesperson Number <8001>, Name ,
4. Receivables Tab ==>Date Active <9-MAY-2002>, Sales Credit Type

Create new payment terms ==> apps.ra_terms_vl was updated as follows:
1. Apps MRD RECEIVABLES SUPER USER
2. Setup-Transactions-Payment Terms

Create new territory
1. Apps MRD ORDER ENTRY SUPER USER
2. Setup-Sales-Territories
3. Fill in Name, Description, Flexfield --> Save

Create new contact
1. Apps MRD ORDER ENTRY SUPER USER
2. Customers-Standard

file://C:\___%20Oracle%20site\software_it_cheat_sheet.htm                    4/1/2005
                                                                                         Page 2 of 3
3. Name Find
4. Move down to indented name and press OK <1st indented>
5. Choose an Address and press OPEN
6. Go to Contacts: Telephones tab made
by filling in Last,First,Area Code,Tel,Type

ORACLE CUSTOM LIBRARY
cd to $AU_TOP/resource
Use f60desm to open forms builder
from ReflectionX as applxxxx user
export DISPLAY=192.168.1.208:0.0
echo $DISPLAY

Make sure permissions are ok if CUSTOM.pll is from another instance
chmod 777 CUSTOM.pll
chmod g-w CUSTOM.pll
chmod o-w CUSTOM.pll

ORACLE REPORTS
cd to $AU_TOP/resource
type: rwbld60 &

ORACLE QUERIES
Active Skus
select pll.inventory_item_id, substr(mtl.segment1,1,8), pll.creation_date,
pll.start_date_active, pll.end_date_active, pll.list_price
from so_price_list_lines pll, mtl_system_items mtl
where (pll.inventory_item_id = 7420 or pll.inventory_item_id = 10734)
and pll.price_list_id = 1001
And pll.inventory_item_id = mtl.inventory_item_id
7420 90181 17-SEP-99 04-MAR-02 0
10734 10022 22-NOV-00 22-NOV-00 59.9
Note that sku 90181 was turned off on Mar 04 while sku 10022 is still good.

HP-UNIX COMMANDS AND SCRIPTS
Find File: find . -name StartNameFileX* -print
Modify Crontab: crontab -e

VI EDITOR
Edit File: vi FileNameX
Insert: i
Delete: x
Delete Line: dd
Close(No Save): ESC!q!ENTER
Save and Close: ESC!wq!ENTER
Remove ^M ??In vi, do a :%s/^M//g To get the ^M hold the control key, press V then M (Both while
holding the control key) and the ^M will appear.


                                                                              Search




file://C:\___%20Oracle%20site\software_it_cheat_sheet.htm                                  4/1/2005
                                                                                                                     Page 3 of 3
Pacific Poker - Online Po            Get the credit you deserv           Guaranteed Credit Card Ap          Matrix Direct Term Life I
Play online poker against real       Legally dispute negative items on   Instant approval, guaranteed       Save up to 70% on your term life
players. 24/7 support, free          your credit report and get them     credit cards issued by major       policy. Smokers receive great
download. Play for fun or for real   deleted! Contact Rep#920 at 800-    banks, regardless of past credit   quotes too!...
money....                            4...                                history. ...

                                                                                                                 Put Your Ad Here For a Penny




file://C:\___%20Oracle%20site\software_it_cheat_sheet.htm                                                               4/1/2005

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:15
posted:8/30/2010
language:English
pages:3