You are browsing the archive for Oracle Inventory.

by oracleguru

Movement Statistics Report

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: Movement Statistics Report
SHORT CODE: INVSTMVT
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

 

Tags: No Comments »

by oracleguru

Transaction historical summary (XML)

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: Transaction historical summary (XML)
SHORT CODE: INVTRHAN_XML
MODULE: Oracle Inventory

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

Report Parameters:

  • Organization : Organization
  • Dynamic Precision Option : Dynamic Precision Option
  • WMS Enabled Flag : WMS Enabled Flag
  • PJM Enabled Flag : PJM Enabled Flag
  • WMS or PJM Enabled Flag : WMS or PJM Enabled Flag
  • Selection Option : Selection Option
  • Sort Option : Sort Option
  • CG Selection Dummy : Cost Group Selection Dummy
  • Cost Group Low : Cost Group Low
  • Cost Group High : Cost Group High
  • Include Consigned : Include Consigned
  • Target Date : Rollback Value/Qty to this Date
  • Category Set Name : Category Set Name
  • Category Structure : Category Structure
  • Category Low : Category Low
  • Category High : Category High
  • Item Low : Item Low
  • Item High : Item High
  • Subinventory Low : Subinventory Low
  • Subinventory High : Subinventory High
  • Source Type One : Source Type One
  • Source Type Two : Source Type Two
  • Source Type Three

 

Tags: No Comments »

by oracleguru

Publish Engineering Change Order Updates

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: Publish Engineering Change Order Updates
SHORT CODE: INV_EBI_PUBLISH_ECO
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:

  • Change Order Name : Enter Change Order 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 »