Wednesday, 28 June 2023

Oracle EBS - SQL query for GL Authorization Limit for Employee

Subject: SQL query for GL Authorization Limit for Employee

SQL Query:

SELECT

    ledger_name,
    ledger_currency,
    employee_name,
    employee_id,
    authorization_limit,
    ledger_id,
    last_update_date,
    last_updated_by,
    created_by,
    creation_date
FROM
    apps.gl_authorization_limits_v
WHERE
    employee_name LIKE '%Ryan%' ---Need to enter user name whoes Authorization Limit need to check
ORDER BY
    ledger_name,
    employee_name

Monday, 22 May 2023

Oracle Fusion: FBDI Solution - How to Close Bulk PO’s using FBDI

Subject: FBDI Solution – How to Close Bulk PO’s using FBDI


Navigate: Procurement > Task > Close Schedules in Spreadsheet

Search PO with Specific Criteria.


 

Need to select the Action against The PO Line. (Action: Finally Close/Close)