Month: July 2022

APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to the following error: error encountered in pa_flexbuild 

SYMPTOMS: In Oracle Payables, when user click on all distributions for one invoice, using the invoice workbench form (APXINWKB.fmb), the following error occurs: Steps to reproduce the issue: Payables Manager responsibility 1. Navigate to Invoices : Inquiry > Invoices 2. Query the invoice 3. Click on all distributions 4. The error is displayed Cause: Workflow …

APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to the following error: error encountered in pa_flexbuild  Read More »

Kill a locked Session using SQL Develope or Toad.

Query All the Locked sessions using below SQL and based on your OBJECT find the session locking it SELECT l.inst_id,SUBSTR(L.ORACLE_USERNAME,1,8) ORA_USER,SUBSTR(L.SESSION_ID,1,3) SID,S.serial#,SUBSTR(O.OWNER||’.’||O.OBJECT_NAME,1,40) OBJECT, P.SPIDOS_PID,DECODE(L.LOCKED_MODE, 0,’NONE’,1,’NULL’,2,’ROW SHARE’,3,’ROW EXCLUSIVE’,4,’SHARE’,5,’SHARE ROW EXCLUSIVE’,6,’EXCLUSIVE’,NULL) LOCK_MODEFROM sys.GV_$LOCKED_OBJECT L, DBA_OBJECTS O, sys.GV_$SESSION S, sys.GV_$PROCESS PWHERE L.OBJECT_ID = O.OBJECT_IDand l.inst_id = s.inst_idAND L.SESSION_ID = S.SIDand s.inst_id = p.inst_idAND S.PADDR = P.ADDR(+)order by l.inst_id …

Kill a locked Session using SQL Develope or Toad. Read More »

Jobs Openings – 17 July

1. Looking for Oracle DBA + RAC Professionals.Experience: 4-6 yearsLocation: Mumbai If interested, please share your CV to ‘pavani.s@savantis.com’. 2. immediate requirement for EBS – Oracle Application . Exp: 5 – 10yrs Work Location: Chennai. Required ExperienceTechno functional knowledge in Oracle Distribution / Oracle Financials / Oracle Manufacturing / Oracle Projects modules / OTL.Hands on …

Jobs Openings – 17 July Read More »

How to schedule Concurrent Program/Request in Oracle Apps?

Concurrent Program is perhaps of the main usefulness accessible in Oracle Apps. It permits clients to parallelly submit occupations. These program run behind the scenes and nonconcurrent way. You can present different occasions of a similar program. A concurrent manager controls and deals with the running of this multitude of program. This is the way …

How to schedule Concurrent Program/Request in Oracle Apps? Read More »

Job Openings – 13JUL22

Currently looking for Oracle Apps technical, HCM functional , PPM functional OIC consultants with a total of 9 yrs of experience at least. If interested please share your resume at recruitment@savianconsulting.com currently looking for the candidates to work under our payroll (W2)Job Title : Java DeveloperClient : N/ALocation : RemoteExperience : 5+ yearsAs a Java …

Job Openings – 13JUL22 Read More »

Jobs openings

We are looking for an Oracle CLOUD PPM Technical OR Functional Relevant experience of 7+ Years, We need who can join immediately on a Contract Basis Duration: 6 months If you are willing to apply to send your profile to: shiva@sanaari.net call:+91 8008814567 Job Type: ContractDuration: 6 monthsLocation : Bangalore WFH. We are hiring for …

Jobs openings Read More »

Purge Concurrent Requests

This alert looks for concurrent requests and their log and out files that are older than the number of days you specify and runs a concurrent program that deletes them. If you enter a concurrent program name input, you should use the program name (located in the column USER_CONCURRENT_PROGRAM_NAME in the table FND_CONCURRENT_REQUESTS), and not …

Purge Concurrent Requests Read More »

Basic Introduction of Database

Data : realities or figures, Pieces of data. (Natural , Unorganized) Data is an assortment of realities, like numbers, words, estimations, perceptions or only depictions of things. Subjective versus Quantitative. Database : It is a coordinated assortment of data. A database set is a coordinated assortment of organized data, or information, commonly put away electronically …

Basic Introduction of Database Read More »

RMAN Full_BACKUP Script

[oravis@dbvis 12.1.0]$ . VIS_dbvis.env[oravis@dbvis 12.1.0]$ rman target/ Recovery Manager: Release 12.1.0.2.0 – Production on Wed Jul 6 15:13:36 2022 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: VIS (DBID=502546441) RMAN> run {set command id to ‘VISION_OnlineBackupFull’;ALLOCATE CHANNEL c1 DEVICE TYPE disk;ALLOCATE CHANNEL c2 DEVICE TYPE disk;ALLOCATE CHANNEL c3 …

RMAN Full_BACKUP Script Read More »

Oracle Forms Compile in Oracle EBS R12.2

First time creating a new form compile: Login is Application Server Source the Environment file. Go to directory $AU_TOP/forms/US execute the command to generate “.fmx” file. Syntax : frmcmp_batch userid=apps/ apps password module=<form.name>.fmb output_file=.<formname>.fmx module_type=form batch=no compile_all=special For Example : frmcmp_batch userid=apps/apps module=XXFUNDREQ.fmb output_file=/uatapp/VIS/fs2/EBSapps/appl/xxvis/12.0.0/forms/US/XXFUNDREQ.fmx module_type=form batch=no compile_all=special If form already, any changes we need to …

Oracle Forms Compile in Oracle EBS R12.2 Read More »