R12 Accounting Definitions: Source Credit Memo Ship To Customer State (CM_SHIP_CUST_STATE) Is Not Working (Doc ID 1381312.1)

Last updated on FEBRUARY 28, 2013

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
FORM:XLAABADR.FMB - Account Derivation Rules
FORM:XLAABDSS.FMB - Sources
EXECUTABLE:XLAACCPB - Create Accounting
EXECUTABLE:ARACCPB - Submit Accounting


Symptoms

Attempting to run Create Accounting and expect the Tax accounts to change based upon the account derivation rule.

In Receivables, there is an account derivation rule that by-passes the accounting on the transaction type and should post tax to GL based upon the seeded source rule of "Ship To Customer State."
However, this is not happening.

Sign into Accounts Receivable application.
Create Account derivation rule (ADR) for credit memo tax.
The issue is with source Credit Memo Ship To Customer State (CM_SHIP_CUST_STATE).
It is not pulling the ship to customer state.
Instead it is pulling the site with identify address flag = Y.

This is only happening with credit memos. This is not happening with invoices which uses a different but very similar source: Ship To Customer State (SHIP_CUST_STATE)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms