51
Points
Questions
0
Answers
8
-
- 1171 views
- 1 answers
- 0 votes
-
- 1350 views
- 1 answers
- 0 votes
-
- 1374 views
- 1 answers
- 0 votes
-
- 1842 views
- 2 answers
- 0 votes
-
This can be done at the DB level, something like:
select distinct(transferred) from change;
This will return the value for yes/no transfer
create table changeFullBk as select * from change;
update change set transferred= xx where class=6000;
this will update all Change orders. The script can be enhanced to exclude deleted changes and/or subclassesHope this helps
Florina- 1861 views
- 5 answers
- 0 votes
-
Change table is part of the agile schema, you need to connect as agile/tartan (default)
I don’t have a 932 system to get exact details but you can start with using a Change # with transfer flag set as you want to set to all ECOsselect id, transferred from change where change_number=’XXXX’;
Also, look into the changes with different transfer flag to understand why the difference in flags
select change_number from change where TRANSFERRED = ‘1 100000000000000000000000000000’ ;
SELECT change_number from CHANGE where TRANSFERRED = ‘10000000000000000000000000000000’ and rownum < 5 order by rownum;
SELECT change_number from CHANGE where TRANSFERRED = ‘10100000000000000000000000000000’ and rownum < 5 order by rownum;
You can change the rownum to a lower number, but in general, review the changes returned to understand, from GUI perspective, why difference in transferred flags and determine which one is best for your update.Once you decide on the transferred flag, backup change table, update and commit.
Of course, test it all in non production. For example, once update and commit, do you see CC attempting to reset the flag in GUI? I remember there is a CC wizard and you need to select from this point on…. ( sorry , ChangeCast is rather old and I haven’t worked with it in a while !)Florina
- 1861 views
- 5 answers
- 0 votes
-
The Oracle logo was replaced in A934 by updating
— application.ear application.war, images folder WEB-INFOweb.xml— Tools | Administration | Visual Themes
These reports are not getting the logo from the application.ear images, because of the integration with the BI Publisher engine, which is used by Agile to generate reports.
An workaround for these 3 reports is using HTML/Excel format to generate report, then add your logo and convert it to PDF manually.-Item Attribute History
-Compare Item Attributes
-BOM Comparison ReportFlorina
- 2271 views
- 4 answers
- 0 votes
-
- 1828 views
- 2 answers
- 0 votes