In Per_all_people_f table what is the significance
of '_f ' ?
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 |
what is the difference between character mode,bitmap mode
2 Answers IBM, Sierra Atlantica,
Difference between set of books id and ledger id in r12 ?
What is Pragma Autonomous transaction. It's Real time Example
What r the validation done in ap inbound ?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Can you have two stored functions with in the same name?
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
how can we return morethan one parameters in procedure?
why r u move in the cus_top only why not move another top
what is lexical parameter?
what is inbound and outbound interface?