Order management is(is a MODULE) the administration of business processes related to orders for goods or services.
Oracle Order Management is one of the most important module of Oracle E-Business Suite.
order is a type of document created by customer for his needed product.
sales order will be have all details about items or goods services requested by customer.
order management two levels: 1. header level(order information)
2.line level(line item)
-->lines will be cancel or delete in entered status. AFTER BOOKING, WE CANNOT DO THE LINE DELETION BUT WE CAN DO CANCEL.
IF WE DELETE THEN ERROR MSG WILL COME BY MENTIONING THE RLM.
--> after the order is booked then we cannot add the new line to that booked(status) order.
invoice number and order number is 11 digit numbers.
1.12. What is order type?
Answer: An order type is the classification of order. It controls the order work flow activity, order number sequence,
credit check point and transaction type.
Order Type is associated to a work flow process which drives the processing of the order
Sales Order Number significance:
Digit 1---------> Division
Digit 2-------> Invoice / Credit note / Debit note ( Invoice=1 ; Credit note=2 ; debit note=3)
Digit 3 and 4 ----------> Depot code ( Chennai=11 ; Ernakulam =12 etc)
Digit 5 and 6----------> Year code ( year 2004=’04’)
Digit 7 to 11----------> Serial number (numeric)
11110209400 signify CPD- invoice – Chennai depot – year 2002- serial no: 9400
1.List price is the price of the item which gets defaulted from the price list.
Unit selling price is the price which gets reflected once the discount which is mentioned in the modifier
2.A lot number is an identification number assigned to a particular quantity or lot of material from a single manufacturer.
3.What is Item Cross References used for?
Cross Reference types define relationship between Items and entities such as Customer Items or Supplier Items.
4.Miscellaneous Issue
if epry date or batch is entered wrong (while taking receipt) mean then the miscellaneous issue will use.
5. Pick release rule
A user-defined set of criteria to define what order lines should be selected during picks release.
6. What does Pick Release mean?
An order cycle action to notify warehouse personnel that orders is ready for picking.
7. What is Back order? When it occurs?
In the Back Order the material gets unreserved. . Backorders caused by Pick Releasing (PR) order lines when there
is no or not enough stock available. and then again do the picking release by changing the unreleased into backorderd.
9.What is a Pick Slip Report?
A: Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.
10. ONT stands for order management.
11.Interface trip stop has 2 parts:
1.It process the data related to Order Management.
2.It Process data related to Inventory
12.Staged/Pick Confirmed for those delivery lines that have received allocation and
Pick Confirmed successfully and Released to Warehouse for delivery lines that
require a manual Pick Confirm or have not been allocated
Released to Warehouse (SE): Pick Release has started but not completed. Either
no allocations were created or allocations have not been Pick Confirmed
13.credit memo: A document that partially or fully reverse an original invoice amount.
14.Autoinvoice is the process of creating an invoice in Accounts Receivables Module.and also moving from interface to receivables.
15.order header level status ,: entered & booked & closed.
16.MODIFIERS enable you to setup price adjustments.
Item Discount gives a price adjustment or benefit to a specific item already on an order when the customer
orders one or more other specified items on the same order.
Promotional Goods adds a new item to an order and gives this item a price adjustment or benefit when the
customer orders one or more specified items on the same order. The item does not need to be originally on the order.
Even if the item is on the order, the pricing engine creates a new line for the item
16. item identifier mean whether it is wgw or tev or scr and so on
17.Statutory reporting is the mandatory submission of financial and non-financial information to a government agency.
18.intransit: shipping is not completed.
19.(i)"debit" usually refers to money removed from a consumer bank account,
such as money removed from your checking account when you buy groceries.
(ii)Similarly, "credit" usually refers to money
added to a consumer bank account,
20. unearned revenue mean the customer pay the money in advance so that money is stored in unearned revenue...
after the invoice the amount is taking from the unearned revenue.(the revenue will hit the unearned revenue).
21.sales reports: it have two sub menu. the sub menu contain many reports in it.
1.statuatory report is compulsory.
2.miscellanous report is if it is necessary mean we can run.
22.ttk netsales repwise
23.In reports, the segment mean item number(like 01100149).
24.lin mean link factor (if uom cas(1) mean the lin is 90 for wgw 130ml)
25.transaction type or order type (both same)
26.outstanding report : in control report
27.quantity*unit selling price = line amount(extended amount)
28.IF THE STATUS IS INTERFACE, MEAN. THE STATUS IS PICKED in line level.SO RUN INTERFACE FROM ORDER MAGMET TO SHIPPING TO INTERFACE.
after shipping==> the status is closed in line level, in shipping transaction form is interface and not applicable. so the
meaning is the order process is over in om module so it is waiting for autoinvoice.
29.pricing engine mean the program which use the modifier and qualifier and price list.......
30.Modifier list level(header level) qualifiers help the pricing engine to determine who is eligible for the modifier lines
31.modifier,it have two level qualiier: 1.list level qualifer(header level). header level(primary).
2.line level qualifer...
32.Lumpsum: Creates a price adjustment for this lump sum amount on the entire line.
The lumpsum can be based on group quantity (sum of item quantities) or an item amount (a monetary amount).
33.REPORTS ---> CONTROL REPORT: TTK SALES ORDER STATUS.
34. ventura division: ayurvedic product
endura division: allopathic product
35.trigger - IS USED FOR control program.
36.What is inside AutoInvoice?
AutoInvoice is a tool consists of 3 main programs. Each program will have unique nature of work to do and they are
called internally except Purge program whose execution is derived on the setup otherwise ready to execute stand alone.
Master (RAXMTR)
Import (RAXTRX)
Purge (RAXDEL)
1] Auto Invoice Master program:
Selects and marks records in the interface tables to be processed based on the parameters the user entered and
then calls the AutoInvoice Import program. Auto Invoice Master program has no report output.
2] Auto Invoice Import Program:
Validates the selected record and creates transaction if it passes validation. Any record that fails validation
is left in the interface table with an error code. Depending on the setup, related records may be rejected as well.
This program has an output file called Auto Invoice Execution report, which you can view by clicking the View Report
button in the Requests window.
37.qoh(quantiy on hand)-ex(100) and available quantity(aq)-ex(75)
38.order source type : internal, online and so on
39.context field is also known as structure field
40. f6 for fresh entry in sales order screen.f4 for exit the window and also exit the query.
41.(RMA) Returned goods details are often received in the Stock Reciept Advice(SRA)
42. receipt number is sex(6) digit numbers.
43.customer site or party site is like wgw,eva and so on
44.Order processing (ENTERING, BOOKING, picking, packing, shipping)
45.An order management system(OMS), is a computer software system used in a number of industries for order
entry and processing.
46.A flexfield is a field made up of sub–fields, or segments. There are two
types of flexfields: key flexfields and descriptive
flexfields.
(i) KFF- Keyflexfields are used throughout the Applications to uniquely identify informations such as GL accounts, INV
items that every business needs to keep track of.
(ii) DFF- Descriptive flexfields enable you to capture additional pieces of information from transaction entered into Oracle EBS.
47.Interface is program used to transfer the data from flat file to database table or from data base table to flat file.
Two types of interfaces:
· Outbound Interface
· Inbound Interface
48. AIA - Application Integration Architecture
49.DEFAULT "PAYMENT TERMS": 30 NET: The balance of the transaction is due within 30 days.
types of payment terms are : DIRECT, ADVANCE DD, THROUGH BANK, IMMEDIATE
50.PAYMENT TYPES IS CASH ,CHECK, CREDIT CARD, DIRECT DEBIT, WIRE TRANSFER.
51.Wire transfer or credit transfer is a method of electronic funds transfer from one person to another.
A wire transfer can be made from one bank account to another bank account.(EX: NEFT, RTGS)
52.AOL: (Oracle)Application Object Library
53. (i)payment terms: direct- the order will go on hold.(it will check the credit check rules)
(ii)payment terms: advance dd- credit balance exceeded message will come while booking.
55.one customer = one primary flag(tick) in customer creation form.
56. if detail like order, price list are not given in ship to(in customer creation form) then order cannot be processed.
57. Credit check rules, order transaction type, payment terms and credit profiles are the key setup entities that
influence the credit check process.(CREDIT CHECK HOLD IS APPLIED IN THESE ABOVE)
58.Automated Clearing House(ACH): IN PAYMENT TYPES SETUP.
59.Credit Memo against Invoice in r12 Receivables.
60. item Rate--> price list--> item rate only based on Batch number.
61.VAT on product gross after discount.
62. fgi- finish goods inventory.
subinv-sub inventory.
63.enter sales order screen--> only display screen with tax
64. CREDIT NOTE AND INVOICE AND DSIN IS RELATED TO OM(DOING IN OM)
65.DEBIT NOTE IS RELATED TO ACCOUNTS RECEIVABLES(AR).
66. CREDIT LIMIT : SUPPLY THE GOODS ONLY BASED ON LIMIT THE COMPANY ASSIGN TO THAT CUSTOMER
67.CREDIT CHECK RULES ---> ADVANCE DD: AT THE TIME OF BOOKING(THE ERROR IS CREDIT Balance IS EXCEEDEDs)
OTHER(DIRECT) ---> AT THE TIME OF PICKING(THE ERROR IS: ITS IN HOLD)
advance dd party ---> no limit because he already paid for his product
68. TRANSACTION TYPES: INVOICE, dsin c/n, CREDIT NOTE, MANUAL D/N, MANAUAL C/N
69. DSIN IS ALSO A ONE TYPE OF CREDIT NOTE.
70. SRS - SCHEDULE REQUEST SERVICE. "Standard Report Submission (SRS)"
71. DC - DELIVERY CHALLAN.
72. CANCEL FMS: WE CAN CANCEL THE fms befor doing transact.
73.modifier - if you want to see which modifier applicable in order is --->actions(in line level)---> view adjustment.
74.ASSESSABLE PRICE LIST: ITS USED FOR CALCULATING vat in particular state with MRP price.
75.Define the transaction sources --- that you will assign to your invoices, debit memos, commitments, credit memos, and
on-account credits. Receivables uses transaction sources to control your transaction and transaction batch numbering, to
specify your default transaction type, and to select validation options for imported transactions. Before you can define a transaction source
for your invoices, you must define transaction sources for your credit memos.
76.At what stage an order cannot be cancelled?
An order cannot be cancelled when it is Pick confirmed.
77.status (release to warehouse) ---> we have to do manual pick.
78.advance dd customer, first we have to do the collection and take receipt and then only do the order for that amount.
79.epd: bill to and ship to: epi,epm,ven,epp,nov.
epi(i mean imd), epm(m mean mmd)
80.in cpd division: except tco(chennai cpd others inv ), all other are (chennai)cpd pharma inv.
81.the order is booked without (automatically) applying modifier so that cancel the order and do the fresh order.
82.in release sales order screen we have two button is 1.execute now and 2.concurrent.
execute now mean the srs(background process) will give first priority to run.
concurrent mean, eg: if 5 (background process) running mean it will run as sixth process.
83.autoinvoice report, error like wrong org id and gl date is closed mean the solution is open the gl period in ar module and
then the run autoinvoices.
84.rma mean sales return and non rma mean van operation, sales promotion, etc.
85. after invoice run two reports that is ttk invoice printing ventor name and ttk sale day book- non mrp (or mrp)
86.after credit note(rma) run reports that is ttk credit note register (rma)
after credit note(non rma) run reports that is ttk credit note register(non rma)
87.(way of shipping the order in shipping form) in shipping transaction form click the deliver and give the status as
open and give the org id and the find and ship confirm.
88.mrp price- maximum retail price (assessable price)
89.non-mrp price-- list price(regular price)
90.after shipping--> line level status is closed
shipping transaction form--> interfaced and not applicable
so run autoinvoices...
the order is interfaced that mean om level process is over.
91. product gross =quantity * unit selling price
92.in price list and modifier, date we have to give
93. in sale day book report
mrp ------- product gross
non-mrp ------------ no product gross
94.credit reason: breakages, cancellation, dsin, damaged product, invoice reversal, expiry, sales promotion,
price difference, product return, shortages, short collection, vat difference.
95. debit note reason: bank charges, AWD Settlement Payable, Difference in VAT Rate, Sales Promotion Expenses - Display...
Oracle Order Management is one of the most important module of Oracle E-Business Suite.
order is a type of document created by customer for his needed product.
sales order will be have all details about items or goods services requested by customer.
order management two levels: 1. header level(order information)
2.line level(line item)
-->lines will be cancel or delete in entered status. AFTER BOOKING, WE CANNOT DO THE LINE DELETION BUT WE CAN DO CANCEL.
IF WE DELETE THEN ERROR MSG WILL COME BY MENTIONING THE RLM.
--> after the order is booked then we cannot add the new line to that booked(status) order.
invoice number and order number is 11 digit numbers.
1.12. What is order type?
Answer: An order type is the classification of order. It controls the order work flow activity, order number sequence,
credit check point and transaction type.
Order Type is associated to a work flow process which drives the processing of the order
Sales Order Number significance:
Digit 1---------> Division
Digit 2-------> Invoice / Credit note / Debit note ( Invoice=1 ; Credit note=2 ; debit note=3)
Digit 3 and 4 ----------> Depot code ( Chennai=11 ; Ernakulam =12 etc)
Digit 5 and 6----------> Year code ( year 2004=’04’)
Digit 7 to 11----------> Serial number (numeric)
11110209400 signify CPD- invoice – Chennai depot – year 2002- serial no: 9400
1.List price is the price of the item which gets defaulted from the price list.
Unit selling price is the price which gets reflected once the discount which is mentioned in the modifier
2.A lot number is an identification number assigned to a particular quantity or lot of material from a single manufacturer.
3.What is Item Cross References used for?
Cross Reference types define relationship between Items and entities such as Customer Items or Supplier Items.
4.Miscellaneous Issue
if epry date or batch is entered wrong (while taking receipt) mean then the miscellaneous issue will use.
5. Pick release rule
A user-defined set of criteria to define what order lines should be selected during picks release.
6. What does Pick Release mean?
An order cycle action to notify warehouse personnel that orders is ready for picking.
7. What is Back order? When it occurs?
In the Back Order the material gets unreserved. . Backorders caused by Pick Releasing (PR) order lines when there
is no or not enough stock available. and then again do the picking release by changing the unreleased into backorderd.
9.What is a Pick Slip Report?
A: Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.
10. ONT stands for order management.
11.Interface trip stop has 2 parts:
1.It process the data related to Order Management.
2.It Process data related to Inventory
12.Staged/Pick Confirmed for those delivery lines that have received allocation and
Pick Confirmed successfully and Released to Warehouse for delivery lines that
require a manual Pick Confirm or have not been allocated
Released to Warehouse (SE): Pick Release has started but not completed. Either
no allocations were created or allocations have not been Pick Confirmed
13.credit memo: A document that partially or fully reverse an original invoice amount.
14.Autoinvoice is the process of creating an invoice in Accounts Receivables Module.and also moving from interface to receivables.
15.order header level status ,: entered & booked & closed.
16.MODIFIERS enable you to setup price adjustments.
Item Discount gives a price adjustment or benefit to a specific item already on an order when the customer
orders one or more other specified items on the same order.
Promotional Goods adds a new item to an order and gives this item a price adjustment or benefit when the
customer orders one or more specified items on the same order. The item does not need to be originally on the order.
Even if the item is on the order, the pricing engine creates a new line for the item
16. item identifier mean whether it is wgw or tev or scr and so on
17.Statutory reporting is the mandatory submission of financial and non-financial information to a government agency.
18.intransit: shipping is not completed.
19.(i)"debit" usually refers to money removed from a consumer bank account,
such as money removed from your checking account when you buy groceries.
(ii)Similarly, "credit" usually refers to money
added to a consumer bank account,
20. unearned revenue mean the customer pay the money in advance so that money is stored in unearned revenue...
after the invoice the amount is taking from the unearned revenue.(the revenue will hit the unearned revenue).
21.sales reports: it have two sub menu. the sub menu contain many reports in it.
1.statuatory report is compulsory.
2.miscellanous report is if it is necessary mean we can run.
22.ttk netsales repwise
23.In reports, the segment mean item number(like 01100149).
24.lin mean link factor (if uom cas(1) mean the lin is 90 for wgw 130ml)
25.transaction type or order type (both same)
26.outstanding report : in control report
27.quantity*unit selling price = line amount(extended amount)
28.IF THE STATUS IS INTERFACE, MEAN. THE STATUS IS PICKED in line level.SO RUN INTERFACE FROM ORDER MAGMET TO SHIPPING TO INTERFACE.
after shipping==> the status is closed in line level, in shipping transaction form is interface and not applicable. so the
meaning is the order process is over in om module so it is waiting for autoinvoice.
29.pricing engine mean the program which use the modifier and qualifier and price list.......
30.Modifier list level(header level) qualifiers help the pricing engine to determine who is eligible for the modifier lines
31.modifier,it have two level qualiier: 1.list level qualifer(header level). header level(primary).
2.line level qualifer...
32.Lumpsum: Creates a price adjustment for this lump sum amount on the entire line.
The lumpsum can be based on group quantity (sum of item quantities) or an item amount (a monetary amount).
33.REPORTS ---> CONTROL REPORT: TTK SALES ORDER STATUS.
34. ventura division: ayurvedic product
endura division: allopathic product
35.trigger - IS USED FOR control program.
36.What is inside AutoInvoice?
AutoInvoice is a tool consists of 3 main programs. Each program will have unique nature of work to do and they are
called internally except Purge program whose execution is derived on the setup otherwise ready to execute stand alone.
Master (RAXMTR)
Import (RAXTRX)
Purge (RAXDEL)
1] Auto Invoice Master program:
Selects and marks records in the interface tables to be processed based on the parameters the user entered and
then calls the AutoInvoice Import program. Auto Invoice Master program has no report output.
2] Auto Invoice Import Program:
Validates the selected record and creates transaction if it passes validation. Any record that fails validation
is left in the interface table with an error code. Depending on the setup, related records may be rejected as well.
This program has an output file called Auto Invoice Execution report, which you can view by clicking the View Report
button in the Requests window.
37.qoh(quantiy on hand)-ex(100) and available quantity(aq)-ex(75)
38.order source type : internal, online and so on
39.context field is also known as structure field
40. f6 for fresh entry in sales order screen.f4 for exit the window and also exit the query.
41.(RMA) Returned goods details are often received in the Stock Reciept Advice(SRA)
42. receipt number is sex(6) digit numbers.
43.customer site or party site is like wgw,eva and so on
44.Order processing (ENTERING, BOOKING, picking, packing, shipping)
45.An order management system(OMS), is a computer software system used in a number of industries for order
entry and processing.
46.A flexfield is a field made up of sub–fields, or segments. There are two
types of flexfields: key flexfields and descriptive
flexfields.
(i) KFF- Keyflexfields are used throughout the Applications to uniquely identify informations such as GL accounts, INV
items that every business needs to keep track of.
(ii) DFF- Descriptive flexfields enable you to capture additional pieces of information from transaction entered into Oracle EBS.
47.Interface is program used to transfer the data from flat file to database table or from data base table to flat file.
Two types of interfaces:
· Outbound Interface
· Inbound Interface
48. AIA - Application Integration Architecture
49.DEFAULT "PAYMENT TERMS": 30 NET: The balance of the transaction is due within 30 days.
types of payment terms are : DIRECT, ADVANCE DD, THROUGH BANK, IMMEDIATE
50.PAYMENT TYPES IS CASH ,CHECK, CREDIT CARD, DIRECT DEBIT, WIRE TRANSFER.
51.Wire transfer or credit transfer is a method of electronic funds transfer from one person to another.
A wire transfer can be made from one bank account to another bank account.(EX: NEFT, RTGS)
52.AOL: (Oracle)Application Object Library
53. (i)payment terms: direct- the order will go on hold.(it will check the credit check rules)
(ii)payment terms: advance dd- credit balance exceeded message will come while booking.
55.one customer = one primary flag(tick) in customer creation form.
56. if detail like order, price list are not given in ship to(in customer creation form) then order cannot be processed.
57. Credit check rules, order transaction type, payment terms and credit profiles are the key setup entities that
influence the credit check process.(CREDIT CHECK HOLD IS APPLIED IN THESE ABOVE)
58.Automated Clearing House(ACH): IN PAYMENT TYPES SETUP.
59.Credit Memo against Invoice in r12 Receivables.
60. item Rate--> price list--> item rate only based on Batch number.
61.VAT on product gross after discount.
62. fgi- finish goods inventory.
subinv-sub inventory.
63.enter sales order screen--> only display screen with tax
64. CREDIT NOTE AND INVOICE AND DSIN IS RELATED TO OM(DOING IN OM)
65.DEBIT NOTE IS RELATED TO ACCOUNTS RECEIVABLES(AR).
66. CREDIT LIMIT : SUPPLY THE GOODS ONLY BASED ON LIMIT THE COMPANY ASSIGN TO THAT CUSTOMER
67.CREDIT CHECK RULES ---> ADVANCE DD: AT THE TIME OF BOOKING(THE ERROR IS CREDIT Balance IS EXCEEDEDs)
OTHER(DIRECT) ---> AT THE TIME OF PICKING(THE ERROR IS: ITS IN HOLD)
advance dd party ---> no limit because he already paid for his product
68. TRANSACTION TYPES: INVOICE, dsin c/n, CREDIT NOTE, MANUAL D/N, MANAUAL C/N
69. DSIN IS ALSO A ONE TYPE OF CREDIT NOTE.
70. SRS - SCHEDULE REQUEST SERVICE. "Standard Report Submission (SRS)"
71. DC - DELIVERY CHALLAN.
72. CANCEL FMS: WE CAN CANCEL THE fms befor doing transact.
73.modifier - if you want to see which modifier applicable in order is --->actions(in line level)---> view adjustment.
74.ASSESSABLE PRICE LIST: ITS USED FOR CALCULATING vat in particular state with MRP price.
75.Define the transaction sources --- that you will assign to your invoices, debit memos, commitments, credit memos, and
on-account credits. Receivables uses transaction sources to control your transaction and transaction batch numbering, to
specify your default transaction type, and to select validation options for imported transactions. Before you can define a transaction source
for your invoices, you must define transaction sources for your credit memos.
76.At what stage an order cannot be cancelled?
An order cannot be cancelled when it is Pick confirmed.
77.status (release to warehouse) ---> we have to do manual pick.
78.advance dd customer, first we have to do the collection and take receipt and then only do the order for that amount.
79.epd: bill to and ship to: epi,epm,ven,epp,nov.
epi(i mean imd), epm(m mean mmd)
80.in cpd division: except tco(chennai cpd others inv ), all other are (chennai)cpd pharma inv.
81.the order is booked without (automatically) applying modifier so that cancel the order and do the fresh order.
82.in release sales order screen we have two button is 1.execute now and 2.concurrent.
execute now mean the srs(background process) will give first priority to run.
concurrent mean, eg: if 5 (background process) running mean it will run as sixth process.
83.autoinvoice report, error like wrong org id and gl date is closed mean the solution is open the gl period in ar module and
then the run autoinvoices.
84.rma mean sales return and non rma mean van operation, sales promotion, etc.
85. after invoice run two reports that is ttk invoice printing ventor name and ttk sale day book- non mrp (or mrp)
86.after credit note(rma) run reports that is ttk credit note register (rma)
after credit note(non rma) run reports that is ttk credit note register(non rma)
87.(way of shipping the order in shipping form) in shipping transaction form click the deliver and give the status as
open and give the org id and the find and ship confirm.
88.mrp price- maximum retail price (assessable price)
89.non-mrp price-- list price(regular price)
90.after shipping--> line level status is closed
shipping transaction form--> interfaced and not applicable
so run autoinvoices...
the order is interfaced that mean om level process is over.
91. product gross =quantity * unit selling price
92.in price list and modifier, date we have to give
93. in sale day book report
mrp ------- product gross
non-mrp ------------ no product gross
94.credit reason: breakages, cancellation, dsin, damaged product, invoice reversal, expiry, sales promotion,
price difference, product return, shortages, short collection, vat difference.
95. debit note reason: bank charges, AWD Settlement Payable, Difference in VAT Rate, Sales Promotion Expenses - Display...
No comments:
Post a Comment