SLA Transfer to GL and GL posting

1. What are the tables involved in the Transfer to GL and GL posting?


Subledger Tables
XLA_AE_HEADERS
XLA_AE_LINES
XLA_DISTRIBUTION_LINKS

Transfer Journal Entries to GL (XLAGLTRN) process takes the subledger journals and inserts records into the Interface Tables

Interface Tables
GL_INTERFACE / XLA_GLT_

Journal Import (GLLEZL) then reads from the interface table and creates records in the GL Tables

GL Tables
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
GL_IMPORT_REFERENCES

GL Posting process then posts to the GL_BALANCES table.
What are the different methods to transfer Subledger journals to GL?
a) ONLINE MODE
GL Transfer can be spawned during Online Accounting using the "Final Post" option for a specific document (Example: AP Invoice and AR Transaction).
Example: Navigation in Payables: Invoices/Entry/Invoices: Action: Create Accounting/Final Post. This spawns the GL Transfer, the Journal Import, Data Manager and the GL Posting processes. This request transfers ALL the final accounted data for that document. This method of transfer uses the interface table GL_INTERFACE to move the journals to the general ledger.

b) BATCH MODE
GL Transfer can also be spawned by the Create Accounting concurrent request when submitted with the "Transfer to GL" parameter set to Y.
Example: Navigation in Payables: Other/Request/Run: Create Accounting
This spawns the journal import and the data manager processes. The GL Posting process is spawned if the Post to GL parameter is set to Yes when submitting the Create Accounting. This request transfers all the final accounting created by the Create Accounting request that spawned it. This method uses the interface table XLA_GLT_.

c) CONCURRENT REQUEST
GL Transfer can be submitted in standalone mode using the concurrent request "Transfer Journal Entries to GL".
Example: Navigation in Payables: Other/Request/Run: Transfer Journal Entries to GL
This spawns the Journal Import and the Data Manager programs. This request transfers all the final accounting that exists for the given ledger and end date. This method uses the interface table XLA_GLT_.
What columns indicate the Transfer Status of accounting data in subledger?
The XLA_AE_HEADERS table shows the transfer status of the accounting data, after successful transfer to the GL and Journal Import:
XLA_AE_HEADERS.gl_transfer_status_code = Y
XLA_AE_HEADERS.gl_transfer_date is not null
XLA_AE_HEADERS.group_id is not null
For 11i data upgraded to R12, the transfer status can be determined using the following
XLA_AE_HEADERS.gl_transfer_status_code = Y
XLA_AE_HEADERS.gl_transfer_date is null
XLA_AE_HEADERS.group_id is null
XLA_AE_HEADERS.upg_batch_id is not null --> indicates 11i data

How many group_ids are created during the transfer process when there is a primary ledger and associated ALC/reporting ledger?
The primary ledger data and associated ALC/reporting ledger data goes into one group_id. Data from this one group_id can be split across multiple GL Batches based on other criteria, such as je_category/date/period. However, one GL Batch can only be associated to one group_id.

Oracle Purchasing Interview Questions

Oracle Purchasing Interview Questions 

Some Oracle Apps Purchasing FAQ’s

1. What is a Purchase Requisition and define various requisitions
2. What are the base tables for a Purchase Requisition?
3. What is a Requisition Import Program?
4. What tables are affected when you run Requisition Import Program?
5. What are the reports associated with requisition import process?
6. When will you use a Requisition Template?
7. What is the purpose of choosing a Category when creating a requisition?
8. What does the status pre-approved mean?
9. What is the difference between a rejected and a returned requisition?
10. What is RFQ and differentiate the types of RFQ’s
11. What is a Quotation, what are the different types of Quotations available and describe the Quote Analysis?
12. What is a Purchase Order and explain the different types of PO’s available
13. What are the base tables that are affected when you create a P.O?
14. What is 2-way, 3-way, 4-way matching?
15. Explain the P2P process flow
16. What is an approval hierarchy?
17. What are the documents that use PO_HEADERS_ALL?
18. Can the original Purchase Order be viewed in any way without resorting to SQL, for a revised Purchase Order?
19. Can we automatically ‘Close’ the Purchase order without receiving the full quantity?
20. When does a Purchase Order line get the Status ‘Closed for Receiving’?
21. Can we match an Invoice against a line even when it is ‘Closed for Invoicing’?
22. What does create internal order conc request do?
23. Explain the Receipt Routing
24. What are the different Purchasing modes in Receiving? 
25. Which tables are updated When you save a Received Data in a form?
26. What are the major transactions in RECEIVING? 
27. What is Pay on Receipt AutoInvoice Program?

Answers

1.   What is a Purchase Requisition and define various requisitions

It is a formal request intended to procure/buy something that is needed by the organization. It is created and approved by the department requiring the goods and services.

A purchase requisition typically contains the description and quantity of the goods or services to be purchased, a required delivery date, account number and the amount of money that the purchasing department is authorized to spend for the goods or services. Often, the names of suggested supply sources are also included.

Basically, requisitions are of two types:

Internal requisition and purchase requisition

Internal Requisitions are created if the Items are to be obtained from one Inventory location to another location within the same organization. Here the source of the requisition would be INVENTORY. There is no approval process for internal requisition.

Purchase Requisitions are created if the goods are obtained from external suppliers. Here the source of the requisition would be SUPPLIERS. The purchase requisitions are sent for approvals.

2.   What are the base tables for a Purchase Requisition?

PO_REQUISITION_HEADERS_ALL (SEGMENT1 column in this table represents the requisition number)

This table stores Header information of a Purchase Requisition.

Important columns of this table:

REQUISITION_HEADER_ID:                     It is a unique system generated Requisition identifier

PREPARER_ID:                                         It is a unique identifier of the employee who prepared  the requisition

SEGMENT1:                                             It is the Requisition number
AUTHORIZATION_STATUS:                      Authorization status type
TYPE_LOOKUP_CODE:                            Requisition type
ORG_ID:                                                  Unique Operating unit unique identifier

PO_REQUISITION_LINES_ALL

This table stores information about Requisition lines in a Purchase Requisition. This table stores information related to the line number, item number, item category, item description, item quantities, units, prices, need-by date, deliver-to location, requestor, notes, and suggested supplier information for the requisition line.

Important columns of this table:

REQUISITION_HEADER_ID:               It is a unique system generated Requisition identifier

REQUISITION_LINE_ID:                     Link between PO_REQUISITION_LINES_ALL And PO_REQ_DISTRIBUTIONS_ALL

LINE_NUM:                                        Indicates the Line number

LINE_TYPE_ID:                                   Indicates the Line type

CATEGORY_ID:                                   Unique Item category identifier

ITEM_DESCRIPTION:                          Description of the Item
QUANTITY NUMBER:                         Quantity ordered

PO_REQ_DISTRIBUTIONS_ALL

This table stores information about the accounting distributions of a requisition line. Each requisition line must have at least one accounting distribution. Each row includes the Accounting Flexfield ID and Requisition line quantity.

Important columns of this table:

DISTRIBUTION_ID:                               Unique Requisition distribution identifier
REQUISITION_LINE_ID:                        Unique Requisition line identifier
CODE_COMBINATION_ID:                    Unique General Ledger charge account identifier
DISTRIBUTION_NUM:                           Distribution number

3.   What is a Requisition Import Program?

It is a concurrent program, which is used to import requisition from Oracle or Non-Oracle system.

Data is first loaded in PO_REQUISITION_ALL table. The RIP can then be run, to import the records from the interface table as requisition in Oracle Processing.

RIP creates a requisition line and one or more requisition distribution for each row it finds in the interface table. It then groups these lines on Requisitions according to parameters defined

4.   What tables are affected when you run Requisition Import Program?

PO_REQUISITION_INTERFACE_ALL

PO_REQ_DIST_INTERFACE_ALL

PO_INTERFACE_ERRORS

5.   What are the reports associated with requisition import process?

Requisition Import Run Report: We can view the number of requisitions created and the number of records that showed an error

Requisition Import Exceptions Report: In this report we can see all the rows that fail validation.

6.   When will you use a Requisition Template?

Requisition templates can be used to help you quickly create requisitions. A requisition template contains much of the information needed to create a requisition, thus reducing the amount of data entry required to create a new requisition. If you find yourself repeatedly creating similar requisitions for your group or department, you should consider creating and saving requisition templates as a time-saver.

If the data of requisition remain the same for repeated purchase of an item, the information can be copied to a template and the same can be copied to the Requisition as many number of times as required.

7.   What is the purpose of choosing a Category when creating a requisition?

The Category box is a required field and is used to define goods and services at a summary or detailed level.

8.   What does the status pre-approved mean?

Pre-Approved is the status of a requisition when an authorized approver has approved the requisition and has forwarded the requisition to another individual to review.

9.   What is the difference between a rejected and a returned requisition?

Only an approver or a reviewer can reject requisition. Only a buyer can return a requisition. A buyer will return a requisition to the preparer for incomplete or inaccurate information.

10.   What is RFQ and differentiate the types of RFQ’s

A Request for Quotation (RFQ) is a formal request sent to the suppliers to find the pricing and other information for an item or items. Based on the information supplied, the supplier quotes a quotation against the RFQ form.

In general, RFQ’s are created before purchasing any item to actually know the price quotes from one or more suppliers.

In Oracle EBS, RFQ’s can be auto created from an existing Purchase Requisition or can be a fresh RFQ.

There are three types of quotations and RFQs that come with Purchasing by default:

• Catalog: Used for high-volume items or items for which your supplier sends you information regularly. A Catalog quotation or RFQ also includes price breaks at different quantity levels.
• Standard: Used for items you’ll need only once or not very often, but not necessarily for a specific, fixed quantity, location, and date. For example, you could use a Catalog quotation or RFQ for office supplies, but use a Standard quotation or RFQ for a special type of pen you don’t order very often. A Standard quotation or RFQ also includes price breaks at different quantity levels.
• Bid: Used for a specific, fixed quantity, location, and date. For example, a Bid would be used for a large or expensive piece of equipment that you’ve never ordered before, or for an item that incurs transportation or other special costs. You cannot specify price breaks for a Bid quotation or RFQ.

11.   What is a Quotation, what are the different types of Quotations available and describe the Quote Analysis?

A quotation is a supplier’s response to RFQ.

Quote analysis is the process of reviewing the quotations given by the suppliers. The best quotation will be selected by analyzing certain factors like price, quality, delivery time etc.

12.   What is a Purchase Order and explain the different types of PO’s available

A Purchase order is a commercial document and first official order issued by the buyer to the supplier, indicating types, quantities, and agreed prices for products or services the supplier will provide to the buyer.

Basically, there are four types of Purchase Orders, viz

Standard Purchase Order	Used for One-time purchases for goods and services. Here you know the item, price, payment terms an delivery schedule
Planned Purchase Order	Created when you have long-term agreement with the supplier. You must specify the details of goods and services, payment terms and the tentative delivery schedule
Blanket Purchase Agreement	Created when the details of items and services, payment terms are known but not specific about the delivery schedule
Contract Purchase Agreement	Created when the terms and conditions of a purchase are known but specific goods and services are not.

13.   What are the base tables that are affected when you create a P.O?

PO_HEADERS_ALL (SEGMENT1 column in this table represents the Document number)

This table stores header information of a Purchasing Document. You need one row for each document you create.

PO_LINES_ALL

This table stores the line information of a Purchasing Document

PO_LINE_LOCATIONS_ALL

This table contains the information related to purchase order shipment schedules and blanket agreement price breaks. You need one row for each schedule or price break you attach to a document line.

PO_DISTRIBUTIONS_ALL

This table contains the information related to accounting distribution of a purchase order shipment line. You need one row for each distribution line you attach to a purchase order shipment

VENDORS_ALL

This table stores the general information about the suppliers

PO_VENDOR_SITES_ALL

This table stores information about the supplier sites. Each row includes the site address, supplier reference, purchasing, payment, bank, and general information.

PO_RELEASES_ALL

This table stores information related to planned and blanket Purchase Order releases. Each row includes the buyer, date, release status, and release number. Each release must have at least one purchase order shipment.

PO_VENDOR_CONTACTS

This table stores information about contacts related to Supplier site. Each row includes contact name and site.

PO_ACTION_HISTORY

This table stores information about the approval and control history of a Purchasing Document. This table stores one record for each approval or control action an employee takes on a purchase order, purchase agreement, release or requisition.

14.   What is 2-way, 3-way, 4-way matching?

Oracle Payables shares purchase order information from your purchasing system to enable online matching with invoices. Invoiced or billed items are matched to the original purchase orders to ensure that you pay only for the goods or services you ordered and/or received.

Two–Way: Purchase order and invoice quantities must match within tolerance before the corresponding invoice can be paid.

Three–Way: Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.

Four–Way: Purchase order, receipt, accepted, and invoice quantities must match within tolerance before the corresponding invoice can be paid.

15.   Explain the P2P process flow

Procure to pay (p2p) is a process of requesting, purchasing, receiving, paying for and accounting for goods and services.  Procure to Pay Lifecycle is one of the important business Process in Oracle Applications. It’s the flow that gets the goods required to do business.  It involves the transactional flow of data that is sent to a supplier as well as the data that surrounds the fulfillment of the actual order and payment for the product or service.

Create a requisition>> create RFQ>> create a quotation from quote analysis>> generate a PO>>receipt of material>> create Invoice in payables>> transfer to GL

16.   What is an approval hierarchy?

Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships.

17.   What are the documents that use PO_HEADERS_ALL?

The following are the documents that use PO_HEADERS_ALL

RFQ’s, Quotations, Standard Purchase Order, Planned Purchase Order, Blanket Purchase Order and Contracts

18.   Can the original Purchase Order be viewed in any way without resorting to SQL, for a revised Purchase Order?

The original version of a revised PO cannot be viewed from the PO form or PO summary form. Information on the original PO can be obtained from the PO_HEADERS_ARCHIVE and PO_LINES_ARCHIVE tables using the PO_HEADER_ID column as a common reference using SQL only.

19.   Can we automatically ‘Close’ the Purchase order without receiving the full quantity?

The Receipt Close Tolerance lets you specify a quantity percentage within which Purchasing closes a partially received shipment. For example, if your Receipt Close Tolerance is 5% and you receive 96% of an expected shipment, Purchasing automatically closes this shipment for receiving.

20.   When does a Purchase Order line get the Status ‘Closed for Receiving’?

Goods have been received on the system against this line but an invoice has not been
matched to the order.

21.   Can we match an Invoice against a line even when it is ‘Closed for Invoicing’?

The Close for invoicing status does not prevent you from matching an invoice to a purchase order or to a receipt.

22.   What does create internal order conc request do?

Create internal order request will transfer the IR info to OM interface tables.

23.   Explain the Receipt Routing

Receipt Routing is of three types: Direct, Standard and Inspection

In Direct once the goods arrive at the destination, we directly move them to a specific Sub-Inv

In Standard once the goods are at the destination, we receive it at the receiving point first and then move them to the Sub-Inv.

In Inspection once the goods are at the destination, we receive it at the receiving point and then we perform inspection and accordingly we either accept it or reject them.

24.  What are the different Purchasing modes in Receiving? 

There are three modes:

Online: Receipts are processed online. If there are any errors, they are shown on the FORM itself, and don’t let you IGNORE and PROCEED.

Immediate: Receipts are processed immediately, but no errors are shown. Errors are recorded in REC_TRANSACTION_INTERFACE table.

Batch: Receipts are processed in batch, but no errors are shown. Errors are recorded in REC_TRANSACTION_INTERFACE table.

Note: In all the above two cases, it requires Receiving Transaction Processor to be run periodically.

25.  Which tables are updated When you save a Received Data in a form?

RCV_SHIPMENT_HEADERS:                               It contains supplier shipment header data like Shipment date, supplier Name

RCV_TRANSACTIONS_INTERFACE:                 It contains received data like Item name, quantity, and receiving location

RCV_SHIPMENT_LINES

MTL_MATERIAL_TRANSACTIONS_TEMP

PO_LINE_LOCATIONS_ALL

PO_DISTRIBUTIONS_ALL

26.  What are the major transactions in RECEIVING? 

Purchase Order Receipts

Internal Requisition Receipts

Inventory Inter-Org Transfer Receipts

Customer Return Receipts

27.   What is Pay on Receipt AutoInvoice Program?

By running this program, we can automatically create an invoice for a PO when we enter a receipt for the respective PO.

28.  What is Invoice Validation Process?

Before you can pay or create accounting entries for any invoice, the Invoice Validation process must validate the invoice.

Invoice Validation checks the matching, tax, period status, exchange rate, and distribution information for invoices you enter and automatically applies holds to exception invoices. If an invoice has a hold, you can release the hold by correcting the exception that caused Invoice Validation to apply the hold by updating the invoice or the purchase order, or changing the invoice tolerances.

ORDER MANAGEMENT Interview Questions

ORDER MANAGEMENT Interview Questions

Q: What are the Process Constraints?
A: Processing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its order or line workflows to avoid data inconsistencies and audit problems.
Q: 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.
Q: At what stage an order cannot be cancelled?
A: If the order is Pick Confirmed, it cannot be cancelled.
Q: When the order import program is run it validates and the errors occurred can be seen in?
A: Order Management Responsibility >Orders, Returns : Import Orders> Corrections
Q: What is the difference between purchase order (PO) and sales order?
A: Purchase Order: The document which is created and sent to supplier when we need to purchase something. (Buying)

Sales Order: The document which is created when customer places an order to buy something. (Selling)
Q: What are primary and secondary price lists?
A: Price list contains information on items and its prices. The pricing engine uses secondary price lists when it cannot determine the price for an item using the price list assigned to an order.
Q: Name some tables in shipping/order/move order/inventory?
A: WSH_DELIVERY_DETAILS,WSH_NEW_DELIVERIES, OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, MTL_SYTEM_ITEMS_B, MTL_MATERIAL_TRANSACTIONS
Q: How is move order generated?
A: When the order is pick released.
Q: What is ONT stands for?
A: ORDER MANAGEMENT
Q: What does Back ordered mean in OM?
A: An unfulfilled customer order due to non-existence of the ordered items in the Inventory.
Q: What are picking rules?
A: A user-defined set of criteria to define the priorities Order Management uses when picking items out of finished goods inventory to ship to a customer. Picking rules are defined in Oracle Inventory.

Q: What is drop ship in OM?
A: A method of fulfilling sales orders by selling products without handling, stocking,or delivering them. The selling company buys a product from a supplier and has the supplier ship the product directly to customers.
Q: What are Defaulting Rules?
A: While creating the order,you can define defaulting rules so that the default values of the fields pop up automatically instead of typing all information.
Q: What are validation templates?
A: A validation template names a condition and defines the semantics of how to validate that condition. Validation templates can be used in the processing constraints framework to specify the constraining conditions for a given constraint.
Q: What are different Order Types?
A: Order Only, Mixed, RMA

Q: Explain the Order Cycle?
A: Book the order
Pick Release
Pick Confirm
Ship Confirm
Close the order
Q: What is packing slip?
A: An external shipping document that is sent along with a shipment itemizing in detail the contents of that shipment.
Q: When an order cannot be deleted?
A: Order cannot be delted if the Order is Pick Confirmed.
Q: What is pick slip?
A: Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.

Q: What is Drop shipment?
A: Drop Shipment is a process where the customer places a purchase order on a company and this company instructs its supplier to directly ship the items to the customer.

1.       What are the various order management processes supported by oracle OM?

2.       Describe the order flow in Order to Cash life cycle

3.       Describe the processes involved after entering sales order?

4.       What are the different types of sales orders available?

5.       When is an item eligible for customer order?

6.       Describe the Header status during the sales order process?

7.       Describe the line status during the sales order process?

8.       Differentiate available quantity and on-hand quantity?

9.       Differentiate Supply Eligible Status and Supply Partial Status?

10.   Describe scheduling in sales order?

11.   What are the various ways of scheduling the sales order?

12.   Differentiate ship set and arrival set?

13.   What are the Process Constraints?

14.   At what stage an order cannot be cancelled?

15.   What are picking rules?

16.   What are Defaulting Rules?

17.   What are validation templates?

18.   What is pick slip?

19.   What is packing slip?

20.   What is shipping exceptions report?

21.   Explain Bill of Lading?

22.   What is Interface trip stop?

23.   When is drop ship order created?

24.   What is ASN?

25.   What is Autoinvoice?

26.   Explain the difference between a credit memo and an invoice?

27.   What is FOB?

28.   What are the different RMA Order Types?

29.   What are the necessary setups to perform Internal Sales Order?

30.   What are Modifiers and Qualifiers?

31.   What are the possible reasons for Interface trip stop to complete with Error?

1.  What are the various order management processes supported by oracle OM

        Standard orders: This method supports Make to Stock business model where the products are made and kept in stock. The products are then shipped to the customer based on his order.

·       Configure to orders: this method supports Assemble to Order business model. The product configuration is chosen at the time of sales order entry. WIP job is created based on the requirement of the sales order

·      Drop ship orders: In this method, your supplier will ship the goods to   your customer on your behalf

·    Internal sales orders: Internal sales orders are created across two    different organizations of the same business group. Internal requisition is raised first and is converted to an internal sales order where the items are shipped based on the quantity specified in the internal sales order.

2.  Describe the order flow in Order to Cash life cycle

• Enter the sales order
• Book the sales order
• Pick release
• Ship confirm
• Auto Invoice generation
• Creating receipt
• Transfer to GL

3.  Describe the processes involved after entering sales order?

• The items specified on the order are validated in Oracle Inventory
• The price of the items are calculated using the pricing engine
• The availability of the items are checked and may be reserved
• The items are then pick released and shipped to the customer.

4.  What are the different types of sales orders available?

• Standard
• Mixed
• Return

5.  When is an item eligible for customer order?

When the attributes ‘Customer Ordered’ and ‘Customer order enabled’are checked in the order management tab of Master Items.

6.  Describe the Header status during the sales order process?

Entering the sales order                               Entered

Booking the sales order                                Booked

Pick release the order                                   Booked

Ship confirm the order                                 Booked

Running interface trip stop                          Booked

7.  Describe the line status during the sales order process?

Entering the sales order                               Entered

Booking the sales order                                Awaiting shipping (when  sufficient quantity is available)

Supply eligible (when sufficient quantity is not available)

Pick release the order                                    Picked

Ship confirm the order                                  Shipped

Running interface trip stop                          Closed

8.  Differentiate available quantity and on-hand quantity?

Available quantity + Reserved quantity = On-hand quantity

9.  Differentiate Supply Eligible Status and Supply Partial Status?

Supply Eligible

When there is no sufficient quantity available.

Example: When user tries to book a sales order for Item ‘TestItem’ for a quantity of 10 but the item contains zero quantity. Then the Sales Order Line Status change to ‘Supply Eligible’.

Supply Partial
when the quantity is partially available.
Example: When user tries to book a sales order for Item ‘TestItem’ for a quantity of 10 but the item contains only 4 quantities. Then the Sales Order Line Status changes to ‘Supply Partial’.

10.  Describe scheduling in sales order?

It is a process of communicating the balance between customer demand and a company’s ability to fulfill an order from current inventory and supply sources

11.  What are the various ways of scheduling the sales order?

• Setting Profile option – OM:AutoSchedule to yes
• From Tools Menu->Check Autoschedule Checkbox in Sales Order Screen.
• Right Click on Sales Order Line ->Scheduling->Schedule.

• Schedule Order Concurrent Program.

12.  Differentiate ship set and arrival set?

In the ship set process, the user would like to ship group of order lines from same warehouse to same location. If Order Lines are grouped under ship set, then until all lines in the ship set satisfy the demand, you cannot ship the goods to customer.

In the Arrival Set process, the customer requests specific order lines to arrive together

13.  What are the Process Constraints?

Processing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its order or line workflows to avoid data inconsistencies and audit problems.

14.  At what stage an order cannot be cancelled?

An order cannot be cancelled when it is Pick confirmed.

15.  What are picking rules?

A user-defined set of criteria to define the priorities Order Management uses when picking items out of finished goods inventory to ship to a customer. Picking rules are defined in Oracle Inventory.

16.  What are Defaulting Rules?

While creating the order, you can define defaulting rules so that the default values of the fields pop up automatically instead of typing all information.

17.  What are validation templates?

A validation template names a condition and defines the semantics of how to validate that condition. Validation templates can be used in the processing constraints framework to specify the constraining conditions for a given constraint.

18.  What is pick slip?

Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.

19.  What is packing slip?

It is a shipping document that is sent along with the shipment which details the contents that are sent in that shipment.

20.  What is shipping exceptions report?

Shipping exceptions report prints the exceptions messages during ship confirmation.

21  Explain Bill of Lading?

It is a legal document between the shipper of a particular item and the carrier detailing the type, quantity and destination of the good being carried

The bill of lading also serves as a receipt of shipment when the good is delivered to the predetermined destination. This document must accompany the shipped goods, no matter the form of transportation, and must be signed by an authorized representative from the carrier, shipper and receiver.

22.  What is Interface trip stop?

ITS is triggered at the time of shipping if the option ‘defer interface’ is not checked. When this report is run, it performs two main things:

Update the order management (OE_ORDER_LINES_ALL)

Trigger the inventory interface (TO UPDATE Inventory tables)

23.  When is drop ship order created?

• Customer requires an item that is not stocked normally
• Customer requires large quantities of the item that is not available with you
• It is more economical when the supplier sends the item directly to the customer

24.  What is ASN?

It is an advanced Shipment Notice which is transmitted via Electronic Data Interchange (EDI) from a supplier to let the receiving organization know that the shipment is arriving.

The ASN contains the shipment date, time, identification number, packing slip data, freight information etc

25.  What is Autoinvoice?

It is a concurrent program which is used to perform the invoice processing. Once the order or lines are eligible for invoicing, the invoice interface workflow activity interfaces the data to reeivables

26.  Explain the difference between a credit memo and an invoice?

Credit memo is raised to partially or fully reverse an original invoice amount

An invoice is generated in receivables which show the amount owed by the customers for the purchase of goods or services. It may also contain tax and freight charges

27.  What is FOB?

The term FOB means Freight (or free) on Board is commonly used when shipping goods to indicate who pays loading and transportation costs, and/or the point at which the responsibility of the goods transfers from shipper to buyer.

“FOB shipping point” or “FOB origin” indicates the buyer pays shipping cost and takes responsibility for the goods when the goods leave the seller’s premises. “FOB destination” designates the seller will pay shipping costs and remain responsible for the goods until the buyer takes possession.

28.  What are the different RMA Order Types?
RMA with Credit is used when the customer returns the physical product and also receives credit as a result of the return.
RMA no Credit is used when the customer will return the product but will not be receiving a credit as a result of the return.
RMA Credit only is used when the customer will receive a credit, but the physical return of the product is not required.

29.  What are the necessary setups to perform Internal Sales Order?

• Internal Order and Internal Ordered Enabled set to ‘Yes’.
• Shipping Network(Intransit or Direct) must be defined.
• Internal Customer must be defined

30.  What are Modifiers and Qualifiers?

Modifiers are discount, surcharge or special charge that may be applied to the base price and may alter the value of the item. It can be applied either at order level or at the line level.

A qualifier helps you define who is eligible for a price list or modifier. A qualifier can be a customer name, a customer class, an order type, or an order amount that can span orders.

31.  What are the possible reasons for Interface trip stop to complete with Error?

Few reasons may be

1) Order is on Hold

2) Tax is not applied properly

3) On-Hand qty is not available in the Inventory

4) Inventory Period is not open

5) Make sure Schedule Ship Date or Requested Date is within the range of order Date