You are browsing the archive for Logistics & Warehouse.

by oracleguru

Movement Statistics Report (XML)

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse

 

NAME: Movement Statistics Report (XML)
SHORT CODE: INVSTMVT_XML
MODULE: Oracle Inventory

Description: Movement Statistics Report (INTRASTAT Report)
Navigation: Oracle Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_LEGAL_ENTITY_ID : Legal Entity id
  • P_ZONE_CODE : Economic Zone Code
  • P_USAGE_TYPE : Usage Type (Internal or External)
  • P_STAT_TYPE : Statistic Type (Intrastat or Extrastat)
  • P_MOVEMENT_TYPE : Movement type
  • P_PERIOD_NAME : Period name
  • P_REPORT_OPTION : Report type
  • P_DUMMY : Control enable/disable – hidden
  • P_AMOUNT_DISPLAY : Amount display format – normal currency precision or whole number
  • P_CURRENCY_CODE : Currency code
  • P_INVERSE_RATE : Inverse rate – hidden field
  • P_RATE_TYPE : Rate type – hidden field
  • P_EXCHANGE_RATE : Exchange rate for movement statistics
  • DebugFlag : Debug Flag

 

Tags: No Comments »

by oracleguru

Lot transaction register (XML)

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse

 

NAME: Lot transaction register (XML)
SHORT CODE: INVTRLNT_XML
MODULE: Oracle Inventory

Description: Lot transaction register
Navigation: Oracle Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Sort By : Sort By
  • Unit of Measure : Unit of Measure
  • Organization : Organization
  • Precision : Precision
  • GL Structure : GL Structure
  • Date From : Date From
  • Date To : Date To
  • Audit Detail : Audit Detail
  • Reason Detail : Reason Detail
  • Location Detail : Location Detail
  • Category Detail : Category Detail
  • Serial Number Detail : Serial Number Detail
  • Lot Number From : Lot Number From
  • Lot Number To : Lot Number To
  • Item Low : Item Low
  • Item High : Item High
  • Transaction Type Low : Transaction Type Low
  • Transaction Type High : Transaction Type High
  • Transaction Reason Low : Transaction Reason Low
  • Transaction Reason High : Transaction Reason High
  • Subinventory Low : Subinventory Low
  • Subinventory High : Subinventory High
  • Category Set : Category Set
  • Category Structure : Category Structure
  • Cate

 

Tags: No Comments »

by oracleguru

Publish Item Attributes Updates

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse

 

NAME: Publish Item Attributes Updates
SHORT CODE: INV_EBI_PUBLISH_ITEM_ATTR
MODULE: Oracle Inventory

Description:
Navigation: Oracle Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Item Name : Enter Item Names separated by double semi-colons(;;)
  • Organization Code : Enter Organization Codes separated by double semi-colons(;;)
  • From Date : From Date
  • To Date : To Date
  • Updated in the last X Hrs : Updated in the last X Hrs

 

Tags: No Comments »