Use of Account Set Flag in AR

ACCOUNT_CLASS defines which type of distribution row you are on. The ACCOUNT_CLASS REC represents the receivable account and is for the total amount of the invoice. There can be at most two REC rows. One that has a ACCOUNT_SET_FLAG set to Y and the other has ACCOUNT_SET_FLAG set to N. Use LATEST_REC_FLAG to join to the later of the two rows. ACCOUNT_SET_FLAG is Y if this row is part of an account set. An account set is a set of rows that represent a model distribution. Account sets are used for invoices with rules. The rows represent how the actual distribution rows should be created and what percentage of the actual distribution should be allocated to each account. For invoices with rules, the distributions are not created when the invoice is initially created. Instead, the invoices are created when the Revenue Recognition program is run.

AR Links to GL

Link between GL to AR

 When you run AR Transfer to GL , GL_INTERFACE table get first populated with reference columns that is then pushed the detailes in GL_JE_LINES table. Here are the details for Refrence columns.

Adjustments

• REFERENCE21 :posting_control_id
• REFERENCE22 :adjustment_id
• REFERENCE23 :line_id
• REFERENCE24 :trx_number
• REFERENCE25 :adjustment_number
• REFERENCE26 :cust_trx_type
• REFERENCE27 :bill_to_customer_id
• REFERENCE28 :ADJ
• REFERENCE29 :source_type prefixed by ‘ADJ’
• REFERENCE30 :AR_ADJUSTMENTS

Transactions

• REFERENCE21 :posting_control_id
• REFERENCE22 :customer_trx_id
• REFERENCE23 :cust_trx_line_gl_dist_id
• REFERENCE24 :trx_number
• REFERENCE25 :cust.account_number
• REFERENCE26 :CUSTOMER
• REFERENCE27 :bill_to_customer_id
• REFERENCE28 :type(CM/DM/CB/INV)
• REFERENCE29 :type||account_class
• REFERENCE30 :RA_CUST_TRX_LINE_GL_DIST

Applications

• REFERENCE21 :posting_control_id
• REFERENCE22 :cash_receipt_id||receivable_application_id for CASH /receivable_application_id for CM
• REFERENCE23 :line_id
• REFERENCE24 :receipt_number for CASH / trx_number for CM
• REFERENCE25 :trx_number if status = ¿APP¿ / NULL for unapplied records
• REFERENCE26 :cust_trx_type
• REFERENCE27 :pay_from_customer for CASH / bill_to_customer_id for CM
• REFERENCE28 :application_type (TRADE or CCURR for CASH / CMAPP for CM)
• REFERENCE29 :application_type||source_type
• REFERENCE30 :AR_RECEIVABLE_APPLICATIONS

Bills Receivable

• REFERENCE21 :posting_control_id
• REFERENCE22 :transaction_history_id
• REFERENCE23 :line_id
• REFERENCE24 :trx_number
• REFERENCE25 :customer_Trx_id
• REFERENCE26 :cust_trx_type
• REFERENCE27 :drawee_id
• REFERENCE28 :cust_trx_type
• REFERENCE29 :BR_||source_type
• REFERENCE30 :AR_TRANSACTION_HISTORY

Key Tables

In order to obtain what is going to be tranfered to GL you can these Major AR table to drill down information.

• ra_customer_trx_all: Transactions accounting
• ra_cust_trx_line_gl_dist_all: Transactions accounting
• ar_adjustments_all:Adjustments accounting
• ar_distributions_all:Adjustments accounting
• ar_cash_receipt_history_all:Receitps accounting
• ar_distributions_all: Receitps accounting
• ar_receivable_applications_all: Receipt applications accounting
• ar_distributions_all:Receipt applications accounting & misc receipts accounting
• ar_misc_cash_distributions_all:Misc receipts accounting

Oracle AOL Object Migration Scripts

Download Concurrent Program:
---------------------------
FNDLOAD apps/simple4u@DCMEMI O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <ldt name>.ldt PROGRAM CONCURRENT_PROGRAM_NAME="XXXX"  -- Short name

FNDLOAD apps/simple4u@DCMEMI O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <ldt name>.ldt PROGRAM CONCURRENT_PROGRAM_NAME="XXXX" -- Short name

Download Request Set:
--------------------
FNDLOAD apps/simple4u@DCMEMI O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <ldt name>.ldt REQ_SET REQUEST_SET_NAME="XXXX" -- Short name

Download Request Set Link:
-------------------------
FNDLOAD apps/simple4u@DCMEMI O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct C<ldt name>.ldt REQ_SET_LINKS REQUEST_SET_NAME="XXXX" -- Short name

Download Request Set Group:
--------------------------
FNDLOAD apps/simple4u@DCMEMI O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <ldt name>.ldt REQUEST_GROUP REQUEST_GROUP_NAME="Request Group Name"


Download Profiles:
--------------------------
FNDLOAD apps/simple4u@DCMEMI 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct <ldt name>.ldt PROFILE PROFILE_NAME=<profile name>


Download Value sets:
-----------------
FNDLOAD apps/simple4u@DCMEMI O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct <ldt name>.ldt VALUE_SET FLEX_VALUE_SET_NAME="XXXX"  -- value set name


 for uploading value set:
------------------------
$FND_TOP/bin/FNDLOAD $APPSID 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct $HOME_PATH/<ldt name>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


 for uploading profile:
------------------------
$FND_TOP/bin/FNDLOAD $APPSID 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct $HOME_PATH/<ldt name>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


 for uploading Concurrent Program:
---------------------------------
$FND_TOP/bin/FNDLOAD $APPSID 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $HOME_PATH/<ldt name>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


for uploading Request Set:
------------------------
$FND_TOP/bin/FNDLOAD $APPSID 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct $HOME_PATH/<ldt name>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


for uploading Request Set Link:
------------------------------
$FND_TOP/bin/FNDLOAD $APPSID 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct $HOME_PATH/<ldt name>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE



for uploading Request group
----------------------------
$FND_TOP/bin/FNDLOAD $APPSID 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct $HOME_PATH/<ldt name>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

API to upload Lookup Code

The below API can be used to upload only specific lookup codes.

FND_LOOKUP_VALUES_PKG.INSERT_ROW

This is good in case you are migrating only 1 or two lookup codes.