ERROR

Error while running AR auto Invoice import program

arcsai() Not all AutoAccounting types are defined Error calling arcdsu_do_setup() Error calling raaini()

SOLUTION

Setup the Auto Accounting for all the Accounting Types.

NAVIGATE: Receivables -> Setup -> Transactions -> AutoAccounting

The minimum mandatory types are below:

1.FREIGHT
2.REC
3.REV
4.SUSPENSE (AutoInvoice Clearing)
5.TAX
6.UNBILL (Unbilled Receivable)
7.UNEARN (Unearned Revenue)

Use below script to identify the missing auto accounting types;

SELECT GL_DEFAULT_ID,

TYPE FROM RA_ACCOUNT_DEFAULTS_ALL

WHERE ORG_ID = &orgid 

AND TYPE IN 

(‘FREIGHT’, ‘REC’, ‘REV’, ‘SUSPENSE’, ‘TAX’, ‘UNBILL’, ‘UNEARN’);

ERROR

Customer Interface Issue: Cannot Populate Account_Name In RA_CUSTOMER_PROFILES_INTERFACE

You cannot create Account Name using Customer Interface (RACUST) as this column does not exist in RA_CUSTOMER_PROFILES_INTERFACE.

SOLUTION

You can use TCA API procedure to populate the Account Name:
Procedure= HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
Parameter Name = &account_name

Please refer the oracle support Notes:

1.  Note 189369.1  How To Create A Customer Via TCA API
2.  Note 230753.1  Different uses of TCA API