Oracle Maniacs' Notes
Abhijit Ray
How to invoke Flexfield form to enter GL accounts as parameters in a report
We have seen in seeded GL reports that take the accounting flexfield as parameters, the DFF form opens on the SRS form when we click on the flexfield parameter. The user enters the flexfield into the form. The flexfield is then transferred into the report and the output is generated. This is a very handy … Continue reading
How to create a multilingual report in Oracle
Oracle gives a very straightforward method to create multilingual reports if we use XML Publisher to design the reports. We no longer need to create very different report layouts for the same report to be used across languages. Once a language has been installed in addition to the default language, English, then we only need … Continue reading
Order to Cash (O2C) process flow
The Order to Cash or O2C cycle, as it is popularly called, is one of the basic and common business flows within Oracle apps. This cycle is common for any manufacturing or related companies which have implemented Oracle eBusiness Suite. The phases in the Order to Cash cycle are, Enter Order Book Order Pick Release Pick … Continue reading
Payables Invoice Interface/Conversion
Sample code for Payables Invoice interface and/or conversion: Cheers! Related articles Supplier & Supplier Sites Interface/Conversion (oraclemaniac.com) SQL to get the status of all expense reports (oraclemaniac.com) How to administer folders in Oracle Apps (oraclemaniac.com) Procure To Pay (P2P) Process flow (oraclemaniac.com) PL/SQL to execute Workflow Background Process (oraclemaniac.com) Employee Interface/Conversion (oraclemaniac.com) Mass Additions process … Continue reading
Asset addition interface
A sample asset addition interface is given below Cheers! Related articles How to run depreciation in Fixed Assets (oraclemaniac.com) Mass Additions process in Fixed Assets (oraclemaniac.com) SQL to get the status of all expense reports (oraclemaniac.com)
Sales Orders Interface/Conversion
Sample code for sales order interface/conversion is given below Cheers! Related articles Supplier & Supplier Sites Interface/Conversion (oraclemaniac.com) Employee Interface/Conversion (oraclemaniac.com) Batch Element Entry interface automation (oraclemaniac.com) Customized process to convert Internal Requisitions to Move Orders (oraclemaniac.com) Receivables Invoice Interface/Conversion (oraclemaniac.com) How to enable Record History for a custom form (oraclemaniac.com) Defaulting Sales Person on … Continue reading
Item Interface/Conversion
Sample item conversion interface and/or conversion code Cheers! Related articles Employee Interface/Conversion (oraclemaniac.com) Supplier & Supplier Sites Interface/Conversion (oraclemaniac.com) Customized process to convert Internal Requisitions to Move Orders (oraclemaniac.com) How to enable Record History for a custom form (oraclemaniac.com) Receivables Invoice Interface/Conversion (oraclemaniac.com) SQL to get the status of all expense reports (oraclemaniac.com)
Customer Interface/Conversion
Sample interface or conversion code for customers: Cheers! Related articles Supplier & Supplier Sites Interface/Conversion (oraclemaniac.com) Batch Element Entry interface automation (oraclemaniac.com) Employee Interface/Conversion (oraclemaniac.com) PL/SQL to execute Workflow Background Process (oraclemaniac.com) How to administer folders in Oracle Apps (oraclemaniac.com) Customized process to convert Internal Requisitions to Move Orders (oraclemaniac.com) How to enable Record History … Continue reading
Instance health check queries
I regularly use the following queries to check the health of the Oracle instance. I use the output of the queries to create my own graphs that I present to management/client. You can modify the queries by changing the KFF names, custom object naming standard (for me the custom objects have been named by starting … Continue reading
Oracle setup steps for Customer outbound interface through PIP to Siebel
We would like to integrate customer from Oracle Apps/EBS with Siebel. The integration will be done using PIP (Process Integration Pack) that has been supplied by Oracle. Step 1: Enable the business events As per the setup document given by Oracle the business events the following business events have to be enabled in Oracle apps. … Continue reading
Set up Oracle to send Items through PIP to Siebel
Items in Oracle Apps can be integrated with Siebel through Oracle AIA Process Integration Pack (PIP). PIP comes packaged with the necessary mappings to pick up the newly created items/modified items and insert into Siebel. The following setup steps have to be completed to enable PIP integration. Configuration steps Step 1: Add the license Responsibility: … Continue reading
Configure Oracle to receive inbound Sales Orders from Siebel through PIP
The following setup steps are to be completed to enable Oracle to receive sales orders raised by Siebel through Oracle AIA Process Integration Pack (PIP). Profile option: HZ: Raise API Events Profile option: HZ: Format Business Object Business Events as Bulk Profile option: HZ: Generate Party Number Profile option: HZ: Generate Party Site Number … Continue reading
Account generation workflow setup and customization
Accounting information for PO and Requisitions can be derived from multiple places within Oracle Apps. Accounts are setup on Employees, Items, Subinventories, Item Categories, etc. Whenever a PO/Requisition is raised the accounting combination for the document lines are derived by the corresponding account generator workflow. The workflows can be customized as well to deviate from … Continue reading
How to get the output or log file of a concurrent request without going to the SRS form in Apps
The log file or the output file of a concurrent request is accessed from the SRS form in Oracle. There is a way to bypass the SRS form and access the files directly from a web browser, without logging into Oracle. Here is the process to do so: We need the values of 2 profile … Continue reading
Customized item requisition process
The requirement: A new class of requisitions will be created by the end users requesting for items from a decentralized location/organization termed as Outstations. The requisitions will be processed by a centralized location/organization (known as Head Office/Main Store) and the items will be issued to the requesting location/organization. To meet this requirement, 2 custom forms … Continue reading
Abhijit Ray
Mohua Mitra Ray
