4/6/2015

Document1088251.1

PowerViewisOff

Dashboard

Knowledge

ServiceRequests

(0)

Madhuri(NotAvailable)

ContactUs

Help

Patches&Updates
GiveFeedback...

AutoInvoice,TransactionWorkbenchorInvoiceAPIError:Pleasecorrecttherevenueaccountassignment(DocID
1088251.1)
InthisDocument

ToBottom

DocumentDetails

Symptoms
Type:
Status:
LastMajor
Update:
LastUpdate:

Cause
Solution

1.CheckAutoAccountingSetup

a)IfSegmentsSource=Salesreps

b)IfSegmentSource=StandardLines

c)IfSegmentSource=TransactionTypes

d)IfSegmentSource=Sites

2.ValidatetheShippingInventoryOrganization

3.IfyouarepassingDatainRA_INTERFACE_DISTRIBUTIONS_ALL

4.Checktheprofileoption:AR:UseInvoiceAccountingforCreditMemos

5.CheckiftheGLaccountexistsandisactive

6.VerifyAccountingFlexfieldsettingforEnabledandAllowDynamicInserts

7.VerifywhethertheGLaccountdoesnotviolateanycrossvalidationrulesofthesegments.

8.CheckforPossibleKnownBugs

9.UsetheAutoInvoicePostProcessValidationReport

StillHaveQuestions?

RelatedProducts

OracleProjectBilling
OracleOrderManagement
OracleReceivables
OracleLeaseandFinance
Management
InformationCenters

InformationCenter:Oracle
OrderManagement
[1395754.2]
InformationCenter:Oracle
ProjectBilling[1381200.2]
InformationCenter:Oracle
LeaseandFinance
Management[1275298.2]

References

InformationCenter:Overview
ofAutoInvoiceinOracle
Receivables(AR)11.5and
later[1137414.2]

APPLIESTO:
OracleProjectBillingVersion11.5.10.1andlater
OracleOrderManagementVersion11.5.10.0andlater
OracleReceivablesVersion11.5.10.0andlater
OracleLeaseandFinanceManagementVersion12.0.1andlater
Informationinthisdocumentappliestoanyplatform.
Checkedforrelevance12Apr2013
Executable:RAXTRXAutoinvoiceImportProgram
Form:ARXTWMAI.FMBTransactions
Executable:PARGDRPRC:GenerateDraftRevenueforaRangeofProjects
Executable:PAIGENPRC:GenerateDraftInvoicesforaRangeofProjects

PROBLEM
PUBLISHED
06Oct2014
06Oct2014

InformationCenter:Overview
oftheTransactionsWorkbench
inOracleReceivables(AR)
11.5andlater[1320546.2]
ShowMore

DocumentReferences

R11i/12:AR:AutoInvoice
PostProcessAnalyzer:
OverviewandInstallation
Instructions[1523525.1]

SYMPTOMS
OracleReceivables(AR):AutoInvoiceInformationCenter>TroubleshootingAutoInvoiceforOracleReceivables
Release11.5Through12>TroubleshootingAutoAccountinginAutoInvoiceNote>1088251.1
WhenCreatingtransactionsviaAutoInvoice,ortheTransactionsFormorAPIsorviaahookupintoReceivables,yougetthe
Error:
Pleasecorrecttherevenueaccountassignment
Thiscanoccurin:
OracleReceivablesTransactionWorkbench
OracleReceivables:AutoInvoiceImport
OracleReceivables:InvoiceAPI's
OracleProjects:ProjectBillingGenerateDraftInvoicesorRevenue

CAUSE
Numerous

SOLUTION
TIP:CheckoutNote1904785.1AutoAccountingAnalyzer,adynamicwaytohelpyouidentifyand
resolveAutoAccountingissues.

RecentlyViewed

HowToSetupFreightFor
AutoInvoiceAndThe
TransactionsWorkbench
[1096942.1]
AutoInvoiceandTransaction
WorkbenchError:Please
completeyourtax
accountingflexfield
[1087263.1]
R11i/12:AR:AutoInvoice
PostProcessAnalyzer:
OverviewandInstallation
Instructions[1523525.1]
AutoAccountingIsFailing
With&quotPleaseCorrect
TheRevenueAccount
Assignment&quotFor
FreightItem[1994304.1]
AutoinvoiceError:Thisline
hasthesametransaction
flexfieldasanotherrowin
theinterfacetable
[1339318.1]
ShowMore

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

1/15

4/6/2015

Document1088251.1

resolveAutoAccountingissues.

Therearemultiplecausesforthiserrortoberaised,thefollowingguidesyouthroughthevariousthingsyoucancheck/useto
addressthiserror:

1.CheckAutoAccountingSetup
IfyouaregettingtheerrorinAutoInvoice,trycreatingamanualtransactionandusethesameGLaccountsegments.Asyou
entereachGLaccountsegmentinthetransactionform,ifvalidationlogicfails,theformwillraiseanerror.Thiswillhelpyouin
identifyingwhichsegmentshaveissuesandwillassistyouinresolvingtheproblem.
Forthisparticualrerrormessage,theGLaccountinerrorwillbedisplayed,andaparticularsegmentwillbemissing.Let'stake
thefollowingasanexample:
Pleasecorrecttherevenueaccountassignment(03000000000000000000000000)
Acloselookattheaccountingsegmentsshowsthe3rdsegmentismissing.
Responsibility:ReceivablesManager
Navigation:Setup>Transactions>AutoAccounting
ThenqueryupforType=Revenue,andreviewthesourceforeachofthesegments.Forthisexample,the3rdsegmentis
raisingtheerror,sopayattentiontowherethe3rdsegmentissourcedfrom.
Dependingonwhatthesourceisforthefailingsegment,youcanusethefollowingstepstoinvestigate/troubleshootfurther.

a)IfSegmentsSource=Salesreps
WhenasegmentoftheGLaccounthastobederivedfromtheGLaccountsassociatedwiththeSalesrep,then
itispertinentthatyouassociateaSalesreptoyourtransactions.Checkwhetherthefollowinghasbeensetup
correctly:
TransactionSource
Responsibility:ReceivablesManager
Navigation:Setup>Transactions>Sources
QueryupthetransactionsourceusedforyourAutoInvoiceimportbatch,andnavigatetothe
AutoInvoiceOptionstab,andensurethatthecheckboxforAllowSalescreditischecked.

NextchecktheSalesCreditValidationtab,verifywhatyouhavesetupforSalesperson,howyousetit
uphereimpactswhatAutoInvoicewillexpecttoseeintheRA_INTERFACE_LINES_ALLtable
(discussedbelow)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

2/15

4/6/2015

Document1088251.1

SystemOptions
Responsibility:ReceivablesManager
Navigation:Setup>System>SystemOptions
NavigatetotheMiscellaneoustabandcheckiftheRequireSalespersoncheckboxischecked.

Thecombinationoftheabovesettingsdeterminesthebehaviorre.SalescreditsdatainAutoInvoice.
Note:Regardlessofthecombinationofsettingsyoudefinebelow,ifyoupassdatain
RA_INTERFACE_SALESCREDITS_ALL,thenAutoInvoicewillvalidatethatthedatayouprovidedis
valid.

AllowSalescredit
field
(InTransaction
Source)

Require
Salesperson
(inSystem
Options)

Requirementof
Salescreditinformation

Checked

Checked

Mandatory

Checked

NotChecked

Optional

NotChecked

Checked

Mandatory

NotChecked

NotChecked

Anydataenteredwillbe
ignored

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

3/15

4/6/2015

Document1088251.1
ignored

GLaccountassociatedtoSalesrep
Responsibility:CRMResourcemanager
Navigation:MaintainResources>Resources
EnsurethatFreight,ReceivablesandRevenueAccountsassociatedtotheSalesrephavebeensetup
completely.

DatainRA_INTERFACE_SALESCREDITS_ALL
WhenyouhavedefinedAutoAccountingsuchthatsomeGLaccountsegmentsaresourcedfrom
Salesreps,makesurethatyoupopulatethetableRA_INTERFACE_SALESCREDITSforeachlinein
RA_INTERFACE_LINES_ALLsothattheproperaccountingcanbederived,andensurethatthevalues
inINTERFACE_LINE_CONTEXT+INTERFACE_LINE_ATTRIBUTE115matchup.
ThisisrequiredwhenyousourcesegmentsfromSalesrepsandisnecessaryevenifyoursystem
optionRequireSalesrepsissettoNo.
DatainRA_INTERFACE_LINES_ALL
IfyoursourceisSalesreps,andyourTransactionSourcesetupforSalespersonis:
Number,thenyoushouldbepopulating
RA_INTERFACE_LINES_ALL.PRIMARY_SALESREP_NUMBER
Id,thenyoushouldbepopulatingRA_INTERFACE_LINES_ALL.PRIMARY_SALESREP_ID
ScripttofindincompleteSalesrepsetupforAutoAccounting
ThefollowingscriptwillpickupallSalesrepsthatdonothavealltheGLaccountssetup,thiscouldassistyou
inproactivelysettingtheseuptoavoidissuesinAutoInvoice.
SELECTNAME,
SALESREP_NUMBER,
SALESREP_ID,
PERSON_ID,
STATUS,
NVL(TO_CHAR(GL_ID_REV),'NULLREV')GL_ID_REV,
NVL(TO_CHAR(GL_ID_REC),'NULLREC')GL_ID_REC,
NVL(TO_CHAR(GL_ID_FREIGHT),'NULLFREIGHT')GL_ID_FREIGHT
FROMJTF_RS_SRP_VL
WHERESTATUS='A'
AND((NVL(START_DATE_ACTIVE,sysdate)<=sysdate)AND
(NVL(END_DATE_ACTIVE,sysdate)>=sysdate))
AND(GL_ID_RECISNULLOR
GL_ID_REVISNULLOR
GL_ID_FREIGHTISNULL)
ANDEXISTS
(SELECT'x'
FROMRA_ACCOUNT_DEFAULTS_ALLa,

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

4/15

4/6/2015

FROMRA_ACCOUNT_DEFAULTS_ALLa,
RA_ACCOUNT_DEFAULT_SEGMENTSs
WHEREs.GL_DEFAULT_ID=a.GL_DEFAULT_ID
ANDs.CONSTANTisnull
ANDs.TABLE_NAME='RA_SALESREPS')

Document1088251.1

ProjectsUsers:SetupaCreditReceiveronaprojectsothattheRA_INTERFACE_SALESCREDITS_ALLtable
ispopulatedbythe'InterfaceInvoicestoReceivables'process.Thismayrequirethatthe'NoSalesCredit'
salespersonbesetupasanemployee.Settingthisupwillallowyoutobypassthemandatorysalesrep
validationwhennoneexists.Tocompletethissetup,gointotheReceivablesresponsibility:NAV
Setup/Transactions/Sources.
Queryyourbatchsource.GototabAutoInvoiceoptions.Markallowsalescredit.

b)IfSegmentSource=StandardLines
WhenyourGLaccountsegmentsaresourcefromStandardlines,itispertinenttoassociateeitheran
InventoryItemoraMemolinetoyourtransaction,sothatAutoAccountingcanderivetheGLaccount
segments.Checkwhetherthefollowinghavebeensetupcorrectly:
TransactionSource
Responsibility:ReceivablesManager
Navigation:Setup>Transactions>Sources
QueryupthetransactionsourceusedforyourAutoInvoiceimportbatch,andnavigatetotheOther
Informationtab,howyousetupMemoLineRuleand/orInventoryItemhereimpactswhat
AutoInvoicewillexpecttoseeinRA_INTERFACE_LINES_ALLtable(discussedbelow).

GLaccountassociatedtoInventoryItemorMemoLine
ForanInventoryItem
Responsibility:ReceivablesManager
Navigation:Setup>Transactions>Items>Defineitems
QuerytheitemandintheInvoicingTabcheckthevalueintheSalesAccountfield.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

5/15

4/6/2015

Document1088251.1

ForaMemoLine
Responsibility:ReceivablesManager
Navigation:Setup>Transactions>MemoLines
MakesurethattheRevenueAccountispopulated.

DatainRA_INTERFACE_LINES_ALL
IfyoursourceisMemoLine,andyourTransactionSourcesetupforMemoLineRuleis:
Value,thenyoushouldbepopulatingRA_INTERFACE_LINES_ALL.MEMO_LINE_NAME
Id,thenyoushouldbepopulatingRA_INTERFACE_LINES_ALL.MEMO_LINE_ID
ifyoursourceisanInventoryItem,andyourTransactionSourcesetupforInventoryItemis:
Segment,thenyoushouldbepopulating
RA_INTERFACE_LINES_ALL.MTL_SYSTEM_ITEMS_SEG120(asappropriate)
Id,thenyoushouldbepopulatingRA_INTERFACE_LINES_ALL.INVENTORY_ITEM_ID
ScripttofindincompleteMemoLineorInventoryItemsetupforAutoAccounting
ThefollowingscriptwillpickupMemoLinesthatdonothavealltheRevenueaccountsetup,thiscouldassist
youinproactivelysettingtheseuptoavoidissuesinAutoInvoice.
SELECTT.NAME,B.MEMO_LINE_ID,
NVL(TO_CHAR(b.GL_ID_REV),'NULLREV')GL_ID_REV
FROMAR_MEMO_LINES_ALL_TLT,
AR_MEMO_LINES_ALL_BB
WHEREb.MEMO_LINE_ID=t.MEMO_LINE_ID
AND((nvl(b.END_DATE,sysdate)>=sysdate)AND
(nvl(b.START_DATE,sysdate)<=sysdate))
ANDb.GL_ID_REVISNULL
ANDEXISTS
(SELECT'x'
FROMRA_ACCOUNT_DEFAULTS_ALLa,
RA_ACCOUNT_DEFAULT_SEGMENTSs
WHEREs.GL_DEFAULT_ID=a.GL_DEFAULT_ID
ANDs.CONSTANTisnull
ANDs.TABLE_NAME='RA_STD_TRX_LINES')

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

6/15

4/6/2015

Document1088251.1
ThefollowingscriptwillpickupInventoryItemsfromorganizationsinvolvedinOrderManagementthatdo
nothavetheSalesAccountsetup,thiscouldassistyouinproactivelysettingtheseuptoavoidissuesin
AutoInvoice.
SELECTORGANIZATION_ID,DESCRIPTION,INVENTORY_ITEM_ID,
NVL(TO_CHAR(SALES_ACCOUNT),'NULLSALESACCOUNT')
FROMMTL_SYSTEM_ITEMS
WHERE((nvl(END_DATE_ACTIVE,sysdate)>=sysdate)AND
(nvl(START_DATE_ACTIVE,sysdate)<=sysdate))
ANDORGANIZATION_IDIN
(SELECTMASTER_ORGANIZATION_ID
FROMOE_SYSTEM_PARAMETERS_ALL)
ANDSALES_ACCOUNTISNULL
ANDEXISTS
(SELECT'x'
FROMRA_ACCOUNT_DEFAULTS_ALLa,
RA_ACCOUNT_DEFAULT_SEGMENTSs
WHEREs.GL_DEFAULT_ID=a.GL_DEFAULT_ID
ANDs.CONSTANTisnull
ANDs.TABLE_NAME='RA_STD_TRX_LINES')
ORDERBY1

c)IfSegmentSource=TransactionTypes
WhenasegmentoftheGLaccounthastobederivedfromtheGLaccountsassociatedwiththeTransaction
Type,thenitispertinentthatyouassociatethecorrectTransactionTypetoyourtransactions,andthattheGL
accountsforthetransactiontypearedefined.Checkwhetherthefollowinghasbeensetupcorrectly:
TransactionSources
Responsibility:ReceivablesManager
Navigation:Setup>Transactions>Sources
QueryupthetransactionsourceusedforyourAutoInvoiceimportbatch,andnavigatetotheOther
Informationtab,andyoursetupforTransactionType.Howyouhaveitsetuphereimpactswhat
AutoInvoicewillexpecttoseeinRA_INTERFACE_LINES_ALL(discussedbelow)

TransactionType
EnsurethatyouhavepopulatedtheGLaccountsassociatedtotheTransactionTypeyouareusingin
yourInterfacetable.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

7/15

4/6/2015

Document1088251.1

DatainRA_INTERFACE_LINES_ALL
IfyourTransactionSourcesetupforTransactionTypeis:
Value,thenyoushouldbepopulatingRA_INTERFACE_LINES_ALL.CUST_TRX_TYPE_NAME
Id,thenyoushouldbepopulatingRA_INTERFACE_LINES_ALL.CUST_TRX_TYPE_ID
ScripttofindincompleteTransactiontypesetupforAutoAccounting
ThefollowingscriptwillpickuptransactiontypesthatdonothavealltheGLaccountssetup.Ifyou
havesomeAutoAccountingdefinedtosourcefromTransactionTypes,thentheincompleteGL
accountsetupcouldcauseissuesthisscriptcouldassistyouinproactivelysettingtheseuptoavoid
issuesinAutoInvoice.
SELECTORG_ID,NAME,CUST_TRX_TYPE_ID,TYPE,
STATUS,POST_TO_GL,ACCOUNTING_AFFECT_FLAG,
NVL(TO_CHAR(GL_ID_REC),'NULLREC')gl_id_rec,
DECODE(type,'BR','NOTAPPLICABLE',
NVL(TO_CHAR(GL_ID_REV),'NULLREV'))gl_id_rev,
DECODE(type,'BR','NOTAPPLICABLE',
NVL(TO_CHAR(GL_ID_FREIGHT),'NULLFREIGHT'))
gl_id_freight,
DECODE(type,'BR','NOTAPPLICABLE',
NVL(TO_CHAR(GL_ID_CLEARING),'NULLCLEARING'))
gl_id_clearing,
DECODE(type,'BR','NOTAPPLICABLE',
NVL(TO_CHAR(GL_ID_TAX),'NULLTAX'))gl_id_tax,
DECODE(type,'BR','NOTAPPLICABLE',
NVL(TO_CHAR(GL_ID_UNBILLED),'NULLUNBILL'))
gl_id_unbilled,
DECODE(type,'BR','NOTAPPLICABLE',
NVL(TO_CHAR(GL_ID_UNEARNED),'NULLUNEARN'))
gl_id_unearned,
DECODE(type,'BR',NVL(TO_CHAR(GL_ID_UNPAID_REC),
'NULLUNPAIDREC'),'NOTAPPLICABLE')gl_id_unpaidrec,
DECODE(type,'BR',NVL(TO_CHAR(GL_ID_REMITTANCE),
'NULLREMITTANCE'),'NOTAPPLICABLE')gl_id_remittance,
DECODE(type,'BR',NVL(TO_CHAR(GL_ID_FACTOR),'NULLFACTOR'),
'NOTAPPLICABLE')gl_id_factor,
START_DATE,END_DATE
FROMRA_CUST_TRX_TYPES_ALL
WHERE((NVL(START_DATE,sysdate)<=sysdate)
AND(NVL(END_DATE,sysdate)>=sysdate))
ANDNVL(STATUS,'A')='A'
AND((TYPE='BR'AND
(GL_ID_RECISNULLOR
GL_ID_UNPAID_RECISNULLOR
GL_ID_REMITTANCEISNULLOR
GL_ID_FACTORISNULL))
OR
(TYPE<>'BR'AND
(GL_ID_RECISNULLOR
GL_ID_REVISNULLOR
GL_ID_FREIGHTISNULLOR
GL_ID_CLEARINGISNULLOR
GL_ID_TAXISNULLOR
GL_ID_UNBILLEDISNULLOR
GL_ID_UNEARNEDISNULL)))
ANDEXISTS
(SELECT'x'
FROMRA_ACCOUNT_DEFAULTS_ALLa,
RA_ACCOUNT_DEFAULT_SEGMENTSs
WHEREs.GL_DEFAULT_ID=a.GL_DEFAULT_ID
ANDs.CONSTANTisnull
ANDs.TABLE_NAME='RA_CUST_TRX_TYPES')
ORDERBY1

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

8/15

4/6/2015

Document1088251.1
d)IfSegmentSource=Sites
TransactionSources
Responsibility:ReceivablesManager
Navigation:Setup>Transactions>Sources
QueryupthetransactionsourceusedforyourAutoInvoiceimportbatch,andnavigatetothe
CustomerInformationtab,andcheckhowyouhavesetupBillToAddressandBillToCustomer,how
youhaveitsetuphereimpactswhatAutoInvoicewillexpecttoseeinRA_INTERFACE_LINES_ALL
(discussedbelow)

CustomerSite
EnsurethatyouhavepopulatedtheAccountsassociatedattheBillToSitelevel.

CheckthattheSiteyouareusingisassociatedtothesameOperatingUnit(ORG_ID)asthetransactionyou
areinterfacing.
Responsibility:ReceivablesManager
Navigation:Customers>Customers
Queryupthecustomerrecord,drilldowntotheAccountLevelandthentotheSiteLevelandensuretheSite

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWin

9/15

4/6/2015

Document1088251.1
Queryupthecustomerrecord,drilldowntotheAccountLevelandthentotheSiteLevelandensuretheSite
islinkedtotherightoperatingUnit.

DatainRA_INTERFACE_LINES_ALL
IfyourTransactionSourcesetupforBillToCustomeris:
Value,thenyoushouldbepopulating
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CUSTOMER_REF
Id,thenyoushouldbepopulating
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CUSTOMER_ID
IfyourTransactionSourcesetupforBillToAddressis:
Value,thenyoushouldbepopulating
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_ADDRESS_REF
Id,thenyoushouldbepopulating
RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_ADDRESS_ID
ScripttofindincompleteSitesetupforAutoAccounting
ThefollowingscriptwillpickupCustomerSitesthatdonothavealltheGLaccountssetupattheBill
ToSite.
Youcanlimittherowsreturnedbyfilteringaddingaconditiononparty_name,orjustcheckingfora
particularGLaccount,orbyprocessinginbatchesusingaconditionlike:
andrownum<300
ThiscouldassistyouinproactivelysettingtheseuptoavoidissuesinAutoInvoice.
SELECTcust_acct.ACCOUNT_NUMBERcustomer_number,
substr(party.PARTY_NAME,1,30)customer_name,
substr(loc.ADDRESS1,1,30)address,
site_uses.CUST_ACCT_SITE_IDaddress_id,
site_uses.LOCATION,site_uses.SITE_USE_ID,
site_uses.SITE_USE_CODE,
nvl(to_char(site_uses.GL_ID_REC),'NULLREC')
gl_id_rec,
decode(site_uses.SITE_USE_CODE,
'BILL_TO',nvl(to_char(site_uses.GL_ID_REV),
'NULLREV'),
'DRAWEE','NOTAPPLICABLE')gl_id_rev,
decode(site_uses.SITE_USE_CODE,
'BILL_TO',
nvl(to_char(site_uses.GL_ID_FREIGHT),
'NULLFREIGHT'),
'DRAWEE','NOTAPPLICABLE')gl_id_freight,
decode(site_uses.SITE_USE_CODE,
'BILL_TO',
nvl(to_char(site_uses.GL_ID_CLEARING),
'NULLCLEARING'),
'DRAWEE','NOTAPPLICABLE')gl_id_clearing,
decode(site_uses.SITE_USE_CODE,
'BILL_TO',
nvl(to_char(site_uses.GL_ID_TAX),
'NULLTAX'),
'DRAWEE','NOTAPPLICABLE')gl_id_tax,
decode(site_uses.SITE_USE_CODE,
'BILL_TO',
nvl(to_char(site_uses.GL_ID_UNBILLED),
'NULLUNBILL'),
'DRAWEE','NOTAPPLICABLE')gl_id_unbill,
decode(site_uses.SITE_USE_CODE,
'BILL_TO',
nvl(to_char(site_uses.GL_ID_UNEARNED),
'NULLUNEARN'),
'DRAWEE','NOTAPPLICABLE')gl_id_unearn,

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWi

10/15

4/6/2015

Document1088251.1

'DRAWEE','NOTAPPLICABLE')gl_id_unearn,
decode(site_uses.SITE_USE_CODE,
'BILL_TO','NOTAPPLICABLE',
'DRAWEE',
nvl(to_char(site_uses.GL_ID_UNPAID_REC),
'NULLUNPAIDREC'))gl_id_unpaidrec,
decode(site_uses.SITE_USE_CODE,
'BILL_TO','NOTAPPLICABLE',
'DRAWEE',
nvl(to_char(site_uses.GL_ID_REMITTANCE),
'NULLREMITTANCE'))gl_id_remittance,
decode(site_uses.SITE_USE_CODE,
'BILL_TO','NOTAPPLICABLE',
'DRAWEE',
nvl(to_char(site_uses.GL_ID_FACTOR),
'NULLFACTOR'))gl_id_factor
FROMHZ_PARTIESPARTY,
HZ_PARTY_SITESPARTY_SITE,
HZ_CUST_ACCOUNTS_ALLCUST_ACCT,
HZ_LOCATIONSLOC,
HZ_CUST_ACCT_SITES_ALLACCT_SITES,
HZ_CUST_SITE_USES_ALLSITE_USES
WHEREparty_site.LOCATION_ID=loc.LOCATION_ID
ANDparty.PARTY_ID=cust_acct.PARTY_ID
ANDcust_acct.CUST_ACCOUNT_ID=
acct_sites.CUST_ACCOUNT_ID
ANDacct_sites.CUST_ACCT_SITE_ID=
site_uses.CUST_ACCT_SITE_ID
ANDparty_site.PARTY_SITE_ID=acct_sites.PARTY_SITE_ID
ANDsite_uses.SITE_USE_CODEin('BILL_TO','DRAWEE')
ANDsite_uses.STATUS='A'
AND((site_uses.SITE_USE_CODE='BILL_TO'AND
(site_uses.GL_ID_RECISNULLOR
site_uses.GL_ID_REVISNULLOR
site_uses.GL_ID_FREIGHTISNULLOR
site_uses.GL_ID_CLEARINGISNULLOR
site_uses.GL_ID_TAXISNULLOR
site_uses.GL_ID_UNBILLEDISNULLOR
site_uses.GL_ID_UNEARNEDISNULL))
OR
(site_uses.SITE_USE_CODE='DRAWEE'AND
(site_uses.GL_ID_RECISNULLOR
site_uses.GL_ID_UNPAID_RECISNULLOR
site_uses.GL_ID_REMITTANCEISNULLOR
site_uses.GL_ID_FACTORISNULL)))
ANDEXISTS
(SELECT'x'
FROMRA_ACCOUNT_DEFAULTS_ALLa,
RA_ACCOUNT_DEFAULT_SEGMENTSs
WHEREs.GL_DEFAULT_ID=a.GL_DEFAULT_ID
ANDs.CONSTANTisnull
ANDs.TABLE_NAME='RA_SITE_USES')

2.ValidatetheShippingInventoryOrganization
IftheShippingandSellingorganizationsaredifferent,witheachbelongingtoadifferentSetofBookseachsetupwithadifferent
ChartofAccounts,youmaygetanerrorsuchasthefollowing,evenwhenyourAutoAccountingsetupiscomplete.
Pleasecompleteyourtaxaccountingflexfieldor
Pleasecorrecttherevenueaccountassignment

ThisissueismanifestedbecausetheChartofAccountsforeachsetofbookshasadifferentnumberofsegments,forexample:
SellingOrganizationGLaccountshas13segments
ShippingOrganizationGLaccountshas7segments
Currentfunctionalitywasnotdesignedtohandlethisscenario.Anenhancementrequesthasbeenloggedforthisissue,viaBug
2432013.

3.IfyouarepassingDatainRA_INTERFACE_DISTRIBUTIONS_ALL
IfyouarepassingthedistributionsinRA_INTERFACE_DISTRIBUTIONS_ALL,adngetthefollowingerrors:
EXCEPTION:arp_auto_accounting.do_autoaccounting_internal()
ORA20000:APP15482:Pleasecorrectthereceivableaccountassignment

Thingstocheck:
IfyouwantAutoAccountingtodetermineyourgeneralledgeraccountsyoumustnotentervaluesin
RA_INTERFACE_DISTRIBUTIONS_ALL.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWi

11/15

4/6/2015

Document1088251.1
RA_INTERFACE_DISTRIBUTIONS_ALL.
IfyouwanttobypassAutoAccounting,thenyouneedtoprovidecompleteinformationinthedistributiontableforthe
ACCOUNT_CLASSdistributionsyouintendtoprovide.
Ifyouareinamultiorginstance,ensurethatyouhaveincludedtheORG_IDvalueinthedistributionsyoupass,andthat
thevalueisconsistentacrosstheinterfacetables.
CheckthattheINTERFACE_LINE_CONTEXT+INTERFACE_LINE_ATTRIBUTE*valuesyouprovideinthe
RA_INTERFACE_DISTRIBUTIONS_ALLtablematchthevaluesinthecorrespondingrowsinRA_INTERFACE_LINES_ALL,
sothatAutoInvoicecanmatchupthetransactiontoitsproperdistributions.

4.Checktheprofileoption:AR:UseInvoiceAccountingforCreditMemos
IfyouareimportingCreditMemos,andyouencountertheerror:Pleasecorrecttherevenueaccountassignment,verifywhether
youwouldlikethecreditmemotousethesameGLaccountsoftheInvoiceitiscrediting.Ifyes,thencheckyoursettingforthe
profileoption:AR:UseInvoiceAccountingforCreditMemos.Ifthesettingis:
Yes,ReceivablesdoesnotuseAutoAccountingtocreatethedefaultvaluesfortheseaccounts.Instead,creditentriesare
createdusingtheGLaccountsoftheinvoiceordebitmemoyouarecrediting.
No,ReceivableswillgenerateGLaccountsforthecreditmemobasedontheAutoAccountingsetup

5.CheckiftheGLaccountexistsandisactive
OnceallthesegmentsofyourGLaccounthavebeenderivedbyAutoAccounting,checkifitexistsandisactive.
Responsibility:ReceivablesManager
Navigation:Setup>Financials>Accounting>GLaccounts
QueryforAccount=theGLaccountsegments,forexample:Queryfor0310013240000000.
TheformwilldisplaywhethertheGLaccountexists,ifitisenabledandactive.
Alternatively,ifyouwanttocheckwhetheraparticularcode_combination_id(ccid)valuereferstoavalidandactiveGLaccount,
youcanrunthefollowing:

selectenabled_flag,start_date_active,end_date_active
fromGL_CODE_COMBINATIONS
wherecode_combination_id=&ccid

6.VerifyAccountingFlexfieldsettingforEnabledandAllowDynamicInserts
ConsideringAutoAccountingwillderiveandbuildGLaccountsonthedemand,youshouldcheckwhetheryouallowtheAccounting
Flexfieldtododynamicinserts.
Ifyourbusinessprocessallowsdynamiccreationofnewcodecombinations,setthecheckboxtoYes.
Responsibility:ReceivablesManager
Navigation:Setup>Financials>Flexfields>Key>Segments.
QueryonFlexfieldTitleAccountingFlexfield
LocatetherecordfortheAccountingFlexfieldStructureyouareusing
checktheEnabledandAllowDynamicInsertscheckbox

Ifyourbusinessdoesnotallowdynamicinserts,thenyouneedtoreviewwhyAutoAccountingattemptedto
generateacodecombinationthatyouhavenotyetsetup.Ifyouverify,thatthenewcodecombinationisvalidyou

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWi

12/15

4/6/2015

Document1088251.1

generateacodecombinationthatyouhavenotyetsetup.Ifyouverify,thatthenewcodecombinationisvalidyou
needtocreatethecodecombinationmanuallytoavoidtheerrornexttimethesamecodecombinationisderived.
Responsibility:ReceivablesManager
Navigation:Setup>Financials>Accounting>GLAccounts

7.VerifywhethertheGLaccountdoesnotviolateanycrossvalidationrulesofthesegments.
Responsibility:SystemAdministrator
Navigation:Application>Flexfield>Key>CrossValidation
QueryforTitle=AccountingFlexfieldStructure=ProvidetheStructureyouareusing
ThenreviewtherulesandseeiftheGLAccountyouareusinghassegmentswhichfallintotherangesexcluded.

References:
Note1080995.1TroubleshootingAutoAccountinginAutoInvoiceprovidesastepbystepoverviewofhowtotroubleshoot
issueswithAutoAccounting.ThisisrecommendedasastartingpointforallAutoAccountingissues.
MakesureyouhavethesetupcompletedforFreightinyourautoaccountingifyouencounterthiserror.Alsochecktoseeif
youareinvoicingfreightasrevenue.RefertoNote764297.1HowTaxonFreightWorksinR12OrdertoCash

8.CheckforPossibleKnownBugs
Whensetuphasbeenruledoutasapossiblerootcause,itisoftengoodtoinvestigatebugstoseeifanyproblemshavebeen
reportedwiththiserror.ItisnotuncommonforabuginAutoInvoicetopresentwithanAutoaccountingerror.Thisoccurs
wheneverAutoInvoicecannotderivedataforoneofthesourcesusedbyyourAutoAccountingsetup.Forexample,ifyour
AutoAccountingusestheSalesRepbutabugispreventingthesystemfromfindingthesalesrep,theproblemcouldshowupasan
errorinderivingtheaccount.
Thetablebelowlistsbugsthathavebeenreportedasofthelastupdatedateforthisnotewhichcausethissymptom.

# Release/
AutoAccounting
Source/Errorin
Log

Cause

Fix

Release11.512.1
AutoAccounting
Source:Nospecific
segment
Errorinlogfile:No
additionalerrors

TheGLAccountwasnotsetuptoPOST.

UpdatetheGLaccounttoallowfor
posting

Release:11.5/R12
AutoAccounting
Source:NoSpecific

Anincorrectprocessingorderforinvoicesandcredit
memos.Theusercreatesthesalesorder,createsthe
return,thenrunsAutoInvoiceatonceforalltransactions.

1.Processallinvoicesvia
AutoInvoice.
2.Processtheassociatedcreditsina

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWi

13/15

4/6/2015

Document1088251.1
Source:NoSpecific
Segment
ErrorinLogFile:No
additionalerror

return,thenrunsAutoInvoiceatonceforalltransactions.
Theinvoiceshouldbecreatedfirst.

Release:11.5/R12
AutoAccounting
Source:NoSpecific
Segment
ErrorinLogFile:No
additionalerror

Incompletesetup.

Release:11.5
AutoAccounting
Source:MemoLines
ErrorinLogFile:No
additionalerror

Zeroamountfreightlines(line_type=line,description=
freight)arefailingwitherror:
"Pleasecorrecttherevenueaccountassignment".

SettingtheprofileoptionTax:
InvoiceFreightasRevenuetoYes
atalllevels,andthencreatinga
freightitemandassigntotheprofile
optionTax:Inventoryitemfor
freightinSystemAdministrator
responsibility

Release:11.5/R12
AutoAccounting
Source:MemoLines
ErrorinLogFile:No
additionalerror

PresentsasAutoInvoiceExceptioninreport
OccurswhenIntercompanyFreightisprocessedanda
memolineisused.AccountwasnotsetontheMemoLine
setupform

Option1
ReceivablesManager
Setup>Transactions>MemoLines.
QueryName:IntercompanyFreight.
MakesuretheRevenueaccounthas
beendefined.
Option2
Setupfreightsothatitcomesinas
revenue.See
Note764297.1HowTaxonFreight
WorksinR12OrdertoCash

Release:11.5
AutoAccounting
Source:Nospecific
source
ErrorinLogFile:No
additionalerror

ThisisacodebuginpackageLNS_PAYOFF_B.pls.
Thebugfixchangesthecodethattheloansaccountingis
usedinsteadofusingautoaccountingfromAR

FixedFile:LNS_PAYOFF_B.pls115.16

2.Processtheassociatedcreditsina
separateAutoInvoicerun.

Theprofileoption,AR:UseInvoiceAccountingForCredit
Memos,issettoYes.Ifboththeinvoiceandthecreditare
comingoveratthesametime,theerrorisreceived
becausethereisnotyetaccountingfortheinvoicewhen
AutoAccountingislookingforrevenueaccountinformation
forthecredit.
Checkthetable
MTL_SYSTEM_ITEMS_Bandverify
Theinventoryitemidassociatedwiththefreightlinehasa thattheinventoryitemand
warehouseidthathasnotbeendefinedfortheinventory
warehousecombinationexists.
item.

RecommendedPatchpatch6683166.

Thisisexplainedinthefollowingbug:
BUG6683166UNABLETOPROCESSLOANPAYOFF
WITHMANUALFEESADDITIONATTHETIMEOF
PAYOFF

Release:11.5
Bug7142942
AutoAccounting
Erroroccurswhensalescreditsarerequiredinthis
Source:Nospecific
operatingunit.
source
ErrorinLogFile:You
mustsupplysales
creditassignmentsfor
thistransaction
becausesystemoption
RequireSalesrepsis
settoYES

Receivablesresponsibility

Release12.x
AutoAccounting
Source:Nospecific
source
ErrorinReport:
Pleasecorrectthe
revenueaccount
assignment

Youcaninterfacethecreditmemoas
OnAccountinstead,byremovingthe
REFERENCE_*fieldsthattieittothe
Invoice.

Itemoncreditmemoshouldmatchtheitemontheinvoice
beingcredited.YoucannotcreateaCreditmemowithan
inventoryitemandapplyittoanInvoicewithoutan
inventoryitem.SincetheProfileOptionAR:UseInvoice
AccountingforCM=Yes,theprocesscannotderivethe
correctaccountingtouseforthecreditmemo.

Setup>System>SystemOptions>
Miscellaneousandmakesure
'RequireAgent'(orRequire
Salesperson)ischecked.
CheckRequireSalespersontoensure
thatrecordsalesrep_id=3will
populatecorrectlyinsalescredit
interfacetable.

9.UsetheAutoInvoicePostProcessValidationReport
ThereisanewAutoInvoiceValidationReportthatprovidesmoredetailsincludingrecommendationsandactionitemsyoucan
followtofixAutoInvoiceImportValidationErrors.ReadmoreaboutthisnewreportinNote1523525.1

StillHaveQuestions?
TodiscussthisinformationfurtherwithOracleexpertsandindustrypeers,weencourageyoutoreview,joinorstarta
discussionintheMyOracleSupportReceivablesCommunity.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWi

14/15

4/6/2015

Document1088251.1

discussionintheMyOracleSupportReceivablesCommunity.
Toprovidefeedbackonthisnote,clickontheRatethisdocumentlink.

REFERENCES
NOTE:1523525.1R11i/12:AR:AutoInvoicePostProcessAnalyzer:OverviewandInstallationInstructions

Related
Products
OracleEBusinessSuite>Projects>Projects>OracleProjectBilling>Invoices>Invoices
OracleEBusinessSuite>OrderManagement>OrderManagement>OracleOrderManagement>Sales&Marketing>InterfacebetweenOMandTelesales
OracleEBusinessSuite>FinancialManagement>CredittoCash>OracleReceivables>TransactionsRelated>AutoInvoice(RAXTRX)
OracleEBusinessSuite>FinancialManagement>Leasing>OracleLeaseandFinanceManagement>UsageBasedBilling>UsageBasedBilling

Keywords
ARXTWMAI.FMB AUTOINVOICE AUTOINVOICEIMPORTPROGRAM PROGRAM RECEIVABLE REVENUE
BacktoTop

Copyright(c)2015,Oracle.Allrightsreserved.

LegalNoticesandTermsofUse

PrivacyStatement

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=219345375820705&id=1088251.1&_adf.ctrl%C3%A2%E2%82%AC%C2%A6=&_afrWi

15/15