Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

EBS General Discussion


AR Interface


Hi  While uploading the AR Legacy data into oracle AR base table, the following method is used.  1. move the data into custom table  2. do all the validation for the data 3. move the valid data to RA_INTERAFACE tables 4. Use Auto Invoice Concurrent program to move the data from interface table to base tables.  Clarification needed  1. The legacy data does not have the code combination id.. inspite of this the data is moved and lines are created with code combination..  can you pls explain me how the code combination id is defined for Revenue, Receivable, Tax  2. Can i modify the default code combination id.. if so how...  Regards Yram

1. The legacy data does not have the code combination id.. inspite of this the data is moved and lines are created with code combination..  can you pls explain me how the code combination id is defined for Revenue, Receivable, Tax It uses Auto Accounting setup from the Receivables setup.  2. Can i modify the default code combination id.. if so how...  Yes, but you have to populate the ra_interface_distributions_all table with the desired values.  Thanks Nagamohan

Hello Code combinations are loaded in the RA_INTERFACE_DISTRIBUTIONS_ALL table. You can use the column CODE_COMBINATION_ID or enter the segment values in the columns SEGMENT1…SEGMENTN If you do not enter this information, the system will pick it from the information entered in the Setup/Transaction/Autoaccounting window.  Hope this helps. Octavio.

Thanks Nagamohan  for the input.   some clarification on the ra_interface_distributions_all table, in this table account_class is a not null column... all other columns are null. what value should gointo this   with my understanding   the legacy data will have the code combination id or the segment column... the code combination id or the segment columns should move to the ra_interface table or ra_interface_distributions_all table...  Regards Yram

Yram some clarification on the ra_interface_distributions_all table, in this table account_class is a not null column... all other columns are null. what value should gointo this  If you look at the ra_cust_trx_line_gl_dist_all (destination table that houses the data from ra_interface_distributions_all) you will get an answer. But the values are usually mapped to accounting needs based on the document.  You can find the values supported from this sql.  select * from fnd_lookup_values where lookup_type='AUTOGL_TYPE';  From documentation what I remember is that the REC is not supported to be used from interface, rest I guess you can.  Thanks Nagamohan


Related Links

Forms Personalization using DB function
Projects Expenditure Inquiry - Forms Personalization Query
Transactional Data Collection in EBS (Discrete Manufacturing-Quality)
open APPS form in enter-query mode
Start and End Date of a shared AR customer's bank account
when-validate-item in custom.pll
Invoice is showing validated by user who do not have the access to Validate
NLS patch for 12.1.1
Form 6i to 10g - Form not loading the graphics/buttons/icons
List Oracle Users in R12
Erro when log mod_oc4j: Response status=499 and reason=Oracle SSO, but fai
how to find list of master tables in oracle apps GL
Using encryption in EBS R12
Need Order Reference Number in Sales Order Lines->Returns Tab
Fresh Installation 12.1.1 then upgrade
How to display the report output from a customized Oracle Form button