Skip to main content

List of iProcurement Profiles


Configuration Category

The table below lists the profile options that impact iProcurement Configuration. 

Configuration Profile Options

Profile Option
Default
User Access
Discoverer DBC filename override
2500
Update
HR: Cross Business Groups
Yes
 
ICX: Date format mask
 
Update
ICX: Date language
 
 
ICX: Default Discoverer Workbook Owner
 
Update
ICX: Default Employee
 
Update
ICX: Default Flow Operand
 
Update
MRP: Default Sourcing Assignment Set
 
 
POR: Bulk Loader Commit Size
2500
 
POR: Cache Time To Live Minutes
15
 
POR: Context value for Requisition distribution descriptive flexfield
 
 
POR: Context value for Requisition header descriptive flexfield
 
 
POR: Context value for Requisition line descriptive flexfield
 
 
POR: Enable Req Distribution Customization
 
 
POR: Enable Req Header Customization
 
 
POR: Enable Requisition Line Customization
Yes
 
POR: Purchasing News Location
 
 
POR: Purge Jobs Older Than (days)
30
 
POR: Transparent Punchout Timeout Limit
60
Update

Receiving Category

 Receiving Profile Options


Profile Option
Default
User Access
POR: Enable Automatic Debit Memo Creation for Returns
No
Update
POR: Require Blind Receiving
No
 
POR: Select Internal Requisition for Confirm Receipt
Yes
 
POR: Select Inventory Replenishment Lines For Confirm Receipts
 
 
POR: Support review for Express Receive
Yes
 

Deployment Category

The table below lists the profile options that impact iProcurement deployment.

 Deployment Profile Options
Profile Option
Default
User Access
Application Framework Agent
WE8MSWIN1252
Update
Apps Servlet Agent
 
Update
ECX: Log File Path
 
 
Help Localization Code
No
Update
ICX: Client IANA Encoding
Western European (ISO-8859-1)
 
ICX: Discoverer OLTP End User Layer Schema Prefix
 
Update
ICX: Discoverer Parameters
 
Update
ICX: Discoverer Release
 
Update
ICX: Discoverer use Viewer
 
Update
ICX: Discoverer Viewer Launcher
 
Update
ICX: Forms Launcher
 
Update
ICX: HTML directory
Default
 
ICX: Language
 
Update
ICX: Limit connect
1000
Update
ICX: Limit time
4
Update
ICX: Match case LOV
 
Update
ICX: Match case View
 
Update
ICX: Media directory
Default
 
ICX: NLS Sort
 
Update
ICX: Numeric characters
 
Update
PO: Enable Services Procurement
No
 
PO: Validate Need-by Time For Requisition Submit
Yes
 
POR : Amount Based Services Line Type
 
 
POR : CA Certificate File Name
 
 
POR: Contractor Expense Line Type
 
Update
POR: Default Currency Conversion Rate Type
 
Update
POR : Goods Line Type
 
 
POR: Hosted Images Directory
 
 
POR : Proxy Server Name
 
 
POR : Proxy Server Port
 
 
POR : Rate Based Services Line Type
 
 
POR : Use Sequence for Requisition Numbering
No
 

Requisition Accounting Category

The table below lists the profile options that impact iProcurement Requisition Accounting.

 Requisition Accounting Profile Options
Profile Option
Default
User Access
PA: Allow Override of PA Distribution in AP/PO
 
 
POR: Allow pcard use with encumbrance
 
Update
POR: Apply Expense Account Rules to Favorite Charge Accounts
No
Update
POR: Enable Check Funds
No
Update
POR: Generate and Display Account at Checkout
No
Update
POR : Override Supplier P-Card
No
 
POR : Preferences - Award
 
Update
POR: Preferences - Expenditure Item Date Offset
 
Update
POR: Preferences - Expenditure Org
 
Update
POR : Preferences - Expenditure Type
 
Update
POR : Preferences - Project
 
Update
POR : Preferences - Selected Items Default to Inventory
 
Update
POR : Preferences - SubInventory
 
Update
POR : Preferences - Task
 
Update

Requisition Approval Category

The table below lists the profile options that impact iProcurement Requisition Approval.

 Requisition Approval Profile Options


Profile Option
Default
User Access
PO: Allow Requisition Approval Forward Action
 
 
PO: Notification Lines Display Limit
20
 
PO:Workflow Processing Mode
 
Update
POR: Display Graphical Approval List
Yes
Update
POR: Reapproval after Contractor Assignment
Always
 
POR : System Approvers are Mandatory
Yes
 

Requisition Checkout Category

The table below lists the profile options that impact iProcurement Requisition Checkout.

Profile Option
Default
User Access
POR: Days Needed By
2
Update
PO: Default Need-By Time
 
 
POR : Preferences - Deliver to Location
 
Update
POR : Preferences - Requester
 
Update
POR: One Time Location
 
Update
POR: Override Location Flag
Yes
 
POR: Override Requestor
No
 
TAX: Allow Override of Tax Recovery Rate
 
 

Search Category

The table below lists the profile options that impact iProcurement Search.

 Search Profile Options
Profile Option
Default
User Access
PO: Legal Requisition Type
 
 
POR:Allow Manual Selection of Source
No
Update
POR: Change Catalog Language
No
Update


Services Procurement Category

The table below lists the profile options that impact iProcurement Services Procurement.

 Services Procurement Profile Options


Profile Option
Default
User Access
PO: Enable Services Procurement
  No
 
POR: Contractor Expense Line Type
Update
POR: Reapproval after Contractor Assignment
Always

User Interface Category

The table below lists the profile options that impact the iProcurement User Interface.
 
User Interface Profile Options
Profile Option
Default
User Access
ICX: Date format mask
 
Update
ICX: Language
 
Update
ICX: Numeric characters
 
Update
POR: Catalog Result Set Size
7
Update
POR: Default Shopping Sort
 
Update
POR: Default Shopping Sort Order
Ascending
Update
POR: Display Graphical Approval List
Yes
Update
POR: Display Legacy Accounting Flex UI
No
Update
POR: Display Shopping Category Count
Yes
 
POR: Enable Advanced Search
 
Update
POR: My Favorite Store
-1
Update
POR: Result Set Size
10
Update
POR: Search Results Skin
Paragraph
Update
POR: Show Thumbnail Images
Yes
Update
POR: Thumbnail Height
 
Update
POR: Thumbnail Width
 
Update

Internal Requisitions  Category

Internal Requisition Profile Options

Profile Option
Default
User Access
PO: Legal Requisition Type
 
 
POR:Allow Manual Selection of Source
No
Update
POR: Select Internal Requisition for Confirm Receipt
Yes
 
POR: Sync up Need by date on IR with OM
No
 
POR: Urgent flag maps to shipping Priority
No
 

Comments

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  
Post a Comment
Read more

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
Post a Comment
Read more

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
Post a Comment
Read more