Wednesday, July 15, 2015

Inventory Convergence make any attempt to copy Descriptive Flexfield (DFF)

Does the OPM Migration process for Inventory Convergence make any attempt to copy Descriptive Flexfield (DFF) setup information for an OPM table from the Release 11i database to the corresponding Discrete Inventory table in the Release 12 environment?

We are specifically thinking of a DFF which we have on the OPM Lot Master table (IC_LOTS_MST). In this example would DFF setup and data be copied to MTL_LOT_NUMBERS in the Release 12 environment?


Provided that there is no data conflict (that is to say, another Descriptive Flexfield already using the relevant 'Attribute' columns in the target table) then the migration process will copy DFF data from the OPM table to the corresponding Discrete Manufacturing (ODM) table.

If there is a data conflict (for example, column ATTRIBUTE1 already used by an existing DFF), then this should be highlighted by the pre-migration report and will need intervention.

Please note, however, that the migration makes no attempt to set up the FND Descriptive Flexfield definition for you in Release 12.  You will need to do this setup (the DFF column names, Value Sets and so on) after the migration is complete.

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. or 8888
User The Oracle HTTP Server administration user.
Group The group for the user.
ServerAdmin The administrator's email address.
ServerName The name of the server for Oracle HTTP Server. If the host does not have a registered DNS name, use the IP address.
WebLogicHost The name of the host on which Oracle WebLogic Server is listening for requests.
WebLogicPort The port number that Oracle WebLogic Server uses to listen for requests.
WebLogicCluster The name of the host on which an Oracle WebLogic Server cluster is running and its port number.
VirtualHost The name of the virtual host. The port number listed should also be listed in the Listen directive.
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.
PlsqlDatabaseConnectString Specific to the PLSQL module, the service name of the database.
PlsqlNLSLanguage Specific to the PLSQL module, the NLS_LANG variable for the database access descriptor (DAD).
ORAConnectSN Specific to the oradav module, the Oracle database to which to connect.
ORAUser Specific to the oradav module, the database user (schema) to use when connecting to the service specified by the ORAConnectSN property.
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.
SSLWallet The location of the SSL wallet, if the wallet is not in the default location.
DocumentRoot The directory that stores the main content for the Web site.
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.
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.
WebGateInstalldir The location of the WebGate installation directory, as specified in the webgate.conf file.

Monday, April 20, 2015

Unable to create new native thread

Unable to create new native thread

Perform all the Steps

Connect as su: UNIX> su - theuser
where "theuser" is the name of Unix user running the processes.
Check the current soft and hard max user processes: UNIX> ulimit -Su
UNIX> ulimit -Hu

If you see 1024 as a value of ulimit -Hu, please ensure you have already rebooted a server after setting * hard nproc 16384 in limits.conf.

If you see 16384 as a value of ulimit -Hu but ulimit -Su is still 1024, please go the next step.
Increase the max user processes soft limitof the current "theuser" session to 16384: UNIX> ulimit -Su 16384  

Re-check the current max user processes: UNIX> ulimit -Su

You should see 16384, then stop and restart both Admin Server an odi_server1 from the current session, re-test the issue and observe the outcome.

Uncategorized exception during repository access

ODI-10182: Uncategorized exception during repository access.

The error can occur when connecting to a 12c PDB (pluggable database) using the Oracle SID in the URL, for example:

Connections to pluggable databases require an Oracle Service Name in the URL, such as:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=<port>)) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<Pluggable Database Service Name>)))

Alternatively an OCI based connection can be used:


Tuesday, April 14, 2015

JDE Technical Interview Questions

1.How many numbers detail sections possible in a report template?
A)Multiple. But the physical page size of report template should not exceed 45 inches in length and width. Report template that exceeds this limit might faces problems at runtime…

2.How many detail sections can be added in a report template using report director?
A)Using the Director, only one detail section can be inserted in the report template. Later RDA can be used to enhance the report template and add extra detail sections

3.How many numbers (max) of Page Header/Page Footer sections possible in a report template?
A) Only one

4.How many numbers (max) of Report Header/Report Footer sections possible in a report template?
A)Only one

5.Can a business view be attached to a Page header section?
A)No. Business views can be attached to details sections only

6.what is the default font used to generate PDF reports in E1?

7.Is it possible to print the attachments that are inserted in the report?
A)No. They are just useful to explain the functionality of the report, any special logic used, documenting the changes etc.,

8.The properties and format of report headers and footers and of page headers and footers are similar to which detail section?
A)Group section

9.Report Templates Vs Batch Versions
A)Report templates are master specifications of the report. It defines the data used, how the data is
Selected , sorted, displayed, and formatted etc.
Batch versions read the master specifications from the associated report template and over ride one or more specification of the report template like:
• Section layout
• Section data selection
• Section event rules
• Section database output
• Section sort sequence
This concept allows creating requirement specific reports (versions) without touching the Master (i.e Report Template). Basically you create one report template and create multiple version by overriding the specifications.
Report Power points:
·      Report template is a Master specification
·      Batch version is a child i.e business need based customization of the Master

JDE Interview Questions

  1. What is an Object in JDE? Define Some…
    Traditionally a OneWorld Object was defined as any object created in Object Librarian.
    Ex: Applications, Business Functions,Business Views, UBEs, Data Structures, Tables, Media Objects
  2. How do JDE Stores Objects?
    Central Objects
    Provides a central location for managing all OneWorld objects. Only used for Development &  Software deployment.
    Never used at runtime.
  3. What are Replicated Objects?
    Replicated Objects are stored in a directory on every workstation and logic server that will run OneWorld
    Built from Central Objects, Deployed via packages (‘point-in-time’ snapshot of selected objects)
    Stored in runtime (TAM vs. RDB) format
  4. What are Control Objects?
    Control objects are like buttons on the Form as Control obj. Fields on the Form are also control objects.
    We set control errors on the form design so that it stops the processing of error is set on the control.
  5. What are tokens?
    A Token has a One-to-One relationship with the following objects:
    Applications, Business Functions, Business Views, UBEs, Data Structures, Tables, Media Objects and Batch Versions
    The Token is used to minimize the possibility of one user overriding another user’s changes to an object.
    When an  object is checked out and is not already checked out by another user The project receives a Token.
    A Token can be released, switched or inherited.
    The Token is released by the project when the project reaches the status designated by the administrator for release.
    A Token is not released by the project when the object is checked back in.
  6. What is OMW?
    As a OneWorld developer I sometimes long for the simple days before XE.  I could check out objects from any environment and check them back into any environment. I could more easily view if an object was checked out and to who and which environment.  I could easily see what objects I personally still had checked out locally. I could also transfer objects from one environment to another with a few mouse clicks. 
    The OMW was designed to replace the old tools we were used to using such as the Object Librarian, Promotion Manager, and Object Transfer.  I believe that the OMW is a great tool when it comes to developing for new projects.  I like the fact that I can group up all of the objects I am working on into a project so I never forget the objects I created or modified for the new module I am creating.  In the old days you would have to keep track of objects in a separate file to give to the CNC guy once it was ready to deploy. Using the old method, how many times do you remember leaving off 1 or 2 objects because you forgot to write them down?
    • Promotion Manager
    • Object Transfer
    • Object Librarian
    • Object Librarian Check-in Log
    • To Hide Object Management Tasks
    • To Provide Better Control of OneWorld Objects
    • To Unify all Development into One Interface
    • To Automate Change Management Process
    • To Provide Detail Logging of Objects
  7. What is Check In & Check Out?
    Check In – We send the updated specs to the server. It will replace the specs on the server with the specs which we are doing check in. User will not lose the Token.
    Check Out – It will override the local specs of the object which we are trying to check out. We will get the latest specs from the server. User will get the token
  8. What is the difference between GET & Check Out?
    Checking out an object allows you to modify the object and check it back in to Central Objects.  Performing a Get copies the latest specifications to your workstation but does not allow you to check in.  This is similar to erasing a check out for those familiar with previous releases of OneWorld.
  9. What are the Object Librarian and Non-Object Librarian Objects?
    Only Object Librarian objects have tokens and Non Object Librarian Objects do not have token.
    non-Object Librarian objects  are based on data source rather than path code.
    One World objects include the following non-Object Librarian objects: 
    • Data dictionary items
    • User defined code items
    • Workflow items
    • Menus
  10. What are the required fields when adding an Object?
    Object Name, Description, Product Code, System Code, Object Use