Error Message from table type : IBY_EXT_PAYEE_NOT_EXIST

Getting the below error when use iby_disbursement_setup_pub.update_external_payee to update Supplier Notification Delivery method etc

Error Message from table type : IBY_EXT_PAYEE_NOT_EXIST

Fix :Please make sure are the below required parameters passing to API.

 

   p_external_payee_tab_type   iby_disbursement_setup_pub.external_payee_tab_type;

   p_ext_payee_id_tab_type     iby_disbursement_setup_pub.ext_payee_id_tab_type;

 

 

        p_external_payee_tab_type (i).payment_function := 'PAYABLES_DISB';

         p_external_payee_tab_type (i).remit_advice_delivery_method := 'PRINTED';

         p_external_payee_tab_type (i).exclusive_pay_flag := 'N';

         p_external_payee_tab_type(i).Payer_Org_Id := v_site.Org_Id;

         p_external_payee_tab_type(i).Payee_Party_Site_Id:=v_site.PARTY_SITE_ID;

         p_external_payee_tab_type(i).Payer_Org_Type :='OPERATING_UNIT';

         p_external_payee_tab_type(i).Supplier_Site_Id :=v_site.Supplier_Site_Id;

         p_external_payee_tab_type (i).payee_party_id := v_site.payee_party_id;

         p_ext_payee_id_tab_type (i).ext_payee_id := v_site.ext_payee_id;

 
 
 
 

 

Duplicate Item Numbers Causing APP-FND-00906 When Quering Items

Incase of any Duplicate Item then it throughs error APP-FND-00906 When Quering Item master.

Run the following steps, Check incase of any duplicate item.

SELECT organization_id, segment1, segment2, segment3, segment4, segment5,
       segment6, segment7, segment8, segment9, segment10, segment11, segment12,
       segment13, segment14, segment15, segment16, segment17, segment18, segment19, segment20,
count(*)
FROM mtl_system_items_b
GROUP BY organization_id, segment1, segment2, segment3, segment4, segment5,
         segment6, segment7, segment8, segment9, segment10, segment11, segment12,
         segment13, segment14, segment15, segment16, segment17, segment18, segment19, segment20
HAVING count(*) > 1 ;


If it returns any rows then update the duplicate items.

update mtl_system_items_b
set segment1 = segment1 || '_N/A'
where organization_id = &organization_id
and inventory_item_id = &item_id;

commit

User is Not Getting Email for Oracle Notificati​on Such As Approval Kind of Mail.

Check notification_preference is ENABLED or DISABLED wf_local_roles for
that user?  If Disabled then run the below update

UPDATE WF_LOCAL_ROLES
SET STATUS ='INACTIVE' ,EXPIRATION_DATE = (SYSDATE-1)
WHERE NAME LIKE '&user_name'
AND PARENT_ORIG_SYSTEM ='WF_LOCAL_USERS'
AND NOTIFICATION_PREFERENCE ='DISABLED';


After that issue a commit and run the below program.
Synchronize WF LOCAL tables
 

Fails With Error UTIL0020 Invalid Concatenated Segment

1. Navigate to Setup -> Financials -> Flexfields -> Key -> Segments

2. Query for the structure (Chart of Accounts), by entering:
      Application = General Ledger
      Flexfield Title = Accounting Flexfield

3. Unfreeze the Flexfield Definition.

4. Confirm that all Segments in the structure are Displayed and Enabled.
     All segments must have the checkbox ticked.

5. Recompile the Structure.

6. Run the posting program again.

Remit-To Address Setup

Responsibility: Receivables Manager
Navigation:  Setup > Print > Remit To Address


Find the row or rows associated to your Operating Unit and check to see if the bill to address is covered by the "Receitps From" definition.

The most common cause of an error in deriving a Remit-To address is in this "Receipts From" mapping. 
 A best way to avoid problems is to set a default remit-to address for all countries where you transact.

 This allows you to avoid errors during AutoInvoice and transaction entry.  

An internal error has occurred in the program xla_accounting_pkg.complete_entries. Technical problem : Problem encountered in sequencing

To implement the solution, please execute the following steps:

Using a General Ledger responsibility, check the document sequencing setup under Accounting Setup Manager. In particular review :-

SEQUENCE CONTEXT DEFINITION

1. Sequence Context Name:
- Ledger Name:
- Sequence Entity:
- Sequence Event:
- Require Assignment:
- Validate Sequence By:

If a secondary ledger exists:

2. Sequence Context Name:
- Ledger Name:
- Sequence Entity:
- Sequence Event:
- Require Assignment:
- Validate Sequence By:

3. Also check that the Sequence has been defined with the correct dates so that it can be used by the Create Accounting program. i.e. the sequence assignment has to be active for the date of the transaction.

4. Retest the issue.

Remaining Life of an Asset in Fixed Assets Query

SELECT DECODE

          (books.period_counter_fully_retired,

           NULL, GREATEST

                         (  NVL (books.life_in_months, 0)

                          - TRUNC

                                 (MONTHS_BETWEEN (SYSDATE,

                                                  books.date_placed_in_service

                                                 )

                                 ),

                          0

                         ),

           0

          ) remaining_life_in_months,

       DECODE

          (books.period_counter_fully_retired,

           NULL, TRUNC

              (  GREATEST

                         (  NVL (books.life_in_months, 0)

                          - TRUNC

                                 (MONTHS_BETWEEN (SYSDATE,

                                                  books.date_placed_in_service

                                                 )

                                 ),

                          0

                         )

               / 12

              ),

           0

          ) remaining_life_in_years,

       asset_id

  FROM  fa_books books

  WHERE asset_id=100036-- Pass your assest 

retrieving the list of values has stopped because it is taking longer than permitted

Go to tools options
         Then Query Governor tab
                     


Change the value 'Cancel Value retrieval after'  from 00.15 seconds to 1.00 and try.

What are the tables that replaced RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES_ALL ?

The migration of customer data from Oracle Receivables (AR) to the Trading Community Architecture (HZ) is very complex. There isn't a one to one mapping of the old table in AR to a new table in HZ, because the structure of data has completely changed.

Old Table	New Table
RA_CUSTOMERS	HZ_PARTIES and HZ_CUST_ACCOUNTS
RA_ADDRESSES_ALL	HZ_PARTY_SITES, HZ_LOC_ASSIGNMENTS, HZ_LOCATIONS and HZ_CUST_ACCT_SITES_ALL
RA_SITE_USES_ALL	HZ_CUST_SITE_USES_ALL

Refund Error: "INVALID ASSIGNMENT" When Applying a Receipt to Refund Activity

When attempting to apply receipt to activity Refund, the following error occurs:

Error:
INVALID ASSIGNMENT

Solution

Responsibility: System Administrator
Navigation: Application > Sequential Numbering > Assign

Create a document sequence assignment for Category = Payment Request

a java runtime version 1.3 or later is installed correctly

XML Error after pressing Preview Button in MS word

PROBLEM

When XML Preview button is pressed in MS Word after loading XML data, The following error is occurred:

Error No:53

Description: File Not Found

Please confirm that:

1) A Java runtime version 1.3 or later  is installed Correctly

2) The Java executable is accessible through the Windows PATH or the Java Home directory is entered in the Preview tab of the Options dialog

To Solve this: 

Go to BI Publisher menu in Word.

Tools - > options -> preview tab.

Java home should be selected there. Confirm that the path is correct.

unable to set nls language workflow

210: Oracle Error: ORA-01403: No Data Found: SQL Text: SELECT NLS_LANGAUGE from WF_LANGAUGES where :1 IN(NLS_LANGAUGE, CODE)

This error occurs while you try to open an existing workflow from an Oracle Database or Save changes of an Workflow to the Database as below

My Computer -> Properties -> Advanced -> Environment variables ->

Setup new Environment variable NLS_LANG with value  'AMERICAN_AMERICA.UTF8'
reconnect it again.

Why Invoices from Two Operating Units are Not Combined in One Check

----------
PROBLEM :
----------

When creating a payment batch for a supplier with invoices in two different operating units, the selection process correctly selects the invoices in the different operating unit but does not combine them on the check. Instead it only prints out one invoice with the corresponding amount on the check.

1. Enter invoice in OU 1
2. Enter invoice in OU 2
3. Validate and Approve invoices
4. Enter payment batch criteria selecting ALL operating units as sources.
5. Run payment batch request

----------
 Fix :
----------

Please check the set up of Payment Process Profile. In PPP, go to tab Payment Instruction Creation tab and see whether Payment Grouping is selected for First Party Organization and First Party Legal Entity. If the check box is selected then unselect the check box and then retest.

XDOLoad & FNDLOAD

- Printer Styles

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

 - Lookups

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND"
LOOKUP_TYPE="lookup name"

 - Descriptive Flexfield with all of specific Contexts

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=’COL_ALL:REF_ALL:CTX_ONE:SEG_ALL’ APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"

 - Key Flexfield Structures

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=’COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL’ APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

 - Concurrent Programs

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name"

 - Value Sets

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

 - Value Sets with values

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

 - Profile Options

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

 - Request Groups

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

 - Request Sets

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET
APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"

 - Responsibilities
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"

 - Menus
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"


XML Data Definition and Data Template

FNDLOAD apps/apps  0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="XXXX" DATA_SOURCE_CODE="XXXX"

FNDLOAD apps/apps  0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="XXXX"
(To down load all)

FNDLOAD apps/apps   0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct  targetldtfile.ldt

FRM-40212: Invalid value for field ORDERED_ITEM_DSP

First check the below check boxes,

Order Management Super User
Navigate: Master Items > Entered Item in Item Master with correct parameters for Order Management tab:
Customer Ordered
Internal Ordered
Customer Orders enabled
Internal Orders Enabled
Shippable
OE Transactable
Returnable


If all check boxes enabled then Check the below profile option, If it is null then change the value to No at site level.

OM: Use Materialized View for Items LOV (Honors Item Orderability Rules)

After changing that run  'Refresh Order Management Materialized Views'  from Order Management Super User.  And then select that item from Sales Order line.

function not available to this responsibility diagnostics examine

1. Login to Applications and choose the System Administrator responsibility.
2. Navigate to Profile System.
3. Search on %diagn%
4. Select 'Utilities: Diagnostics'.
5. Set profile to 'Yes'.