Thursday, April 18, 2019

SQL to extract Bill-to Customer Site Number And Ship-to Customer Site Number


a) Bill-To site number:
SELECT fss.SET_CODE,
  fss.SET_NAME, hcsu.location -- Site number shown in AR transaction page
FROM hz_cust_accounts hca,
hz_cust_acct_sites_all hcsa,
hz_cust_site_uses_all hcsu,
FND_SETID_SETS fss
WHERE hca.cust_account_id = hcsa.cust_account_id
AND hcsa.cust_acct_site_id = hcsu.cust_acct_site_id
AND HCSU.SITE_USE_CODE = 'BILL_TO'
and hcsa.set_id = fss.set_id
and hca.account_number = '<Customer Account Number>'
--and hcsu.location='<Site Number>';

b) Ship-To site number:
SELECT fss.SET_CODE,
  fss.SET_NAME, hps.party_site_number -- Ship-To Site number shown in AR transaction page
FROM hz_cust_accounts hca,
hz_cust_acct_sites_all hcsa,
hz_cust_site_uses_all hcsu,
hz_party_sites hps,
FND_SETID_SETS fss
WHERE hca.cust_account_id = hcsa.cust_account_id
AND hcsa.cust_acct_site_id = hcsu.cust_acct_site_id
and hcsa.party_site_id = hps.party_site_id
AND HCSU.SITE_USE_CODE = 'SHIP_TO'
and hcsa.set_id = fss.set_id
and hca.account_number = '<Customer Account Number>'
--and hps.party_site_number='<Site Number>';

Friday, July 15, 2016

MSCTRIGS: Collections Triggers Error


+---------------------------------------------------------------------------+
Advanced Supply Chain Planning: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

MSCTRIGS: Collections Triggers
+---------------------------------------------------------------------------+

Current system time is 16-JUL-2016 10:15:06

+---------------------------------------------------------------------------+

**Starts**16-JUL-2016 10:15:06
**Ends**16-JUL-2016 10:26:36
Error in creating Source Triggers
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
16-JUL 10:15:06 : Request : 7452875 :Creates Item Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452876 :Creates BOM Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452877 :Creates Routing Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452878 :Creates WIP Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452879 :Creates Demand Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452880 :Creates Supply Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452881 :Creates Other Triggers used by Collections Process
16-JUL 10:15:06 : Request : 7452882 :Creates Repair Order Triggers used by Collections Process
16-JUL 10:15:06 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
16-JUL 10:15:06 : select NVL(FND_PROFILE.VALUE('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) from dual
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size:
0


Output is not being printed because:
The print option has been disabled for this report.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 16-JUL-2016 10:26:36

+---------------------------------------------------------------------------+

Solution:

To implement the solution, please execute the following steps:

1. Go into the responsibility: system administrator

2. Navigate to concurrent - manager - define

3. query for standard manager, click on workshifts and increase processes to 15

4. Retest the issue.

Thursday, July 14, 2016

Demantra tables

a) Staging Tables

select * from t_src_item_tmpl;

select * from t_src_sales_tmpl;

select  * from t_src_loc_tmpl;


b) Patch

select * from version_details_history;


c) Base tables

select * from sales_data;--sales order historical data

select * from mdp_matrix;--combination data

select * from inputs;--time buckets

select * from queries;--worksheets

select * from items;--items

select * from location;--locations


d) Workflow

select * from wf_schemas;

select * from wf_process_log;


e) Integration interface

select * from transfer_query;

Demantra 12.2.5 Installation on windows



Pre-requisites:

   1) JDK 1.7 or 1.8
   2) Oracle client  11g higher or 12c installed on your server
   3) Make sure have 'SYS' credentials for installation.

Note: Demantra 12.2.5 best compatible with Windows 7. 

Installation:
  1) Install Demantra version 12.2.5.1 -  Patch 21951481 
  2)  Install mandatory patches
        a) 23088083
        b) 22254051
        c) 23016941
       

Note  : Follow note Installing Demantra 12.2.5.1 Screen Shot - Step by Step (Doc ID 2069281.1)

Demantra JVM installation issue


In the process of installing demantra 12.2.5,ran setup.exe as administrator but the system shows error.



or Error: Could not create the Java virtual machine



Solution:

To fix  this, set up _JAVA_OPTIONS from : Windows > go to Start > Control Panel > System > Advanced >  Click Environment Variables > in the System Variables section,click New > enter "_JAVA_OPTIONS" as the Variable Name, and set its  value to -Xmx512M > OK

  or

Run the install.exe file from D:\p21951481_122510_WINNT\Disk1\InstData\VM.

Installation will be done.Make sure u have setup the java_home in environment variable with value as the patch of JDK installed or else the server will not be up and application does not work.

or Run the setup.exe from command prompt.

Wednesday, July 13, 2016

Demantra Installation issue

Demantra Installation Importing Issue IMP-00058: ORACLE error 1950 encountered, ORA-01950: no privileges on tablespace( Doc ID 2094007.1)


Demantra installation issue
Install Demantra 12.2.5.1 (patch 21951481) we are getting error:
IMP-00058: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'DEV'
That implies, do not have access to Apps table space even though another demantra tablespace in the installation screen for standalone databases is working normal and was able to finish the installation.


Solution:

From internal Bug 12624910

The problem is new feature introduced in 11.2 database version.
The workaround is to run the following:

ALTER SYSTEM SET DEFERRED_SEGMENT_CREATION=FALSE;

This causes the import to work properly.

Please review this Note, which has more information on DEFERRED_SEGMENT_CREATION parameter:
11.2 Database New Feature Deferred Segment Creation [Video] (Doc ID 887962.1)

Same issue occurred for 12c database also and this above solution has resolved. Can be applied for 12c Database as well.

Thursday, June 2, 2016

Steps For The Collaboration Team Enter The Scores On Negotiation


A. How to define a scoring team:

Scoring teams are groups of personnel who collectively evaluate a particular aspect of a negotiation 

based on their area of knowledge or expertise. Once the scoring teams have evaluated a negotiation 

line's responses, they provide a score value. 

This score is combined with scores from any other scoring teams and used along with the  price to 

determine the winner of that negotiation line.

All scoring team members must be defined to the Collaboration Team for that negotiation.


1. On the Create: negotiation page, define the member to the Collaboration Team.
Give them either Full or Score access.

2. In the Requirements area of the page, click Select Scoring Settings.

3. Click Enable Team Scoring, if it is not already selected.

4. Click Add Another Row.

5. Give the team a name. You can optionally enter instructions to the team members.

6. If you deselect the Price Visibility checkbox, members of the team will not be able to   view the 

pricing information offered by the supplier on the line. (The Price  Visibility option can be changed 

any time before the award is completed.)

7. Click the pencil icon to add members to the team.

8. On the Scoring Team page, click Add Another Row.

9. Open the Name menu. The menu lists all members of the Collaboration Team who  have either 

Full or Score access.

10. Select the member to add to the team.

11. Continue adding members to your scoring team until all appropriate members have   been added. 

Note that the same member can appear on more than one team.

12. Click Apply.


 B. How to assign a scoring team to a Requirements.

1. When you are returned to the Select Scoring Settings page, the Section column in  the Section 

Assignment area lists all Requirement sections defined for the  negotiation. Click the Team 

Assignment menu.

2. Select the appropriate scoring team and associate it with its Requirements section.

3. Click Apply.



C. How to score responses to a negotiation's Requirements.

If team scoring has been enabled for a negotiation, you must be a member of a scoring team to enter 

scores.  If team scoring is not enabled, you must be a negotiation editor (either the negotiation 

creator or a Collaboration Team member with Full access) to enter scores. 

If the scoring method for the Requirement is None or Automatic you do not enter scores (for 

Automatic scoring, the system assigns a score to the response based on the acceptable values defined

 by the negotiation creator).

NOTE: The negotiation must be closed before entering scores.



D. How to enter scores:

1. From the negotiation home page, access the negotiation for which you wish to enter scores.

2. Select Enter Scores from the Actions menu.

3. On the Enter Scores by Bid page, click the pencil icon in the Enter Scores column  for the response
 whose Requirements you wish to score.

4. On the Enter Scores page, view the Requirement and its response and enter a value  in the Score 
column. Note that you can not enter a value higher than the maximum  score the negotiation creator 
defined for that Requirement. 

     You may optionally enter an internal note.

5. Click Submit Score.

6. Continue scoring subsequent responses.


 E. How are the response's score calculated?

There are two ways Requirement can be assigned a score.

• Manually - a member (or members) of a scoring team enters a score value for all the  Requirements
 that are included in the Requirement section the negotiation creator  assign to their scoring team.

• Automatically - the system assigns a score based on the acceptable values defined  by the negotiation
 creator.

When multiple members of a scoring team score a response, the system uses the individual team member
s' values to calculate the average score for that Requirement. The system then uses the weight for the 
Requirement  to calculate the weighted score for that Requirement.

Participants can respond to Requirements defined with a scoring method of None. But evaluators are not 
able to enter scores for those responses.