2024年8月20日 · Could any help me with the SQL Query or table names to fetch the ratings from the talent profile. Navigation: Me>career and performance>skills and qualification. Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):

2023年5月2日 · Summary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer).

2020年5月21日 · SQL/Table to fetch Purchase order change history Content. Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was able to get the preliminary details from po_version but I need the further details on what was changed what was the old value and what is the new value.

2023年12月1日 · I am building an audit report to get a clear view of the PO Changes and Approval History. There is not much that I can find and the query I am using does not seem to be correct.

Display of login history in SQL Feb 2, 2010 7:42AM edited May 21, 2010 11:03AM in Database Administration (MOSC) 14 comments Answered To address a security finding, I need to display the following upon entry to SQL: Last successful login date or number of failed logon attempts.

2021年5月10日 · Summary Query to fetch BIP report job historyContent Hi Team, Is there any query from table to fetch the BIP report Job History. Thanks, Sourav

2022年11月28日 · What table show the Approval history for Enterprise Contracts? Looking for the tables showing the following fields in the Enterprise Contracts. Navigation path: Contract Management > Contracts > Search for a Contract > Go to History Tab. 1. Dates: Approved Date. 2. Dates: Signed Date. 3. Versions. 4. Approval History. 5. Status. Supporting ...

2024年8月26日 · Now this is replated with FND_SESSIONS. By using this table not getting all users login dates. we have scheduled the "Import User Login History" job on daily basis. We have used these SQL's. But not getting the last login date for all users. Please suggest any SQL or any other way to find the last login date. Regards, Deepika K

2024年7月10日 · We need to customize "AP Invoice Account Coding Workflow Notification" to display approval history using SQL Query. In BPM Workflow notification we can see the approval history in UI (Navigation: BPM Worklist -> Open a notification - > Actions -> View Approvals). The same approval information we want to display in the bottom of the notification.

2024年11月6日 · I am using the query below to retrieve serial numbers for receipt 30148, but it does not show all four serials as seen in the Transaction History UI. SELECT eib.item_number, c.receipt_num, rsl.QUANTITY_RECEIVED, am.serial_number, b.transaction_date, b.po_header_id, poa.segment1 FROM inv_serial_numbers am, inv_material_txns imt, …