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.

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.

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

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')

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"

4.reimbursement approval

Validate Payables Invoices

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

5. Assets:

Account: fin$/assets$/import$

JobName: /oracle/apps/ess/financials/assets/retirements/massRetirements,PostMassRetirements

Parameters VALUE:CORPORATE ASSET BOOK,Asset_RetirementsYYYYMMDD

Post Mass Transfer:

JobName: /oracle/apps/ess/financials/assets/tracking/massTransfers,PostMassTransfers

Post Mass Update Descriptive Details:

JobName: /oracle/apps/ess/financials/assets/tracking/massTransfers,PostMassUpdateDescDetails

Post mass Additions:

JobName:/oracle/apps/ess/financials/assets/additions,PostMassAdditions

Sample Parameters: "CORPORATE ASSET BOOK,#NULL,NORMAL,#NULL,#NULL,#NULL,#NULL"

6. Cash Management:

Import bank statements from a Spreadsheet

JobName: /oracle/apps/ess/financials/cashManagement/bankStatements,ImportBankStatements

Auto Reconcile bank statements:

JobName:

oracle/apps/ess/financials/cashManagement/bankStatements,AutoReconciliation

JobParameters: #NULL

7. JournalImportLauncher

JobName: /oracle/apps/ess/financials/generalLedger/programs/common,JournalImportLauncher

JobParameters: $dataAccessSetId,$sourceId,$ledgerId,#NULL,N,N,N