Showing posts from 2019

SOA Java Snippet to Decode and Encode

Decode:  XMLElement EncodedData = (XMLElement)getVariableData(" VariableName "," VariablePart "," PathOfTheElementHoldingData ");          String EncodedReportData=EncodedData.getTextContent();                          oracle.soa.common.util.Base64Decoder B64Decoder = new oracle.soa.common.util.Base64Decoder();                                            try                                             {                                                String DecodedReportData = B64Decoder.decode(EncodedReportData);                setVariableData("DecodedString",DecodedReportData);                                               }                              catch(Exception e)                                                 {                                                addAuditTrailEntry("Exception During Decode "+e.getMessage());              e.printStackTrace();                                             } Encode:  XMLE

PGP Encrypt and Decrypt Script

#!/bin/bash SourceFilePath=$1 OutFilePath=$2 PublicKeyUser=$3 echo "Running GPG Encrypt Command" gpg --batch --yes --trust-model always -r $PublicKeyUser -o $OutFilePath -e $SourceFilePath ------------------------------ -------------- #!/bin/bash SourceFilePath=$1 OutputFileName=$2 PassPhrase=$3 echo "Running GPG Decrypt Command" cat $PassPhrase | gpg --output $OutputFileName --batch --yes --passphrase-fd 0 $SourceFilePath

Oracle MFTCS Configurations

MFT Configurations can be done using mftconsole Login to mftconsole using admin credentials. After login, select Administration tab on the right corner. Following configurations are available Server Properties.  Payload Storage Directory domain_dir/mft/storage Callout Directory domain_dir/mft/callout Store inline Payload - File or DB type We can select the number of processors for Source , Transfer and Target Configure Control Directory domain_dir/mft/contrl_dir Inbound datasource jndi outbound datasource jndi Import and Export You can this section to import and export MFT artifacts.  Keystore Management Keystore MFT uses SSL and SSH keys to secure embedded SFTP server.  Use this section to configure SSL and SSH keys .  Steps to configure SSL certificates.  Go to WLST command line path /mft/common/bin Start WLST connect("weblogic","welcome1","t3://localhost:7003") Access Oracle Platform Se

BPEL Custom Invoke Properties

<bpelx:toProperties> <bpelx:toProperty name= "jca.jndi"  variable="Dynamic_JNDI"/> </bpelx:toProperties> <bpelx:toProperties>             <bpelx:toProperty name=" csf-key " variable=" inputVariable(Variable holding the key value) " part="payload">               <bpelx:query> ns:ParametersList/ns:Parameters[ns:ParameterName='KEY_NAME']/ns:ParameterValue </bpelx:query>             </bpelx:toProperty>           </bpelx:toProperties>         <bpelx:fromProperties>           <!--<bpelx:fromProperty name="Authorization" variable="authTokenVar"/>-->           <bpelx:fromProperty name="x-intg-source-system" variable="sourceSystemUserVar"/>         </bpelx:fromProperties>

Simple Steps to Create an HCM Extract.

Steps to Create an HCM  Extract : Login to HCM Go to data exchange.  In Tasks (Right menu), select Manage Extract Definition.  Select create ( + ) Give a name to Extract. Give Start Date value. 01-Jan-2000   The Start date is an effective start date that applies to all date-effective interactions in the current session. Select extract type HR Archive is for getting assignment and person details.  Payroll interface is for getting payroll related details. Create Data Group Give Group Name.  Give Display  Name.  Select User Entity based on the data you want to extract.    Example :  PER_EXT_SEC_ASSIGNMENT_UE     PER_EXT_EMAIL_ADDRESSES_UE set Threading Action Type = Object Action Select Threading Database Item - It will be the unique value of the Main table that will be used to join or get the values.   Example : Extract Assignment ID Create a Record Give a Record Name. Give a Tag name - This value will be a XML tag (Parent Tag) value under which the at

HCM Extract Issue Resolutions

Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation: /Custom/Project/Entity/DemoATest.xdo, user: fusion_apps_hcm_ess_appid, permission: 192  Solution  Go to HCM Analytics Go to the report path Select the report Click More options and select permissions.  Add BI Consumer Role Select Custom Permission and Add all the permission.  Dummy File Deleted Solution : There may be multiple issues.  Check and make sure data model is attached the report.  Use Global Payroll Data model --- Dont miss this Shared Folders/Human Capital Management/Payroll/Data Models/globalReportsDataModel Check proper output format is selected  The report cannot be rendered because of an error, please contact the administrator. java.lang.NullPointerException Solution : After you upload the template to a report, select view report option .  If there is no error then it will display as Report Compile

SOACS Instance Auto Purge Configuration.

Go to SOA-INFRA -> SOA Administration -> Auto Purge Auto Purge Job Name -SOA Flow Purge Job 1 and Enable it.  Provide Job Schedule details as per below . Run every Day at Midnight FREQ=DAILY; BYHOUR=00; Run every weekday at midnight FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=00; Run every weekend at midnight and 05:00AM FREQ=DAILY; BYDAY=SAT,SUN; BYHOUR=00,05; Run every weekday 30 minutes past midnight FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=00; BYMINUTE=30; Run every weekend 30 minutes past midnight and 5AM FREQ=DAILY; BYDAY=SAT,SUN; BYHOUR=00,05; BYMINUTE=30; Run every friday at midnight FREQ=DAILY; BYDAY=FRI; BYHOUR=0; Purge Type -> Single Retain Data ->  7 or 30 days.  Batch Size 

MFT Event Driven Integration with SOA

Use the following steps to create MFT flow.  Create a transfer.   After you create a transfer , select create a source option Provide source name and source type ex: SFTP or FILE Provide the SFTP login credentials and source location.  Submit create. Open the source , Go to Source schedule Select Event option.   Next event option click the link and get the WSDL URL .  http://localhost/mftapp/services/MFTEventService?WSDL  Source Encryption or Decryption We can encrypt or decrypt a file at source before transfer.  Select actions in source page.  select the Encryption or Decryption option Provide the encryption or decryption key.   For encryption, you must reference the public PGP key alias. For decryption, you must reference the private PGP key alias. We can archive or delete the file by providing necessary details in advanced/operations tab.  Select create target and provide the target details and submit create button.  Save all the changes and deploy.  Use

ORACLE SOACS - Invoke a WebService using OAuth

Create a Keystore for OWSM  -- One Time Configuration Go to the WebLogic Domain → Security → Keystores page. Click on “Create Stripe” button Enter the name “owsm” Click on the newly created “owsm” stripe Click on the “Create Keystore” button.. Fill in the Keystore name as “keystore” Ensure the Protection type is “Policy” Click on “OK” Create a credentials map for OWSM  -- One Time Configuration Go to WebLogic Domain → Security → Credentials Click on the “Create Map” button Fill in the name “” Click "OK Create a Credential Key - csfkey for OAuth Click on the map created in the previous step Click on the “Create Key” button Ensure that the Type field has “Password” selected Enter the OAuth Client ID in the “User Name” field Enter the OAuth Client Secret in the “Password” field Enter the same value in the “Confirm Password” field Click “OK” Create a composite and attach following policies to the reference/target component. "


HDL - HCM Data Loader is the recommended way of loading data to HCM. HDL load can be done manually or through Web Service. Pre requisites are : Configure Source System Owner Navigator  > Setup and Maintenance > Search Search for - Manage Common Lookups Lookup Type = HRC_SOURCE_SYSTEM_OWNER Update or add new source system owner. Use this value while loading worker data.  Configure Legal employer and Business Units.   Verify existing LE and BU  Navigator  > Setup and Maintenance > Search Search for Manage Legal Entity HCM Information Lookup type = Use existing LE value  Business Units Navigator  > Setup and Maintenance > Search Search for Manage Business Units Lookup type = Use existing BU value.   Create a required worker files.  Zip the files.  Go to Menu > My Workforce > Data Exchange Go to Tasks > Import and Load Data Import the zip file.  Load the Business Objects.  Worker Data : SourceSystemOwner VK