Oracle Application Blog

fs_clone failed while running txkADOPPreparePhaseSynchronize.pl

fs_clone failed :[UNEXPECTED]Error occurred running”perl/oradata/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl When attempting to run FSclone, the following error occurs. Error can be seen in adop_<TIME_STAMP>.log:   [UNEXPECTED]Error occurred running “perl <DIR>/<SID>/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=<DIR>/<SID>/fs1/inst/apps/<CONTEXT_NAME>/appl/admin/<CONTEXT_NAME>.xml -patchcontextfile=<DIR>/<SID>/fs2/inst/apps/<CONTEXT_NAME>/appl/admin/<CONTEXT_NAME>.xml -promptmsg=hide -console=off…

Read More

Oracleasm lib commands

ASMLIB is a storage management interface. ASMLIB is not required for ASM to function; it is like an add-on library that simplifies the tasks of managing and discovering the disks.…

Read More

All About Oracle DB Audit

The auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time when a user attempts anything in the database…

Read More

ASMCMD useful Commands

Below are some of the useful ASM commands which will be helpful all the time. ASMCMD > showversion ASMCMD > showversion –releasepatch –softwarepatch ASMCMD > showpatches ASMCMD > showclustermode ASMCMD…

Read More

adcfgclone return code = .16.17.18.19.20.21

Where I Faced this Issue? When I ran adcfgclone appsTier on EBS 12.2 I got this error, and it said got error while running autoconfig, but the actual error is…

Read More

Query to fetch on hand quantity of an item for historic date

Introduction  This blog explains to get the On hand quantity if a item in inventory for a specific date #Code# SELECT SUM (TRANSACTION_QUANTITY) TARGET_QTY FROM MTL_ONHAND_QTY_COST_V MOQV WHERE MOQV.ORGANIZATION_ID =…

Read More

Fusion – Global Human Resources Views

Global Human Resources Views EEC_CONTEST_TEMPLATE_HDR_VL EEC_METRICS_VL EEC_REWARDS_VL HCM_EXTENDED_LOOKUP_CODES_VL HR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS_F_VL HR_ALL_ORGANIZATION_UNITS_TL HR_ALL_ORGANIZATION_UNITS_VL HR_ALL_ORGANIZATION_UNITS_X HR_ALL_POSITIONS HR_ALL_POSITIONS_F_VL HR_ALL_POSITIONS_X HR_BU_LOCATIONS_X HR_COMPANY_VS_V HR_COST_CENTER_VS_V HR_DOCUMENT_TYPES_VL HR_LEGAL_ENTITIES HR_LOCATIONS HR_LOCATIONS_ALL HR_LOCATIONS_ALL_F HR_LOCATIONS_ALL_F_VL HR_LOCATIONS_ALL_TL HR_LOCATIONS_ALL_VL HR_LOCATIONS_ALL_X HR_LOCATION_EXTRA_INFO HR_LOCATION_EXTRA_INFO_F…

Read More

Fusion – Sample Payload For FindCustomerAccount Operation In TCA Account Web Service

SOLUTION Below are some sample payload for findCustomerAccountOperation: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/cdm/foundation/parties/customerAccountService/applicationModule/types/” xmlns:typ1=”http://xmlns.oracle.com/adf/svc/types/”> <soapenv:Header/> <soapenv:Body> <typ:findCustomerAccount> <typ:findCriteria> <typ1:fetchStart>0</typ1:fetchStart> <typ1:fetchSize>1</typ1:fetchSize> <typ1:filter> <typ1:conjunction/> <typ1:group> <typ1:conjunction/> <typ1:upperCaseCompare>false</typ1:upperCaseCompare> <typ1:item> <typ1:conjunction/> <typ1:upperCaseCompare>false</typ1:upperCaseCompare> <typ1:attribute>AccountNumber</typ1:attribute> <typ1:operator>=</typ1:operator> <typ1:value>GB000557</typ1:value> </typ1:item>…

Read More

Fusion – Update Supplier, Supplier Site, Supplier Contact Payload – Webservice

<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” xmlns:sup=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/” xmlns:sup1=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierSites/” xmlns:sup2=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierAddress/” xmlns:sup3=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplier/” xmlns:sup4=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierContact/”> <soapenv:Header/> <soapenv:Body> <typ:updateSupplier> <typ:supplierRow> <!–Optional:–> <sup:SupplierId></sup:SupplierId> <!–Optional:–> <sup:Supplier></sup:Supplier> <!–Optional:–> <sup:SupplierNew></sup:SupplierNew> <!–Optional:–> <sup:SupplierNumber>1538988727</sup:SupplierNumber> <!–Optional:–> <sup:AlternateName>SV supplier 01 updated</sup:AlternateName> <!–Optional:–> <sup:TaxOrganizationType></sup:TaxOrganizationType> <!–Optional:–> <sup:SupplierType></sup:SupplierType> <!–Optional:–>…

Read More

Fusion – Create Supplier, Supplier Site, Supplier Contact Payload – Webservice

<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” xmlns:sup=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/” xmlns:sup1=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierSites/” xmlns:sup2=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierAddress/” xmlns:sup3=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplier/” xmlns:sup4=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierContact/”> <soapenv:Header/> <soapenv:Body> <typ:createSupplier> <typ:supplierRow> <sup:Supplier>SV supplier01 Corporation</sup:Supplier> <sup:BusinessRelationship>SPEND_AUTHORIZED</sup:BusinessRelationship> <sup:TaxOrganizationType>CORPORATION</sup:TaxOrganizationType> <sup:SupplierType>SUPPLIER</sup:SupplierType> <sup:AlternateName>SV supplier 01</sup:AlternateName> <sup:SupplierBusinessClassifications> <sup:Operation>CREATE</sup:Operation> <sup:BusinessClassification>WOMAN_OWNED</sup:BusinessClassification> <sup:CertifyingAgency>Association for Women Owned Business</sup:CertifyingAgency> <sup:CertificateNumber>AS105</sup:CertificateNumber>…

Read More