Oracle lookup is a collection of values (or, list of values) which is accessed through a user interface and used for validation and to keep programs flexible and easier to configure.
There are three types of lookup in Oracle R12 which are System, Extensible and User. [Read more..]
The Inventory Transactions Manager (Process Transaction interface – INCTCM) reads records from the MTL_TRANSACTION_INTERFACE table, validates them and moves the successful transactions into the MTL_MATERIAL_TRANSACTIONS_TEMP table. If record got stuck(while processing) it can be viewed from Transaction Open Interface (TOI) Window. INCTCM then submits Inventory Transaction workers (sub-processes – INCTCW) which then process these records to MTL_MATERIAL_TRANSACTIONS. [Read more….]
Interface Trip Stop program is submitted automatically (if Defer Interface Flag is unchecked in ship confirm window) at the time of ship confirm, or it can be submitted manually later from Order Management responsibility/Shipping/Interfaces/Run. Run the request: Interface Trip Stop – SRS.
Interface Trip Stop program consists of two parts:
1. Order Management Interface
2. Inventory Interface
In this Article, we will go through the entire flow cycle from the Creation of Requisition(Internal) to creation of Sales Order(Internal) and then receiving against that Internal Sales Order into the destination Organization. This Flow covers multiple modules like Purchasing, Order Management, Inventory.
Major Steps involved are:
1. Make an Internal Requisition(in Purchasing responsibility)
2. Run Create Internal Orders program
3. Run Order Import program and process the order.
4. Receive/Deliver the Shipment against the Internal Sales Order
Chebyshev’s inequality in Data Science The part of any arrangement of numbers lying within k standard deviations of those numbers of the mean of those numbers is at least . […]
Descriptive Statistics in depth for Data Science: Variance is an estimation of the variability between data points in a data set. Variability can be measured by estimating the distance between […]
Linking between Internal Requisition IR and Customer for creating Internal Orders in Oracle(R12). This scenario is based on creating an Internal Order from Internal Requisition (IR-ISO cycle). Internal Order is […]
Statistics The science that handles with the gathering, grouping, investigating, and explanation of numerical actualities or information, and that, by utilization of scientific hypotheses of probability, urges request and normality […]
What is Data Science ? Collaborative field that combine statistical and mathematical methods or process, algorithm to model data,system to analyze the information behind structured and unstructured data is called […]