Error in Pack Slip Generation during Ship Confirmation
22 NovTo Query Profile option details for any user or responsibility
2 MaySELECT FPO.PROFILE_OPTION_ID,
FPO.PROFILE_OPTION_NAME,
FPOT.USER_PROFILE_OPTION_NAME,
FPOV.LEVEL_ID,
DECODE(FPOV.LEVEL_ID,
‘10001’,
‘Site’,
‘10002’,
‘Appllication’,
‘10003’,
‘Responsibility’,
‘10004’,
‘User’,
FPOV.LEVEL_ID) LEVEL_TYPE,
FPOV.LEVEL_VALUE,
DECODE(FPOV.LEVEL_ID,
‘10001’,
‘Site’,
‘10002’,
(SELECT APPLICATION_NAME
FROM APPS.FND_APPLICATION_TL
WHERE APPLICATION_ID =FPOV.LEVEL_VALUE),
‘10003’,
(SELECT RESPONSIBILITY_NAME
FROM APPS.FND_RESPONSIBILITY_TL
WHERE RESPONSIBILITY_ID =FPOV.LEVEL_VALUE),
10004,
(SELECT DESCRIPTION
FROM APPS.FND_USER
WHERE USER_ID = FPOV.LEVEL_VALUE),
FPOV.LEVEL_ID) LEVEL_VALUE,
FPOV.PROFILE_OPTION_VALUE,
FPOV.LAST_UPDATE_DATE,
FPO.SQL_VALIDATION,
TRUNC(FPOV.LAST_UPDATE_DATE),
(SELECT DESCRIPTION
FROM APPS.FND_USER
WHERE USER_ID = FPOV.LAST_UPDATED_BY)UPDATED_BY
FROM APPS.FND_PROFILE_OPTIONS FPO,
APPS.FND_PROFILE_OPTION_VALUES FPOV,
APPS.FND_PROFILE_OPTIONS_TL FPOT
WHERE FPOV.PROFILE_OPTION_ID = FPO.PROFILE_OPTION_ID
AND FPOT.PROFILE_OPTION_NAME =FPO.PROFILE_OPTION_NAME
AND FPOV.LEVEL_VALUE =
(SELECT USER_ID FROM FND_USER WHERE USER_NAMEIN (‘305030341’)) –for user
/*AND (FPOV.LEVEL_ID = 10003 AND
FPOV.LEVEL_VALUE IN
(SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_TL
WHERE RESPONSIBILITY_NAME LIKE ‘%%’)) –for responsibility*/
/*AND UPPER(FPOT.USER_PROFILE_OPTION_NAME) LIKE ‘%WMS%TCP%’ — for profile option*/
Tags: oracle, oracle apps, oracle query, oracle sql script, oracle user, profile options, query, Responsibility, setup
- Comments Leave a Comment
- Categories oracle, oracle apps, oracle query, oracle sql script, oracle user, profile options, query, Responsibility, setup
Order Management: Profile Options
7 JanOrder Management: Profile Options
Profile Categories
Profiles have been categorized so that they can be easily classified or grouped. The following table displays the profile categories and the profile options that belong to each one. Some profile options belong to more than one category and are indicated in the table below.
Profile Category Name | Profile Option(s) |
Configurations | OM: Allow model fulfilment without configuration; |
OM: Configuration Quick Save; | |
OM: Copy Model DFF to child lines; | |
OM: Included Item Freeze Method; | |
OM: Party Totals Currency; | |
OM: Use Configurator; | |
Customer Usage | OM: Add Customer; |
OM: Add Customer (Order Import); | |
OM: Create Account Information; | |
OM: E-Mail Required on New Customers; | |
OM: Party Totals Currency; | |
OM: Sales Order Form: Restrict Customers | |
Debug | OM: Debug Log Directory; |
OM: Debug Level; | |
OM: Generate Diagnostics for Error Activities; | |
Deployment | OM: DBI Installation; |
OM: Orders Purge Per Commit; | |
OM: New EDI Acknowledgment Framework; | |
OM: Printed Document Extension Class Name; | |
OM: Use Configurator; | |
Electronic Messaging | OM: Change SO Response Required; |
OM: Electronic Message Integration Event Sources | |
OM: New EDI Acknowledgment Framework; | |
OM: Order Accept State for XML; | |
OM: Run Order Import for XML; | |
OM: Send Acknowledgment for Change PO Response; | |
Forms UI | OM: Add Customer; |
OM: Administer Public Queries; | |
OM: Automatically Open Related Items Window; | |
OM: Contact Center Actions Menu Name; | |
OM: Cust Item Shows Matches; | |
OM: Display Actions Button vs. Poplist; | |
OM: Display Current Selections in Pricing/Availability; | |
OM: Enable Related Items and Manual Substitutions; | |
OM: Item View Method; | |
OM: Quick Sales Order Form: Auto Refresh; | |
OM: Quick Sales Order Form: Defer Pricing; | |
OM: Sales Order Form: Cascade Header Changes to Line; | |
OM: Sales Order Form: Refresh Method (Query Coordination); | |
OM: Sales Order Form: Restrict Customers; | |
OM: Sales Order navigation from Pricing/Availability form; | |
OM: Sales Orders Form preference; | |
OM: Scheduling Role; | |
OM: Show Line Details; | |
OM: Show Process Messages Flag; | |
OM: Use Configurator; | |
OM: View Cancel Lines; | |
OM: View Closed Lines; | |
OM: View Pricing & Availability Information in Related Items; | |
Fulfillment | OM: Allow model fulfillment without configuration; |
OM: Included Item Freeze Method; | |
OM: Over Return Tolerance; | |
OM: Over Shipment Tolerance; | |
OM: Population Of Buyer Code For Dropship Lines; | |
OM: Source Code; | |
OM: Under Return Tolerance; | |
OM: Under Shipment Tolerance; | |
OM: Automatically Interface Lines to IB on Fulfillment | |
Holds | OM: Modify Seeded Holds; |
OM: Prevent Booking for Line Generic Holds; | |
Invoicing | OM: Interface freight tax code from line; |
OM: Invoice Numbering Method; | |
OM: Set Receivables Transaction Date as Current Date for Non-Shippable Lines; | |
OM: View Intercompany AR Invoice | |
Item Usage | OM: Customer Item Shows Matches; |
OM: Enable Related Items and Manual Substitutions; | |
OM: Item Flexfield; | |
OM: Restrict Customer Items for Line Level Ship To Address; | |
Logistics | OM: Sequence for TP Ship/Deliver Deadline; |
OM: Source for TP Early Ship/Deliver Date; | |
Order Import | OM: Add Customer (Order Import); |
OM: Import Multiple Shipments; | |
OM: Unique Order Source, Orig Sys Document Ref Combination For Each Customer; | |
Payments | OM: Commitment Sequencing; |
OM: Credit Card Privileges; | |
OM: Preserve External Credit Balances | |
Portal UI | OM: Customer Service Feedback; |
OM: Customer Service Report Defect; | |
OM: Records On Summary Page For External Users; | |
Pricing | OM: Charges For Backorders; |
OM: Charges for included item; | |
OM: Charging Privilege; | |
OM: Discounting Privileges; | |
OM: Enable Group pricing for DSP lines; | |
OM: Item Change Honors Frozen Price; | |
OM: List Price Override Privilege; | |
OM: Negative Pricing; | |
OM: Promotion Limit Violation Action; | |
OM: Send Changed Lines to Pricing; | |
OM:Unit Price Precision Type; | |
OM: UOM Class for Charge Periodicity; | |
OM: Price Adjustment Modifier for AIA Order Lines | |
Returns | OM: Customer Service Feedback; |
OM: Customer Service Report Defect; | |
OM: Over Return Tolerance; | |
OM: Notification Approver; | |
OM: Return Item Mismatch Action; | |
OM: Return Unfulfilled Referenced Line Action; | |
OM: Under Return Tolerance; | |
Scheduling | OM: Assign New Set For Each Line; |
OM: Authorized To Override ATP; | |
OM: Auto Push Group Date; | |
OM: AutoSchedule; | |
OM: Enforce Shipping Method for Ship Sets; | |
OM: Schedule ATO Item Without BOM; | |
OM: Scheduling Role; | |
Security | OM: Add Customer; |
OM: Add Customer (Order Import); | |
OM: Administer Public Queries; | |
OM: Authorized To Override ATP; | |
OM: Cascade Service; | |
OM: Charging Privilege; | |
OM: Create Account Information; | |
OM: Credit Card Privileges; | |
OM: Discounting Privileges; | |
OM: List Price Override Privilege; | |
OM: Modify Seeded Holds; | |
OM: Scheduling Role; | |
OM: Authorized To Override ATP; | |
Service | OM: Cascade Service; |
Transaction Entry | OM: Apply Automatic Attachments; |
OM: Cascade Service; | |
OM: Configuration Quick Save; | |
OM: Copy Model dff to child lines; | |
OM: Default Blanket Agreement Type; | |
OM: Default Blanket Transaction Phase; | |
OM: Default Sales Transaction Phase; | |
OM: Default Salesrep; | |
OM: Display New Order After Copy | |
OM:Enforce check for duplicate Purchase Orders; | |
OM: Generic Update Constraints Apply to DFF?; | |
OM: Prevent Booking for Line Generic Holds; | |
OM: Return Item Mismatch Action; | |
OM: Return Unfulfilled Referenced Line Action; | |
Upgrade | OM: Context Responsibility for Upgraded Orders; |
OM: Notification Approver; |
Profiles à System
Tags: order management, profile options, setup for order management
- Comments 1 Comment
- Categories order management, profile options, setup for order management
Order Management: Profile Options
7 JanOrder Management: Profile Options
Profile Categories
Profiles have been categorized so that they can be easily classified or grouped. The following table displays the profile categories and the profile options that belong to each one. Some profile options belong to more than one category and are indicated in the table below.
Profile Category Name | Profile Option(s) |
Configurations | OM: Allow model fulfilment without configuration; |
OM: Configuration Quick Save; | |
OM: Copy Model DFF to child lines; | |
OM: Included Item Freeze Method; | |
OM: Party Totals Currency; | |
OM: Use Configurator; | |
Customer Usage | OM: Add Customer; |
OM: Add Customer (Order Import); | |
OM: Create Account Information; | |
OM: E-Mail Required on New Customers; | |
OM: Party Totals Currency; | |
OM: Sales Order Form: Restrict Customers | |
Debug | OM: Debug Log Directory; |
OM: Debug Level; | |
OM: Generate Diagnostics for Error Activities; | |
Deployment | OM: DBI Installation; |
OM: Orders Purge Per Commit; | |
OM: New EDI Acknowledgment Framework; | |
OM: Printed Document Extension Class Name; | |
OM: Use Configurator; | |
Electronic Messaging | OM: Change SO Response Required; |
OM: Electronic Message Integration Event Sources | |
OM: New EDI Acknowledgment Framework; | |
OM: Order Accept State for XML; | |
OM: Run Order Import for XML; | |
OM: Send Acknowledgment for Change PO Response; | |
Forms UI | OM: Add Customer; |
OM: Administer Public Queries; | |
OM: Automatically Open Related Items Window; | |
OM: Contact Center Actions Menu Name; | |
OM: Cust Item Shows Matches; | |
OM: Display Actions Button vs. Poplist; | |
OM: Display Current Selections in Pricing/Availability; | |
OM: Enable Related Items and Manual Substitutions; | |
OM: Item View Method; | |
OM: Quick Sales Order Form: Auto Refresh; | |
OM: Quick Sales Order Form: Defer Pricing; | |
OM: Sales Order Form: Cascade Header Changes to Line; | |
OM: Sales Order Form: Refresh Method (Query Coordination); | |
OM: Sales Order Form: Restrict Customers; | |
OM: Sales Order navigation from Pricing/Availability form; | |
OM: Sales Orders Form preference; | |
OM: Scheduling Role; | |
OM: Show Line Details; | |
OM: Show Process Messages Flag; | |
OM: Use Configurator; | |
OM: View Cancel Lines; | |
OM: View Closed Lines; | |
OM: View Pricing & Availability Information in Related Items; | |
Fulfillment | OM: Allow model fulfillment without configuration; |
OM: Included Item Freeze Method; | |
OM: Over Return Tolerance; | |
OM: Over Shipment Tolerance; | |
OM: Population Of Buyer Code For Dropship Lines; | |
OM: Source Code; | |
OM: Under Return Tolerance; | |
OM: Under Shipment Tolerance; | |
OM: Automatically Interface Lines to IB on Fulfillment | |
Holds | OM: Modify Seeded Holds; |
OM: Prevent Booking for Line Generic Holds; | |
Invoicing | OM: Interface freight tax code from line; |
OM: Invoice Numbering Method; | |
OM: Set Receivables Transaction Date as Current Date for Non-Shippable Lines; | |
OM: View Intercompany AR Invoice | |
Item Usage | OM: Customer Item Shows Matches; |
OM: Enable Related Items and Manual Substitutions; | |
OM: Item Flexfield; | |
OM: Restrict Customer Items for Line Level Ship To Address; | |
Logistics | OM: Sequence for TP Ship/Deliver Deadline; |
OM: Source for TP Early Ship/Deliver Date; | |
Order Import | OM: Add Customer (Order Import); |
OM: Import Multiple Shipments; | |
OM: Unique Order Source, Orig Sys Document Ref Combination For Each Customer; | |
Payments | OM: Commitment Sequencing; |
OM: Credit Card Privileges; | |
OM: Preserve External Credit Balances | |
Portal UI | OM: Customer Service Feedback; |
OM: Customer Service Report Defect; | |
OM: Records On Summary Page For External Users; | |
Pricing | OM: Charges For Backorders; |
OM: Charges for included item; | |
OM: Charging Privilege; | |
OM: Discounting Privileges; | |
OM: Enable Group pricing for DSP lines; | |
OM: Item Change Honors Frozen Price; | |
OM: List Price Override Privilege; | |
OM: Negative Pricing; | |
OM: Promotion Limit Violation Action; | |
OM: Send Changed Lines to Pricing; | |
OM:Unit Price Precision Type; | |
OM: UOM Class for Charge Periodicity; | |
OM: Price Adjustment Modifier for AIA Order Lines | |
Returns | OM: Customer Service Feedback; |
OM: Customer Service Report Defect; | |
OM: Over Return Tolerance; | |
OM: Notification Approver; | |
OM: Return Item Mismatch Action; | |
OM: Return Unfulfilled Referenced Line Action; | |
OM: Under Return Tolerance; | |
Scheduling | OM: Assign New Set For Each Line; |
OM: Authorized To Override ATP; | |
OM: Auto Push Group Date; | |
OM: AutoSchedule; | |
OM: Enforce Shipping Method for Ship Sets; | |
OM: Schedule ATO Item Without BOM; | |
OM: Scheduling Role; | |
Security | OM: Add Customer; |
OM: Add Customer (Order Import); | |
OM: Administer Public Queries; | |
OM: Authorized To Override ATP; | |
OM: Cascade Service; | |
OM: Charging Privilege; | |
OM: Create Account Information; | |
OM: Credit Card Privileges; | |
OM: Discounting Privileges; | |
OM: List Price Override Privilege; | |
OM: Modify Seeded Holds; | |
OM: Scheduling Role; | |
OM: Authorized To Override ATP; | |
Service | OM: Cascade Service; |
Transaction Entry | OM: Apply Automatic Attachments; |
OM: Cascade Service; | |
OM: Configuration Quick Save; | |
OM: Copy Model dff to child lines; | |
OM: Default Blanket Agreement Type; | |
OM: Default Blanket Transaction Phase; | |
OM: Default Sales Transaction Phase; | |
OM: Default Salesrep; | |
OM: Display New Order After Copy | |
OM:Enforce check for duplicate Purchase Orders; | |
OM: Generic Update Constraints Apply to DFF?; | |
OM: Prevent Booking for Line Generic Holds; | |
OM: Return Item Mismatch Action; | |
OM: Return Unfulfilled Referenced Line Action; | |
Upgrade | OM: Context Responsibility for Upgraded Orders; |
OM: Notification Approver; |
Profiles à System
- Comments 1 Comment
- Categories order management, profile options, setup for order management
Categories
- 11i Dataload (2)
- 11i vs R12 (1)
- account receivables (1)
- advance invoice (1)
- API (4)
- application developer (2)
- applying deposit (1)
- apps (48)
- assigning item to organization (2)
- atp (2)
- AutoCreate Purchase Order (2)
- automation sourcing (1)
- business group (1)
- calendar (2)
- Category sets (2)
- Changes in R12 WMS (1)
- components of purchasing (2)
- concurrent program (3)
- concurrent request (3)
- Container Type (2)
- Conversion (4)
- cost group (1)
- cost group assignment (1)
- creating an item (4)
- creating PO from requisition (2)
- customer (2)
- Customer Import (2)
- Customization (3)
- customization of form (1)
- database query (1)
- Dataloader (2)
- Default Quick Sales Order (1)
- Defining Item (2)
- Defining Locators (2)
- Defining Subinventory (2)
- deposit (1)
- Difference in 11i and R12 (1)
- Difference in Oracle Inventory and WMS (2)
- drop ship (5)
- drop ship flow (3)
- drop ship tables (1)
- Enterprise (48)
- ERP (50)
- error generating/validating the sequence number (1)
- flexfields (6)
- forecast (2)
- Form Personalization (3)
- Function (1)
- Functional Interview (3)
- handson (2)
- http://schemas.google.com/blogger/2008/kind#post (6)
- Interfaces in Oracle (4)
- internal order (1)
- Internal requisition to Internal Order IR to IO (1)
- Interview QA (8)
- inv implementation (9)
- inventory (45)
- Inventory Interview (1)
- invoice (1)
- Invoice Import (2)
- IR (1)
- item (12)
- item attributes (8)
- Item Catalogs (2)
- Item Categories (2)
- Item Conversion (2)
- Item Import (2)
- Item Picking Rule (2)
- Item setup (2)
- Item Status (2)
- Item Templates (2)
- Item Types (2)
- Label Printing (2)
- legal entity (3)
- locations (2)
- Locators (2)
- master item (6)
- Mobile Page Personalization (1)
- Modules (2)
- Move Order (1)
- Move Order Types (1)
- MSCA customization (2)
- MSCA Label Printing (2)
- MSCA Page setup (2)
- MSCA Personalization (1)
- multiple fulfillment (4)
- New Features in r12 WMS (1)
- o2c (2)
- OM System Parameters (2)
- Onhand Conversion (2)
- operating unit (3)
- oracle (16)
- oracle application (2)
- oracle apps (37)
- oracle apps 11i (1)
- Oracle apps 11i vs R12 (1)
- Oracle Apps Dataload (2)
- Oracle Apps Interview question (6)
- oracle AR (1)
- Oracle Conversion (2)
- oracle finance (1)
- oracle functional interview (3)
- oracle inventory (3)
- Oracle Inventory Interview (1)
- Oracle Label Printing (2)
- Oracle Modules (2)
- Oracle MSCA (1)
- Oracle MWA Personalization Framework (1)
- oracle om (2)
- Oracle purchasing (2)
- oracle query (2)
- Oracle R12 (11)
- oracle receivables (1)
- Oracle SCM functional Interview (3)
- oracle script (1)
- oracle sql script (1)
- oracle tables (1)
- oracle user (1)
- Oracle WMS (12)
- oracle wms rule simulation (1)
- oracle wms rules (1)
- order fulfillment (2)
- Order Import (2)
- order management (29)
- order management interview (1)
- order management SQL (1)
- order to cash (12)
- Order to Cash Cycle (1)
- order2cash (8)
- organization (7)
- organization item (4)
- Outbound Plan (1)
- pack slip (1)
- pack slip error (1)
- Packing (1)
- parties (2)
- party (2)
- payment terms (2)
- pick (3)
- Pick release rule (1)
- pick rule (1)
- Picking (1)
- planning (1)
- PO using sourcing rule (1)
- procurement (2)
- profile options (4)
- Purchase Order Conversion (2)
- purchasing (5)
- Purchasing Interview (1)
- putaway rule (1)
- query (1)
- query to find drop ship flow (1)
- Quick Codes (2)
- Quick Sales Order (1)
- Quoatation (2)
- R12 data Load (2)
- requisition (4)
- Requisition Import (2)
- Responsibility (2)
- RFQ (2)
- rules (2)
- Sales Representatives (2)
- Salespersons (2)
- SCM (3)
- SCM interview (3)
- screenshot (2)
- Script (1)
- select statement drop ship (1)
- sequence number (1)
- Set of Books (2)
- setup (1)
- Setup Checklist for WMS (2)
- setup for order management (2)
- Setup for WMS (4)
- ship confirm (1)
- Ship confirm rule (1)
- Shipping (3)
- shipping network (2)
- sourcing rule (1)
- SQL (1)
- steps in order to cash (1)
- Structure (2)
- Supply Chain Management (2)
- sysadmin (2)
- tables (1)
- technical interview questions (4)
- transactions (2)
- Types of Label printing (1)
- Uncategorized (37)
- UOM (4)
- Warehouse management System (3)
- WMS (8)
- WMS Consolidation (1)
- WMS Form Function (1)
- WMS Label printing (2)
- wms rule simulation (1)
- wms rules (1)
Archieves
- December 2019
- May 2019
- July 2018
- April 2018
- January 2018
- September 2017
- July 2017
- March 2017
- January 2017
- December 2016
- November 2016
- October 2016
- August 2016
- July 2016
- May 2016
- March 2016
- February 2016
- January 2016
- December 2015
- September 2015
- August 2015
- June 2015
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- May 2014
- April 2014
- March 2014
- December 2013
- October 2013
- September 2013
- July 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- June 2012
- May 2012
- April 2012
- February 2012