In Per_all_people_f table what is the significance
of '_f ' ?
- 6 Answers
- 25059 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeep
_F these are date tracked tables, which occur in HR and
Payroll. For these there are two date columns
EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together
with the PK identifies a row uniquely. The date intervals
cannot overlap.
| Is This Answer Correct ? | 21 Yes | 1 No |
Answer / phani
Yes, I agress with the above comment.
These tables are design for the Tracking purpose.
When we try to make any changes in the Oracle apps forms
which are based on these dates. They gives us a option to
CORRECT or UPDATE.
Based on the Option we choose, It is change the same table
or else it will create new record in the table.
For the better understanding about the Oracle Apps, I
suggest you to go through the following link.
http://alloracletech.blogspot.com/2008/08/oracle-applications-concept.html
Regards,
Phani
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / prince pradeep
PLZ UNDERSTAND THE QUESTION WHAT F STANDS FOR THATS IT
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ag
It stands for FULL (i.e. full history of the person, not
just the current date tracked row)
| Is This Answer Correct ? | 3 Yes | 0 No |
how to make a parameter optional in the query?
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?
Tell me some thing about SQL-LOADER.
what is the invoice matching
What is multoorg and what is it's level or structure
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
What is secuirity's in R12 features.
where is chandra institute in hyderabad for oracle apps technical training ?
what is tuning in oracle apps technical
What is the autonomous transaction?give me example?
how to initialize applications?
Oracle Apps Technical 
