Skip to main content

iProcurement Favorite Charge Accounts

Favorite Charge Accounts

The favorite charge accounts functionality provides the requester the capability to maintain a list of up to 50 frequently used charge accounts on the iProcurement Preferences page. During the checkout process, the requester can access the favorite charge accounts list and use it to automatically complete the charge account information for the items, rather than having to manually enter the charge account information.
Setup Steps
  1. Log in to Oracle iProcurement.
  2. On the Home page, click Preferences in the upper-right corner.
  3. In the Preferences area, click iProcurement Preferences.
  4. Enter Favorite Charge Accounts and a nickname for each account. To add another row, click Add Another Row.
  5. Select a default favorite charge account.
  6. Save the changes.
Function Security
  • Function Security exists to disable the Favorite Charge Account List functionality. The function is called Favorite Charge Accounts. For information about function security setup, see Set Up Function, Menu, and Data Security.
Implementation Considerations
  • The favorite charge account list is the last resort to generate the charge account information for the item. If the Account Generator workflow engine, which includes Employee Default Charge Account and the Commodity-based Accounting Rules, has already been set up, then the favorite charge accounts functionality does not affect it.

  • The requester can add, delete, or modify accounts in the list. A nickname for an account is mandatory, and it must be unique by list. One of the accounts in the list must be selected as the default.

  • The requester can have one favorite charge account list for each responsibility. If the requester has multiple responsibilities, they can choose a favorite charge account list by responsibility. The accounts maintained in one responsibility are not available in the other responsibilities. If the requester has responsibilities that roll up to multiple sets of books with different accounting structures, then the favorite charge accounts list conforms to the respective accounting structures.

  • The favorite charge account functionality does not affect the system profile for Dynamic Insertion of Charge Accounts. If the profile has been turned on, requesters still can create new charge accounts simultaneously in the preferences as well as during the edit lines step of the checkout.

  • A requester can store only valid charge accounts in the favorite charge account list. If a charge account is deactivated in Oracle General Ledger after the requester has already stored it in the favorite charge accounts list, then an error appears when the requester resubmits the iProcurement Preferences page (by clicking Apply Changes). The requester then has the opportunity to edit or delete the charge account in the favorite charge account list. Until the deactivated account is changed, it displays an error if it is used during checkout.


  1. How do you delete account favorites for people that are no longer Oracle users? We have people that are no longer active users, but their alias are still hanging out there in the system.

  2. Hi,

    I am not seeing any issue with inactive users having defult Gl Account. If you can provide any business justification, i will do more research on this.


Post a Comment

Popular posts from this blog

SQL Query to extract Oracle Purchase Order Information

SELECT   poh.po_header_id,    poh.type_lookup_code PO_TYPE,   poh.authorization_status PO_STATUS,   poh.segment1 PO_NUMBER,   pov.vendor_name SUPPLIER_NAME,   povs.vendor_site_code Location,   hrls.location_code Ship_To,   hrlb.location_code Bill_to,   pol.line_num ,   msib.segment1 Item,   pol.unit_price,   pol.quantity,   pod.amount_billed Amount,   pod.destination_subinventory,   ppf.full_name Buyer_Name,   poh.closed_Code  FROM   PO_HEADERS_ALL poh,   PO_LINES_ALL pol,   mtl_system_items_b msib,   PO_LINE_LOCATIONS_ALL poll,   PO_DISTRIBUTIONS_ALL pod,   po_vendors pov,   po_vendor_sites_All povs,   hr_locations_all hrls,   hr_locations_all hrlb,   per_all_people_f ppf,   po_line_types polt WHERE   1                         =1 AND polt.line_type_id    = pol.line_type_id AND povs.vendor_site_id     = poh.vendor_site_id AND pov.vendor_id           = poh.vendor_id AND pol.item_id             = msib.inventory_item_id AND msib.organization_id  

Query to find Operating Unit, Business Group and Legal Entity Information

SELECT   DISTINCT   hrl . country ,                  hroutl_bg . name              bg ,                  hroutl_bg . organization_id ,                  lep . legal_entity_id ,                  lep . name                    legal_entity ,                  hroutl_ou . name              ou_name ,                  hroutl_ou . organization_id   org_id ,                  hrl . location_id ,                  hrl . location_code ,                  glev . flex_segment_value FROM     apps . xle_entity_profiles   lep ,         apps . xle_registrations   reg ,         apps . hr_locations_all   hrl ,         apps . hz_parties   hzp ,         apps . fnd_territories_vl   ter ,         apps . hr_operating_units   hro ,         apps . hr_all_organization_units_tl   hroutl_bg ,         apps . hr_all_organization_units_tl   hroutl_ou ,         hr_organization_units   gloperatingunitseo ,         apps . gl_legal_entities_bsvs   glev WHERE    lep . transacting_entity_flag   =   'Y'         AND   l

List of iExpenses Tables

List of iExpenses Tables  Table Name Description AP_EXPENSE_REPORT_HEADERS_ALL Expense report header information AP_EXPENSE_REPORT_LINES_ALL Expense report lines information AP_EXP_REPORT_DISTS_ALL Expense report distribution information. It contains the accounts against each expense report line. AP_CREDIT_CARD_TRXNS_ALL Table to store the corporate credit card transactions that are sent by the banks. These lines are saved as expense lines when the user creates the expense lines for credit cards AP_NOTES Table to store the comments entered by approvers and auditors     Setup tables   AP_EXPENSE_REPORTS_ALL This table contains the header level information about the expense templates AP_EXPENSE_REPORT_PARAMS_ALL This table contains the detail level information about the expense templates AP_POL_CAT_OPTIONS_ALL Table to store the policy options AP_POL_CONTEXT Table to store the policy context     AP_POL_LOCATIONS_TL Table