Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Month: August 2017

August 1, 2017 Customer Interface Issue: Cannot Populate Account_Name In RA_CUSTOMER_PROFILES_INTERFACE
Accounts ReceivablesErrors/Workarounds-AROracle Functional

ERROR

Customer Interface Issue: Cannot Populate Account_Name In RA_CUSTOMER_PROFILES_INTERFACE

You cannot create Account Name using Customer Interface (RACUST) as this column does not exist in RA_CUSTOMER_PROFILES_INTERFACE.

SOLUTION

You can use TCA API procedure to populate the Account Name:
Procedure= HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
Parameter Name = &account_name

Please refer the oracle support Notes:

  1.  Note 189369.1  How To Create A Customer Via TCA API
  2.  Note 230753.1  Different uses of TCA API

 

 

August 1, 2017 APP-SQLGL-08090: Please open the period you have selected for this batch before posting
Errors/Workarounds-GLGeneral LedgerOracle Functional

ERROR

‘APP-SQLGL-08090: Please open the period you have selected for this batch before posting

(more…)

August 1, 2017 Transaction type does not have any action types for the rule type selected
Accounts PayablesErrors/Workarounds-APOracle Functional

ERROR

This transaction type does not have any action types for the rule type selected. Ensure you add the selected rule type’s action types to this transaction type to use in a rule.

(more…)

August 1, 2017 Supplier Site (VALUE=1002) is not an active and valid purchasing supplier site.
Accounts PayablesErrors/Workarounds-APOracle Functional

ERROR

Supplier Site (VALUE=1002) is not an active and valid purchasing supplier site.

(more…)