Create Supplier then Customer to Use Single Party in TCA

In order to create a one party representation of an entity in Oracle's TCA be sure to create the Supplier first! 

Set the profile option ‘AR: Show parties without Accounts in DQM’ to Yes before doing the following

STEP 1 – Log in to Payables application and create a new supplier. This will create a new party record in HZ_PARTIES which is linked to the supplier record in vendors table.

STEP 2 – In receivables query the Supplier name you used when creating the supplier in step 1.

STEP 3 – Select the party and click on the button ‘Create Account’ and continue to create the customer account under the same party.

Oracle Receivables (AR) Set the Party Number Next Number

The database sequence that handles the creation of customer numbers is defined in HZ_PARTY_NUMBER_S.

select max(party_number) from ar.hz_parties;

Then using the number returned above, define the sequence to start with a higher value.

If for example the above returns 10001, then you can do the following to ensure the sequence will not create overlapping Party numbers:

DROP SEQUENCE AR.HZ_PARTY_NUMBER_S;10002 INCREMENT BY 1 MAXVALUE 999999 CACHE 20;

Oracle Receivables (AR) Set the Customer Account Automatic Numbering

The database sequence that handles the creation of customer numbers is defined in HZ_ACCOUNT_NUM_S.

select max(account_number) from ar.hz_cust_accounts_all;

Then using the number returned above, define the sequence to start with a higher value.

If for example the above returns 1114, then you can do the following to ensure the sequence will not create overlapping account numbers:

DROP SEQUENCE AR.HZ_ACCOUNT_NUM_S;
CREATE SEQUENCE AR.HZ_ACCOUNT_NUM_S START WITH 1115 INCREMENT BY 1 MAXVALUE 999999 CACHE 20;