• Inbound Logistics (Receiving from Supplier, Returns, Corrections)
• Outbound Logistics (Picking, Packing, Shipping)
• Reverse Logistics (Customer Returns)
• Stocking and Internal Inventory Movements
• WIP JOB Assembly completion, Component issues

Oracle Conversion

1. Difference b/w procedure and function?  A procedure may return (one or more values using OUT & INOUT Parameters) or may not return a value. But a function has to return a single value and has the return clause in its definition. Function can be called in select statements but procedure can only be called in a pl/sql block.  Procedure's parameters can have IN or OUT or INOUT parameters. But function's parameters can only have IN parameters.

2. Difference b/w ROWID and ROWNUM? ROWID : It gives the hexadecimal string representing the address of a row.It gives the location in database where row is physically stored. ROWNUM: It gives a sequence number in which rows are retrieved from the database.

1. None :- Validation is minimal.

• Chart of Accounts (M)
• Account Combinations
• Period Types (M)
• Calendar (M)
• Transaction Calendar
• Currencies (M)
• Set of Books or SOB (M)
• Assign SOB to a responsibility (M)
• Daily conversion Rate types (M)
• Rates

Introduction to Cycle count

• Performed periodically to ensure accuracy of inventory quantities & values.
• Frequency of counting item may be based on the classification of items.
1. Example:
• Class A items shall be counted 4 times a year
• Class B items shall be counted 2 times a year
• Class C items shall be counted once in a year
• A method of taking inventory that does not require the inventory organization to shut down in order to count actual inventory items.

System Reference

• Oracle Inventory: ABC Codes
• ABC Compiles.
• ABC Classes.
• ABC Assignment Groups.
• Inventory, Vision Operations (USA): Counting > Cycle Counting > Cycle Counts

User Responsibilities



The store’s in-charge is responsible for:
• Setting up the cycle count parameters and scheduling.


The store’s person is responsible for:
• Printing cycle count requests.
• Performing the item counting.
• Entering actual item counts.
• Resolving inventory discrepancies in the database with Finance department.

Ownership

The Head of Material’s Department is responsible for ensuring that this document is necessary, reflects actual practices and supports company policy.

Prerequisites

• Item classification shall be done (by finance and material dept)
• Frequency of counting shall be decides (by Material dept)
• System setup shall be done (by Material / IT)

Steps for ABC Analysis

1. Creating a ABC compile.
2. Generating ABC descending value report.
3. Defining ABC Classes.
4. Defining ABC Assignment Group.
5. Associating classes and assignment group.
6. Assigning items to classes.
7. Updating item assignment.
8. Generating the ABC assignment report.

1. Create a ABC compile



The ABC compile ranks all the items in your inventory based upon compile criteria. This ranking is used to assign classes to your items.


Compile Criterion:
ABC analysis is done based on the value of consumptions. But initially till next 6 months from the date of Oracle implementation it will be based on Stock-in-hand value. Moving ahead it will be shifted to Consumption base.

Current on-hand quantity	Use the current on-hand quantity of inventory. Assign the sequence number by descending quantity.
Current on-hand value	Use the current on-hand quantity of inventory times the cost for the cost type. Assign the sequence number by descending value.
Historical usage value	Use the historical usage value (transaction history). This is the sum of the transaction quantities times the unit cost of the transactions for the time period you specify. Assign the sequence number by descending value.
Historical usage quantity	Use the historical usage quantity (transaction history) for the time period you specify. Assign the sequence number by descending quantity.
Historical number of transactions	Use the historical number of transactions (transaction history) for the time period you specify. A ssign the sequence number by descending number of transactions.
Forecasted usage value	Use the forecasted usage value based on the forecast quantity calculated and the cost type you specify. Assign the sequence number by descending value.
Forecasted usage quantity	Use the forecasted usage quantity. Assign the sequence number by descending quantity.
Previous cycle count adjustment quantity	Use the previous cycle count adjustment quantity. Oracle Inventory sums the value of all cycle count adjustments since the last ABC compile date. Assign the sequence number by descending quantity.
Previous cycle count adjustment value	Use the previous cycle count adjustment transaction value. Oracle Inventory sums the value of all cycle count adjustments since the last ABC compile date. Assign the sequence number by descending value.
MRP demand usage quantity	Use the MRP demand usage quantity. Oracle Inventory sums the MRP gross requirements for the MRP plan you specify. Assign the sequence number by descending quantity.
MRP demand usage value	Use the MRP demand usage value. Oracle Inventory sums the MRP gross requirements for the MRP plan you specify. The value is derived from the item cost type you choose in the ABC compile form. Assign the sequence number by descending value.



• Login to Oracle.
• Select  “Inventory, Vision Operations (USA)”
• Select “ABC COMPILE”.

FND POPIDR APPL_SHORT_NAME=”SQLGL” CODE=”GL#”
  NUM=:$FLEX$.XLA_SRS_CHART_OF_ACCOUNTS REQUIRED=”Y”
  VALIDATE=”NONE” SEG=”:!VALUE” DESC=”:!MEANING”
  NAVIGATE=”!DIR” VDATE=””

Use Global Variables in Form Personalization:

• Select Type as ‘Property’ and select Object Type as ‘Global Variable’.
• Give a name to the global variable in the ‘Target Object’ tab. (Ex. G_ITEM_NAME, G_ORG_CODE)
• Select the Property Name as ‘VALUE’.
• In the value tab- Give ‘=:Block_name.Field_name’ (Use: Help > Diagnostics > Examine). This is the value which you want to put in the global variable.

VARIOUS QUERIES ON CUSTOMER DATA (HZ TABLES)

Queries

Supplier API in R12