In Per_all_people_f table what is the significance
of '_f ' ?
- 6 Answers
- 28026 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 pass data into EXECUTE_IMMEDIATE statement in plsql body ?
how to create a file in forms?
what is the differences between internal requisition and internal sales order?
Do you know what are user profiles in apps. Any examples you can give?
what are the difference between oracle discoverer and report6i
what is the difference between credit memo and debit memo?...
Difference between set of books id and ledger id in r12 ?
suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?
do i need to declare bind parameter before using in the query?
what is the standard program for blanket po to process data from interface table to bace table
what is instead of trigger in where u will use?
What are the validations you don in .CTL file in inbound interface process?
Oracle Apps Technical 
