Translate

Saturday, September 20, 2014

FRM-92101 errors accompanied by oracle.forms.net.ConnectionException: Connection from new browser window not supported errors


Temp Soulution

Method 2: -nomerge Switch for iexplore.exe
To start a separate session IE8 browser frame, type the following at Start Search, Run command box or in Command Prompt:
iexplore.exe -nomerge



Permanent Solution


Make use of the -nomerge switch parameter for the IE8 executable. With -nomerge switch, which is also triggerable via “New Session” in menu bar, IE8 default behavior will be overridden to start each new browser window in a new, unique and separate frame process, and session.
Tip: -nomerge switch only works on new IE8 browser window/frame, and not new tab.
So, in order to have multiple concurrent logins to a web application, just load a new instance of the IE8 web browser by using one of the following three methods.
Method 1: New Session
In an existing IE8 web browser window, press Alt to reveal and show the menu bar. Go to File drop down menu, and then select New Session.

Method 2: -nomerge Switch for iexplore.exe
To start a separate session IE8 browser frame, type the following at Start Search, Run command box or in Command Prompt:
iexplore.exe -nomerge
Run Unique Session Window in IE8
Tip: You may have to change directory (cd) to %ProgramFiles%\Internet Explorer\ folder if the path is not defined in command prompt and/or Run command box.
Method 3: Modify IE8 Shortcut to Permanently Launch New IE Browser Window in New Session
Right click on the IE8 shortcut (all IE8 shortcuts or icons on desktop, Start Menu, Quick Launch bar or Taskbar that you want it to run as a new instance session have to be changed), and choose Properties from the right click context menu. Then, append -nomerge to the end of the of the program path in “Target” text box at “Shortcut” tab. For example,
“C:\Program Files\Internet Explorer\iexplore.exe” -nomerge
For IE8 shortcuts that automatically open an URL link location directly, the “-nomerge” parameter should come before the URL. For example,
“C:\Program Files\Internet Explorer\iexplore.exe” -nomerge http://hostname:port/forms/frmservlet?

Multiple Session in oracle Application

Open multiple forms in an Oracle apps session

It becomes quite irritating when I open a new form and the previously opened form is closed automatically by Oracle. This can be fixed by unchecking the box “Close Other Forms” from the Tools menu. Once I have seen this option is checked and disabled. What do I do now?

The parameter FND_SINGLE_FORM_INSTANCE is set to 'Y' for the form.
So when the form is called, this parameter is read and hence only one instance 
of the form is allowed.

SOLUTION

(1) Responsibility : Application Developer 
(2) Navigate to Application --> Function
(3) Query for Function corresponding to the form
(4) Click on "Form" tab
(5) Find the parameter with the value FND_SINGLE_FORM_INSTANCE='Y'
(6) Remove this parameter and save

You can see that the check box “Close Other Forms” is disabled. Oracle allows opening multiple forms when this checkbox is unchecked. Since the checkbox is checked and disabled we have no option but open only 1 form at a time. We need to enable the checkbox so that we can open multiple forms simultaneously. How do we do it?
Go through the following steps:
Responsibility: System Administrator
Navigation: Security > Responsibility > Define
Query for the responsibility, UAE HRMS Manager.
On this form you need to exclude a function. Enter the details as given below,
Type: Function
Name: Navigator: Disable Multiform
Save the form
Now go back to UAE HRMS Manager responsibility.
You can now check or un-check the box to open multiple windows simultaneously.


Thursday, September 18, 2014

Purchase order (PO) in Oracle

Steps to create a Purchase order (PO) in Oracle Apps

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 OrderUsed for One-time purchases for goods and services. Here you know the item, price, payment terms an delivery schedule
Planned Purchase OrderCreated 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 AgreementCreated when the details of items and services, payment terms are known but not specific about the delivery schedule
Contract Purchase AgreementCreated when the terms and conditions of a purchase are known but specific goods and services are not.
Let’s create a Standard Purchase Order.
Here, we will Auto Create a Purchase Order based on Approved Requisition.
Navigation: Purchasing>> Auto Create
Enter requisition number and click Find to navigate to Auto Create documents window
Find Requisition lines
Find Requisition lines
Auto Create Document
Auto Create Document
Select your Requisition Line by ticking the check box next to the Requisition Line
Action:                             Create
Document Type:              Standard PO
Grouping:                        Default
Click Automatic button and click create button in the New Document form. By clicking Automatic button, a standard PO is created based on the details provided in the Purchasing requisition.
You can select Supplier either in the New Document form or in thePurchase Order form
New document
New document
Auto Create to PO
Auto Create to PO
Status represents the status of the document. Incomplete is the default status for all purchase orders until they are submitted for the first time for approval.
Click Shipments button.
Shipment number, Org, Ship-to, UOM, Quantity and Need-by-date are shown by default. These fields can be edited as needed. You can split the lines and can change the ship-to Organization, quantity of items to be shipped and delivery date.
[you can request the supplier to supply some of the quantities to be supplied by the need-by date you provided and rest of the quantities (to the same ship-to address or a different address) to a different need-by-date]
Shipments
Shipments
Click More tab. The default values are generated
Shipments
Shipments
Receipt Close Tolerance (%) determines when this line will close for receiving
Invoice Close Tolerance (%) determines when this line will close for invoicing
Purchase Order has three main close points: Closed for Receiving,Closed for Invoicing (these two relate to a specific line) and Purchase Order itself has a closed status.
The entire order will not close automatically if all the lines are not closed for both receiving and invoicing. A tolerance of 0% indicates that it will close when the total amount received or invoiced equals the amount on the order, whereas a close tolerance of 100% indicates that no receipts or invoices are required for this order, which will close the lines for receiving as soon as the order is approved. Reviewing these default close tolerances on a regular basis is a good idea to ensure orders are properly controlled and closed with minimal intervention by the purchasing agent.
Select an option at Match approval Level
This determines the close point for an order.
2-way determines Purchase Order and Invoice quantities must match with in the tolerance before the corresponding invoice can be paid.
Quantity Billed = Quantity Ordered
Invoice Price = Purchase Order Price
3-way determines Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.
Quantity Billed = Quantity Ordered
Invoice Price = Purchase Order Price
Quantity Billed = quantity Received
4-way determines Purchase order, receipt, accepted, and invoice quantities must match within tolerance before the corresponding invoice can be paid.
Quantity Billed = Quantity Ordered
Invoice Price = Purchase Order Price
Quantity Billed = quantity Received
Quantity Billed= Quantity Accepted

Select an Invoice Match Option
The Invoice Match Option determines whether the invoice will be matched to the Receipt or the PO when using 3-Way matching
Select PO when using 2-way and select PO or Receipt for 3-Way.
Enter the Receiving control information by clicking Receiving Controlsbutton
Receiving Controls
Receiving Controls
Enter distributions for the shipments by clicking Distributions button
Distributions
Distributions
Click on More tab. The Requisition number from which this Purchase Order has been created is shown by default.
Distributions
Distributions
Click Terms to enter terms, conditions, and control information for purchase orders.
Terms
Terms
Click Currency button to enter and change currency information
Save your work and click Approve button for Approval process.
Approve Document
Approve Document
Click OK and check the status in the Purchase Order

Ordermangement Shipping Issues and Fixes

QUESTIONS AND ANSWERS

How to address a return order that shows error, Cust_Trx_Type_Id is required for Invoice Interface.

See Note 339989.1 - What to Check Upon Error - Required Attribute Customer
Trx Type Id is Missing

Unable to Invoice sales orders. Error "Description is required for Invoice Interface"

See Note 364292.1 - Description Is Required For Invoice Interface In Order Management 11.5.10


Message Batch Source Name is required for invoice interface

See Note 343430.1 - Batch_Source_Name is required for Invoice Interface Error Prevents Invoicing

Bill Only Orders Do Not Get Invoiced when Released from Hold

In order to achieve this functionality:
1) Created a hold source named Invoice Interface Hold: Workflow Item - Order Line Workflow activity - Line level Invoice interface
2) Enter a sales order with 2 lines
3) Apply this hold to one of the lines
4) Book, pick release, ship confirm the lines
5) Upon fulfillment, Invoice Interface fails for one line (because of the hold) The Other line is interfaced
6) Query the sales order line, release the hold on the other line and progress the order. The other line is subsequently interfaced

Additional reference:

Note 339036.1 -When Hold is Removed Workflow does not Automatically Progress the Line Past Invoice Interface Eligible.

Receivables Interface Sales_order_line Does Not Match Order Management Line Numbers

In Receivables it is a character field and only contains the "line number" not the composite line number as seen in Order Management. Here is an explanation for the OM - Invoice Interface functionality:

1. Oracle Order Management inserts information into two of the three Auto invoice
interface tables (RA_INTERFACE_LINES and RA_INTERFACE_SALES_CREDITS).

2. The Auto-Invoice program collects the data from above mentioned tables and
populates RA_CUSTOMER_TRX tables. Once the transaction tables are populated,
data in RA_INTERFACE_LINES and RA_INTERFACE_SALES_CREDITS are purged.

3. Order Management line numbers are populated in the following manner within RA_INTERFACE_LINES.:
INTERFACE_LINE_ATTRIBUTE6 (line_id)
INTERFACE_LINE_ATTRIBUTE12 (shipment_number)
INTERFACE_LINE_ATTRIBUTE13 (option_number)
INTERFACE_LINE_ATTRIBUTE14 (service_number)

4. Receivables provides the following transaction attributes that you can use in your line ordering rules (from the table
RA_INTERFACE_LINES_ALL):
ACCOUNTING_RULE_DURATION
ACCOUNTING_RULE_ID
ACCOUNTING_RULE_NAME
AMOUNT
ATTRIBUTE_CATEGORY
ATTRIBUTE1–15
FOB_POINT
INTERFACE_LINE_ATTRIBUTE1–15
INTERFACE_LINE_CONTEXT
QUANTITY
QUANTITY_ORDERED
REASON_CODE
REASON_CODE_MEANING
REFERENCE_LINE_ATTRIBUTE1–15
REFERENCE_LINE_CONTEXT
REFERENCE_LINE_ID
SALES_ORDER
SALES_ORDER_DATE
SALES_ORDER_LINE
SALES_ORDER_SOURCE
SHIP_DATE_ACTUAL
SHIP_VIA
TAX_CODE
UNIT_SELLING_PRICE
UNIT_STANDARD_PRICE
UOM_CODE
UOM_NAME
WAYBILL_NUMBER

5. Suggested change to the line invoicing rule to align sorting as values are
    defined in Order Management (OM)
Go to the Line Ordering screen
Navigate: AR> Setup > Transaction > Auto invoice > Line Ordering
Set it to order by Order Line Number, interface_line_attribute6, interface_line_attribute12, interface_line_attribute13, interface_line_attribute14

Freight Charges Are Getting Into Receivables With Line Type As 'Freight' and Freight Charge is not Taxed

Taxes on charges are not calculated at this time during order entry, even if charges are
taxable in the jurisdiction. If it is necessary for charges to be taxed, the
user should set the ‘TAX: Invoice Freight as Revenue’ profile option to Yes
and also set up a dummy Freight item in Inventory that is taxable and
specify it in the ‘TAX: Inventory Item for Freight’ profile option. Then
OM’s Invoicing Integration will send the charges to Receivable’s
Autoinvoice as Lines with that Inventory Item on them, rather than as
Freight. There the charges can be taxed as required and revenue
accounting for the charges using AutoAccounting can be done.

Note: Be sure to set Profile option Tax: Invoice Freight as Revenue set to Yes
for the Responsibility that is used to run the Workflow Background process.


How Does The Invoice Date Get Derived From The Sales Order Line?



Oracle Receivables derives the invoice date from either the ship date actual or the sales order date.

For shippable lines, Order Management derives the ship date actual as follows:

SELECT dl.initial_pickup_date
FROM wsh_new_deliveries dl
WHERE dl.delivery_id = <delivery id of the line>;

If this is null then the sales order date will be used as invoice date. Please
set the intial pickup date correctly for shippable lines because that is what
will be the invoice date.

For non-shippable lines, since there is no shipping date,
1. you can choose to have the ship date actual as NULL (which allows AR to derive the invoice date as order date)
OR
2. you can choose to have the ship date actual as sysdate
(the date when invoice ice iscompleted) by setting the profile option
OM:Set Receivables Transaction Date as Current Date for non shippable lines.
This profile option is available as part of Patch 2008789.
Reference Note 227816.1 for more details on this patch.

Two Invoices Generated For Lines With Same Invoice Rule

On a sales order with two order lines using the same Invoice Rule, there are two separate invoices generated. In the OE_ORDER_LINES_ALL table, the INVOICING_RULE_ID is the same (-2) for both lines on the sales order. The problem is that only certain lines are being populated in RA_INTERFACE_LINES_ALL table with the INVOICING_RULE_ID field. This causes the lines to end up on separate invoices. Invoice rule is a required grouping attribute. These lines have the same invoice rule in OM and should appear on the same invoice.

In this situation, the same Invoicing Rule was used but, a different Accounting Rule was used Line 1: Invoice Rule : Advance Invoice, Accounting Rule : Immediate and Line 2: Invoice Rule: Advance Invoice Accounting Rule: 12 month revenue
The solution is to set up a new accounting rule that has the same properties as IMMEDIATE (ACCOUNTING_RULE_ID=1) with a new name (ie:IMMEDIATELY) this will give the rule a different ACCOUNTING_RULE_ID. Then Invoice Rule will then get passed to RA_INTERFACE_LINES_ALL and both lines will end up on the same invoice

Why Can the Purchase Order Number on the Invoice be Different to the Value on the Sales Order Header?

The Invoice Interface program puts the oe_order_lines_all.customer_po_number to ra_interface_lines_all.purchase_order and the AutoInvoice program puts the value ra_interface_lines_all.purchase_order to ra_customer_trx_all.purchase_order.
So in normal cases, there should not be any differences between oe_order_headers_all.customer_po_number and ra_customer_trx_all.purchase_order.

However, there are 2 possible ways in which there can be difference between the oe_order_headers_all.customer_po_number and ra_customer_trx_all.purchase_order

a) the value of ra_interface_lines_all.purchase_order might have been modified manually BEFORE AutoInvoicing is done - from the form Receivables -> Control -> AutoInvoice -> Interface Lines or from SQL*Plus by running an update script
OR
b) the oe_order_headers_all.customer_po_number changed BEFORE the order is closed, but AFTER the order line is closed - ie. invoiced. This can be done by simply updating the Customer PO from the Sales order header

For Sales Orders at Closed Status, it is not possible to change the Purchase order number.

Bill To On Order Header Does Not Match Bill To On The Invoice

Bill To from the Sales Order line is passed to Invoice Interface. This may or may not be different from the Bill To of the Sales Order header. It is the Sales Order line Bill To which appears on the Invoice.

Additional References:
Note 785547.1 - How Does One Set Up Invoice To Show The Same Bill-To Address
as Order Header ?



Freight Charges Added To Delivery Are Split Into Multiple Lines On The Invoice


This is currently an enhancement request Bug 4542163 - Freight Charges Added to Delivery
Are Split Into Multiple Lines on the Invoice



Autoinvoice Rejected Error Non Negative Total Amount

Query up the Order Number in the Receivables under the Control -> AutoInvoice -> Interface Lines
and change the Invoiced Quantity to same as that on the order line. Ordered Quantity, Shipped quantity and Invoiced Qty should be a positive number in the OE_ORDER_LINES_ALL table for non-return orders .
Make this change, run the AutoInvoice again and this line should get processed correctly.



New Transaction Type Does Not Process Line Through Invoicing


The required setup for Transaction Sources (Receivables > Setup > Transactions > Source) Transaction Type in not correct. It is set to Value. Per Oracle Order Management Open Interfaces, API & Electronic Messaging Guide, Release 11i, page
2-160 Table 2-47, the required setting for this field is ID.
To implement the solution, please execute the following steps:
1. Query the Source on the Transaction Sources (Receivables > Setup > Transactions > Sources)
2. Change setting for Transaction Type (Other Information tab) set to ID.
3. Run AutoInvoice



Why Are Adjustment Records Rounding Differently in AR Interface Table RA_INTERFACE_LINES_ALL Than Shown in OE_PRICE_ADJUSTMENTS?

For the answer, please refer to the details and screen shots outlined in Note 1542786.1

Thursday, September 11, 2014

MRP SET UP R12

Introduction

Setting up the Oracle Master  Scheduling/MRP and Oracle Supply Chain Planning modules is easy.  Determining how your business will leverage the features,
is the hard part. This document can be used as a guide during your implementation. 


Before you set up Oracle Supply Chain Planning, you must complete the setup for the following: products:

Oracle Inventory
Oracle Purchasing
Oracle Bills of Material
Oracle Work in Process
Oracle Project Manufacturing


Planning Setup Checklist

Required steps for System Administration, General Ledger, Inventory, Purchasing, Bills of Material, and WIP modules need to be completed before
Planning is setup.

The following steps need to be completed in the order shown:

Step 1:

Define your Master Scheduling/MRP Setup Parameters (Required) 
NAV/Supply Chain Planning/Setup/Parameters or
NAV/Material Planning/Setup/Parameters

You can override the execution defaults, when defining the MPS, MRP or DRP for your organization(s).   
To have all past due demand (sales orders, forecast, etc.) reflected in your plans, select Null for Include MDS Days. 
Entering a value will limit the past due information visible in the Plan.

Step 2: 

Define your Deliver-to Locations (Optional)
NAV/Inventory/Setup/Organizations/Locations

Step 3: 

Define your Employees (Optional)
NAV/Work In Progress/Setup/Employees
Note: Enter Employees through Human Resources, if installed.  
A required step when implementing planning recommendations from the Planner Workbench (Step 21).

Step 4: 

Set Profile Options (Required with Defaults)
NAV/Profiles/System/Find MRP

Note: Use the Sysadmin Responsibility. The value for Snapshot Workers can be increased depending on the number of items being planned.  Use the
following formula to determine how many Standard Managers are required to support the process.  The value for the Planning Manager Max Workers should
not be more than the number of Standard Managers.

(Snapshot workers value *2) + 4 = # of Standard Managers
(2*2) + 4 = 8 Standard Managers

Recommended initial values:

MRP:Environment variable to set path for MRP files Null/Blank
MRP:Planning Manager Max Workers                        6
MRP:Retain Dates within Calendar Boundary               Yes
MRP:Snapshot Workers                                    2
MRP:Use Direct Load Option                              No


Step 5: 

Define your Forecast Sets (Optional)
NAV/Supply Chain Planning/Forecast/Sets
NAV/Material Planning/Forecast/Sets

Step 6:

Define your Master Demand Schedules (MDS)(Optional)
NAV/Supply Chain Planning/MDS/Names
NAV/Material Planning/MDS/Names

Step 7:

Define your Master Production Schedules (MPS) (Optional)
NAV/Supply Chain Planning/MPS/Names
NAV/Material Planning/MPS/Names

Step 8: 

Define your Material Requirements Plans (MRP);
Define your Distribution Requirements Plans (DRP) (Optional)
NAV/Supply Chain Planning/MRP/Names
NAV/Supply Chain Planning/DRP/Names
NAV/Material Planning/MRP/Names

Step 10:

Define your Sourcing Rules or Bills of Distribution (BOD)
NAV/Supply Chain Planning/Sourcing
Note: When you select All Orgs for your Sourcing Rule, it can be used by all organizations when defining an Assignment Set.  A Local
Sourcing Rule would only have the Org selected, and can only be used by the defining organization.   The Planning Active box will only be checked
if the allocation % = 100.  The planning process will not use the rule, unless the Planning Active box is checked

Step 11: 

Create your Assignment Sets
NAV/Supply Chain Planning /Sourcing/AssignSourcing Rules/BOD
Note:  A Local Sourcing Rule assigned at the Item-Organization level, overrides all others for that item.

Step 12: 

Define your Inter-organization Shipping Network
NAV/Inventory/Setup/Organizations/Shipping Network

Step 13:

Define Shipping Methods and associated intransit lead times
NAV/Inventory/Setup/Organization/Shipping Methods
NAV/Inventory/Setup/Organization/Shipping Network
  Special Menu:  Shipping Methods  Intransit Times

Step 14: 

Run the Information Audit (Optional-highly recommended)
NAV/Supply Chain Planning/Reports/Audit Information Report
NAV/Material Planning/Reports/Audit Information Report

Step 15: 

Define your Planning Parameters (Required)
NOTE: this is a duplicate of Step 1.

Step 16: 

Start the Planning Manager (Required)
NAV/Supply Chain Planning/Setup/Planning Manager or
NAV/Material Planning/Setup/Planning Manager
(See screen shot below; the active box should be checked and you should see current messages)

Step 17:

Define your Planners (Optional)
NAV/Inventory/Setup/Planners

Step 18: 

Define your Planning Exception Sets (Optional)
NAV/Supply Chain Planning/Setup/Exception Sets
Or NAV/ Material Planning/Setup/Exception Sets

Step 19:

Define your Demand Classes (Optional)
NAV/Supply Chain Planning/Setup/Demand Classes
OR NAV/Material Planning/Setup/Demand Classes
Note: Selecting a Demand Class when defining your MDS or MPS,restricts data seen in the schedules.  Only Sales Orders with the
demand class entered at the line level will be included in your MDS. 
Only Discrete Jobs with the demand class added,(NAV/WIP/Discrete/Discrete Jobs/More) will be included in your MPS.

Step 20: 

Create Source Lists (Optional)
NAV/Supply Chain Planning/Forecast or MDS or MPS /Source List
NAV/Material Planning/Forecast or MDS or MPS/Source List


Step 21: 

Set Up Planner Workbench (Required)
For instructions, see: Setting Up Planner Workbench:
Oracle Master Scheduling/MRP and Supply Chain Planning User's Guide Release 11: page 1-28.

Step 22: 

Set Up for Supplier Planned Inventories (Optional) For instructions on setting up Supplier Planned Inventories, see the prerequisites in
Oracle Master Scheduling/MRP and Oracle Supply Chain Planning User's Guide Release 11, page 5-8.