Write and Get Paid at Oracleapps4u

Start sending your writings to Oracleapps4all@gmail.com

All you need to do is, submit 10 posts on various topics related to Oracle apps.

Once you have sent your post content, our team will review your writings. You will be paid for all your approved posts.

Conditionally disable DFF components in Oracle apps

A frequent requirement in most Oracle Applications implementations is to be able to conditionally disable one of the components of a Descriptive Flexfield (DFF). DFFs follow the “all or none law” for a given DFF context. If a DFF is displayed, it is enabled and can be changed. The only exception to this rule is when the entire record is read-only. However, if your DFF is using five attributes, there is no mechanism to disable one attribute out of the five attributes. Also, since the DFF window is a user exit call, you cannot disable any attribute field by using set_item_property. We’ll show you how to protect DFF using CUSTOM.pll.

How to Copy a Sales order from backend

Following is the piece of code to copy a Sales order from backend

declare

        l_return_status               varchar2(1);

        l_order_number_from           number :=XYZ; -- Sample order

        l_order_source_id             number :=1041;

begin

        oe_debug_pub.debug_on;

        oe_debug_pub.initialize;

Oracle Purchasing Approvals setup

Defining Approval Groups

Use the Approval Groups window to define and update approval groups. Once you have defined an approval group here, you can then use it to assign approval functions to jobs or positions in the Approval Assignments window. You cannot delete an approval group that is used in an active assignment. You can enable or disable the entire approval group, or you can enter inactive dates for individual approval rules.

R12 Enhancements in Oracle Purchasing

•       Professional Buyer’s Work Center

•       Enhanced Catalog Access

•       Document Styles

•       Procurement for Complex Services

•       Multi-Org Access Control

•       E-Business Tax

Subledger Import Process

This diagram depicts the Subledger Import process:

1.    This diagram depicts the Import Subledger Transactions sub-process

a.     Journal Import:

Journal Import creates journal entries from accounting data you import from Oracle and non-Oracle feeder systems. You can review, change and post imported journal entries the same as any other journal entry.

2.    Account Inquiry

An account inquiry shows you actual, budget, and encumbrance account balances for summary and detail accounts. You can perform variance calculations for both summary and detail accounts.

3.    Run Standard Reports

General Ledger provides a complete set of standard reports such as journal reports, general ledgers, account analyses and trial balances.

Oracle Apps Training - Course Content

Oracle Apps Training

http://oracleapps4u.blogspot.in/ 

How to schedule a concurrent program in oracle apps

When you are moving your new concurrent programs to production instance, you may have to schedule them based on the requirement.

In this blog post we will see how to schedule a concurrent program and the different ways involved in it:

Compile an Oracle form in 11i and R12

How to compile Oracle Apps 11i Forms

============================

Check whether the forms that you want to generate are not in use at the time you are generating them.

 If they are in use when you generate the fmx files, the forms client session terminates.

1) Login to the Forms server node as applmgr and run .env file to set the applications environment.