INBOUND INTERFACE: Suppose I have 100 Records of employees
in flat file.When moving the records from flat file to
STAGING table using .CTl file, I want to restrict the
records whose salary is less than 500.what are the
validations(or conditions) you write to achieve this.
- 2 Answers
- 7436 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / basha
we can apply the condotion by using 'when sal<500' before
columns name and after the into statemnt
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / prasanna
WHILE DEVELOPING THE xml format rtf you can make condition
on the field using choose element
| Is This Answer Correct ? | 1 Yes | 1 No |
Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen
Plz anybody send me Technical specification for AP Interface
How to develop XML report without rdf?
hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411
what are the types of interfacing?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
What is MO operating units. Why it need to to set this and where .
How to move the one file from one instance to another instance? And your scripts also?
How to create user and how u attach with responsibility.
What are the Import Programs We need to run after creating Interface table for all modules
What is Place holder Columns?
where we will put the control file ,where we will run sql star loader what is the cmd?
Oracle Apps Technical 
