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

OIC - ERP - How to get the child process id from import request id using OTBI report

What: To show how to get child process id from process request id.

How: Highlevel:

• Create a BI report using SQL query 
• Call it from OIC using soap connection
• Check it from ERP schedule processes

Step1: create BI report

Sql query to use in data model:

See the below blogs:.

How to create data model and test sql:

oic-erp-how-to-test-sql-query-in-otbi

How to create BI reports:

oic-how-to-create-bi-report-in-oracle

 How to create eText based BI report:

oic-create-etext-template-based-bi

How to invoke erp Bi report:

oic-invoke-erp-bi-report

Step2:

Create a conneection using ExternalReportWSSServices wsdl

In the Integration, Invoke the connection and operarion as runreport and map as following:

• Provide name values pair as Name: P_REQUEST_ID & value: importRequestID
• provide report absolute path
• SizeofDatachunkDownload as -1

Step3: We can see the processes status from ERP Schedule process : 

Import accounting Trasactions is the import req id: 1720657

Child process : Create Accounting for Data Set : 1720660

OIC -ERP - How to test sql query in OTBI data model

What: Here I will show you how we can test ERP OTBI sql query from data model:

Why: Suppose we have an OTBI report which we are invoking from OIC to get some details. Sometimes it gets failed and showing BI report db sql query related issue. For that issue triage, we need to test the data set sql query behind the BI report. Most of the cases, its a big query so we can break the sql into small executable module and test in data model.

How: Steps:

Step1: Navigate to Menu 》 Tools 》 Reports and Analytics 

Step2: Browse Catalog

 

Step3: shared folders 》 Custom 》 GO to the path and select desired folder.

 Step4: Edit the report 

Step5: click on the data model.

Step6: Hit on the + sign button to create a Dataset for SQL Query

Step7: Provide the sql query to test and press ok.

This will create the dataset. 

Step8: Click on data tab and view

It will show the tested query result.