Oracle e-Business Suite

How to enable creation of employee as supplier in oracle payable supplier entry form

Set Following Profile Options as Required at User or Site Personalize Self-Service Defn = YES FND: Personalization Region Link Enabled = YES Disable Self-Service Personal = NO (Only at Site) FND: Diagnostics = Yes Bounce the Apache Server Login to Application you can see the About This Page Link on all web pages By Using About This ...

Early Payment Discount Example customer order received for item A and we have scheme for item A if user order item A we will give him discount of 200 $ on each items but only in case if he pay in 3 days how it will be handled ? Solution Example: Payment Terms Receivables ...

In a query involving more than one table, join processing is involved to determine the most optimal plan to perform the join. This comprises: Join cardinality Enumerating join orders Evaluating the costs associated with each join ...

Content Set In FSG A content set is used to override row set account assignments to generate different variations of the same report without defining separate reports. Most of the time, content sets are used to generate a given report for every value in a segment of the Chart of Accounts—for ...

In Release 12, Payables Supplier Bank Information is stored somewhere else instead of PO_VENDORS table as in 11i. After going thru the guides, it seems that the bank information (such as bank account numbers, etc) for suppliers may be in TCA or in Cash Management Bank Model. Please provide the ...

1) Restored the backup from the tape to the source destination. 2) Changed the ownership of all the directories. chown -R appltest:dba * chown -R oratest:dba * --- Incase its multi-user. 3) Created a control file in the name of control.sql In the source database ... issue conmmand ... ...

Oracle 10g Cluster Ready Services enables databases to use a Virtual IP address to configure the listener on. This feature is to assure that oracle clients quickly failover when a node fails. When a client connects to a tns-alias, it uses a TCP connection to an IP address, defined in the ...

In one of my client they are facing problem that oracle shipping process is very hectic and lengthy for making one gate pass / delivery note they need 10 to 15 minutes They are following these Steps to Ship / dispatch an order Release order Navigate to Transact Move order Allocate quantity Transact ...

Nice Article Written and Shared by Foaud

Accounting entries for purchase orders with destinations type expense, item type expense and with accrue on receipt option is true. Sequence of actions and accounting entries Action Create, Approve, Reserve PO Accounting entries Budget a/c DR @ PO price (base + Non Recoverable Tax calculated for the (received quantity * PO ...

Problem In one of my operating unit sale officer enter order and released to ware house, after that sale officer cancel that sale order. Now it showing me quantity reserved for that sale order in system but actually order is canceled how can I unreserved this quantity Solution For 11i - 11.5.7 / ...

Complete manual payments and adjustments for the period (including cleanup of ‘Out of Balance’ batches) Check and Complete final Receivables Interface from Order Management Complete manual invoices, DEBIT Memos and credit memos Run your final Auto Invoice process Correct ALL Auto Invoice rejects and re-run Clear all receipts from Cash Management Apply receipts against Invoices and ...

Please apply Patch#4900462 and find the following example scripts under QP_TOP/patch/11.5/sql directory. QPBLKEX1.sql - Script populates interface tables to insert price list header and price list line. QPBLKEX2.sql - Script populates interface tables to insert price list header and price list line and pricing attributes. QPBLKEX3.sql - Script populates interface tables to ...

serial-number-is-not-available-when-doing-a-inventory-transaction-but-shows-in-on-hand-quantity

There are two types of Hierarchies used for approval routing. a. Position Hierarchies b. Supervisor Hierarchies Position Hierarchies ======================== Position Hierarchies are hierarchies that have a JOB/POSITION relationship. For example, you could have a JOB called BUYER and within BUYER you could have various grades or POSITIONS of BUYER - Junior, Senior and Chief Each POSITION ...

The formula is   Actual Available to Reserve = Minimum (Available to Reserve at Particular node/Sub Inventory level, Available to Reserve at higher nodes/ Inventory Organization Level)Explanation -------------------------------- 1. Organization level (highest level): On Hand Quantity for item A = 345 - 30 = 315 (Here Consider 30 is stuck quantity in MMTT, Mean ...

how-to-find-applied-and-unapplied-credit-memos-in-oracle-application-115102

I would like to thank all the visitors of this blog for there support and co-operation which gave me confidence to walk through the blog life with firm steps!!! Bundle of THANKS!!! I can’t believe it’s been a year since I started this blog. It’s really quite amazing when I look ...

If you have some order lines in booked status and the ship line activity is in error instead of 'Notified' then use the following script (But check on Test Environment first). Pass the line_id for one of the line from problematic order and check if this will progress the line ...