Doyen Domains

Blog Archives

Follow us on

Total Page Views

601 views

Oracle Application Express in Oracle Database 12c

Oracle Application Express in Oracle Database 12c

Oracle Application Express in Oracle Database 12c Oracle Application Express Release 4.2.0.00.08 is installed by default in Oracle Database 12c. One of the major new capabilities introduced in Oracle Database 12c is Multitenant Architecture. Oracle Database 12c New Features for Application Express Developers VARCHAR2 32K (Extended Data Type) The byte / character limit for VARCHAR2 columns can be extended from...[ read more ]

  • September 21, 2014 | 137 views

Oracle Multitenant in Database 12c Enterprise Edition

Oracle Multitenant in Database 12c Enterprise Edition

Oracle Multitenant - an Oracle Database 12c Enterprise Edition option – introduces a new architecture that enables customers to easily consolidate multiple databases into a standardized database version that is deployed on a shared cloud infrastructure, without changing their applications. This new architecture delivers all the benefits of managing many databases as one, yet retains the isolation and resource prioritization...[ read more ]

  • September 21, 2014 | 2 views

Eliminating block.field issue while upgrading from EBS R11i to R12 versions

Eliminating block.field issue while upgrading from EBS R11i to R12 versions

Eliminating block.field issue while upgrading from EBS R11i to R12 versions Problem In 11i, Customers are accessed through Oracle forms where :block.field reference is allowed to dynamically bring values in value sets. But in R12, Customers are accessed through OAF page where this will throw error. Solution The Customer OAF page can be personalized to dynamically bring the value referred in...[ read more ]

  • September 26, 2014 | 5 views

Setups for Discoverer Desktop

Setups for Discoverer Desktop

Setups for Discoverer Desktop The following steps have to be implemented after installation of Discoverer Administrator and Discoverer Desktop: 1. In Discoverer Desktop, go to tools --> options --> Connections and click on Connect to Both 2. Enter GWYUID as APPLSYSPUB/pub 3. Enter FNDNAM as APPS 4. Check the location where Discoverer is installed in the local machine. 5. Confirm...[ read more ]

  • September 29, 2014 | 0 views

Useful Discoverer Queries

Useful Discoverer Queries

Query #1 - To List the Discoverer Reports SELECT DOC_ID,         DOC_NAME,         DOC_DEVELOPER_KEY,         DOC_CREATED_BY    FROM EUL5_US.EUL5_DOCUMENTS       --EUL_APPS.EUL4_DOCUMENTS     Query #2 - To List the Discoverer Reports and users having access to them SELECT   ACCESS_PRIVS.AP_CREATED_DATE,            DECODE (    ...[ read more ]

  • September 29, 2014 | 6 views

APEX upgrade from 4.0 to 4.2 – Technical Issues

APEX upgrade from 4.0 to 4.2 – Technical Issues

           1. Problem: Login issue – unable to login to the Apex application.                Solution: Remove the old APEX user (4.0) after upgrade.     2. Problem: Error session state protection violation                   Solution: Set the “Save Session State” property to “No” 3. Problem: Item alignment issues...[ read more ]

  • September 29, 2014 | 1 views

PO Workflow Error – Document Manager Failed with Error Number 3 while processing Standard Purchase Order XXXXXX

PO Workflow Error – Document Manager Failed with Error Number 3 while processing Standard Purchase Order XXXXXX

Reset a Purchase Order Statuses From In Process or Pre-Approved To Incomplete/Requires Reapproval Title: Document Manager Failed with Error Number 3 while processing  Standard Purchase Order XXXXXX Issue Description: PO Workflow got stuck in Error with the error message "Document Manager Failed with Error Number 3 while processing Standard Purchase Order XXXXXX". Not able to process the Purchase Order using...[ read more ]

  • September 30, 2014 | 2 views

Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120

Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120

RECEIVING TRANSACTION PROCESSOR ERROR ISSUE Title: Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120 Issue Description: When attempting to take a receipts against the Purchase Orders, the Receiving Transaction Processor will end-up in error with the error numbers RVTTH-445, RVTBM-008 & RVTBM-120. Error Message: RVTTH-445: Subroutine  returned error Cause:        Subroutine  returned an internal error.  Action:        Note...[ read more ]

  • September 30, 2014 | 2 views

How to Process the Stuck Purchase Orders with an Pending “Respond to Changes” Action

How to Process the Stuck Purchase Orders with an Pending “Respond to Changes” Action

Issue: Requisitions are created using either from the Core Purchasing or Internet Procurement responsibilities. Then the requisitions will be converted into Purchase Orders using either Buyers Work Centre form or Autocreate form and will be submitted for Approval. During the PO Approval process, if the Requestor requested any changes in the Requisition through iProcurement then the related PO workflow will...[ read more ]

  • September 30, 2014 | 11 views

How to Add or Assign the Printer to a desired Reports

How to Add or Assign the Printer to a desired Reports

How to Add/Assign the Printer to a desired Report Responsibility: Order Management Super User Navigation: Setup > Shipping > Documents > Choose Printers “Choose Document and Label Printers” Page will open. Click the Documents link shown below. Select the desired report name which you want to attach the Printer Printers and its assignments will be listed. Add a new line...[ read more ]

  • September 30, 2014 | 6 views