Single Shipment to the Order – Deliver available quantity and cancel unshipped lines/quantities automatically

Order processing in certain scenarios requires to deliver available quantity and cancel the remaining quantity and unshipped lines instead of creating the back order. This is very common requirement from some customers to send a single shipment for their orders. Currently there is no way to setup this in Oracle EBS R12.2.8 or prior versions, … Read more

Categories EBS

“AR Invoice Print Solution Using Bill Presentment Architecture and Minimizing Tech Customizations” recorded session

I presented “AR Invoice Print Solution Using Bill Presentment Architecture and Minimizing Tech Customizations” session at OATUG Form Online on 04/20/2020. Here is the recording for the session. AR Invoice Print Solution Using Bill Presentment Architecture and Minimizing Tech Customizations Presentation PDF Document

Categories EBS

Installing Oracle Developer Suite 10g on Windows 10 64 bit for EBS R12 Custom Forms & Reports Development

When installing the certified version of Oracle Developer Suite 10g (10.1.2.0.2) for custom forms/reports development in E-Business Release 12 on windows 10+64 bit client desktop, The command prompt shows up, then gracefully exists; the Oracle Universal Installer never shows up. You have tried changing the compatibility of the setup.exe to Windows XP and running as … Read more

Copying a concurrent program

We have common business requirement to customize the seeded reports/programs like Sales Order Acknowledgement, Invoice Print New Invoices, Invoice Print Selected Invoices, Autoinvoice Import Program etc., In this case, We don’t modify the existing concurrent program’s definition/concurrent program’s source PL/SQL procedure or report, but we will create a copy of the source procedure or report … Read more

Oracle EBS R12.2 Application Technology new features

Online Patching: One of the key Feature of R12.2 is the switch to online patching. This helps to reduce significantly the downtime traditionally needed for patching and related maintenance activities An edition is a private environment in which you can redefine database objects. With online patching, patches are applied to a separate edition while users … Read more

Categories EBS

MOAC setup from SQL Plus/TOAD

Multi Organization Access Control(MOAC) is maintained using Virtual Private Database (VPD). VPD applies security policies to the tables, views and synonyms. VPD replaced views for operating unit access in R12. In R12, org-specific views are replaced with synonyms Setting operating unit context in R11i exec fnd_client_info.set_org_context(&org_id); Setting Operating Unit context in R12: Single Organization/Operating Unit … Read more

Categories EBS

Account Receivables eInvoicing

I presented AR eInvoicing Solution at the OATUG COLLABORATE19 event on 04/11/2019. Presentation Abstract: Automatically sending AR Invoice PDF document to customers via email and copy of the same document to AR Invoice Dept. Customers are setup as EDI Trading partner to receive AR invoice document via email. The program runs for all the newly … Read more

Categories EBS

Oracle EBS Strategy Updates from Oracle

I attended Oracle EBS Strategy Updates sessions by Cliff Godwin & Jeanne Lowell at OATUG Forum Online in April’2020. Here are my takeaways from the sessions. Oracle EBS R12.1 premier support ends Dec 2021. Support beyond 2021 available thru Oracle Advanced Customer Services(ACS) contract. EBS 12.2 provides substancial value now and into future: The latest … Read more

Categories EBS

Oracle Business Network or Oracle Supplier Network

Oracle Business Network (OBN) is a cloud-based supplier registration and messaging service provided to Oracle customers and their trading partners. For example, organizations can use OBN to automate electronic transmission of important business documents such as Purchase Orders and Invoices with their trading partners. The OBN service is hosted at https://businessnetwork.oracle.com. You will need to … Read more