How does Requisition Import determine the grouping method for incoming pieces of data?
This function groups requisitions. It first assigns values to REQUISITION_LINE_ID and REQ_DISTRIBUTION_ID; the function then groups Requisitions based on the REQ_NUMBER_SEGMENT1 column. All requisitions with the same NOT NULL REQ_NUMBER_SEGMENT1 are assigned the same REQUISITION_HEADER_ID. The function then groups Requisitions based on the GROUP_CODE column. All requisitions with the same value in the GROUP_CODE column are assigned the same REQUISITION_HEADER_ID. It then groups based on the GROUP_BY parameter, which takes on the value of DEFAULT_GROUP_BY if not provided. GROUP_BY could be one of the following: BUYER, CATEGORY, ITEM, VENDOR, LOCATION or ALL.
What is the Basic Purchasing Setup for Requisition Import?
If importing requisitions from Inventory, input a value for the profile option INV: Minmax Reorder Approval. If the value of INCOMPLETE is selected, the result will be imported Requisitions that require an approval. If the value is APPROVED, then the requisitions cannot be queried in the Requisition entry form; rather, the Requisition Summary form will have to be utilized to view information on the imported approved requisitions.
Oracle apps 12.1.1 Modules db prefixes
These are the oracle applications module's database table prefixes. Format is PREFIX -- Module name.
All tables in Order Entry Module are starts with with OE_. Here is full list
List of tables in Oracle Apps order management 12.1.1
These are all tables present in Order Management modules
How to Cancel an Order Line that been pick released ?
It is not possible to cancel a pick released order line if there are processing constraint which have been enabled to prevent this from happening.
There are two methods that can be used to.
How are cancellations handled in drop ship orders?
A new functionality for Cancelling Drop Ship Orders is added in OE with
the fix for bug 1380679.
How are over/under shipments handled in drop shipment?
If part of a drop-ship line ships and you do not wish to fulfill the
remaining quantity, cancel the line. Over-shipments must also be handled
manually. If the supplier ships more than the ordered quantity, you can bill
your customer for the additional quantity or request that they return the
item.
Use the 'Sales Order and Purchase Order Discrepancy Report' to view differences between your
drop-ship sales orders and their associated purchase requisitions and orders.
Refer to Order Entry/Shipping User's Guide, R11 Volume 1, page 2-1
What are the Item Attributes that affect Drop Ship orders?
The following item attributes affect drop ship orders and they should be set to respective values as below:
Recent Posts
- Oracle Nukes ETRM
- Urgent Required- IT MNC- Oracle Apps SCM Professionals-Bangalore,Pune,Chennai,Hyderabad
- Account Receivables Tables list oracle r12.2
- General Ledger tables
- Account Payables Tables
Recent Comments
Archives
- April 2021
- June 2015
- April 2015
- March 2015
- July 2014
- April 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- August 2013
- January 2013
- June 2012
- May 2012
Categories
- Account Payables
- Advanced Pricing
- General Ledger
- implementation
- Inventory
- jobs
- Multi Org
- Oracle apps general
- oracle fnd
- oracle forms
- oracle hrms
- Order Management
- Purchasing
- Receivables
- Uncategorized
- vision instances