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.






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


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,,#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


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:



6. Cash Management:

Import bank statements from a Spreadsheet

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

Auto Reconcile bank statements:



JobParameters: #NULL

7. JournalImportLauncher

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

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

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...