EBS Technical

Deploying “Create Employee” API as REST Service :

Introduction This Post illustrates steps Deploying “Create Employee” API as REST Service: in Oracle EBS R12. Go to Integrated SOA Gateway –> Integration Repository The below page will open. 2. Click on the Search button.…

Read More

Create AR Transaction/Invoice adjustment(API)

Interoduction This Post is about to Create AR Transaction/Invoice adjustment(API) Scope: To apply the adjustment in AR Invoice. (eg. To make AR Invoice amount roundoff). Before RoundOff adjustment API Applying…

Read More

Personalization at Adjustment/Sales order/Credit Memo application form

Introduction This component can be used for requirements related to personalization where we want to restrict the user to create an RMA/Adjustment/Credit memo if certain(user-defined) conditions are not met.  …

Read More

How to Update the Web Adi Template

Introduction This post is about How to Update the Web Adi Template in Oracle EBS R12.   Purpose As per the business requirement user had requested to add some fields…

Read More

Daily Exchange Currency Rates Interface

Description: URL will be passed as a parameter where we can identify the currency rate conversion amount. FROM_CURRENCY, TO_CURRENCY, and the date for when it has to be run will…

Read More

AR Transactions Query

Description: The below Post indicates the responsibility to check the AR Transactions Query on AR XLA GL   SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6…

Read More

How to Oracle BI Publisher Introduction

Description: Oracle XML/BI Publisher is a very good reporting tool, which outputs reports into many formats like Word, Excel, PowerPoint, PDF and even to Adobe Flash. This can deliver reports…

Read More

Query to get the details of invoice with tax information’s

Description: Query to get the details of invoice with tax information’s select ctx.customer_trx_id, case when (    hrloc.address_line_1 is not null and (   hrloc.address_line_2 is not null or hrloc.address_line_3 is not…

Read More

Displaying of 7 Consecutive Dates in Report Header

Description: Displaying of 7 Consecutive Dates in Report Header   Step 1:   Create a date field for selecting the date. Step 2:   Create a report for displaying the…

Read More

How to JQuery Id selector in ADF

Description: The ADF components will render with some mixed special characters. For this case, if you want to find the id, We need do add ‘\\’ before to the special character. Example: ADF Actual Rendered ID:pt1:r1:0:pgl13 JQuery ID selector: $(“#pt1:r1:0:pgl13”);———-It doesn’t work $(“#pt1\\:r1\\:0\\:pgl13”)——-It works.   Summary: The…

Read More