Showing posts with label Oracle Inventory. Show all posts
Showing posts with label Oracle Inventory. Show all posts

Wednesday, April 16, 2014

Setup Workday Calendar in Inventory Oracle APPS R12

Workday Calendar
A workday calendar consists of a start date, and end date, and on and off days that follow one or more defined workday patterns. A workday calendar can also include shift information and exception dates, such as holidays or scheduled down time.
Use a workday calendar for forecasting and planning material requirements, use shift information for job scheduling, and capacity analysis.
Workday exceptions identify deviations to the workday calendar. Shift exceptions identify deviations for a shift.
        Attention: Shift exceptions take precedence over workday exceptions. (This is only relevant if a workday exception and a shift exception overlap.)
To assign workday exceptions to a workday calendar or calendar shift, either select them intuitively from the Calendar Dates (or Shift Calendar Dates) window, or apply them from an existing template, calendar, or shift.
To create a workday calendar:
1.      Navigate to the Workday Calendar window.
2.      Enter a name for the workday calendar.
3.      Select a quarterly calendar type:
4/4/5 Week Pattern: Two four-week periods followed by one five-week period.
5/4/4 Week Pattern: One five-week period followed by two four-week periods.
Calendar Months: Twelve periods per year based on calendar months.
13 Periods: Thirteen four-week periods per year.
Note: If you use Oracle Master Scheduling/MRP, choose the 4/4/5 Weekly Pattern or the 5/4/4 Weekly Pattern to report MRP information in weeks and months. Otherwise, if you choose the 13 Periods calendar or Calendar Months, you can only report MRP information in monthly buckets.
4.      Enter a date range for the workday calendar. The default end date is four years from the start date.
Note: Days on and off are calculated based on the start date and the day of the week. For example, if you want a standard five day workweek to start on 01-JAN, you must enter the start date as the Monday before 01-JAN (unless 01-JAN falls on a Monday).
5.      Continue creating the workday calendar by choosing one of the following buttons:
Workday Pattern: Set workdays on or off.
Shifts: Assign shifts to the workday calendar.
6.      Dates: Review your work so far and its effect on the workday calendar. Do this before you build or rebuild the workday calendar you are now creating. (You can only do this after you have defined a workday pattern.)
Once you have created a workday pattern, assigned shifts, assigned workday and shift exceptions, and reviewed your work, you must build the calendar and assign it to an organization.
7.      Save your work.


Once you have created the calendar, to make it active for using in other places, you need to build the calendar.


Thursday, June 6, 2013

Difference between Location, Ship_to, Bill_to, Customer, Party, Sites


Let’s take a case and try to answer your questions. Diamond Electronics is a company which sells electronic items. They sell those electronics wholesale and retail. Anybody can buy them online or at their stores.

They sell wholesale to other companies like WINTER HOTELS. 
They sell retail to direct persons like you i.e. SRI KRISHNA. 

OK. Now, they are implementing Oracle Applications as their ERP system.


What could be difference between customer and party? Give some examples.

You go to Diamond Electronics shop and ask for some information about an electronic item. You are interested to buy, but first you want to get information and decide later. They will show you the item and explain the details and after that they take your personal details, so that they contact you later or it would be easy when you buy later. That’s part of Customer Relationship Management. When they enter in Oracle ERP, You become a party in TCA, not customer because you have not yet decided to purchase. 

The same case happens, if somebody from WINTER HOTELS goes to them and tells them that, he is representing WINTER HOTELS and they are planning to buy lot of electronic items to their new hotel. Here, 3 things are entered in Oracle TCA. WINTER HOTELS information, the person (ex: JOHN) who is representative of WINTER HOTELS, and the relationship between that person and the WINTER HOTELS. Here WINTER HOTELS is a party, JOHN is party contact and the relationship is AGENT.

After sometime, you or WINTER HOTELS decided to buy electronics and you go again and make a purchase. That time, you become customer.


What could be difference between customer, customer accounts and customer account sites?

Customer is already explained above.

You are buying 2 items, but you want them to go to different places and billing address is also different. This way, it is easier for your financial consolidation. So, you give them different credit cards and different shipping and billing addresses. That time, they would create 2 customer accounts for you. 

The same case may happen to WINTER HOTELS, they may have Corporate Hotel Address, but they want to these expenses to be calculated at their new hotel. So they create a new account based on this new hotel address. 

Generally, site is logical representation of the location. Their new hotel physical address is location and it can be represented as site. Now, depending on the use it can be BILL-TO or SHIP-TO. The site use determines where the items to be shipped physically and where the invoice should go.
 

What could be difference between site and location?

Location is the physical address which needs to be created first. Then attach account site to the address based on the usage. Usage is at the site level and not at the location level. One physical address can be site for COMMUINCATION, CORPORATE, BILL-TO , SHIP-TO etc. I would say, site determines the purpose of the physical location.

What could be difference between contacts and contact points?

In the above case, JOHN is the Contact of WINTER HOTELS. 

Contact Points are ways to reach that person. Like his phone numbers, email address etc. They also take phone numbers of WINTER HOTELS.

These contact points applicable to you also. When you give them your phone numbers while buying the item, they are attached to your party record as contact points.


What could be difference between addresses and address uses?

Not clear. Address is the physical address of the party. I never heard the term address use. In TCA, we have party site use and account site use. They determine the usage of the address determining at what stage you are, either at party level or customer level.

What could be difference between contacts and contact roles?

In the above case, JOHN is the Contact of WINTER HOTELS. 
Contact Role is, what is the role of JOHN in the WINTER HOTELS? He is employee of WINTER HOTELS, but it is not mandatory that he is authorized to purchase items. Contact Role determines what is the role of JOHN as employee of WINTER HOTELS, so that when DIAMOND Electronics sell items, they check whether he is the correct person or not.


Which information store in table hz_relationships?

HZ_RELATIONSHIPS store the relationship between the parties. They may take information about WINTER HOTELS Corporate and WINTER HOTELS new hotel. Here new hotel is child of Corporate. They create a relationship between them as parent-child. This table stores that information.

In your case, they make ask your family details. If you give your spouse details, they create her as new party and create a relationship between you as HUSBAND-WIFE. The hz_relationships table stores this relationship details.


How TCA help client and programmer explain with one example?

It is proven, flexible customer model. It is very flexible that it can be implemented with most types of the businesses. 

For programmer, it is complex and challenging. Anyhow, for a programmer, things should be challenging.


How the party information store in different levels or tables (like party >> party site>> contacts ...) and also give brief information about each tables.


To set up locations for Purchasing:
  1. Navigate to the Locations window.
  2. For information on the Name, Description, Inactive Date, Global, and Address Details fields.
Fill in information in the Shipping Details tabbed region.
Note: Selecting the check boxes means that you are making the location Name a valid location in the list of values on a Purchasing document. For example, selecting Ship-To Site makes the location Name a valid choice in the list of values for the Ship-To field on a purchase order header. Note that if you define a default Ship-To or Bill-To Location in the Supplier-Purchasing region of the Financials Options window for your organization, that is the location that defaults onto your purchase orders. But if you wanted to change that default, the location Name that you define here and enable as a Ship-To or Bill-To site is available in the list of values for you to choose from in the Ship-To or Bill-To fields.
Contact: Optional contact name for the location Name.
Ship-To Location: Usually the same as the location Name. You could select a separate, previously defined Ship-To Location-for example, if you wanted to create a location Name, Office A, and specify Receiving Dock A as its Ship-To Location. Note, however, that once you specify a separate Ship-To Location, you can no longer enable the location Name as a Ship-To Site. In this example, Receiving Dock A is the ship-to site for Office A; therefore, Office A itself cannot also be the ship-to site.
Ship-To Site: Select this option to make the location Name a valid ship-to organization on a purchase order or requisition.
Receiving Site: Select this option to make the location a valid receiving Location when creating a receipt or receiving transaction.
Office Site: Select this option to indicate that this location Name is an office site, such as a field office.
Bill-To Site: Select this option to make the location Name a valid bill-to site. The Bill-To Site, which is used by Payables, is specified on a purchase order header.
Internal Site: Select this option to make the location a valid internal ship-to location when creating an internal requisition.
  1. Optionally fill in information in the Other Details tabbed region.
Inventory Organization: Select an inventory organization within which this location will be available in the list of values on a Purchasing document. By selecting no inventory organization, this location becomes available on Purchasing documents in all organizations.
EDI Location: If you use Electronic Data Interchange (EDI) to receive Advance Shipment Notices (ASNs) or ASNs with billing information (ASBNs), enter a defined location. This location should match the ship-to location specified on an ASN or ASBN.

  1. If you want to use the Extra Information button to enter additional information required by your business.

Thursday, March 28, 2013

Unprocessed Shipping Transactions Records not visible in Inventory


Navigation> Inventory> Accounting Close Cycle> Inventory Accounting Periods
Select the "Pending" button
The Unprocessed Shipping Transactions zone shows "Pending Transactions".
Solution:
a) Ensure that all the Sales Orders for this accouting period have status of "Interfaced" in the Shipping Transactions Form.
Navigation> Order Management> Shipping> Transactions
Or use the following to identify any sales orders that have not been Shipped or Inventory Interfaced.
select wdd.source_header_id, ooh.order_number,wnd.delivery_id, wnd.name, wdd.delivery_detail_id,
wdl.pick_up_stop_id, wdd.inv_interfaced_flag
from wsh_delivery_details wdd, wsh_delivery_assignments wda,
wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
oe_order_headers_all ooh, oe_order_lines_all ool
where wdd.source_code = 'OE'
and wdd.released_status = 'C'
and wdd.inv_interfaced_flag in ('N' ,'P')
and wdd.organization_id = &organization_id
and wda.delivery_detail_id = wdd.delivery_detail_id
and wnd.delivery_id = wda.delivery_id
and wnd.status_code in ('CL','IT')
and wdl.delivery_id = wnd.delivery_id
and trunc(wts.actual_departure_date) between '&period_start_date'and '&period_end_date'
and wdl.pick_up_stop_id = wts.stop_id
and wdd.source_header_id = ooh.header_id
and wdd.source_line_id = ool.line_id
b) Run the omse11il.sql (Note: 133464.1 ) for any Sales Order that may show as Interfaced or Shipped, but it is suspected that it has not been processed through Inventory.
c) Verify that there are NO records for this Sales Order in the Pending Transactions Form or the Transaction Open Interface Form. Address the errors if any. The records retrieved in these forms will list the Sales Order Number under the "Source" or "Transaction Source"columns for the Source TAB respectively.
Navigation> Inventory> Transactions> Pending Transactions
Navigation> Inventory> Transactions> Transaction Open Interface
d )If records are not in any of these forms, then confirm the Material Transactions Form. Please query by transaction type (Sales Order Issue), and address errors if any. If records are listed in this form for any particular Sales Order, this will confirm that material has been processed out of stores.
Navigation> Inventory> Transactions> Material Transactions

Look for the MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID and MTL_MATERIAL_TRANSACTIONS.PICKING_LINE_ID to correspond to the OE_ORDER_LINES_ALL.LINE_ID and WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID respectively.
The sum of the primary quantity for sales order records (do not include the records for the Move Order Transactions) should match the original Sales Order line quantity. Unless overpicking is allowed, then the sum of the primary quantity must match the total of deliveries for each line.
select
substr(decode(mmt.trx_source_line_id,NULL,'NULL',mmt.trx_source_line_id),1,9) "Line Id",
substr(decode(mmt.picking_line_id,NULL,'NULL',mmt.picking_line_id),1,9) "Pick Id",
substr(decode(mmt.transaction_type_id,NULL,'NULL',mmt.transaction_type_id),1,9) "Txn Type",
substr(decode(mmt.primary_quantity,NULL,'NULL',mmt.primary_quantity),1,12) "Pri Qty",
substr(decode(wdd.delivery_detail_id,NULL,'NULL',wdd.delivery_detail_id),1,9) "Del Id",
substr(decode(mmt.locator_id,NULL,'NULL',mmt.locator_id),1,9) "Loc Id",
substr(decode(mmt.transaction_type_id,52,'Move Order',33,'Sales Order',mmt.transaction_type_id),1,15) "Type",
substr(decode(ooh.header_id,NULL,'NULL',ooh.header_id),1,9) "Header",
substr(decode(ooh.order_number,NULL,'NULL',ooh.order_number),1,12) "Ord Num",
substr(decode(ool.line_id,NULL,'NULL',ool.line_id),1,9) "OE Line"
from mtl_material_transactions mmt,
wsh_delivery_details wdd, oe_order_headers_all ooh,
oe_order_lines_all ool
where mmt.trx_source_line_id = wdd.source_line_id
and mmt.trx_source_line_id = &line_id
and ool.line_id=mmt.trx_source_line_id
and ooh.order_number = '&order_number'
However, if no records are found for the Sales Order, then verify the status of the line. See the next step.
e) If there are no records in the Material Transactions, Pending Transactions, or the Transaction Open Interface Forms, then confirm the value for the columns WSH_DELIVERY_DETAILS.OE_INTERFACED_FLAG and WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG. Use the output from the omse11i.sql.
f) For records with WSH_DELIVERY_DETAILS.OE_INTERFACED_FLAG or WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG values "P", please run the Interface Trip Stop process in Order Management to complete workflow for the Sales Order.
Navigation> Order Management> Shipping> Interfaces> Run
Select the Interface Trip Stop - SRS