Tuesday, November 12, 2013

Invalid LPN Error

SELECT DISTINCT wlpn.license_plate_number,
wlpn.lpn_id
FROM wms_license_plate_numbers wlpn,
mtl_txn_request_lines mtrl
WHERE wlpn.lpn_context = 3
AND wlpn.lpn_id = mtrl.LPN_ID
AND mtrl.wms_process_flag = 2
AND mtrl.quantity - NVL(mtrl.quantity_delivered,0) > 0
AND mtrl.line_status = 7
AND EXISTS
(SELECT '1'
FROM mtl_txn_request_headers mtrh
WHERE mtrl.header_id = mtrh.header_id
AND mtrh.MOVE_ORDER_TYPE = 6
)
UNION ALL
SELECT DISTINCT wlpn.license_plate_number,
wlpn.lpn_id
FROM wms_license_plate_numbers wlpn,
mtl_txn_request_lines mtrl,
mtl_material_transactions_temp mmtt,
wms_op_operation_instances wooi
WHERE wlpn.lpn_context = 3
AND wlpn.lpn_id = mtrl.LPN_ID
AND mtrl.wms_process_flag = 1
AND mtrl.quantity - NVL(mtrl.quantity_delivered,0) > 0
AND mtrl.line_status = 7
AND mtrl.line_id = mmtt.move_order_line_id
AND mmtt.transaction_temp_id = wooi.source_task_id
AND wooi.operation_type_id = 2
AND wooi.operation_status = 2
AND EXISTS
(SELECT '1'
FROM mtl_txn_request_headers mtrh
WHERE mtrl.header_id = mtrh.header_id
AND mtrh.MOVE_ORDER_TYPE = 6
);

Thursday, May 9, 2013

How to create DBC file yourself


Open the link :-
http://hostname:port /OA_HTML/ jsp/fnd/aoljtest.jsp


For ex :- 
http://frmapp01-v.fin.corp.com:8000/OA_HTML/jsp/fnd/aoljtest.jsp


Screenshot :-

Thursday, May 2, 2013

Inventory Profile Options


Implementing Profile Options Summary

The table below indicates whether you (the User) can view or update the profile option and at which System Administrator levels the profile options can be updated: at the user, responsibility, application, or site levels. The second column, User, references the user, while the next four columns, User, Resp, App, and Site, reference the System Administrator. The last two columns, Required and Default Value, reference requirements.
A Required profile option requires you to provide a value. An Optional profile option already provides a default value, so you only need to change it if you don't want to accept the default.

Profile Option Settings

Profile Option User User Resp App Site Required? Default Value
Bom or Engineering + + + + + Yes BOM
INV: Accounting Category Set - - - - + Yes No default
INV: Advanced Pricing for Intercompany Invoice - - - - + Yes No
INV: Advanced Pricing for Inter-Org Transfers - - - - + No No Default
INV: Allow Expense to Asset Transfer - - + - + No No Default
INV: Batch Size - - - - Yes No Null
INV: Capable to Promise _ _ _ _ + Yes No default
INV: CCEOI Commit Point + + + + + Yes No Default
INV: CCEOI Workers - - - - + Yes No Default
INV: Component Pick Batch Size + + 0 0 + No None
INV: Consigned Inventory Aging Enabled - - - - + No Yes
INV: Cross Reference Type 0 0 0 0 + No Null
INV: Debug File (Including the complete path) + + + + + Yes No Default
INV: Debug level + + + + + Yes No Default
INV: Debug Trace + + + + + Yes No Default
INV: Default Item Status + + + + + Yes Active
INV: Default Primary Unit of Measure + + + + + Yes Each
INV: Detect Truncation on UOM Conversion - - - - + Yes No Default
INV: Dynamic Precision Option for Quantity on Reports + + + + + Yes -9,999,999.00
INV: External ATP _ _ _ _ + Yes No Default
INV: FIFO for Original Receipt Date + + + + + Yes No
INV: Fill & Kill Move Order 0 0 0 0 + No No
INV: Fill Kanban on Partial Move Order Receipt - - - - + No No
INV: Genealogy Delimiter + + + + + Yes -
INV: Genealogy Prefix or Suffix + + + + + No Prefix
INV: GTIN Cross Reference Type - 0 0 0 + No Null
INV: Inter-Organization Currency Conversion + + + + + Yes Corporate
INV: Intercompany Currency Conversion + _ + + + Yes Corporate
INV: Intercompany Invoice for Internal Orders - - - - + Yes No
INV: Item Default Tab + + + + + No Null
INV: Item Form Folder Category Set + + + + + Yes Null
INV: Item Form Uses Master Set of Folders in the Org Items Form + + 0 0 0 No Null
INV: Item Master Default Template + + + + + No Null
INV: Item Master Flexfield + + + + + Yes No Default
INV: Material Status Support - - - - + No No Default
INV: Max # of Txn Purge Processes + + - - + No Null
INV: Maximum Number of Quantity Trees - - - - + Yes 500
INV: MGD Maximum Number of Workers Permitted + + + + + Yes No Default
INV: Minmax Reorder Approval + + + + + Yes Approved
INV: Move Order Transact Form + + + + + Yes Online Processing
INV: Multiple Serials Per Delivery Detail 0 0 0 0 0 Yes None
INV: Override Neg for Backflush + + + + + Yes Yes
INV: Override Reservation for Transactions + + + + + No No Default
INV: Pick Slip Batch Size + + 0 0 + No None
INV: Product Family Item Template - + + + + Yes Product Family
INV: Project Miscellaneous Transaction Expenditure Type + + + + + Yes User Entered
INV: Purchasing by Revision - - - - + No -
INV: Quantity Tree Timeout for Lock - - - - + Yes No Default
INV: Replenishment Move Order Grouping 0 0 0 0 + No Null
INV: RC Line Failure + + + + + Yes Continue Processing
INV: RC Requisition Approval + + + + + Yes Approved
INV: Restrict Receipt of Serials + + + + + No No
INV: RPC Timeout + + + + + Yes 300
INV: Round Reorder Qty + + + + + Yes Yes
INV: Save Search Items + + + + + Yes No
INV: Supplier Consigned Enabled - - - - + No Yes
INV: Target Preferred Grade + + + + + No No Default
INV: Transaction Date Validation + _ + + + Yes Allow Date In Any Open Period
INV: Transaction Reasons Security 0 0 0 0 + No No
INV: Updateable Customer Item + + + + + Yes No
INV: Updateable Item Name + + + + + Yes No
INV: Use Backorder Caching + + + + + No No Default
INV: Use Model & Options for Configuration Pricing - - - - + No Yes
INV: Use catalog name in the item description + - - - + Yes No
INV: Validate Returned Lot - - - - + No No Default
INV: Validate Returned Serial - - - - + No No Default
INV: View Item Category People + + + + + No Null
INV: VMI Enabled - - - - + Yes No
TP: INV Cycle Count Approvals form + + + + + Yes Online Processing
TP: INV Cycle Count Entries form + + + + + Yes Online Processing
TP: INV Enter Replenishment Count form + + + + + Yes Concurrent Processing
TP: INV Inter-Organization Transfer form + + + + + Yes Online Processing
TP: INV Miscellaneous Issue and Receipt form + + + + + Yes Online Processing
TP: INV Transaction Processing Mode + + + + + Yes Immediate Concurrent Processing
TP: INV Transfer Between Subinventories form + + + + + Yes Online Processing
TP: INV Update Average Cost form + + + + + Yes Online Processing
TP: Server Side Online Processing + + + + + Yes Yes
+ You can update the profile option.
- You can view the profile option value, but you cannot change it.
0 You cannot view or change the profile option value.

SQL Query to find concurrent program details along with parameters and valus set attached to those parameters


  SELECT fcpl.user_concurrent_program_name
      , fcp.concurrent_program_name
      , par.column_seq_num      
      , par.end_user_column_name
      , par.form_left_prompt prompt
      , par.enabled_flag
      , par.required_flag
      , par.display_flag
      , par.flex_value_set_id
      , ffvs.flex_value_set_name
      , flv.meaning default_type
      , par.DEFAULT_VALUE
 FROM   fnd_concurrent_programs fcp
      , fnd_concurrent_programs_tl fcpl
      , fnd_descr_flex_col_usage_vl par
      , fnd_flex_value_sets ffvs
      , fnd_lookup_values flv
 WHERE  fcp.concurrent_program_id = fcpl.concurrent_program_id
 AND    fcpl.user_concurrent_program_name = '%Auto%Accounting%'
 AND    fcpl.LANGUAGE = 'US'
 AND    par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
 AND    ffvs.flex_value_set_id = par.flex_value_set_id
 AND    flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
 AND    flv.lookup_code(+) = par.default_type
 AND    flv.LANGUAGE(+) = USERENV ('LANG')
 ORDER BY par.column_seq_num

Wednesday, May 1, 2013

Generate FNDLOAD Command

Dynamically create FNDLOAD command

Dynamically create FNDLOAD command

Select the options from dropdown list.

  ApplLoadOption InstanceFile Name
.ldt

Additional Parameters :