Yearly Archives: 2020

How Doyensys helped a US-based Floral Retailer in its Business Growth

At Doyensys, we firmly believe that commitment and consistency in our services can make a substantial difference in the businesses of our clients. When a US-based floral and gourmet foods…

Read More

Petmate : A Success Story

Petmate is a leading and trusted pet care solutions firm based in the US. They started in 1959 with kennels and subsequently progressed into making collars, leashes, and other accessories.…

Read More

XML Gateway Outbound PO Errors With Filenotfoundexception On Cwallett.Sso

APPLIES TO: Oracle XML Gateway – Version 12.0.0 to 12.1.3 [Release 12 to 12.1] Information in this document applies to any platform. SYMPTOMS Setup xml gateway with trading partner for…

Read More

POXML Workflow fails intermittently with Error Process ‘POXML/XXXX-XXXXX’ has no activities waiting to receive event ‘oracle.apps.po.event.xmlpo’

APPLIES TO: Oracle Purchasing – Version 12.1.3 and later Information in this document applies to any platform. SYMPTOMS When attempting to send some Purchase Orders (POs) by XML Gateway after…

Read More

Important Data Guard Process

Remote File Server (RFS) Process: The RFS process runs on the standby database and is responsible for communication between the primary and the standby database. For the log transport service,…

Read More

DataGuard Issue – Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

Warning: ORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration – ZEE_DG_CONFIG Protection Mode: MaxPerformance Databases: zee – Primary database zeedr…

Read More

APP-SQLAP-10771: Could not reserve record.

Error: APP-SQLAP-10771: Could not reserve record. Unable to pay the AP invoice in full, Got above error while performing the action –> pay in full Solution: Database lock from another…

Read More

Some useful scripts – V1

Some useful fnd scripts which available in $FND_TOP/sql directory FNDATPRG.sql  Purge audit trail tables before a given date FNDCPDC2.sql  Delete a concurrent program and SRS definition if needed, calls FNDCPDCP.sql…

Read More

Workflow related useful scripts – $FND_TOP/sql

wfbkg.sql    WorkFlow BacKGround engine, starts the background engine, running for the indicated number of minutes. wfbkgchk.sql WorkFlow Background Check. It displays a status report on background work waiting to…

Read More

EBS R12.2 ADOP phases and parameters

EBS R12.2 ADOP phases and parameters 1) Prepare  – Starts a new patching cycle. Syntax:  adop phase=prepare 2) Apply – Used to apply a patch to the patch file system…

Read More