soalicious: January 2022

Sunday, January 30, 2022

OIC - Merge two different schema files into a single CSV file

What : We will read 2 csv files having different schemas and marge them into a single final csv file.

Input:

Sample_1.csv

Sample_2.csv

Output:

Final.csv

Implementation Steps:

Create a FTP connection and create an Orchestrated integration.
Read 1st file using ftp connection and 1st CSV file schema.

Write the file in the Stage location with the same 1st CSV schema and map the read file.

Read the 2nd file using FTP connection and 2nd CSV file schema.

Write file into a stage location with the 2nd CSV schema. Keep the same file name and location. And also, keep Append to existing file checked in and map the read 2nd file.

Write the both marged file into a location using FTP connection.

Thursday, January 27, 2022

OIC - iCal Expression to run each month on specific day and specific time

FREQ=MONTHLY;BYMONTHDAY=1,10,15;BYHOUR=5,10 15,20;BYMINUTE=15;

The following exp indicates that the integration will run each month on the 1st, 10th, and 15th day of the month at 5:15AM, 10:15AM, 3:15PM, and 8:15PM

FREQ:DAILY;BYHOUR=0,1,2,3 4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20 21,22;BYMINUTE=0,5,10,15,20,25,30,35,40,45,50,55;

The following exp will run daily each 5 mins interval except 11th hour of the day.

Monday, January 24, 2022

OCI - Oracle Cloud Infrastructure foundations 2021 associate 1Z0-1085-21 exam questions and answers

Q7: correct answers C and D

Q8: correct answers B

Q11: correct answers: CDE

Q14: correct answers: ADE

Q22: Correct answers: BE

Q29: correct ans: EF

Q32: correct ans: BD

Q38: correct ans: B

Q50: correct ans: AE

Sunday, January 23, 2022

ODI - database - datafile - check used and allowed max file size

Run the following commands to get the tablesapce used size, allocated max size:

For all Tablespace:

Select FILE_NAME, FILE_ID, TABLESPACE_NAME, BYTES/1024/1024/1024 size_gb, maxbytes/1024/1024/1024 max_gb, STATUS, AUTOEXTENSIBLE, ONLINE_STATUS from dba_data_files

For speecific tablespace:

Select FILE_NAME, FILE_ID, TABLESPACE_NAME, BYTES/1024/1024/1024 size_gb, maxbytes/1024/1024/1024 max_gb, STATUS, AUTOEXTENSIBLE, ONLINE_STATUS from dba_data_files where tablespace_name in ('undo_8')

Wednesday, January 19, 2022

ERP - Sample Job details , Parameters used, account name details

Some examples of the job name and details:

1. subledger accounting:

Accounting Transactions.

DocumentAccount: "fin$/fusionAccountingHub$/import$"

Jobname: /oracle/apps/ess/financials/subledgerAccounting/shared,XLATXNIMPORT

Parameters used:doc id received from ucm upload,XlaTransactionUpload_FAH.zip,#NULL,#NULL,Y,F,S,Y,Y,Y

No of arguments: 10

2. Payables/invoices:

Import Payable Invoices

Jobname: /oracle/apps/ess/financials/payables/invoices/transactions,APXIIMPT

No of arguments: 14

Parameters used:#NULL,$businessUnitId,N #NULL,#NULL,#NULL,1000 $Source,#NULL,N,N,$ledgerID,#NULL,1

DocumentAccount: "fin$/assets$/import$" or "fin$/payables$/import$

3. Expenses

Jobname: /oracle/apps/ess/financials/expenses/shared/scheduler,FinExmUploadCCTransactionsjobDef

Job Parameters used: JobPackageName,JobDefinitionName,"UPLOAD",Visa,$p_program_id, #NULL,#NULL,#NULL,"FILE_FMT_VISA",$P_DownloadProgramId,"$decrypt_key"