How to Edit Customer Site number in Fusion

How to Edit Customer Site number in Fusion.

Setup and MaintenanceàManage Administrator Profile Values

Search for profile option: HZ_GENERATE_PARTY_SITE_NUMBER

Keep the profile value as: Auto numbering, update Allowed

Search for profile option: HZ_AUTO_SITE_NUMBERING

Keep the profile value as: Auto numbering, update Allowed

Query to find profile Option values using SQL

SELECT po.profile_option_name "NAME", po.user_profile_option_name,
DECODE (TO_CHAR (pov.level_id),
'10001', 'SITE',
'10002', 'APP',
'10003', 'RESP',
'10005', 'SERVER',
'10006', 'ORG',
'10004', 'USER',
'???'
) "LEV",
DECODE (TO_CHAR (pov.level_id),
'10001', '',
'10002', app.application_short_name,
'10003', rsp.responsibility_key,
'10005', svr.node_name,
'10006', org.NAME,
'10004', usr.user_name,
'???'
) "CONTEXT",
pov.profile_option_value "VALUE"
FROM fnd_profile_options_vl po,
fnd_profile_option_values pov,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
WHERE 1 = 1
AND pov.application_id = po.application_id
AND pov.profile_option_id = po.profile_option_id
AND usr.user_id(+) = pov.level_value
AND rsp.application_id(+) = pov.level_value_application_id
AND rsp.responsibility_id(+) = pov.level_value
AND app.application_id(+) = pov.level_value
AND svr.node_id(+) = pov.level_value
AND org.organization_id(+) = pov.level_value
ORDER BY "NAME", pov.level_id, "VALUE";

Importing Standard Cost In Oracle Fusion Using FBDL

• Importing Standard Cost In Oracle Fusion Using FBDL
• navigate to docs.oracle.com and download the FBDI template to load standard costs
• Link : http://docs.oracle.com/cloud/latest/scmcs_gs/OEFSC/Standard_Costs_Import_300758851_fbdi_42.htm
• Add details of the standard cost on the spreadsheet and save.
• Click on Generate CSV button, follow the instructions in the first worksheet.
• Load the zip file using tools-> File Import export from Navigator menu
• Run, Load Interface File program against UCM account: scm/standardCost/import
• Navigate to Costing Accounting Workarea -> Manage Cost Scenario Exceptions page
• Verify the data is loaded and is in "new" status.
• Click button "Import Standard Cost", this will move the data from Interface tables to base costing tables.
• Once the program completes successfully, the records will disappear from Manage Cost Scenario Exceptions page, which means that the records were imported successfully.
• Go to Manage Cost scenarios and search for your scenarios and from action menu choose Update standard Cost. Update Cost Job gets submitted, Once it completes successfully, Cost scenario status will change form 'In progress' to 'Published' and Standard Cost will be effective from the scenario effective date. The effective start date should not overlap between two scenarios defined for same Item/cost org valuation unit combination.

How to display multiple rows in one records in sql

Syntax :
select
   Col1,
        listagg(COL2, ',') within group (order by COL2) as COL2
From TABLE
Group By
   Col1


Example
Create Table Test_Transpose(Ids Number , Val Number);
Insert Into Test_Transpose Values (1, 11);
Insert Into Test_Transpose Values (1, 12);
Insert Into Test_Transpose Values (1, 13);
Insert Into Test_Transpose Values (1, 14);
Insert Into Test_Transpose Values (1, 15);
Insert Into Test_Transpose Values (2, 21);
Insert Into Test_Transpose Values (2, 22);
Insert Into Test_Transpose Values (2, 23);
Insert Into Test_Transpose Values (2, 24);
Insert Into Test_Transpose Values (2, 25);
Commit;
/

Select * From  Test_Transpose;
Output

IDS	VAL
1	11
1	12
1	13
1	14
1	15
2	21
2	22
2	23
2	24
2	25

Select
   IDS,
        listagg(VAL, ',') within group (order by VAL) as VAL
From Test_Transpose
Group By
   Ids
Output :

IDS	VAL
1	11,12,13,14,15
2	21,22,23,24,25

TO_DATE Format

TO_DATE Format Masks
Format	Returns
D	Day of the week
DD	Day of the month
DDD	Numerical day of the year, 1 ~ 365 (366 for Leap years)
DAY	Full textual representation of the day, i.e. "Monday", "Tuesday", "Wednesday"
DY	Day in three letters, i.e. "MON", "TUE", "FRI"
W	Week of the month
WW	Week of the year
MM	Month in two digits, i.e. 01 = Jan, 02 = Feb,...12 = -Dec
MON	Month in three characters, i.e. "Jan", "Feb", "Apr"
MONTH	Full textual representation of the Month, i.e. "January", "February", "April"
RM	Month in Roman Characters (I-XII, I-Jan, II-Feb, ... XII-Dec)
Q	Quarter of the Month
YY	Last two digits of the year.
YYYY	Full year
YEAR	Year in words like "Nineteen Eighty Seven"
HH	Hours in 12 hour format
HH12	Hours in 12 hour format
HH24	Hours in 24 hour format ("military time")
MI	Minutes
SS	Seconds
FF	Fractional Seconds
SSSSS	Milliseconds
J	Julian Day i.e Days since 1st-Jan-4712BC to till-date
RR	If the year is less than 50 then Oracle considers the year as a 21st century date. If the year is greater than 50 then Oracle considers the year to be in the 20th century.