GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Oracle Apps  >  Apps Technical
Go To First  |  Previous Question  |  Next Question 
 Apps Technical  |  Question 26 of 125    Print  
What was your role in Customer Interface?

  
Total Answers and Comments: 1 Last Update: December 28, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 28, 2006 11:17:03   #1  
shaik ghouse        

RE: What was your role in Customer Interface?

Generally to start with the role involves creation of staging tables by copying the same structure of interface tables so that it could be easy , these staging tables are to be loaded with leagacy data and then when u find the data in staging tables thru the SQL loader programs,

then we will run the package created to transfer the data from staging tables to interface tables with necesary validations made on the requied columns,

then when we find the data in interface tables then run the standard interface program 'Customer open interface Program' so that the data gets transferred from interface tables to oracle base tables.

may this help u,

Shaik


 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : hi,   small clarification, do u want the total steps for customer interface, now the companies r using TCA architecture. so its differs now compared to older versions.bhanu.   ...

Latest Answer : Hi,Take the error code which you have encountered in the interface table and check it in AR document where u can find the list of customer error codes and their description.You can act on the error code accordingly.ThanksGanga ...

Latest Answer : Generally to start with the role involves creation of staging tables by copying the same structure of interface tables so that it could be easy , these staging tables are to be loaded with leagacy data and then when u find the data in staging tables thru ...

Latest Answer : HZ is a profile option. All the customer related tables starts with HZ ...

What are Interface table in AP, AR,GL ? AP INTERFACE TABLE: 1). AP_INTERFACE_CONTROLS. 2). AP_INTERFACE_REJECTIONS 3). AP_INVOICE_INTERFACE 4). AP_INVOICE_LINES_INTERFACE. AR INTERFACE TABLE: 1). AR_PAYMENTS_INTERFACE_ALL 2). AR_TAX_INTERFACE 3). HZ_PARTY_INTERFACE 4). HZ_PARTY_INTERFACE_ERRORS 5). RA_CUSTOMERS_INTERFACE_ALL 6). RA_INTERFACE_DISTRIBUTIONS_ALL 7). RA_INTERFACE_ERRORS_ALL 8). RA_INTERFACE_LINES_ALL 9). RA_INTERFACE_SALESCREDITS_ALL GLINTERFACE TABLE: 1). GL_BUDGET_INTERFACE 2). GL_DAILY_RATES_INTERFACE 3).

Latest Answer : this is the standard program through which the data from interface table RA_interface_lines_all will be pulled into oracle receivables on making the validations on various feilds.batch source will play major role in this transferring of records. the pulled ...
Read Answers (2) | Asked by : vaishali

Is there any inbuilt interface programs in the Oracle financials? If the answer is yes , list all interface programs for all modules? Why we are creating interface programs even there are inbuilt interface programs?
View Question | Asked by : Bavani

Latest Answer : oe_interface_errors_all ...
Read Answers (1) | Asked by : bala

Hi! Any one can you send me the details and process of item conversion?1.What are the interface tables in item conversion?2.What are the base tables in item conversion?3.what are the validations and what 
Latest Answer : Interface tables involved in Item COnversion:MTL_SYSTEM_ITEMS_INTERFACEMTL_ITEM_CATEGORIES_INTERFACEMTL_ERRORS_INTERFACEBase Tables:MTL_SYSTEM_ITEMSMTL_ITEM_CATEGORIESStandard Import Program name: Item Import (INCOIN)This program does most of the standard ...


 Sponsored Links

 
Related Articles

BI Role in Making Corporate Decisions

BI Role in Making Corporate Decisions What is a Corporate Decision A decision that deals with the safety success and livelihood of a business can be defined as a corporate decision These decisions can range anywhere from financial issues and customer satisfaction to product popularity and environmen
 

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat
 

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

XML Processing in PHP and Oracle Applications

Processing XML in PHP Oracle Applications As mentioned there are two alternatives when it comes to performing XML processing in your PHP Oracle application You can perform any required XML processing using either PHP s XML extensions or PEAR XML packages or Oracle s XML features mosgoogle In the fol
 

PHP Oracle Web Development

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax is a good starting b
 

Getting Started with Oracle and ODP.NET

ODP NET Developer’ s Guide by Jagadish Chatarji Pulakhandam Sunitha Paruchuri A practical guide for developers working with the Oracle Data Provider for NET and the Oracle Developer Tools for Visual Studio 2005 Application development with ODP NET Dealing with XML DB using ODP NET Oracle
 

PHP Oracle Web Development Review

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books The author is also an expert in open source technologies and SOA Service Oriented Architecture But besides
 

High-Speed Serial Interface (HSSI)

High Speed Serial Interface HSSI HSSI is High Speed Serial Interface was first developed by Cisco systems and the main purpose was to solve high speed requirement issues The main application of HSSI is on the Wide Area Networks and it helps to enhance the data flow speed on these networks It can wor
 

Fiber Distributed Data Interface (FDDI)

Fiber Distributed Data Interface FDDI The Fiber Distributed data interface or the FDDI is a 100 mbps line using the LAN network and is connected through a fiber optic cable The FDDI technology is used where the networks need a high speed bandwidth and need to cover huge distances than the copper wir
 

Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape