how data is transferred from interface table to base table ?

Answers were Sorted based on User's Feedback



how data is transferred from interface table to base table ?..

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

how data is transferred from interface table to base table ?..

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

how data is transferred from interface table to base table ?..

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

how data is transferred from interface table to base table ?..

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

Post New Answer

More Oracle Apps Financial Interview Questions

accrual journal entries

1 Answers   IBM,


necessary steps for ledger creation?

2 Answers  


How can I get the Profit & Loss (P/L) report of a period in GL ? plz tell me the parameter name if it required me to submit a new request ?

2 Answers   KPIT,


can you explain aim methodology, what are the documents need to be prepare as functional consultant, explain about gap.

2 Answers   Oracle,


where should Accrual account define in account payable that will affected during Invoicing?

1 Answers  


What is the formula for funds available?

1 Answers  


How to open the new future periods in GL while we are in P2P or in O2C

1 Answers  


Invoice Approval Process?

0 Answers   TCS, Wipro,


Anyone provide the oracle fin/scm definetions

0 Answers   Fresher, Genesis,


What is 2 way , 3 way and 4 way matching?

12 Answers   Chartered Accountant, HCL, IBM, MNC, Shell, TCS,


I hv done revaluation corectly even got the result also but why report showing in warning mode in view window after refreshing ?

2 Answers  


What is TCA and use ?

2 Answers   IBM,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)