CREATED_BY :NUMBER(15) NOT NULL Keeps track of which user created each row
Value:TO_NUMBER(FND_PROFILE.VALUE(’USER_ID’))
CREATION_DATE :DATE NOT NULL:Stores the date on which each row was created
LAST_UPDATED_BY :NUMBER(15) NOT NULL Keeps track of who last updated each row
Value:TO_NUMBER(FND_PROFILE.VALUE(’USER_ID’))
LAST_UPDATE_DATE: DATE NOT NULL:Stores the date on which each row was last updated
LAST_UPDATED_LOGIN :NUMBER(15):Provides access to Information about the operating system login of the user who last updated each row Value: TO_NUMBER(FND_PROFILE.VALUE(’LOGIN_ID’))
Oracle HCM & ERP insights from the field — Fusion Cloud, Redwood UI, Payroll, Absence, BIP, OTBI and integrations.
Subscribe to:
Post Comments (Atom)
Redwood Recruiting: the ESS and OSCS index ingest jobs must all succeed, or the data won't load
# Fix of the Day #25: Redwood Recruiting: the ESS and OSCS index ingest jobs must all succeed, or the data won't load Part of my Oracl...
-
Absence Management in Oracle Fusion is powerful — and easy to get wrong. The accrual plan is where most of the complexity lives. Here is a...
-
HCM Extracts are Oracle's built-in mechanism for extracting structured HR data for payroll interfaces, benefits carriers, and third-pa...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.