Translate

Tuesday, May 5, 2015

Oracle VCP- ASCP Staging Tables


select * FROM msc_st_calendars WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_workday_patterns WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_shift_times WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_calendar_exceptions WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_shift_exceptions WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_demand_classes WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_trading_partners WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_trading_partner_sites WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_location_associations WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_planners WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_units_of_measure WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_uom_conversions WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_uom_class_conversions WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_system_items WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_category_sets WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_item_categories WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_resource_groups WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_department_resources WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_resource_shifts WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_routings WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_routing_operations WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_operation_resources WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_boms WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_bom_components WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_supplies WHERE sr_instance_code = '&enter_sr_instance_code' AND order_type = 18;

select * FROM msc_st_safety_stocks WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_item_suppliers WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM MSC_ST_ITEM_SOURCING WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_interorg_ship_methods WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM MSC_ST_SR_LOOKUPS WHERE sr_instance_code = '&enter_sr_instance_code';

Move Plan Properties for Oracle HTTP Server

 Move Plan Properties for Oracle HTTP Server

Property Description Sample Value
Listen The Listen address. It can include the host name and port or just the port.
orcl3.example.com:8888 or 8888
User The Oracle HTTP Server administration user.
admin_user
Group The group for the user.
admin_group1
ServerAdmin The administrator's email address.
Webmaster@example.com
ServerName The name of the server for Oracle HTTP Server. If the host does not have a registered DNS name, use the IP address.
orcl1.example.com
WebLogicHost The name of the host on which Oracle WebLogic Server is listening for requests.
orcl2.example.com
WebLogicPort The port number that Oracle WebLogic Server uses to listen for requests.
9002
WebLogicCluster The name of the host on which an Oracle WebLogic Server cluster is running and its port number.
orcl3.example.com:9003
VirtualHost The name of the virtual host. The port number listed should also be listed in the Listen directive.
*.8888
PlsqlDatabasePassword Specific to the PLSQL module, the name of a secure file containing the password. You must provide a password file, even if you are not changing the configuration.
/scratch/orcl/plsql_passwd
PlsqlDatabaseConnectString Specific to the PLSQL module, the service name of the database.
orcl.example.com:1521:orcl1
PlsqlNLSLanguage Specific to the PLSQL module, the NLS_LANG variable for the database access descriptor (DAD).
America_America.UTF8
ORAConnectSN Specific to the oradav module, the Oracle database to which to connect.
db_host:db_port:db_service_name
ORAUser Specific to the oradav module, the database user (schema) to use when connecting to the service specified by the ORAConnectSN property.
db6175_PORTAL
ORACRYPTPASSWORD Specific to the oradav module, the absolute path to the secure file containing the password for oradav. You must provide a password file, even if you are not changing the configuration.
/scratch/oracle/dav_passwd
SSLWallet The location of the SSL wallet, if the wallet is not in the default location.
/scratch/oracle/mw_home/ORACLE_INSTANCE/config/OHS/ohs1/keystores/mywallets
DocumentRoot The directory that stores the main content for the Web site.
/scratch/oracle/mw_home/ORACLE_INSTANCE/config/ohs/ohs1/htdocs
Alias The location of the alias, if it is not in the default location. Note that you change the value within the double quotation marks.
/icons/"/scratch/orcl/icons/"
ScriptAlias The location of the script alias, if it is not in the default location. Note that you change the value within the double quotation marks.
/cgi-bin/"/scratch/oraclcgi-bin/"
WebGateInstalldir The location of the WebGate installation directory, as specified in the webgate.conf file.
/scratch/oracle/mw_home/Oracle_OAMWebGate1/webgate/ohs