2018-09-24 20:09
Q)Is it possible to call Calling PL/SQL procedure/function from a BI Reports Template ?In data template we can call as below e.g.but in case of BI report templates we can't c… Read More
Blog Directory > Software Blogs > Programming Blogs > eBiz Integration Technics programming Blog >
Ebiz Integration Technics Blog
ebiztechnics.blogspot.in
Tags:
requisition
receipt
arrival
parameter
debit memos
requisition lines
purchase
plsql procedurefunction
hold
table
Oracle Applications R12 implementation,upgrades,Oracle SCM,Finance, ADF,OAF, workflow,SQL,PL/sql, forms/Reports 10G, BI publisher reports Interfaces
2018-09-10 18:13
Passing Report name as Report TitleQuestion :Using Desktop Publisher for Word and a standalone BIP Enterprise version, is it possible to pass the report name to the rtf template so that… Read More
2018-09-10 10:08
Let's say we have the following data,1020......50And we want to print them in the following way:10 2030 4050- With using of MS Word basic method (Format->columns), it will print the data… Read More
2018-09-06 06:43
Grouping Type of Default: Combine requisition lines for the same item, revision, line type, unit of measure, supplier item number, and transaction reason onto one purchase order line.&n&hell…Read More
2018-08-31 06:36
How to Change Receipt Routing For Partially Received Purchase Orders?Can receipt routing be updated for partially received PO's? The receipt routing is set initially to 'Direct Delivery… Read More
2018-08-31 05:49
Q) How to create automatic receipts in Purchasing Case 1: When we don't want receipts We can set the PO shipment to 2-way match with 100% receipt tolerance. This way th… Read More
2018-08-29 08:25
Link from PO to Requisition: Table with related column: PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID(Requisition distribution unique identifier) If you autocreate this accounting… Read More
2018-08-20 10:49
When trying to schedule arrival date based on customer calendar,schedule arrival date is not considering and shipping happening on customer non-work days.Expected BehaviorExpect scheduling t… Read More
2018-08-20 07:30
Setup of Holds to Prevent Specific or All Actions on a Sales Order The following examples show how pick release is prevented with any of the 2 options when a hold is applied to a sales… Read More
2018-08-18 05:48
Problem: There is ‘Payables Invoice Approval’ transaction type in AP AME which implies that AP AME works for AP invoice approval irrespective of invoice type(s). Is there a… Read More
2018-08-07 11:24
These scripts will identify duplicate lots when the uniqueness is set to "Across Items" at organization level.Note: Lot Uniqueness - Across Items - it means that there could be only 1… Read More
2018-08-06 05:27
Error: Some times while generating LOT numbers by using API - INV_LOT_API_PUB.Auto_gen_lot ,will get error "Lot number can not be generated as item is being modified in other sessi… Read More
2018-08-02 05:44
One of the reason may be : Inconsistency between sourcing rules and replenishment source type setupSet the replenishment source type to 'Supplier' in Oracle Inventory product. 1) I… Read More
2018-08-01 05:23
By using Create ReleasesThe only way to automatically get the Blanket Agreement number on the Release Header is by creating the releases from the Blanket Sales Agreement screen by clic… Read More
2018-07-20 05:36
No control: Serial number control not established for this item. All material transactions involving this item bypass serial number information.At inventory receipt: Create and assign s… Read More
2018-07-19 06:23
Scenario :While creating PO it is assumed that items received will be a quality leather and its rate is a A quality leather rate. But while receiving item, some quantity received… Read More
2018-07-18 06:53
Release Symptom/Presentation Cause Fix 11.5.x Attempting to run Customer Interface and receive the following error:ORA-01422: exact fetch returns more than requested number of rows… Read More
2018-07-11 09:01
11.5.x to 12.1.x A attempting to import customers through Customer Interface (RACUST) and receive the following error:racinc: inserting customers. Current system time is 01-DEC-2011 11… Read More
2018-07-10 05:32
Release Cause Fix 11.5.x to 12.1.x Attempting to insert contacts through the Customer Interface program and receive the following error:racict: Error inserting contacts. ORA-00001: u… Read More
2018-07-09 11:03
CREATE OR REPLACE PACKAGE ebiz_ven_bank_assn_pkgIS PROCEDURE ebiz_vendor_prc (retcode OUT VARCHAR, errbuf OUT VARCHAR);END ebiz_ven_bank_assn_pkg;/CREATE OR REPLACE PACKAGE BODY… Read More
2018-07-04 04:24
CREATE OR REPLACE PACKAGE ebiz_VEN_SITE_PKGISPROCEDURE ebiz_vendor_site_creation(ERRBUF OUT VARCHAR,RETCODE OUT VARCHAR);END ebiz_VEN_SITE_PKG;/CREATE OR REPLACE PACKAGE BODY ebiz_VEN_SITE_P… Read More
2018-07-04 04:20
/* Formatted on 5/24/2018 12:34:40 PM (QP5 v5.163.1008.3004) */CREATE OR REPLACE PACKAGE ebiz_ven_contactIS PROCEDURE xxven_contact_creation;END ebiz_ven_contact;/CREATE OR REPLA… Read More
2018-06-27 06:37
Business Units and Reference Data SetsReference data sharing is a feature within Oracle Fusion that enables you to group set-enabled reference data such as jobs or grades so that the data ca… Read More
2018-06-25 16:22
Approval RulesApproval rules are routing policies or rules that are evaluated to determine the approvers or FYI (for your information) recipients for a business transaction.Action TypeThere… Read More
2018-06-24 09:50
Purchase Order Approval status Approved In Process, Incomplete Pre-Approved Rejected, or Requires Re-approvalControl status… Read More
2018-06-23 07:19
Creation of Internal Requisition From Sales OrderThe detailed steps are:1. Create a 100% transfer from sourcing rule.2. Assign it to your ATO Item/Model using a sourcing rule.3. Add so… Read More
2018-06-22 13:02
First add roles· General Accounting Manager· General Accountant· &nb&hell…Read More
2018-06-22 07:39
How to setup Buyer in Oracle fusion Procurement ?Very Simple .Add :Employee Role and Buyer Role to the user Read More
2018-06-21 18:41
The cause of the issue is missing data. The DELIVER_TO_LOCATION_ID value is missing for PO Line 1. Once the value was populated, the error was resolved and receipt created… Read More
2018-06-20 06:28
Data security policies and their enforcement across analytics application for the job role BuyerBusiness Object Policy Description Policy Store Implementation Analytics Implementatio… Read More
2018-06-18 20:21
Issue : 'No Purchasing Document Will Be Created Because All Responses Were RejectedResolution: 1. Goto Manage Negotiations in Fusion application and open the negotiation2. Once Negotiat… Read More
2018-06-18 20:05
What is a Procurement Agent?Procurement agents are typically users with procurement roles such as:BuyerCatalog AdministratorCategory ManagerProcurement Contract AdministratorProcurement Mana… Read More
2018-06-12 09:50
Fusion allows a BU /OU to function as a service provider for other BUs. This relatoinship is defined using the concept "Shared Service Center" .Refer to above documentation about what this i… Read More
2018-06-06 21:33
How to set default Inventory Organization ?Normally we can change the Inventory organization using Path: Financials->Organization Structures->Manage Inventory Organization Data Access… Read More
2018-06-06 05:56
How Can we assign the organization for a newly created Item:Navigation ->PIP->TASK->Create Item Read More
2018-06-02 11:57
Issue:JBO-FND:::FND_KF_STR_NO_REQUIRED_LABEL: FND-2742You must assign a required label GL_ACCOUNT to at least one segment.In application 101, key flexfield GL#, and structure Vision Corp CoA… Read More
2018-05-28 05:23
EBS Vs Fusion Org StructureOracle E-Business Suite Application and Oracle Fusion Applications have a few key functional differences, such as Middleware concepts, Fusion Enterprise Structure… Read More
2018-05-26 10:04
Oracle Payable:Bank account :Multiple Vendor Site Assignments.After creating the account holder, for attaching that account at a specific level, you need to call the below procedure in the p… Read More
2018-05-12 07:17
Question :Can We Add Attachments To Oracle Payable Invoice In Closed Period? Ans:Yes you can add an attachment even if the invoice is in a closed period.Note :It is applicable Vers… Read More
2018-05-11 05:08
1) First, create a new AME Attribute (you call it REQ_SOURCE for example) using the SQL to retrieve the po_requisition_headers_all.apps_source_code value. 2) Then create a new AME Condi… Read More
2018-05-09 10:28
An item category is a multi-segment value that describes the item. An example would be: Corporate.Professional Services.Consulting.Software This is also a reporting tool an… Read More
2018-05-09 04:44
How to Prevent Users from Creating a Correction on Receipt that has Been Matched to Invoice?SolutionIt is Oracle standard functionality to allow customers to correct a receipt that has been… Read More
2018-04-17 06:26
Purchase Order Shipment Defaulting RulesShipment Information Standard Planned Blanket Contract Release Ship-To Organization - 1 Financial System Options (blanket release… Read More
2018-04-13 03:57
Purchase Order Line Defaulting Rules Line Information Standard Planned Blanket Contract Release Line Type Purchasing Options Purchasing Options Purchasing Options… Read More
2018-04-12 06:07
Purchase Order Header Defaulting RulesHeader Information Standard Planned Blanket Contract Release Purchase Order Type Value = "Standard" Value = "Blanket" Buyer User name… Read More
2018-04-09 10:20
The Standard Functionality will close the order header by last day of the month when all the lines are closed. To Close the order header as soon as the line is closed or to close the lines a… Read More
2018-04-05 18:20
"You are not authorized to release sales orders from this Organization". Why this error will occur?Solution: The upgrade role had to be granted for that Organization&nb&hell…Read More
2018-03-29 09:49
Service Contracts Order Reprocessing Program" was responsible for the creation of contracts by picking the data from the OKS_REPROCESSING table.The R12 Order Capture integrati… Read More
2018-03-27 06:51
Workflow Background Process For Order ManagementFor best performance it should have three workflow background processes running each with different parameters.1) Process Deferred=YesPr… Read More
2018-03-21 15:26
Purchasing allows you to perform returns to suppliers and returns to customers in the Receiving Returns window.Use the Receiving Returns window to return delivered items to receiving and to… Read More
2018-03-19 17:52
How to update Payables Invoice number? R12We cannot update once validating and creating accounting .Best practice is to cancel the invoice and enter new one with correct number11… Read More
2018-03-15 15:08
How to Cancel the Invoices From a Payables responsibility If the Invoice has been paid: Go to the Payments workbench &nbs&hell…Read More
2018-03-09 20:51
How to Prevent Users from Creating a Correction on Receipt that has Been Matched to Invoice?SolutionIt is Oracle standard functionality to allow customers to correct a receipt that has been… Read More
2018-03-07 16:08
Can we change UOM in Standard Purchase Order Auto Created from Purchase Requisition?Navigate to Purchasing > AutoCreate Query for requisition. Plac… Read More
2018-03-06 17:36
Can we change UOM once item is defined?Once the item is defined, One cannot change the primary UOM of the item anymore.If the item has not been transacted, in that case one can delete… Read More
2018-03-04 09:35
AutoInvoice Errors and ResolutionsError MessageCauseActionPlease define all periods in which revenueis to be recognized or credited.Note that revenue cannot be recognized or credited inclose… Read More
2018-03-03 14:12
GL Date Validation In AutoInvoice1. The entered or derived GL date must be in an Open or Future enterable accounting period. 2.  &hell…Read More
2018-03-01 18:08
Date Derivation In AutoInvoince: During the process of AutoInvoice you can enter the General Ledger (GL) date and the Transaction date for a particular transaction explicitly in t… Read More
2018-02-28 06:34
Some times we need to integrate PO with digital signatures.For that Oracle is provided E-Records.with this we can integrate PO with E-Signatures for quality related checks… Read More
2018-02-27 07:39
Why Sales order salesperson and Receivables invoice Sales order is different?For example:A Salesperson say Vikrant left the company and the new salesperson Yasin is now assigned.Vikrant's re… Read More
2018-02-23 17:16
How to return items to stock or sub-inventory after it is wrongly picked via picked release?1. Delete the Reservation from front end using form2. After Delete the Reservation the Line Status… Read More
2018-02-22 08:54
The 'Deliver To' address is a customer address with the usage type of 'Deliver To'.The 'Deliver To' is useful as an internal address, for ex. the delivery contact on client side related to t… Read More
2018-02-20 17:24
Steps to create a predefined configuration:a. Create a new item number in Master Items. Provide Item Number, Description, UOM. Use a template to apply other attributes. typ… Read More
2018-02-19 18:53
1.1. Preprocessing Lead Time: A component of total lead time that represents the time required to release a purchase order or create a job from the time you learn of the requirement.&nb&hell…Read More
2018-02-16 15:50
When defining normal items the items are stockable,but incase of service item ,the items are not stockableSet attributes as below for the Service itemsAttribute Name Value User Item Type U… Read More
2018-02-15 18:51
Can I create PO with need by date as backdated Date?Yes, We can. Need by date is intentionally allowed to be backdated to support the data entry of old documents .Why because Purchasin… Read More
2018-02-14 10:11
PO Approval without need by date/ Promised date ?i,e YesIt is allowed only for a one-time expense item as it doesn't require planning.i.e The item is non planned and 'Expense Stoc… Read More
2018-02-12 20:14
2018-02-11 06:00
How to set PO Approval Assignments In Non Functional Currency ?Approval groups and assignments are done in functional currency. Standard Functionality that Purchase Orders or Requisitio… Read More
2018-02-07 19:52
Unable to return more than released(ordered) quantity. First, we need to update the shipping return tolerance of the customer in shipping tolerance form.Then, we need to put exact quantity a… Read More
2018-02-06 18:03
Here I am discussing some basic difference between EBS and Fusion Import(Supplier) processEBS tableS Fusion Tables AP_SUPPLIERS_INT POZ_SUPPLIERS_INT AP_SUPPLIER_SITES_INT POZ_SUPPLIER_SI… Read More
2018-02-04 08:06
PER_ALL_PEOPLE_F HZ_PARTIES … Read More
2018-02-03 19:00
QuerySELECT IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM, IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME, &n&hell…Read More
2018-01-30 15:05
This diagnostic test verifies the basic setup for Purchasing.This test should be used proactively during the setup of the Purchasing module to verify setup correctness. It can also be used… Read More
2018-01-29 19:01
Can we create 2 Purchase Orders for two suppliers simultaneously Lets say you are having demand for Item AAA of 10 qty then you will define ASL for AAA for both the suppli… Read More
2018-01-26 14:44
Issue: Shipped Quantity Not Matching With AR Invoiced Quantity Reasons:The reason why fulfilled_quantity and invoiced_quantity is different is because of the ship tolerance. Since in both ca… Read More
2018-01-25 19:15
2018-01-25 15:03
_B - base table. It holds the main details of the object in question and it implies that there is also a _TL table for it. You'd never find a _B table without a _TL table. the primary key is… Read More
2018-01-24 19:47
How does digital imaging happen in Oracle iExpenses?AnsThere are couple of options for imaging documents in Oracle. · One is scann… Read More
2018-01-23 20:22
Is it possible to perform Inventory Transactions especially Miscellaneous Transactions using Item cross reference Inventory Transactions:Sub-inventory TransferMiscellaneous / Account Alias I… Read More
2018-01-22 16:01
What is Borrow Payback Transaction?Ans: In a Project Manufacturing scenario, there are often material that was bought on a PO for Project A. However the Project A does not need it in t… Read More
2018-01-19 19:27
Is it possible for us to update the person number ?Changing the Person Number1. From the navigator, select Setup and Maintenance work area.2. Search for t… Read More
2018-01-16 20:00
How to add multiple assignments for an employee with in same Legal Entity1- first make sure you are allowed to do so.. in the FSM - task - Manage Enterprise HCM Information -- check the empl… Read More
2018-01-16 15:19
We can create enterprise structures by accessing the individual 'manage' screens for each of the objects you need to create. To replace the Enterprise… Read More
2018-01-10 15:46
Q) Lengthy TAGS will decrease the performance?Ans: "YES".The layout is basic, which is good.60 MB of data is high for EBS but doable.For each row two tags need to open and close:/LINE_… Read More
2018-01-09 06:42
When you run UTL_FILE, you might encounter these errors – possible causes and fixes are given below.1. PLS-00201: identifier ‘UTL_FILE’ must be declared(a) Check that… Read More
2018-01-06 12:43
What is The Maximum Number of Files That Can Be Opened Using UTL_FILE.FOPEN() ?CAUSEThe maximum number of concurrent files that can be opened by fopen is 50 files.This function opens a file… Read More
2018-01-05 09:21
Assemble-to-Order Item(ATO)Assemble-to-Order item consists of:Standard bill of material with standard componentsItem manufactured from standard componentsThe three types of ATO items are:Aut… Read More
2018-01-04 08:55
· Subtypes specify the same set of operations as their base type, but only a subset of its values.·  &hell…Read More
2018-01-01 09:44
2017-12-29 05:06
Differences Between CHAR and VARCHAR2 Data TypesPredefined SubtypesHow Blank-Padding WorksValue Comparisons:CHAR and VARCHAR2 Blank-Padding DifferenceIn this example, both the CHAR variable… Read More
2017-12-28 09:25
BOOLEAN Data TypeThe PL/SQL data type BOOLEAN stores logical values, which are the Boolean values TRUE and FALSE and the value NULL. NULL represents an… Read More
2017-12-27 06:20
Data Type :NATURALDefinition:In Oracle PL/SQL, NATURAL is a 32 bit sub datatype derived from BINARY_INTEGER. It allows positive integers or NULL values. (To prevent the assigning of nulls to… Read More
2017-12-24 09:16
2017-12-20 07:18
Q)What is the Data Type of NULL?Ans)Oracle treats NULL as character value of length of 0.So, the default data type of NULL is a character data type and to prove it, Created a view on a null… Read More
2017-12-20 05:54
Problem:Created new Responsibility for order management got the following error Solution:The specified subinventory is invalid to use, the profile option INV: Allow Expense to Asse… Read More
2017-12-20 05:33
Pro'sPunchout to Supplier(s)Desktop ReceivingCatalog ManagementRequisition Tracking and ManagementAbility to see the Lifecycle ( Req > Po > Shipment > Receipt > Invoice > Paym… Read More
2017-12-16 11:10
Created a new item and want to assign category set but not sure why the item is not listed on category set window. What possibly could have gone wrong? It will display you need to assig… Read More
2017-12-15 06:02
Does EBS allow the payment for unaccounted invoices?orTwo invoices were paid but their status in "Accounted" was no. Clicked on actions and view accounting was also disabledAns: EBS all… Read More
2017-12-14 16:40
Converting data from the table to XML formatselect dbms_xmlgen.getxml('select employee_id, first_name, last_name, phone_number from employees where rownum from dualSELECT xmlelement("Na… Read More
Subscribe to Ebiz Integration Technics
Get updates delivered right to your inbox!