Oracle EBS - How to reset oracle application password using PLSQL script

 --Reset Password

DECLARE

  v_user_name    VARCHAR2(30):= '&USER_NAME';

  v_new_password VARCHAR2(30):= 'welcome';

  v_status       BOOLEAN;

BEGIN

  update fnd_user set user_guid = null where user_name = v_user_name;

 

  v_status   := fnd_user_pkg.ChangePassword ( username => v_user_name,

                                              newpassword => v_new_password

                                            );

  IF v_status =TRUE THEN

    dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);

    COMMIT;

  ELSE

    DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));

    ROLLBACK;

  END IF;

END;

Oracle EBS - Order Management Sales Order Cancelled Line Return Reason SQL Query

Requirement: We need to fetch cancelled sale order line return reason query.

Navigation: Order Management Responsibility > Sales Order > Action > Additional Information > Quantity Hitrory.

SQL Query:

 (select LISTAGG( FLV.MEANING, ',') WITHIN GROUP (ORDER BY  FLV.MEANING)

        from 

        OE_REASONS OER,

        fnd_lookup_values_vl FLV

        where 

        FLV.LOOKUP_TYPE=OER.REASON_TYPE

        AND FLV.LOOKUP_CODE=OER.REASON_CODE

        AND OER.HEADER_ID=OOHA.HEADER_ID  --Need to pass order header Id

        AND OER.ENTITY_ID=OOLA.LINE_ID        -- Need to pass order line Id

) return_reason_code

Oracle Fusion: How to Migrate Bulk Customer Using FBDI Template

 

Oracle Fusion:

How to Migrate Bulk Customer Using FBDI Template?

 

Requirement:

We need to create customer and contact using Oracle Fusion FBDI template.

 

Solution:

Step1: First required to prepare data as per the FBDI template format in the below sheets.

- FBDI template download link: Customer FBDI Template

Customer Sheets:

-          HZ_IMP_PARTIES_T

-          HZ_IMP_PARTYSITES_T

-          HZ_IMP_PARTYSITEUSES_T

-          HZ_IMP_ACCOUNTS_T

-          HZ_IMP_ACCTSITES_T

-          HZ_IMP_ACCTSITEUSES_T

-          RA_CUSTOMER_PROFILES_INT_ALL

Contacts Sheet:

-          HZ_IMP_ACCTCONTACTS_T

-          HZ_IMP_CONTACTPTS_T

-          HZ_IMP_CONTACTROLES

-          HZ_IMP_CONTACTS_T

-          HZ_IMP_RELSHIPS_T

-          HZ_IMP_ROLERESP

Step2: After data loaded in the template file generated .CSV file using FBDI template

Step3: Once .CSV file generated we need to schedule the request. “Load Interface File for Import”

                Import Process: Import Trading Community Data in Bulk

                Date File: Assign .CSV zip file which is generated and saved in the local system.

Step4: Enter the required details and submit the request. Wait for the completion of the request.

Step5: After the Load Interface request complete we need to submit “Import Bulk Customer Data”

    - Batch Id: 20210420

                - Batch Name: 20APR_1

                - Object: Customer and Consumer

                - Source System: CSV

Step6: Submit the request and wait till the request completed successfully.

Step7: We can Import Data.

                Navigation: Home > Receivables > Billing Tab > Task > Manage Data Import

 

Step8: We can see our Batch Name and Batch ID which we processed.

 

 

Step9: We can see the record and process status from this screen. If it’s completed without error. Customer created successfully.

 

Step10: We can cross verify the customer in Fusion AR from the customer master screen. We can search customer with Organization Name. We can found a customer with the same name. W can also found that contact also assigned to a customer in the Account - communication tab.

Navigation: Home > Receivables > Billing > Manage Customers.