OBIA Load GL no data(w_gl_blance_a no data). — Oracle Analytics

Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIA Load GL no data(w_gl_blance_a no data).

Received Response
11
Views
3
Comments

Hello,,

I used OBIA 11.1.1.10.1 to load GL from EBS. I select a fact table:GL_Balance (GLBAL_FG) in my load plan. And the load plan type is "Source Extract and Load (SDE, SIL and PLP)". I opened Dashborad that no data display in BIEE after load plan executed succeed. I traced the query script and found no data in W_GL_BLANCE_A.

Actually, It's still same problem when I tried other load plan type "Domain-only Extract and Load (SDE and SIL)" and Warehouse Load (SIL and PLP) together.

Therefore, I need some help in Community. If you had been face same problem, tell me your solution, please! Thanks a lot~

Best regards,

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    _A means aggregate table ... did you map the domains and group accounts correctly in BIACM?

  • 1045001
    1045001 Rank 2 - Community Beginner

    Hello Thomas,

    I not map the domain and group accounts in BIACM. Can you tell me what have to do, please? Thanks a lot!

    Best regards,

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    You need to follow the configuration guide for the version of BI Apps (and specifically for the modules you've implemented)