Best Of
Re: 19.29 oneoff patch missing? 37690446
Ideally at some point next week. Please keep checking on the available patch back ports.
Re: How are you integrating multiple P6 schedules in OPC and importing updates without losing logic?
so one of the issues you may have with the update settings is the chance the relationships get updated and therefore the external ties get lost because the new file does not contain the externals.
Best practice is to
- Receive baseline files from subs
- Conduct external relationship meetings/agree on Program Baseline
- Perform exports of each subprojects and return them to the subcontractors ( these versions will contain the external relationships)
- Each sub is to use the provided file to update their schedules.
- Receive the updated files from the subs with the update setting. (files will all still have the external relationships)
- Conduct meeting/manage external relationships and agree on program progress.
- Repeat export of projects
- Repeat process
The key is on both parties to adhere to
- Always use the current file provided by master
- Never adjust external relationships while the individual projects are being updated outside the master
It’s a method… but to be honest given that we live in a world of shared environments, just pull out your credit card, bring your subs into OPC, and give them their project access with limited permissions and stop doing all this import/export stuff. And don’t say they don’t know how to use it. They can be trained. Companies have to learn Aconex let’s say if the project documents are stored there even if the only have ever used Procore. This is the same.
Re: Oracle 12 Spatial – How to Set Up NTv2 Grid for GDA94 to GDA2020 Transformation
To enable NTv2 grid-based transformations (such as from GDA94 to GDA2020) in Oracle Spatial (Oracle Database 12c),
you need to ensure that Oracle Spatial can locate and access your NTv2 grid files (*.gsb). Here’s how you can do this:
Oracle Spatial looks for datum shift (grid) files in the directory specified by the SDO_COORD_ATR_PATH initialization parameter.
If this parameter is not set, Oracle will use its default directory ($ORACLE_HOME/md/demo/coordinate/), but setting the parameter is best practice.
Place your .gsb files in a directory accessible to the Oracle server, e.g.:
/u01/app/oracle/product/12.2.0/dbhome_1/md/demo/coordinate/
or a custom directory (preferred for custom files), e.g.:
/u01/app/oracle/ntv2_grids/
Set the SDO_COORD_ATR_PATH database initialization parameter to point to this directory.
You can set this system parameter (as SYSDBA):
ALTER SYSTEM SET SDO_COORD_ATR_PATH = '/u01/app/oracle/ntv2_grids/' SCOPE=SPFILE;
Restart the database if you set the parameter using SPFILE or pfile.The Oracle RDBMS user must have read access to the grid files and the directory.
Oracle Spatial transformations must refer to the NTv2 transformation by name, referencing your grid file in the transformation definition.
Check the table SDO_DATUM_TRANSFORMS to see if your transformation is already defined, or create a custom transform referencing the grid file.
Thanks
Swati A
Re: Cascading of existing Style Supplier onto a new SKU is a base functionality?
Hi User_B13BC,
Yes, this is standard out-of-the-box MFCS behavior.
The parameter CORESVC_ITEM_CONFIG.CASCADE_IUD_ITEM_SUPPLIER determines whether inserts, updates, or deletes on item/supplier details should cascade to child items. When this parameter is set to 'N', propagation is disabled, meaning each SKU will only have the suppliers explicitly assigned to it.
Thanks,
Atanu
Re: Concurrent request completes without error but cannot view output or log file in the browser.
We are having the exact same problem, and it also started today Jan 31 2023. No configuration changes, nothing we did that might have triggered the problem. A bounce of services didn't help. We are running AutoConfig now, as you found, to see if that helps us.
Re: Ability to Push New Cost Code Rows from Template to Existing Project Shells
Thanks Jeff! This is useful. I used Create Code but wasn't aware of the Sort Cost Sheet APIs.
Re: Ability to Push New Cost Code Rows from Template to Existing Project Shells
Hi Nasim,
I agree that this would be a great enhancement to Unifier.
If you're looking for an immediate solution, I've suggested to other customers in the past to look at our REST APIs for this exact purpose. You can use tools like OIC or Postman to iterate through all your project numbers.
Check out:
- Create CBS Codes (https://docs.oracle.com/cd/G18097_01/English/Integration_Documentation/integration/10293166.htm) as
- Sort Cost Sheet (https://docs.oracle.com/cd/G18097_01/English/Integration_Documentation/integration/10301291.htm).
Jeff
Re: Calendar Groups
Hello Kimberly,
Yes, you can use the Calendar Group - Auto Creation page (GP_AUTO_CAL_GRP) to create calendar groups using existing periods and calendars newly.
Navigation:
Global Payroll & Absence Mgmt > Absence and Payroll Processing > Define Calendars > Calendar Group - Auto Creation
https://docs.oracle.com/cd/G40410_01/hcm92pbr53/eng/hcm/hgpy/DefiningAutomatedCalendarGroups.html
Re: CRM Activity Email issue
Thanks for your help and we were able to get it to work



