how data is transferred from interface table to base table ?
Answers were Sorted based on User's Feedback
Answer / dinesh
For example if you want to upload the data from
ap_supplier_site_int interface table to its base table, Run
the standard interface program called Supplier sites open
interface import. which will upload the Data.
All the validations for duplicates checking should be done
in the staging table level..As no validation can be done
from in to base table.
Thanks,
Dinesh.
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / srinibas
It is good question
i m giving a example to under stand this
suppose we have make some invoice transaction in payable
module.and we need to transafer them to the gl module.
first run the payable trnsfer to gl program
after running this program the data go to the gl interface
table.
so u need to import them to the gl table
just go to gl module and import the data which are exist in
the gl interface table to gl base table
in ap and ar module there are certain import program
avilable to transfer data from interface to base table also
for example-payable invoice import program,auto invoice
import program etc.
srinibas
oracle_sri08@rediffmail.com
| Is This Answer Correct ? | 17 Yes | 2 No |
Answer / amit
I never heard this question before in my last 4 years Apps
career.
When interface tables and base tables are part of oracle
package, it is Oracle responsibility to supply you the
interface programme name to do this job.There are different
interface programs specific to a module as part of Oracle
seeded inbound programs which generally do these activities.
| Is This Answer Correct ? | 14 Yes | 7 No |
Answer / charan
Interface:Before validate the data will store in interface
tables.
Base Tables: After validate the data will store in base tables
| Is This Answer Correct ? | 4 Yes | 4 No |
explain with examples what r the roles & Responsiblities of a functional consultant who reviews the Test Scripts, Test Cases and Test Execution Results of AP, FA and GL.
what is the difference between position hierarchy and employee hierarchy in purchasing module?
What are the tables associated with Invoice?
What are the various Implementation method for oracle apps
Can I increase/decrease the size of value set?
what is meant by accural report? it consist of ?
What is difference between consolidation and revaluation?
1)I created a business group BG and assigned profile classes to that and my question is a)In purchasing financial options under human resource tab unable to see my BG but VISION CORPORATION is coming. b)at ledger level operating units page whenevr adding my OUs vision corporations are showing instead of my BG. 3)Tell me after create my BG assign profile classe to my RESP then wht is the next step with BG
what is the difference between balance, account, none (automatic offset methods)?
what is the difference between Financial and payable options in Accounts Payables?
Hi Friends!! I've completed my MBA in Finance and Systems and currently working in a Staffing firm. Recently I've joined in Oracle Apps training institute and can anyone let me know whether there are any chances of getting a job as a fresher. Please help me!!
ERS Invoice means?