Saturday, March 5, 2016

Do you see the error while creating AR transactions "System cannot determine geographical information for this location and cannot derive a tax jurisdiction"??

You might want to check if the geography and tax validations are enabled for that country for which you are seeing this error....

If they are enabled then you might have not run the 'Geography name referencing program' for this country...

To implement the solution, execute the following steps:

  1. First check if there is a value for profile option HZ :Generate Party Number, if no, set it to 'yes'. Post that follow the below steps.
  2. For the ship-to/bill-to which is failing navigate to the customer form and look up the particular ship-to/bill-to record. Please make note of the site number 
  3. Run the following queries to determine the location_id which is failing

    select party_site_id, party_id, location_id
    from hz_party_sites
    where party_site_number = '&site_number';


    select location_id, country, address1, address2, address3, city, postal_code, state, county
    from hz_locations
    where location_id = &location_id; 
  4.  once you have the valid location id, then run this query
    select map_status, location_id
    from hz_geo_name_reference_log
    where location_id = &location_id;

    Map_status S means that the location_id is successfully created.
    Map_status E means that the location_id has not been successfully created.

  5. Navigate to Trading Community Manager -> Administration -> Geography Hierarchy

    Click on Manage Validations, and find the geography mapping and validations.

    For eg:
    State, County, City, Postal Code

    Verify if tax validation and geography validation is enabled for each of the segments

  6. In the customer form, query the customer in question and review the ship-to, bill-to addresses

    The format you selected under the geography hierarchy must match what you have entered under each bill-to, ship-to

    for example if you are missing the county and you have selected to have this segment validated under the geography hiearchy, you must have this field entered for the ship-to, bill-to under the customer.

Monday, June 22, 2009

R12: Build Program Ends with Error after Review of Invoices RUP4

Build Program Error:

I am trying to make batch payment in Release 12 via a Payment Manager.

The invoice which are selected by the payment process request belong to 2 operating units. The problem comes with the build progam getting errored out.

The out file displays the following message:
"Build program error: Exception occured when attempting to create payments from the documents payable of the provided payment service request."

The log file is as follows:

---------------------------------------------------------------------------
Payments: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

IBYBUILD module: Build Payments
---------------------------------------------------------------------------

Current system time is 22-JUN-2009 15:08:50

---------------------------------------------------------------------------

**Starts**22-JUN-2009 15:08:50
**Ends**22-JUN-2009 15:09:08
BUILD PROGRAM ERROR - CANNOT CREATE PAYMENTS
---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------

---------------------------------------------------------------------------
Executing request completion options...


Finished executing request completion options.

---------------------------------------------------------------------------
Concurrent request completed
Current system time is 22-JUN-2009 15:09:09


Could someone please provide a solution for this??

Please refer to this document: Note: 558114.1

Thursday, June 18, 2009

Granting access for Banks to Legal Entity

With release 12, the legal entity took the ownership of the banks. To grant access to banks

1) Access user management responsibility
2) Go to roles and Inheritance tab
3) Select roles and responsibilities, choose our responsibility name and the appliction to which it belongs to
4) Click on update icon
5) Select the tab security wizards
6) Run thesecurity wizard named, CE_UMX_Securitywizard
7) Choose the legal entities to whichyou would want to give the access and save the information

Why should we do this???

You would not need to, unless you want to associate a legal owner(LE) while creating a bank account ;)

AP/ AR Netting Set ups and transactions

Setups required for AP/AR Netting:

1. Netting control Account:
In GL module
Path: Setup>Financials>Flexfields>Key>Values
Segment qualifier for netting control account = Liability

2. Netting bank, branch and bank account.
Netting flag to be set as yes for the bank account
use netting control account in placeof cash and cash clearing account

Note:
? Reason for defining netting control account.
:) To facilitate us to use it as cash account while defining netting bank account

? Why should you use netting control account in place of netting bank account
:) As you not actually paying or receiving cashwhile you are performing netting

3. Netting receipt class
Receivables module
path: setup>receipts>receipt classes

? Why do we need a netting receipt class
:) To facilitate the system to create a receipt automatically specifying the mode in which we received this receipt as netting

4.Netting Agreement
Canbe created either from payables or receivables
path(AP) payments>netting>netting agreement
path(AR) receipts>netting>netting agreement


5. Netting batch
Picks the invoices and AR transactions to be netted as per the criteria specified in the netting agreement.

6. Submit the netting batch.Review the invoices and transactions picked. Resubmit the batch and viewthe proposed and final netting reports.

Making payments of multiple operating units

Are you trying to make payment of invoices pertaining to multiple operating units having different transacting currencies??

Here is the list of what you need.
1. A bank with multiple currency flag enables. Similarly the check boxes of multi currency payments and multi currency receipts should be enabled.

2. A payment process profile with the payment format specified for the payable documents defined for the bank

3. Exchage rate type and rate defined for the foeign currencies

Transaction part.
1. Raise invoices intherespective OUs
2. create a payment process request via payment manager
3. generate payments

Validate Application Accounting Definition

Unable to create online accounting???

When you are implementing on a fresh instance for you to be able to do the accounting of your transactions. you should run the following request "Validate Application ccounting Definition" request.

Make sure that both in GL and AP the period in which the transactions exist are open.

Cheers.

Wednesday, June 17, 2009

Invoice currency field grayed out

Invoice currency field grayed out:

I created a multi org with 2 OUs one in the US and the other in India. The currencies are USD and INR respectively. While keying in an invoice, the invoice currency tab is greyed out and only one currency is automatically picked and is not letting me change???

Soulution:

Go to Currency tab in Payable options and enable the check box, multiple currencies. Give the realised gain and relaised loss account and the rounding differences account.

And your problem is solved :)