Skip to main content

Oracle EBS & Fusion

Search This Blog

How to change Form color Oracle EBS

on January 23, 2015

Get link
Facebook
X
Pinterest
Email
Other Apps

Navigation: System Administrator > Profile > System

Enter Profile value: Java Color Scheme

SYSTEM

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Labels

AR
INV
ITEM
OM
SYSTEM

Popular Posts

Autoinvoice: Invalid Warehouse ID

Setup Issue. Rules are transferred to RA_INTERFACE_LINES_ALL, so Accounting Rules and Invoices rules assigned to Transaction Types on the ORDER level Responsibility: Order Management Navigation: Setup > Transaction Types > Define On the Finance Tab : Invoicing Rule and Accounting Rule Defined Responsibility: Receivables Navigation: Setup > Transactions > Sources Go To: Accounting Information tab Invoicing Rule and Accounting Rule are set to 'None.' This means that AutoInvoice will not import this information into Receivables. However, AutoInvoice might still validate the data and could reject the containing line(s) if that data is invalid. To fix the issue and make all valid warehouses available in AR, please validate the following setups: 1) Check the Receivables responsibility having the access to warehouse. Navigation: Setup >Transactions > Define item It will show warehouse deta...

Tips, Tricks, and Shortcuts within Shipping Execution

An Oracle White Paper November 2004 Tips, Tricks, and Shortcuts within Shipping Execution EXECUTIVE OVERVIEW Oracle Shipping Execution is dynamically designed to support the most complicated shipping operations and flexibly designed to support the most basic shipping operations. This versatility allows the user to match their business operations with actual computer application processes. A user can control business processing through setting up parameters and scheduling concurrent programs. Additionally, the user interfaces can be changed in terms of content and layout that makes sense for your operations. This paper explains the key features and functions in Oracle Shipping Execution that can be used as tips, tricks, and shortcuts to automate the shipping process. INTRODUCTION Many steps in shipping operations are routine and repetitive. These types of business scenarios provide a opportunity to streamline the business process by allowing the computer application automatically ...

CALL STORED PROCEDURE FROM FORMS PERSONALIZATION

To call a pl/sql API from forms personalization, do this 1. Personalize the form 2. Create an action of type "BuiltIn" 3. BuiltIn Type for Action should be "Execute a Procedure" 4. Argument should be as below ='declare v_field_value VARCHAR2(200) ; begin plsql_package.procedurenameHere ; end' or alternately ='declare v_field_value VARCHAR2(200) ; begin apassi_prc ('''||${item.PO_CONTROL_RULES.OBJECT_CODE_DISPLAYED_VALUE.value}||'''); end' or ='DECLARE XXX NUMBER; BEGIN DELETE CRM.CRM_CONTRACT_INTERFACE where CONTRACT_NUM='''||:SUMMARY.CONTRACT_NUM||'''; END' Note the syntax, after =, entire declare begin end is within single quote. Also, there is no semi colon after "end" You can pass field values as '''||${item.BLOCKNAME.FIELDNAME.value}||'''

Powered by Blogger