Wednesday, April 29, 2015

Some of the supplier are not listing in the PO FORM/Auto Create FORM in oracle purchasing R12

Issue:

Why Are Some Of The Suppliers/Supplier Sites Not Available In The Suppliers/Supplier Sites LOV Of The Purchase Order Form

Solution:

What you are attempting is not available via the standard functionality in the product. The application does not allow users to choose a supplier/supplier site once the site is checked with 'RFQ Only' option.

To ensure that RFQ flag is unchecked, please recheck the following:

Release 12

1. Query the supplier in the supplier page.
2. Click on Address Book.
3. Choose UPDATE: confirm that RFQ Only is unchecked.
4. Navigate back to the previous page.
3. Choose Manage sites: confirm that RFQ Only is unchecked.


Sunday, April 19, 2015

Can Payment Currency be Different than Invoice Currency in Release 12?


Payment Currenncy:


The default for payment currency in the suppliers window is the value you enter for supplier Invoice Currency. You can change the Payment Currency value only if the Invoice Currency has associated fixed-rate currencies (for example, euro). If the Invoice Currency is a fixed-rate currency, you can change the Payment Currency value to an associated fixed-rate currency. The supplier Payment Currency is used as a default for all new supplier sites you enter. The supplier site Payment Currency is the default for the Payment Currency field in theInvoices window. It is also the default currency for invoices you create for this supplier site by using Payment on Receipt, Payables Open Interface Import, and Recurring Invoices.


Invoices:

Payment Curr. (LOV) :
If the Invoice Currency is not a fixed-rate currency, then the Payment Currency will be the same as the Invoice Currency and you cannot enter a value in this field.
If the payment currency is a fixed-rate currency, such as euro or another EMU currency, you can change it to an associated currency. For fixed-rate currencies, the payment
currency value defaults from the supplier site. If the supplier site has no default payment currency, the value defaults from the Invoice Currency. If you change the Invoice Currency then the value for Payment Currency will change to the value for Invoice Currency.

FRM-40735: on-insert trigger raised unhandled exception ORA-01403

Issue:
FRM-40735: on-insert trigger raised unhandled exception ORA-01403

Form Path : /u01/install/APPS/fs1/EBSapps/appl/ar/12.0.0/forms/US/ARXTWMAI.fmx
Form Version : 12.0.149.12020000.17
Form Last Modified : $Date: 2014/04/02 23:09  $

Solutions:

Review the HR: Security Profile option to be sure it has been assigned at the Responsibility level
before the User is assigned to the Responsibility

Responsibility:  System Administrator 
Navigation:  Profile > System > Set HR Security Profile at responsibility level.

Also check the profile MO: Security Profile.  The two profiles must be same, otherwise the error will occur.